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

164 columns | Print definition?ERP 6.0  | EFF_FROM_DT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_MPAPHFill Header for Measure Point Allocation Profile Header6EFF_FROM_DTEffective from datenvarchar80
2OIUX6Y_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data PPN9EFF_FROM_DTEffective from datenvarchar80
3OIUX6_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data9EFF_FROM_DTEffective from datenvarchar80
4OIUX8Y_NM_MASTERTax 2.0 - NM - Master Data PPN9EFF_FROM_DTEffective from datenvarchar80
5OIUX8_NM_MASTERTax 2.0 - NM - Master Data9EFF_FROM_DTEffective from datenvarchar80
6OIUX8_NM_SUFFDECTax 2.0 - New Mexico Suffix Decimal10EFF_FROM_DTEffective from datenvarchar80
7OIUX8_NM_SUFFXRFTax 2.0 - New Mexico Suffix and tax rate x-ref4EFF_FROM_DTEffective from datenvarchar80
8OIUY3Y_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data PPN9EFF_FROM_DTEffective from datenvarchar80
9OIUY3Y_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master PPN9EFF_FROM_DTEffective from datenvarchar80
10OIUY3_TX_BAXRFRoyalty 2.0 - TX GLO/TAU - BA Xref4EFF_FROM_DTEffective from datenvarchar80
11OIUY3_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data9EFF_FROM_DTEffective from datenvarchar80
12OIUY3_TX_OWNOVRRoyalty 2.0 - TX GLO/TAMU Owner Level Reporting Override9EFF_FROM_DTEffective from datenvarchar80
13OIUY3_TX_RPDTMRoyalty 2.0 - TX GLO/TAMU - Report Detail - Masters14EFF_FROM_DTEffective from datenvarchar80
14OIUY3_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master9EFF_FROM_DTEffective from datenvarchar80
15OIUY3_TX_UNITRoyalty 2.0 - TX GLO - Unit Master3EFF_FROM_DTEffective from datenvarchar80
16OIUY6Y_WY_MASTERRoyalty 2.0 - WY - Master Data PPN9EFF_FROM_DTEffective from datenvarchar80
17OIUY6_WY_MASTERRoyalty 2.0 - WY - Master Data9EFF_FROM_DTEffective from datenvarchar80
18OIUY6_WY_PRICERoyalty 2.0 - WY - Report Pricing6EFF_FROM_DTEffective from datenvarchar80
19OIUY6_WY_RPDTMRoyalty 2.0 - WY - Lease/Unit Report Detail - Masters13EFF_FROM_DTEffective from datenvarchar80
TOPBalancing
20OIUBL01_PBAProduct Balancing Agreement3EFF_FROM_DTEffective from datenvarchar80
21OIUBL01_PBAXREFPBA to Well Completion/Measurement Point Cross-ref6EFF_FROM_DTEffective from datenvarchar80
22OIUBL_PBAMPCross reference for measurement point and PBA4EFF_FROM_DTEffective from datenvarchar80
23OIUBL_PBAWCCross Reference for Well Completion and PBA5EFF_FROM_DTEffective from datenvarchar80
TOPCheck Input
24OIUCI_PDXPurchaser DOI Cross Reference8EFF_FROM_DTEffective From Datenvarchar80
25OIUCI_PDXLOCKIncoming Check Usage of Property/DOI xref master data6EFF_FROM_DTEffective From Datenvarchar80
TOPContractual Allocation
26OIUCA_CTMPPRA: Transporter Contract Measurement Point XRef5EFF_FROM_DTEffective from datenvarchar80
27OIUCA_CTWCPRA: Transporter Contract Well Completion XRef6EFF_FROM_DTEffective from datenvarchar80
28OIUCA_PRPHStores the Percent Returned to Producer Header Data7EFF_FROM_DTEffective from datenvarchar80
29OIUCA_PSPPlant Component Options for Selective Processing3EFF_FROM_DTEffective from datenvarchar80
TOPOwnership
30OIUOW_DOH_WKOwnership History Workable12EFF_FROM_DTEffective from datenvarchar80
31OIUOW_DORHDO Owner Request History11EFF_FROM_DTEffective from datenvarchar80
32OIUOW_DTCHDOI Transfer Change Header4EFF_FROM_DTEffective from datenvarchar80
33OIUOW_ESTDTEscheated Transfer Date8EFF_FROM_DTEffective from datenvarchar80
34OIUOW_ESTDT_WKEscheated Transfer Date Worktable8EFF_FROM_DTEffective from datenvarchar80
35OIUOW_INTOHInterface Owner Header10EFF_FROM_DTEffective from datenvarchar80
36OIUOW_INTOH_WKInterface Owner Header Worktable10EFF_FROM_DTEffective from datenvarchar80
37OIUOW_PUC_WKProperty Unit Use Control - work table5EFF_FROM_DTEffective from datenvarchar80
38OIUOW_RETDTRoyalty Escrow Transfer Date8EFF_FROM_DTEffective from datenvarchar80
39OIUOW_RETDT_WKRoyalty Escrow Transfer Date8EFF_FROM_DTEffective from datenvarchar80
40OIUOW_RTCHRD DOI Transfer Change Header8EFF_FROM_DTEffective from datenvarchar80
41OIUOW_RTCH_WKRD DOI Transfer Change Header Worktable8EFF_FROM_DTEffective from datenvarchar80
42OIUOW_RTDRD DOI Transferee Detail14EFF_FROM_DTEffective from datenvarchar80
43OIUOW_RTD_WKRD DOI Transferee Detail Worktable14EFF_FROM_DTEffective from datenvarchar80
TOPProduct Control
44OIUPC_AVGRPAvailability Group Header4EFF_FROM_DTEffective from datenvarchar80
TOPProduction
45OIUPR_SSHSupply Source Header9EFF_FROM_DTEffective from datenvarchar80
TOPProduction and Revenue Accounting
46OIUP_PR_MPVLPRA: Measurement Point Volumetric Data (PDM Shadow)19EFF_FROM_DTEffective from datenvarchar80
47OIUP_PR_WCDVLHWC Disposition Volumes Header (PDM Shadow)8EFF_FROM_DTEffective from datenvarchar80
48OIUT2_INT_FDNObsolete: Funds Delete Notification Control8EFF_FROM_DTEffective from datenvarchar80
49OIUXI_INT_FDNFunds Delete Notification Control8EFF_FROM_DTEffective from datenvarchar80
50OIU_DO_BGUCBearer Group Use Control6EFF_FROM_DTEffective from datenvarchar80
51OIU_DO_BGUC_WKBearer Group Use Control6EFF_FROM_DTEffective from datenvarchar80
52OIU_DO_DODivision of Interest Ownership9EFF_FROM_DTEffective from datenvarchar80
53OIU_DO_DOHOwnership History12EFF_FROM_DTEffective from datenvarchar80
54OIU_DO_DO_WKDivision of Interest Ownership Worktable9EFF_FROM_DTEffective from datenvarchar80
55OIU_DO_DPDOI Accounting Information6EFF_FROM_DTEffective from datenvarchar80
56OIU_DO_DPICDOI Product Interest Control6EFF_FROM_DTEffective from datenvarchar80
57OIU_DO_DPIC_WKDOI Product Interest Control6EFF_FROM_DTEffective from datenvarchar80
58OIU_DO_DPUCDOI Product Use Control5EFF_FROM_DTEffective from datenvarchar80
59OIU_DO_DPUC_WKDOI Product Use Control5EFF_FROM_DTEffective from datenvarchar80
60OIU_DO_PUCProperty Unit Use Control5EFF_FROM_DTEffective from datenvarchar80
61OIU_PR_CHAHChemical Analysis Header5EFF_FROM_DTEffective from datenvarchar80
62OIU_PR_CHATHComponent Typification Header3EFF_FROM_DTEffective from datenvarchar80
63OIU_PR_CTPAMHContract to Gas Plant Allocation Method Xref Header3EFF_FROM_DTEffective from datenvarchar80
64OIU_PR_CUSPAMHCustom Plant Allocation Methods Header3EFF_FROM_DTEffective from datenvarchar80
65OIU_PR_CXREFComponent Crossreference3EFF_FROM_DTEffective from datenvarchar80
66OIU_PR_DNAPHNetwork Allocation Profile Header4EFF_FROM_DTEffective from datenvarchar80
67OIU_PR_DNTCMDelivery Network Theoretical Calculation Method5EFF_FROM_DTEffective from datenvarchar80
68OIU_PR_DNVDDelivery Network Variable Data3EFF_FROM_DTEffective from datenvarchar80
69OIU_PR_DN_LINKDelivery Network Links3EFF_FROM_DTEffective from datenvarchar80
70OIU_PR_FRMHFormula Rules Maintenance Header3EFF_FROM_DTEffective from datenvarchar80
71OIU_PR_LWGORLease Wide Gas/Oil Ratio5EFF_FROM_DTEffective from datenvarchar80
72OIU_PR_MPALBPRA: Measurement Point Allocation Base3EFF_FROM_DTEffective from datenvarchar80
73OIU_PR_MPAPHMeasure Point Allocation Profile Header5EFF_FROM_DTEffective from datenvarchar80
74OIU_PR_MPFUSHMeasure Point Fuel Use Specification3EFF_FROM_DTEffective from datenvarchar80
75OIU_PR_MPHVMeasurement Point Heating Value3EFF_FROM_DTEffective from datenvarchar80
76OIU_PR_MPRMATMeasurement Point Reproduced Materials3EFF_FROM_DTEffective from datenvarchar80
77OIU_PR_MPTRNHPRA: Measurement Point Transporter Xref3EFF_FROM_DTEffective from datenvarchar80
78OIU_PR_MPVDPRA: Measurement Point Variable Data3EFF_FROM_DTEffective from datenvarchar80
79OIU_PR_MPVLPRA: Measurement Point Volumetric Data18EFF_FROM_DTEffective from datenvarchar80
80OIU_PR_TWCDVHTemporary Well Completion Volumes7EFF_FROM_DTEffective from datenvarchar80
81OIU_PR_WCACDPRA: Weighted Average Chemical Analysis Component Detail3EFF_FROM_DTEffective from datenvarchar80
82OIU_PR_WCALBPRA: Well Completion Allocation Base4EFF_FROM_DTEffective from datenvarchar80
83OIU_PR_WCDHHDownhole Commingled Well Completion4EFF_FROM_DTEffective from datenvarchar80
84OIU_PR_WCDVLHWell Completion Disposition Volumes Header7EFF_FROM_DTEffective from datenvarchar80
85OIU_PR_WCHAHPRA: Weighted Average Chemical Analysis Header3EFF_FROM_DTEffective from datenvarchar80
86OIU_PR_WCHVWell Completion Heading Value4EFF_FROM_DTEffective from datenvarchar80
87OIU_PR_WCOLHPRA: Well Completion Offset Lease4EFF_FROM_DTEffective from datenvarchar80
88OIU_PR_WCRMATWell Completion Reproduced Materials4EFF_FROM_DTEffective from datenvarchar80
89OIU_PR_WCSSHWell Completion Supply Source Dated Header8EFF_FROM_DTEffective from datenvarchar80
90OIU_PR_WCTCMPRA: Well Completion Theoretical Calculation Method6EFF_FROM_DTEffective from datenvarchar80
91OIU_PR_WCTRNHPRA: Well Completion Transporter Xref4EFF_FROM_DTEffective from datenvarchar80
92OIU_PR_WCVDWell Completion Variable Data4EFF_FROM_DTEffective from datenvarchar80
93OIU_RV_CGPTContract General Price Terms8EFF_FROM_DTEffective from datenvarchar80
94OIU_RV_CMCCContract Marketing Cost Control Header7EFF_FROM_DTEffective from datenvarchar80
95OIU_RV_CPTRContract Product Tax Reimbursement Header7EFF_FROM_DTEffective from datenvarchar80
96OIU_RV_DMCHProperty/DOI Marketing Cost Header5EFF_FROM_DTEffective from datenvarchar80
97OIU_RV_FRMLDValuation Formula Detail4EFF_FROM_DTEffective from datenvarchar80
98OIU_RV_GRVDGravity Scale Adjustment Detail4EFF_FROM_DTEffective from datenvarchar80
99OIU_RV_MR_MPMarketing Rate Header for MP5EFF_FROM_DTEffective from datenvarchar80
100OIU_RV_MR_WCMarketing Rate Header for WC6EFF_FROM_DTEffective from datenvarchar80
101OIU_RV_PBDPrice Bulletin Posting Table4EFF_FROM_DTEffective from datenvarchar80
102OIU_RV_PDXSSSettlement Statements/Purchaser - DOI Cross Reference5EFF_FROM_DTEffective from datenvarchar80
103OIU_RV_TCLDTax Class9EFF_FROM_DTEffective from datenvarchar80
104OIU_RV_VCRValuation Cross Reference12EFF_FROM_DTEffective from datenvarchar80
105OIU_SB_ACRHheader table for the Allocation Cross Reference6EFF_FROM_DTEffective from datenvarchar80
106OIU_SB_DOIMPCross-reference for MP and DOI8EFF_FROM_DTEffective from datenvarchar80
107OIU_SB_DOIWCDOI/WC Cross Reference9EFF_FROM_DTEffective from datenvarchar80
108OIU_SB_MGDDMarketing Group Determination Detail6EFF_FROM_DTEffective from datenvarchar80
109OIU_SB_MGKWMarketing Group Keep Whole5EFF_FROM_DTEffective from datenvarchar80
TOPRevenue
110OIUAR_RESPIDAccounts Receivable Responsibility ID5EFF_FROM_DTEffective From Datenvarchar80
111OIUE2_RUN_HDRProc 2.0 - Run Header12EFF_FROM_DTEffective from datenvarchar80
112OIURV02_ADA_DTAlternative Dual Accounting Multipliers Header2EFF_FROM_DTStart Datenvarchar80
113OIURV02_ADA_HDAlternative Dual Accounting Multipliers Header2EFF_FROM_DTStart Datenvarchar80
TOPRoyalty Reporting
114OIUREPP_LEASEMMS-2014 - Lease PPA6EFF_FROM_DTEffective from datenvarchar80
115OIUREPP_SALETYPEMMS-2014 - Sales Type PPA7EFF_FROM_DTEffective from datenvarchar80
116OIUREP_LEASEMMS-2014 - Lease6EFF_FROM_DTEffective from datenvarchar80
117OIUREP_MASTERRegulatory Reporting Master Data6EFF_FROM_DTEffective from datenvarchar80
118OIUREP_MASTER_MPRe.Reporting - MP related Reg ID5EFF_FROM_DTEffective from datenvarchar80
119OIUREP_PRPAYXREFMMS-2014 - Property / Payor XRef5EFF_FROM_DTEffective from datenvarchar80
120OIUREP_REG_OPERRegulatory Reporting Operator and Contact Xref EFF Dated8EFF_FROM_DTEffective from datenvarchar80
121OIUREP_SALESTYPEMMS-2014 - Sales Type7EFF_FROM_DTEffective from datenvarchar80
122OIUREP_WCPAYXREFMMS-2014 - Well Completion / Payor XRef4EFF_FROM_DTEffective from datenvarchar80
123OIUY1_GEN_CD_VALMaintain Code with Effective Dated6EFF_FROM_DTEffective from datenvarchar80
TOPTax Reporting
124OIUX3Y_TX_BATXIDTax Reporting - Texas BA Tax ID PPN4EFF_FROM_DTEffective from datenvarchar80
125OIUX3Y_TX_MASTERTax Reporting - Texas Master Data PPN9EFF_FROM_DTEffective from datenvarchar80
126OIUX3Y_TX_MSTOVRTax Reporting - Texas Master Data Overrides9EFF_FROM_DTEffective from datenvarchar80
127OIUX3_RPT_PROFTax Reporting - Reporting Profile4EFF_FROM_DTEffective from datenvarchar80
128OIUX3_TX_BATXIDTax Reporting - Texas BA Tax ID4EFF_FROM_DTEffective from datenvarchar80
129OIUX3_TX_MASTERTax Reporting - Texas Master Data9EFF_FROM_DTEffective from datenvarchar80
130OIUX3_TX_MSTOVRTax Reporting - Texas Master Data Overrides9EFF_FROM_DTEffective from datenvarchar80
131OIUX4_RESP_IDTaxes Payable Responsibility ID7EFF_FROM_DTEffective From Datenvarchar80
132OIUX5Y_OK_BATXIDTax 2.0 - Oklahoma BA Tax ID PPN4EFF_FROM_DTEffective from datenvarchar80
133OIUX5Y_OK_MASTERTax 2.0 - Oklahoma Master Data PPN8EFF_FROM_DTEffective from datenvarchar80
134OIUX5Y_OK_MSTCNTTax 2.0 - Oklahoma Master Data Counties8EFF_FROM_DTEffective from datenvarchar80
135OIUX5_OK_BATXIDTax 2.0 - Oklahoma BA Tax ID4EFF_FROM_DTEffective from datenvarchar80
136OIUX5_OK_MASTERTax 2.0 - Oklahoma Master Data8EFF_FROM_DTEffective from datenvarchar80
137OIUX5_OK_MSTCNTTax 2.0 - Oklahoma Master Data Multiple Counties8EFF_FROM_DTEffective from datenvarchar80
138OIUX5_OK_TAX_RTTax 2.0 - Oklahoma Tax Rates4EFF_FROM_DTEffective from datenvarchar80
139OIUX6Y_WY_BAOPIDTax 2.0 - Wyoming BA Operator ID PPN4EFF_FROM_DTEffective from datenvarchar80
140OIUX6Y_WY_MASTERTax 2.0 - Wyoming Master Data PPN9EFF_FROM_DTEffective from datenvarchar80
141OIUX6_WY_BAOPIDTax 2.0 - Wyoming BA Operator ID4EFF_FROM_DTEffective from datenvarchar80
142OIUX6_WY_CTAX_RTTax 2.0 - Wyoming Conservation Tax Rates2EFF_FROM_DTEffective from datenvarchar80
143OIUX6_WY_CTXRATETax 2.0 - Wyoming Conservation Tax Rate1EFF_FROM_DTEffective from datenvarchar80
144OIUX6_WY_LCDOVRTax 2.0 - Wyoming Lease Condensate Override8EFF_FROM_DTEffective from datenvarchar80
145OIUX6_WY_MASTERTax 2.0 - Wyoming Master Data9EFF_FROM_DTEffective from datenvarchar80
146OIUX6_WY_RATE_CDTax 2.0 - Wyoming Rate Codes3EFF_FROM_DTEffective from datenvarchar80
147OIUX6_WY_STAX_RTTax 2.0 - Wyoming Severance Rate Codes4EFF_FROM_DTEffective from datenvarchar80
148OIUX7_WY_MKTOVRTax 2.0 - WYGP Marketing Type Xref Override6EFF_FROM_DTEffective from datenvarchar80
TOPValuation
149OIURV_DOC_RUNTKTValuation Transaction - Run Ticket7EFF_FROM_DTEffective from datenvarchar80
150OIURV_TAXCONFDState tax configuration detail7EFF_FROM_DTEffective from datenvarchar80
151OIURV_TAXCONFHState tax configuration header7EFF_FROM_DTEffective from datenvarchar80
152OIURV_TCDTax calculation data8EFF_FROM_DTEffective from datenvarchar80
153OIUVL_GASRPTDGas statement report detail7EFF_FROM_DTEffective from datenvarchar80
154OIUVL_MTAHMarketing Cost Tax Exemption - Header8EFF_FROM_DTEffective from datenvarchar80
155OIUVL_OILRPTDOil statement report detail5EFF_FROM_DTEffective from datenvarchar80
156OIUVL_OILTKT_CUROil Ticket Detail7EFF_FROM_DTEffective from datenvarchar80
157OIUVL_OILTKT_HSTOil Ticket Current7EFF_FROM_DTEffective from datenvarchar80
158OIUVL_PLTRWeighted average plant reimbursement header3EFF_FROM_DTEffective from datenvarchar80
159OIUVL_RPAHRoyalty Processing Allowance Header5EFF_FROM_DTEffective from datenvarchar80
160OIUVL_STTRState Tax Rates6EFF_FROM_DTEffective from datenvarchar80
161OIUVL_TCJVTax Class - Venture DOI's6EFF_FROM_DTEffective from datenvarchar80
162OIUVL_TCMPTax Class Measurement Points4EFF_FROM_DTEffective from datenvarchar80
163OIUVL_TCWCTax Class - Well Completion5EFF_FROM_DTEffective from datenvarchar80
164OIUVL_TPAHTax Processing Allowance5EFF_FROM_DTEffective from datenvarchar80