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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

61 columns | Print definition?ERP 6.0  | OID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TLRT_THM_RES_HThreshold Result Header Data2OIDGlobally Unique Identifiervarbinary160
2TLRT_THM_RES_POSThreshold Result Position Data2OIDGlobally Unique Identifiervarbinary160
3TLRT_THM_RES_TIGThreshold Result Instrument Group Data2OIDGlobally Unique Identifiervarbinary160
4TREAT_FUT_DIFFTreasury: TREA Differentiation for Deal Position2OIDGlobally Unique Identifiervarbinary160
TOPBasic Data and Tools
5RMWBA_81RMS-WB: Object Key for Favorites4OIDDatabase Object Key for Favoritesnvarchar100
TOPBrowser-Based PI Sheet Cockpit
6POC_DB_C_TRIGGERDomain Model: Trigger Collection2OIDGlobally Unique Identifiervarbinary160
7POC_DB_PROTOCOLDomain Model: Event Log for Process Steps2OIDGlobally Unique Identifiervarbinary160
8POC_DB_TRIG_PROTLogging: Trigger for Event in Domain Model2OIDGlobally Unique Identifiervarbinary160
TOPControlling
9COAS_ATTR_VALUESAttribute Values2OIDObject Identificationnvarchar220
10COAS_REFERENCESReferences in Attribute Service2OIDObject Identificationnvarchar220
TOPMaster Recipe
11CPC_CMX_DB_CORMaster Recipe: Context Table for Recipe Header2OIDXSteps: Object ID for Persistence Layernvarchar220
12CPC_CMX_DB_COSMaster Recipe: Context Table for Recipe Operations/Phases2OIDXSteps: Object ID for Persistence Layernvarchar220
13CPC_CMX_DB_LOGXSteps: Change Log5OIDXSteps: Object ID for Persistence Layernvarchar220
14CPC_CMX_DB_R_CORRouting: Context Table for Plan Header2OIDXSteps: Object ID for Persistence Layernvarchar220
15CPC_CMX_DB_R_COSRouting: Context Table for Operations2OIDXSteps: Object ID for Persistence Layernvarchar220
16CPC_CMX_DB_R_LOGXSteps (Routing): Change Log5OIDXSteps: Object ID for Persistence Layernvarchar220
TOPProcess Management
17CMX_XSR_DB_CLOGXSteps: Change Log5OIDXSteps: Object ID for Persistence Layernvarchar220
18CMX_XS_DB_HOBJXSteps: Historical Objects (Status Table)2OIDXSteps: Object ID for Persistence Layernvarchar220
19CMX_XS_DB_HRELXSteps: Links to Historical Objects (Relationships)2OIDXSteps: Object ID for Persistence Layernvarchar220
20CMX_XS_DB_INSTRXSteps: Process Instructions Table2OIDXSteps: Object ID for Persistence Layernvarchar220
21CMX_XS_DB_INSTRTXSteps: Texts for Process Instruction Table2OIDXSteps: Object ID for Persistence Layernvarchar220
22CMX_XS_DB_METAXSteps: Metadata2OIDXSteps: Object ID for Persistence Layernvarchar220
23CMX_XS_DB_METATXSteps: Texts for Metadata2OIDXSteps: Object ID for Persistence Layernvarchar220
24CMX_XS_DB_PREDXSteps: Predecessor2OIDXSteps: Object ID for Persistence Layernvarchar220
25CMX_XS_DB_PREXXSteps: Predecessor before the Generation2OIDXSteps: Object ID for Persistence Layernvarchar220
26CMX_XS_DB_PSXSteps: Parameter, Definition in DB Format SMALL2OIDXSteps: Object ID for Persistence Layernvarchar220
27CMX_XS_DB_PSLXSteps: Parameter, LIVE Data in DB Format SMALL2OIDXSteps: Object ID for Persistence Layernvarchar220
28CMX_XS_DB_PSLTXSteps: Texts for Parameters, LIVE Data in DB Format SMALL2OIDXSteps: Object ID for Persistence Layernvarchar220
29CMX_XS_DB_PSTXSteps: Texts for Parameters in DB Format SMALL2OIDXSteps: Object ID for Persistence Layernvarchar220
30CMX_XS_DB_REFXSteps: Step References Table2OIDXSteps: Object ID for Persistence Layernvarchar220
31CMX_XS_DB_REFTXSteps: Texts for Step Reference Table2OIDXSteps: Object ID for Persistence Layernvarchar220
32CMX_XS_DB_ROOTXSteps: Step Root2OIDXSteps: Object ID for Persistence Layernvarchar220
33CMX_XS_DB_ROOTTXSteps: Texts for Step Root2OIDXSteps: Object ID for Persistence Layernvarchar220
34CMX_XS_DB_STEPXSteps: Step Table2OIDXSteps: Object ID for Persistence Layernvarchar220
35CMX_XS_DB_STEPTXSteps: Text for Step Table2OIDXSteps: Object ID for Persistence Layernvarchar220
36CMX_XS_DB_VSXSteps: Values in DB Format SMALL2OIDXSteps: Object ID for Persistence Layernvarchar220
37CMX_XS_DB_VSTXSteps: Texts for Values in DB Format SMALL4OIDXSteps: Object ID for Persistence Layernvarchar220
38POC_DB_COMMANDDomain Model: Table for Step Commands2OIDGlobally Unique Identifiervarbinary160
39POC_DB_C_COMMANDDomain Model: Command Collection2OIDGlobally Unique Identifiervarbinary160
40POC_DB_C_COMMENTDomain Model: Comment Collection2OIDGlobally Unique Identifiervarbinary160
41POC_DB_C_DEVIATDomain Model: Deviation Collection2OIDGlobally Unique Identifiervarbinary160
42POC_DB_C_DEVVARDomain model: Collection for variable setting (deviation)2OIDGlobally Unique Identifiervarbinary160
43POC_DB_C_METADATDomain Model: Local Value Collection2OIDGlobally Unique Identifiervarbinary160
44POC_DB_C_PREDECDomain Model: Predecessor Table2OIDGlobally Unique Identifiervarbinary160
45POC_DB_C_STEPDomain Model: Step Collection2OIDGlobally Unique Identifiervarbinary160
46POC_DB_C_VALUEDomain Model: Value Container Collection2OIDGlobally Unique Identifiervarbinary160
47POC_DB_OPERATIONDomain Model: Table for Operations2OIDGlobally Unique Identifiervarbinary160
TOPProcess Order
48COCR_CMX_DB_CRContext Data for Root Node2OIDXSteps: Object ID for Persistence Layernvarchar220
49COCR_CMX_DB_CSContext Data for XSteps2OIDXSteps: Object ID for Persistence Layernvarchar220
TOPRecords and Case Management
50RMPSPRO_MAILMIMEMime for E-Mail2OIDUUID in X form (binary)varbinary160
TOPTreasury and Risk Management
51TREAT_ASSIGNMENTTreasury: TREA Assignment2OIDGlobally Unique Identifiervarbinary160
52TREAT_FHA_DIFFTreasury: TREA Differentiation for Deal Position2OIDGlobally Unique Identifiervarbinary160
53TREAT_SUBTOTALTREA: Position Subtotal2OIDGlobally Unique Identifiervarbinary160
54TREAT_SUBTOTAL_CTREA: Subtotal Components2OIDGlobally Unique Identifiervarbinary160
TOPWorkforce Management Core
55/SAPAPO/LRPREQWDSearch/Requirements Profile for Work Descriptions2OIDGUID of WFM Search Profile for Work Descriptions (Internal)nvarchar220
56/SAPAPO/LRPRQPROQualifications Profile3OIDGUID of a Persistent Objectnvarchar220
57/SAPAPO/LRPSCPROSupplied WD Time Capacity Limits Profile Set3OIDGUID of a Persistent Objectnvarchar220
58/SAPAPO/LRPSOPROSupplied WD Time Overtime Profile Set3OIDGUID of a Persistent Objectnvarchar220
59/SAPAPO/LRPSQPROQualifications Profile3OIDGUID of a Persistent Objectnvarchar220
60/SAPAPO/LRPSUBIDTable for Subscription of Concrete Subjects8OIDGUID in 'CHAR' Format in Uppercasenvarchar320
61/SAPAPO/LRPSUPWDWFM Capacity Profile for Work Descriptions (Internal)2OIDUID of WFM Offering Profile for Work Description (Internal)nvarchar220