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  | SA_DT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBalancing
1OIUBL_IMBMPMeasurement Point Imbalance5SA_DTSales datenvarchar80
2OIUBL_IMBWCWell Completion Imbalance6SA_DTSales datenvarchar80
3OIU_SB_SPEMP_TSpecial owner entitlements at MP level5SA_DTSales datenvarchar80
4OIU_SB_SPEWC_TSpecial owner entitlements at WC level6SA_DTSales datenvarchar80
TOPCheck Input
5OIUCI_JEIncoming Check Journalized. Temporary hold79SA_DTSales Datenvarchar100
TOPCheck Write
6OIUCW_EXTDExtended Details from Payment Run16SA_DTDate of Char type for compatabiliy with dats stored as Charnvarchar80
7OIUCW_PAYMENTPayment Details from Payment Run17SA_DTDate of Char type for compatabiliy with dats stored as Charnvarchar80
8OIU_CW_SUM_PAYSummarized Payable Table for Check Write8SA_DTDate of Char type for compatabiliy with dats stored as Charnvarchar80
TOPContractual Allocation
9OIUCA_OSPTermination Point Component Options for Selective Process.9SA_DTSales datenvarchar80
10OIUCA_TIKPCNetwork Take-In-Kind Percent by Material4SA_DTSales datenvarchar80
11OIUCA_TIKPC_TNetwork Take-In-Kind Percent by Material Temp Table4SA_DTSales datenvarchar80
TOPProduction and Revenue Accounting
12OIUP_SB_ACTMPActual Owner Level CA results at MP's (PDM Shadow)7SA_DTSales datenvarchar80
13OIUP_SB_ACTWCActual Owner Level CA results at WC's (PDM Shadow)8SA_DTSales datenvarchar80
14OIUP_SB_ENTMPMP level owner entitlements (PDM Shadow)9SA_DTSales datenvarchar80
15OIUP_SB_ENTWCWC level owner entitlements (PDM Shadow)10SA_DTSales datenvarchar80
16OIUP_SB_RNAWCResidue and NGL actual at a WC level (PDM Shadow)8SA_DTSales datenvarchar80
17OIUP_SB_RNEWCResidue and NGL entitlements at a WC level (PDM Shadow)8SA_DTSales datenvarchar80
18OIU_SB_ACTMPActual Owner Level Contractual Allocations results at MP's6SA_DTSales datenvarchar80
19OIU_SB_ACTMP_TActual Owner Level Contractual Allocations results at MP's6SA_DTSales datenvarchar80
20OIU_SB_ACTWCActual Owner Level Contractual Allocations results at WC's7SA_DTSales datenvarchar80
21OIU_SB_ACTWC_TActual Owner Level Contractual Allocations results at WC's7SA_DTSales datenvarchar80
22OIU_SB_CAMPHContract volumes by measurement point header4SA_DTSales datenvarchar80
23OIU_SB_CTRMPVolumes for sale3SA_DTSales datenvarchar80
24OIU_SB_CTRMP_TVolumes for sale3SA_DTSales datenvarchar80
25OIU_SB_CTRWCVolumes for sale3SA_DTSales datenvarchar80
26OIU_SB_CTRWC_TVolumes for sale3SA_DTSales datenvarchar80
27OIU_SB_ENTMPMP level owner entitlements8SA_DTSales datenvarchar80
28OIU_SB_ENTMP_TMP level owner entitlements8SA_DTSales datenvarchar80
29OIU_SB_ENTWCWC level owner entitlements9SA_DTSales datenvarchar80
30OIU_SB_ENTWC_TWC level owner entitlements9SA_DTSales datenvarchar80
31OIU_SB_MGOPMPMarketing Group Owner Percent MP8SA_DTSales datenvarchar80
32OIU_SB_MGOPMP_TMarketing Group Owner Percent MP8SA_DTSales datenvarchar80
33OIU_SB_MGOPWCMarketing Group Owner Percent WC9SA_DTSales datenvarchar80
34OIU_SB_MGOPWC_TMarketing Group Owner Percent WC9SA_DTSales datenvarchar80
35OIU_SB_NIMBMarketing representative imbalance volumes4SA_DTSales datenvarchar80
36OIU_SB_OAHOwner Availability Header4SA_DTSales Date / Monthnvarchar80
37OIU_SB_OZOPHOutside operated residual contract header4SA_DTSales Date / Monthnvarchar80
38OIU_SB_RNAMPResidue and NGL actual at a MP level6SA_DTSales datenvarchar80
39OIU_SB_RNAMP_TTemporary Residue and NGL actual at a MP level6SA_DTSales datenvarchar80
40OIU_SB_RNAWCResidue and NGL actual at a WC level7SA_DTSales datenvarchar80
41OIU_SB_RNAWC_TTemporary Residue and NGL actual at a WC level7SA_DTSales datenvarchar80
42OIU_SB_RNEMPResidue and NGL entitlements at a MP level6SA_DTSales datenvarchar80
43OIU_SB_RNEMP_TTemporary Residue and NGL entitlements at a MP level6SA_DTSales datenvarchar80
44OIU_SB_RNEWCResidue and NGL entitlements at a WC level7SA_DTSales datenvarchar80
45OIU_SB_RNEWC_TTemporary Residue and NGL entitlements at a WC level7SA_DTSales datenvarchar80
46OIU_SB_SPEMPSpecial owner entitlements at MP level5SA_DTSales datenvarchar80
47OIU_SB_SPEWCSpecial owner entitlements at WC level6SA_DTSales datenvarchar80
TOPRevenue
48OIUAR_BAL_TRFRAccounts Receivable Balance Transfer9SA_DTSales Date / Monthnvarchar80
49OIUAR_REC_BALAccounts Receivable Balance8SA_DTSales Date / Monthnvarchar80
50OIUAR_REC_BAL_HAccounts Receivable Balance History8SA_DTSales Date / Monthnvarchar80
51OIUE1_LSSL_SUMLegal Suspense Summary7SA_DTSales datenvarchar80
52OIUE2_ESCH_DTLProc 2.0 - Escheat - Owner Details8SA_DTSales datenvarchar80
53OIUE2_ESCH_DTLHProc 2.0 - Escheat - Owner Detail History8SA_DTSales datenvarchar80
54OIUE2_ESCROW_DTLProc 2.0 - WY Escrow - Owner Details8SA_DTSales datenvarchar80
55OIUE2_JEINTFProc 2.0 - JE Interface Table80SA_DTSales Datenvarchar100
56OIUH_RV_ARINTFPRA Journal Entries to A/R interface table78SA_DTSales Datenvarchar100
57OIUH_RV_JEINTFPRA Journal Entries79SA_DTSales Datenvarchar100
TOPRoyalty Reporting
58OIUREPP_PRPAYXRFMMS-2014 - Property / Payor XRef PPA5SA_DTSales datenvarchar80
59OIUREPP_WCPAYXRFMMS-2014 - Well Completion / Payor XRef PPA4SA_DTSales datenvarchar80
TOPTax Reporting
60OIUX3_JEINTFTax Reporting - JE Interface Table31SA_DTSales Datenvarchar100
61OIUX4_BALANCETaxes Payable Balance4SA_DTSales Date / Monthnvarchar80
62OIUX4_BALANCE_HTaxes Payable Balance History4SA_DTSales Date / Monthnvarchar80
63OIUX4_BAL_CTGZNTaxes Payable Balance Categorization4SA_DTSales Date / Monthnvarchar80
64OIUX4_COMMENTSTaxes Payable Comments4SA_DTSales Date / Monthnvarchar80
TOPValuation
65OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table81SA_DTSales Datenvarchar100