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

39 columns | Print definition?ERP 6.0  | PD_CD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBalancing
1OIUBL01_PRD_GRPDBallancing Product Group Detail - Product code Xref4PD_CDMinor Product Codenvarchar20
TOPCheck Input
2OIUCI_CDEXDCDEX Detail9PD_CDCDEX Product Codenvarchar20
3OIUCI_JEIncoming Check Journalized. Temporary hold19PD_CDProduct Codenvarchar30
4OIUCI_PDXPurchaser DOI Cross Reference13PD_CDProductnvarchar30
TOPCheck Write
5OIUCW_EXTDExtended Details from Payment Run18PD_CDProduct Codenvarchar30
6OIUCW_PAYMENTPayment Details from Payment Run11PD_CDProduct Codenvarchar30
7OIU_CW_SUM_PAYSummarized Payable Table for Check Write7PD_CDProduct Codenvarchar30
TOPContractual Allocation
8OIUCA_ENT_VTCA Allocation Entitlement Volume Types5PD_CDMinor Product Codenvarchar20
TOPOwnership
9OIUOW_DOACCDOI Owner Override Account Codes3PD_CDMinor Product Codenvarchar20
10OIUOW_DOACC_WKDOI Owner Override Account Codes Worktable3PD_CDMinor Product Codenvarchar20
TOPProduction and Revenue Accounting
11OIUCM_CMPNTCommon table for cross-referencing product codes and compo2PD_CDMinor Product Codenvarchar20
12OIU_CM_MAT_PRCDMaterial and Product Code (processing) Xref4PD_CDMinor Product Codenvarchar20
13OIU_CM_PDCDProduct Codes - Tblcm0032PD_CDMinor Product Codenvarchar20
14OIU_CM_PDCD_TXProduct Codes - Tblcm003 - Text3PD_CDMinor Product Codenvarchar20
15OIU_PR_WVMTDWell Completion Volumes Measurement Type Determination3PD_CDMinor Product Codenvarchar20
TOPRevenue
16OIUAR_BAL_TRFRAccounts Receivable Balance Transfer10PD_CDProductnvarchar30
17OIUAR_REC_BALAccounts Receivable Balance9PD_CDProductnvarchar30
18OIUAR_REC_BAL_HAccounts Receivable Balance History9PD_CDProductnvarchar30
19OIUAR_RESPIDAccounts Receivable Responsibility ID4PD_CDProductnvarchar30
20OIUE1_LSSL_SUMLegal Suspense Summary6PD_CDFull three char. product code (Major and Detail Products)nvarchar30
21OIUE2_ESCH_DTLProc 2.0 - Escheat - Owner Details7PD_CDFull three char. product code (Major and Detail Products)nvarchar30
22OIUE2_ESCH_DTLHProc 2.0 - Escheat - Owner Detail History7PD_CDFull three char. product code (Major and Detail Products)nvarchar30
23OIUE2_ESCROW_DTLProc 2.0 - WY Escrow - Owner Details7PD_CDFull three char. product code (Major and Detail Products)nvarchar30
24OIUE2_JEINTFProc 2.0 - JE Interface Table20PD_CDProduct Codenvarchar30
25OIUH_NM_PDCD_XRFNew Mexico Product Code Cross Reference (TBLTR091)2PD_CDMinor Product Codenvarchar20
26OIUH_RV_ARINTFPRA Journal Entries to A/R interface table18PD_CDProduct Codenvarchar30
27OIUH_RV_JEINTFPRA Journal Entries19PD_CDProduct Codenvarchar30
TOPRoyalty Reporting
28OIUREP_CODE_XREFReg Reporting Product/Volume Type to Report Code Cross Ref7PD_CDMinor Product Codenvarchar20
29OIUREP_STAT_SPLTRegulatory Reporting: Well Status Split table9PD_CDMinor Product Codenvarchar20
TOPTax Reporting
30OIUX3_JEINTFTax Reporting - JE Interface Table15PD_CDFull three char. product code (Major and Detail Products)nvarchar30
31OIUX4_BALANCETaxes Payable Balance5PD_CDProductnvarchar30
32OIUX4_BALANCE_HTaxes Payable Balance History5PD_CDProductnvarchar30
33OIUX4_BAL_CTGZNTaxes Payable Balance Categorization5PD_CDProductnvarchar30
34OIUX4_COMMENTSTaxes Payable Comments5PD_CDProductnvarchar30
TOPValuation
35OIURV_CRH_HSTCombined Run Header History6PD_CDOIUH_CHAR2nvarchar20
36OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table21PD_CDProduct Codenvarchar30
37OIURV_DOC_OOBJEOut Of Balance JEs11PD_CDOIUH_CHAR3nvarchar30
38OIURV_DUAL_JEBRDual Accounting JE Backout / Rebook8PD_CDOIUH_CHAR3nvarchar30
39OIU_RV_MKTRANTransaction Code Cross Reference With MarketingType Code4PD_CDOIUH_CHAR2nvarchar20