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

38 columns | Print definition?ERP 6.0  | KEY_FIELD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSSCR_RULEScrambling Rules8KEY_FIELDField Namenvarchar300
2CNV_MBT_ME_SIM_CCustomizing Table to store a Fieldcats to an identifier3KEY_FIELDGeneral Flagnvarchar10
3CNV_MBT_ME_SIM_FTable to Customize the Merge Simulation (Fields)6KEY_FIELDGeneral Flagnvarchar10
4PIQC_PREP_KEY_CPricing prepare: Keys for KOMK/KOMP fields (Customer)4KEY_FIELDField Namenvarchar300
5PIQC_PREP_KEY_SPricing prepare: Keys for KOMK/KOMP fields (SAP delivery)4KEY_FIELDField Namenvarchar300
TOPAccounting Engine
6/EACC/V_TOTALS_FJournal Totals - Field List8KEY_FIELDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPApplication Frame
7CRMC_UI_PMASTERBusiness Role Function Profile Master5KEY_FIELDKey Fieldnvarchar300
TOPBusiness Rule Framework
8TBRF911BRF: Test Data Records - Item Data6KEY_FIELDBRF: General Key Field of a Key/Value Pairntext10737418230
TOPCountry-Specific Objects
9DMEE_SORT_ABADMEE: Sort and Key Fields for Format5KEY_FIELDDMEE: sort field is key fieldnvarchar10
TOPDialog People-Centric UI for Products
10COMC_PR_MAP_KEYTable Keys that Are Mapped to Each Other2KEY_FIELDKey Fields of Tables Mapped to Each Othernvarchar300
TOPDictionary Maintenance
11DDTEST_DBTAB1Test Object1KEY_FIELDCharacter field, 8 characters longnvarchar80
12DDTEST_DBTAB2Test Object1KEY_FIELDCharacter field, 8 characters longnvarchar80
TOPDocument Builder
13/IPRO/TVAR_CMPVariable table7KEY_FIELDKey Field Variablenvarchar200
TOPDocument Management System
14DMS_USER_DEF01DMS: User-Specific Settings4KEY_FIELDnvarchar500
TOPInteraction Center WebClient
15CRMC_IC_PMASTERIC WebClient Profile Master5KEY_FIELDKey Fieldnvarchar300
TOPLocalization
16DMEE_TREE_SORTDMEE: Sort and Key Fields for Format5KEY_FIELDDMEE: sort field is key fieldnvarchar10
TOPLogistics - General
17ECP_FUNCTION_KEYList of key fields for supported functions3KEY_FIELDField namenvarchar300
TOPMaintenance Orders
18/MRSS/C_SQE_RSSTMRS: structure for matching result5KEY_FIELDKey fieldnvarchar300
TOPMobiles User Interface
19PUSHTPLWAP Push Templates1KEY_FIELD3-Byte fieldnvarchar30
TOPPersonal Object Worklist
20POWL_EASY_HDRDefinition for Easy-POWL Feeder5KEY_FIELDName of the Field(s) uniquely identifying a Table Linenvarchar600
TOPProduction Orders
21COCF_SN_BOShift Note: Maintained Reference Objects4KEY_FIELDName of Key Field (Structure COCF_S_DYNF_SN)nvarchar300
TOPRapid Applications
22AXT_RUN_KEY_MAPTable Key Mapping Table (for parent - child relations)2KEY_FIELDField IDnvarchar300
TOPRoyalty Reporting
23OIUREP_CODE_RULEReg Reporting Rules for Column Data5KEY_FIELDKey Fieldnvarchar300
TOPService Data Download
24/SDF/CMO_ERR_LOGCMO Service: Error log1KEY_FIELDCMO Service: Object Countint100
25/SDF/CMO_T_36BCMO Service: Patches in DEV1KEY_FIELDCMO Service: Object Countint100
26/SDF/CMO_T_36CCMO Service: Addons in DEV1KEY_FIELDCMO Service: Object Countint100
27/SDF/CMO_T_36DCMO Service: Components in DEV1KEY_FIELDCMO Service: Object Countint100
28/SDF/CMO_T_36ECMO Service: Component patches in DEV1KEY_FIELDCMO Service: Object Countint100
29/SDF/CMO_T_36FCMO Service: Component patches in DEV1KEY_FIELDCMO Service: Object Countint100
30/SDF/CMO_T_36GCMO Service: Addons in QAS1KEY_FIELDCMO Service: Object Countint100
31/SDF/CMO_T_36HCMO Service: Components in QAS1KEY_FIELDCMO Service: Object Countint100
32/SDF/CMO_T_36ICMO Service: Component patches in QAS1KEY_FIELDCMO Service: Object Countint100
TOPServices
33FINB_COMPKEYMAPMapping of Component Keys3KEY_FIELDField Name of a Configuration Aspectnvarchar300
34FINB_COMPKEY_VALValue of Keys of Configurable Components3KEY_FIELDField Name of a Configuration Aspectnvarchar300
35FINB_COMP_KEYSComponent Key (Client-Specific)2KEY_FIELDField Name of a Configuration Aspectnvarchar300
36FINB_PR_TFIELDSFields of a Persistence Object8KEY_FIELDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPSingapore
37T5RTEXT_KEYMapping table for subtype of infotype 741 to the keyfields3KEY_FIELDKey for text handling in SG reportsnvarchar60
TOPUse Subcomponents
38SOMFSAPoffice: Address tables for fax screen4KEY_FIELDSAPoffice: Name of key field in address tablenvarchar100