SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

65 columns | Print definition?ERP 6.0  | SELECTION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_SUGFLDFields for rendering Suggestion List Dialog5SELECTIONCheckboxnvarchar10
2/FLDQ/HNASUGGTABDQM for SAP suggestion list table for transactional TASK1SELECTIONint100
3/GEOE/CONFIG_14Configuration for Search Sub Panel Fields9SELECTIONChar255nvarchar2550
4/PLMB/EXP_LAYOUTDownload Data: Selection Layout8SELECTIONDownload Data: Generic Selectionntext10737418230
5/XPPM/CAR_C_OPOutput and selection definiton11SELECTIONis selectionoptionnvarchar10
6CNVMBT09PACKPackage features4SELECTIONParameter for the generic deletion programnvarchar10
7CNVMBT09TABLETables to be processed13SELECTIONParameter for the generic deletion programnvarchar10
8CNVMBTDELPARAMSParameter for the generic deletion program6SELECTIONParameter for the generic deletion programnvarchar10
9CNVMBT_DEL_PACKPackage features4SELECTIONParameter for the generic deletion programnvarchar10
10CNVMBT_DEL_TABLETable to be processed13SELECTIONParameter for the generic deletion programnvarchar10
11CNVTDMS_09_PACKPackage features4SELECTIONFlag for type of selectionnvarchar10
12CNVTDMS_09_TABLETables to be processed13SELECTIONFlag for type of selectionnvarchar10
13CNV_10996_DELIMDelimitation of archiving objects by org. units6SELECTIONConversion: Selection via field / routine / modulenvarchar300
14CNV_MBT_09_TABLETables for table deletion13SELECTIONJust one characternvarchar10
15ITAGCYSELMODEAssignment of Selection Variants to Modes2SELECTIONSelection Variantnvarchar20
16RFCTSTTABTable of RFC Test Destinations2SELECTIONSelection Criteria for RFC Test Destinationnvarchar800
17RSODP_BW_REQ_MAPQueue Model for BW Objects: mapping of requests10SELECTIONntext10737418230
18T5GPBS_SELME: Selection in reporting (Primary/all)3SELECTIONME: Selection of primary in reporting (not All/Primary only)nvarchar10
TOPBusiness Application Support
19CNVFIELDREFAssignment of fields to organizational units9SELECTIONConversion: Selection via field / routine / modulenvarchar300
20CNVFIREF_DELTATable for delta maintenance of CNVFIELDREF10SELECTIONConversion: Selection via field / routine / modulenvarchar300
21CNVPERFDEMANDTable of performance requirements by scenario31SELECTIONConversion: Name of subscheme at this eventnvarchar400
TOPBusiness Partner
22TXO_CLUSTERObsolete4SELECTIONnvarchar320
23TXO_GEN_DBXO-User-Specific Generic Database Table5SELECTIONAdditional Selection Criterionnvarchar320
TOPBW Service API
24ROOSFIELDDataSource Fields4SELECTIONProperties of a DataSource Fieldnvarchar10
TOPCentral Part of Product Master
25COMC_CRD_GEN_BWECRM CRD: Relevant Fields of the Object Tables7SELECTIONSelection Option Fields for Extractor-Generationnvarchar10
26COMC_CRD_GEN_BWICRM CRD: Relevant Fields of the Link and Master Data Table5SELECTIONSelection Option Fields for Extractor-Generationnvarchar10
27COMC_CRD_GEN_BWSCRM CRD: Selection Fields for Generated Attribute DataSource3SELECTIONProperties of a DataSource Fieldnvarchar10
TOPClient-System Adapter
28MDMEXTRFLDMDM Field Table for Extraktor Metadata14SELECTIONMDM Extraction Object: Selectionnvarchar10
29MDMEXVARISELMDM Extractor: Selection Criteria10SELECTIONMDM Extraction Object: Flagnvarchar10
TOPCollectionsDisbursements
30ITAGCYSELSelection Variants for OI Selection in Agency Collections2SELECTIONSelection Variantnvarchar20
31ITAGCYSELTText Table for ITAGCYSEL3SELECTIONSelection Variantnvarchar20
TOPData Staging
32RSDSSEGFDDataSource - Segment Fields16SELECTIONSelectionnvarchar10
33RSDSSEGFDSHDataSource in BW - Shadow Table Fields16SELECTIONSelectionnvarchar10
34RSISOFIELDInfoSource fields (provider structure of a source system)17SELECTIONSingle-Character Indicatornvarchar10
35RSOLTPSOURCEFDSHShadow Table: OLTP Source Fields17SELECTIONSingle-Character Indicatornvarchar10
36RSOLTPSOURCEFIEOLTP Source Fields17SELECTIONProperties of a DataSource Fieldnvarchar10
37RSOLTPSOURCESFISegment Fields of a DataSource18SELECTIONProperties of a DataSource Fieldnvarchar10
TOPFast Search Infrastructure
38SFSRFW_IDX_DReplication Framework - Index Definition9SELECTIONReplication Framework - Selection (Table/Node)nvarchar300
39SFSRFW_IDX_IFDReplication Framework - Definition of Index Fields4SELECTIONReplication Framework - Selection (Table/Node)nvarchar300
40SFSRFW_REQ_OBJSReplication Framework Requested Tables4SELECTIONReplication Framework - Selection (Table/Node)nvarchar300
TOPFinancial Services
41BWFS_CFM_DEALSELSelection Table for TR-TM Transaction Master Data2SELECTIONObject Identity in Database Formatnvarchar320
42BWFS_CFM_SELECSelection Table for TR-TM Position Management2SELECTIONObject Identity in Database Formatnvarchar320
43BWFS_CML_SELECSelection Table for FS-CML2SELECTIONObject Identity in Database Formatnvarchar320
44BWFS_SETTINGSTime Stamp Delta Extraction3SELECTIONObject Identity in Database Formatnvarchar320
45BWFS_SETTINGS_ITime Stamp Init Extraction3SELECTIONObject Identity in Database Formatnvarchar320
TOPFinancials Basis
46UGR31008FIN Master Data: Dummy Field Names with Properties6SELECTIONSelection Options of a Data Source Fieldnvarchar10
47UGR31022FIN Master Data: Buffer Table f.Fields of Extract Structures4SELECTIONSelection Options of a Data Source Fieldnvarchar10
TOPForms
48TSELFIELDS_01HR Forms: Selection Options for Selections5SELECTIONHR Forms: Name of Selectionnvarchar90
TOPGovernance, Risk and Compliance
49GRFNREPLOGSETReport: Log settings for further check4SELECTIONXMLimage21474836470
TOPImplementation Guide
50TSTATCSelection specifications for a project2SELECTIONSelection fieldsnvarchar120
51TSTATCESelection specifications1SELECTIONSelection fieldsnvarchar120
52TSTATCPAssignment of selection to project and activity1SELECTIONSelection fieldsnvarchar120
53TSTATCSSelection assignment for status object2SELECTIONSelection fieldsnvarchar120
54TSTATCTSelection field text2SELECTIONSelection fieldsnvarchar120
TOPInformation System
55FTI_LDB_DDIC_MAPMapping Field from Logical Database to Database Table5SELECTIONSpecifies Whether this Field Can Be Selectednvarchar10
TOPNetWeaver Enterprise Search
56ESH_OM_ADPRVDFData Providers: Fields9SELECTIONField can be used for Selectionnvarchar10
57ESH_OM_CDPRVDFData Providers: Fields9SELECTIONField can be used for Selectionnvarchar10
58ESH_OM_IDPRVDFData Providers: Fields9SELECTIONField can be used for Selectionnvarchar10
59ESH_OM_SDPRVDFData Providers: Fields9SELECTIONField can be used for Selectionnvarchar10
TOPOrganizational Management
60T77FOBJMANDefinition of Object Manager Scenario2SELECTIONObject Manager: Single/Multiple Selectionnvarchar10
61T77FSEAADefinition of Interaction Tools2SELECTIONObject Manager: Single/Multiple Selectionnvarchar10
TOPProfitability Analysis
62TKEFACO-PA Archiving Management: Field Assignment3SELECTIONIndicator: Characteristic for Prof. Analysis in Selectionnvarchar10
TOPResults Recording
63TQEC30Settings for Copy Inspection Results Function/Operation UD9SELECTIONData Selection Procedure for Copy Insp. Results Functionnvarchar30
TOPSAP Business Partner
64MDMEXTRFLD_PREFMDM Field Table Extractor Metadata (Copy)14SELECTIONMDM Extraction Object: Selection (Copy)nvarchar10
TOPWeb Screen Tools - ABAP
65WDY_CTX_NODEWeb Dynpro: Context Nodes of Controllers11SELECTIONWeb Dynpro: Cardinalitynvarchar20