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

149 columns | Print definition?ERP 6.0  | EFF_TO_DT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX6Y_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data PPN12EFF_TO_DTEffective To Datenvarchar80
2OIUX6_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data11EFF_TO_DTEffective To Datenvarchar80
3OIUX8Y_NM_MASTERTax 2.0 - NM - Master Data PPN11EFF_TO_DTEffective To Datenvarchar80
4OIUX8_NM_MASTERTax 2.0 - NM - Master Data10EFF_TO_DTEffective To Datenvarchar80
5OIUX8_NM_SUFFDECTax 2.0 - New Mexico Suffix Decimal12EFF_TO_DTEffective To Datenvarchar80
6OIUX8_NM_SUFFXRFTax 2.0 - New Mexico Suffix and tax rate x-ref5EFF_TO_DTEffective To Datenvarchar80
7OIUY3Y_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data PPN13EFF_TO_DTEffective To Datenvarchar80
8OIUY3Y_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master PPN11EFF_TO_DTEffective To Datenvarchar80
9OIUY3_TX_BAXRFRoyalty 2.0 - TX GLO/TAU - BA Xref5EFF_TO_DTEffective To Datenvarchar80
10OIUY3_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data12EFF_TO_DTEffective To Datenvarchar80
11OIUY3_TX_OWNOVRRoyalty 2.0 - TX GLO/TAMU Owner Level Reporting Override10EFF_TO_DTEffective To Datenvarchar80
12OIUY3_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master10EFF_TO_DTEffective To Datenvarchar80
13OIUY3_TX_UNITRoyalty 2.0 - TX GLO - Unit Master5EFF_TO_DTEffective To Datenvarchar80
14OIUY6Y_WY_MASTERRoyalty 2.0 - WY - Master Data PPN13EFF_TO_DTEffective To Datenvarchar80
15OIUY6_WY_MASTERRoyalty 2.0 - WY - Master Data12EFF_TO_DTEffective To Datenvarchar80
16OIUY6_WY_PRICERoyalty 2.0 - WY - Report Pricing7EFF_TO_DTEffective To Datenvarchar80
TOPBalancing
17OIUBL01_PBAProduct Balancing Agreement4EFF_TO_DTEffective To Datenvarchar80
18OIUBL01_PBAXREFPBA to Well Completion/Measurement Point Cross-ref7EFF_TO_DTEffective To Datenvarchar80
19OIUBL_PBAMPCross reference for measurement point and PBA5EFF_TO_DTEffective To Datenvarchar80
20OIUBL_PBAWCCross Reference for Well Completion and PBA6EFF_TO_DTEffective To Datenvarchar80
TOPCheck Input
21OIUCI_PDXPurchaser DOI Cross Reference9EFF_TO_DTEffective To Datenvarchar80
22OIUCI_PDXLOCKIncoming Check Usage of Property/DOI xref master data7EFF_TO_DTEffective To Datenvarchar80
TOPContractual Allocation
23OIUCA_CTMPPRA: Transporter Contract Measurement Point XRef6EFF_TO_DTEffective To Datenvarchar80
24OIUCA_CTWCPRA: Transporter Contract Well Completion XRef7EFF_TO_DTEffective To Datenvarchar80
25OIUCA_PRPHStores the Percent Returned to Producer Header Data8EFF_TO_DTEffective To Datenvarchar80
26OIUCA_PSPPlant Component Options for Selective Processing4EFF_TO_DTEffective To Datenvarchar80
TOPOwnership
27OIUOW_DOH_WKOwnership History Workable17EFF_TO_DTEffective To Datenvarchar80
28OIUOW_DORHDO Owner Request History12EFF_TO_DTEffective To Datenvarchar80
29OIUOW_DTCHDOI Transfer Change Header5EFF_TO_DTEffective To Datenvarchar80
30OIUOW_ESTDTEscheated Transfer Date9EFF_TO_DTEffective To Datenvarchar80
31OIUOW_ESTDT_WKEscheated Transfer Date Worktable9EFF_TO_DTEffective To Datenvarchar80
32OIUOW_INTOHInterface Owner Header11EFF_TO_DTEffective To Datenvarchar80
33OIUOW_INTOH_WKInterface Owner Header Worktable11EFF_TO_DTEffective To Datenvarchar80
34OIUOW_PUC_WKProperty Unit Use Control - work table6EFF_TO_DTEffective To Datenvarchar80
35OIUOW_RETDTRoyalty Escrow Transfer Date9EFF_TO_DTEffective To Datenvarchar80
36OIUOW_RETDT_WKRoyalty Escrow Transfer Date9EFF_TO_DTEffective To Datenvarchar80
37OIUOW_RTCHRD DOI Transfer Change Header9EFF_TO_DTEffective To Datenvarchar80
38OIUOW_RTCH_WKRD DOI Transfer Change Header Worktable9EFF_TO_DTEffective To Datenvarchar80
39OIUOW_RTDRD DOI Transferee Detail16EFF_TO_DTEffective To Datenvarchar80
40OIUOW_RTD_WKRD DOI Transferee Detail Worktable16EFF_TO_DTEffective To Datenvarchar80
TOPProduct Control
41OIUPC_AVGRPAvailability Group Header5EFF_TO_DTEffective To Datenvarchar80
TOPProduction
42OIUPR_SSHSupply Source Header10EFF_TO_DTEffective To Datenvarchar80
TOPProduction and Revenue Accounting
43OIUP_PR_MPVLPRA: Measurement Point Volumetric Data (PDM Shadow)20EFF_TO_DTEffective To Datenvarchar80
44OIUP_PR_WCDVLHWC Disposition Volumes Header (PDM Shadow)9EFF_TO_DTEffective To Datenvarchar80
45OIU_DO_BGUCBearer Group Use Control7EFF_TO_DTEffective To Datenvarchar80
46OIU_DO_BGUC_WKBearer Group Use Control7EFF_TO_DTEffective To Datenvarchar80
47OIU_DO_DODivision of Interest Ownership10EFF_TO_DTEffective To Datenvarchar80
48OIU_DO_DOHOwnership History17EFF_TO_DTEffective To Datenvarchar80
49OIU_DO_DO_WKDivision of Interest Ownership Worktable10EFF_TO_DTEffective To Datenvarchar80
50OIU_DO_DPDOI Accounting Information9EFF_TO_DTEffective To Datenvarchar80
51OIU_DO_DPICDOI Product Interest Control7EFF_TO_DTEffective To Datenvarchar80
52OIU_DO_DPIC_WKDOI Product Interest Control7EFF_TO_DTEffective To Datenvarchar80
53OIU_DO_DPUCDOI Product Use Control6EFF_TO_DTEffective To Datenvarchar80
54OIU_DO_DPUC_WKDOI Product Use Control6EFF_TO_DTEffective To Datenvarchar80
55OIU_DO_PUCProperty Unit Use Control6EFF_TO_DTEffective To Datenvarchar80
56OIU_PR_CHAHChemical Analysis Header6EFF_TO_DTEffective To Datenvarchar80
57OIU_PR_CHATHComponent Typification Header4EFF_TO_DTEffective To Datenvarchar80
58OIU_PR_CTPAMHContract to Gas Plant Allocation Method Xref Header4EFF_TO_DTEffective To Datenvarchar80
59OIU_PR_CUSPAMHCustom Plant Allocation Methods Header4EFF_TO_DTEffective To Datenvarchar80
60OIU_PR_CXREFComponent Crossreference4EFF_TO_DTEffective To Datenvarchar80
61OIU_PR_DNAPHNetwork Allocation Profile Header5EFF_TO_DTEffective To Datenvarchar80
62OIU_PR_DNTCMDelivery Network Theoretical Calculation Method6EFF_TO_DTEffective To Datenvarchar80
63OIU_PR_DNVDDelivery Network Variable Data4EFF_TO_DTEffective To Datenvarchar80
64OIU_PR_DN_LINKDelivery Network Links6EFF_TO_DTEffective To Datenvarchar80
65OIU_PR_FRMHFormula Rules Maintenance Header4EFF_TO_DTEffective To Datenvarchar80
66OIU_PR_LWGORLease Wide Gas/Oil Ratio6EFF_TO_DTEffective To Datenvarchar80
67OIU_PR_MPALBPRA: Measurement Point Allocation Base8EFF_TO_DTEffective To Datenvarchar80
68OIU_PR_MPAPHMeasure Point Allocation Profile Header6EFF_TO_DTEffective To Datenvarchar80
69OIU_PR_MPFUSHMeasure Point Fuel Use Specification4EFF_TO_DTEffective To Datenvarchar80
70OIU_PR_MPHVMeasurement Point Heating Value4EFF_TO_DTEffective To Datenvarchar80
71OIU_PR_MPRMATMeasurement Point Reproduced Materials4EFF_TO_DTEffective To Datenvarchar80
72OIU_PR_MPTRNHPRA: Measurement Point Transporter Xref5EFF_TO_DTEffective To Datenvarchar80
73OIU_PR_MPVDPRA: Measurement Point Variable Data4EFF_TO_DTEffective To Datenvarchar80
74OIU_PR_MPVLPRA: Measurement Point Volumetric Data19EFF_TO_DTEffective To Datenvarchar80
75OIU_PR_TWCDVHTemporary Well Completion Volumes8EFF_TO_DTEffective To Datenvarchar80
76OIU_PR_WCALBPRA: Well Completion Allocation Base9EFF_TO_DTEffective To Datenvarchar80
77OIU_PR_WCDHHDownhole Commingled Well Completion6EFF_TO_DTEffective To Datenvarchar80
78OIU_PR_WCDVLHWell Completion Disposition Volumes Header8EFF_TO_DTEffective To Datenvarchar80
79OIU_PR_WCHAHPRA: Weighted Average Chemical Analysis Header4EFF_TO_DTEffective To Datenvarchar80
80OIU_PR_WCHVWell Completion Heading Value5EFF_TO_DTEffective To Datenvarchar80
81OIU_PR_WCOLHPRA: Well Completion Offset Lease5EFF_TO_DTEffective To Datenvarchar80
82OIU_PR_WCRMATWell Completion Reproduced Materials5EFF_TO_DTEffective To Datenvarchar80
83OIU_PR_WCSSHWell Completion Supply Source Dated Header9EFF_TO_DTEffective To Datenvarchar80
84OIU_PR_WCTCMPRA: Well Completion Theoretical Calculation Method7EFF_TO_DTEffective To Datenvarchar80
85OIU_PR_WCTRNHPRA: Well Completion Transporter Xref6EFF_TO_DTEffective To Datenvarchar80
86OIU_PR_WCVDWell Completion Variable Data5EFF_TO_DTEffective To Datenvarchar80
87OIU_RV_CGPTContract General Price Terms9EFF_TO_DTEffective To Datenvarchar80
88OIU_RV_CMCCContract Marketing Cost Control Header8EFF_TO_DTEffective To Datenvarchar80
89OIU_RV_CPTRContract Product Tax Reimbursement Header8EFF_TO_DTEffective To Datenvarchar80
90OIU_RV_DMCHProperty/DOI Marketing Cost Header7EFF_TO_DTEffective To Datenvarchar80
91OIU_RV_FRMLDValuation Formula Detail5EFF_TO_DTEffective To Datenvarchar80
92OIU_RV_GRVDGravity Scale Adjustment Detail6EFF_TO_DTEffective To Datenvarchar80
93OIU_RV_MR_MPMarketing Rate Header for MP6EFF_TO_DTEffective To Datenvarchar80
94OIU_RV_MR_WCMarketing Rate Header for WC7EFF_TO_DTEffective To Datenvarchar80
95OIU_RV_PBDPrice Bulletin Posting Table5EFF_TO_DTEffective To Datenvarchar80
96OIU_RV_PDXSSSettlement Statements/Purchaser - DOI Cross Reference6EFF_TO_DTEffective To Datenvarchar80
97OIU_RV_TCLDTax Class10EFF_TO_DTEffective To Datenvarchar80
98OIU_RV_VCRValuation Cross Reference13EFF_TO_DTEffective To Datenvarchar80
99OIU_SB_ACRHheader table for the Allocation Cross Reference7EFF_TO_DTEffective To Datenvarchar80
100OIU_SB_DOIMPCross-reference for MP and DOI9EFF_TO_DTEffective To Datenvarchar80
101OIU_SB_DOIWCDOI/WC Cross Reference10EFF_TO_DTEffective To Datenvarchar80
102OIU_SB_MGDDMarketing Group Determination Detail7EFF_TO_DTEffective To Datenvarchar80
103OIU_SB_MGKWMarketing Group Keep Whole6EFF_TO_DTEffective To Datenvarchar80
TOPRevenue
104OIUAR_RESPIDAccounts Receivable Responsibility ID6EFF_TO_DTEffective To Datenvarchar80
105OIUE2_RUN_HDRProc 2.0 - Run Header13EFF_TO_DTEffective To Datenvarchar80
106OIURV02_ADA_HDAlternative Dual Accounting Multipliers Header3EFF_TO_DTEnd Datenvarchar80
TOPRoyalty Reporting
107OIUREPP_LEASEMMS-2014 - Lease PPA7EFF_TO_DTEffective To Datenvarchar80
108OIUREPP_SALETYPEMMS-2014 - Sales Type PPA8EFF_TO_DTEffective To Datenvarchar80
109OIUREP_LEASEMMS-2014 - Lease7EFF_TO_DTEffective To Datenvarchar80
110OIUREP_MASTERRegulatory Reporting Master Data7EFF_TO_DTEffective To Datenvarchar80
111OIUREP_MASTER_MPRe.Reporting - MP related Reg ID6EFF_TO_DTEffective To Datenvarchar80
112OIUREP_PRPAYXREFMMS-2014 - Property / Payor XRef6EFF_TO_DTEffective To Datenvarchar80
113OIUREP_REG_OPERRegulatory Reporting Operator and Contact Xref EFF Dated9EFF_TO_DTEffective To Datenvarchar80
114OIUREP_SALESTYPEMMS-2014 - Sales Type8EFF_TO_DTEffective To Datenvarchar80
115OIUREP_WCPAYXREFMMS-2014 - Well Completion / Payor XRef5EFF_TO_DTEffective To Datenvarchar80
116OIUY1_GEN_CD_VALMaintain Code with Effective Dated8EFF_TO_DTEffective To Datenvarchar80
TOPTax Reporting
117OIUX3Y_TX_BATXIDTax Reporting - Texas BA Tax ID PPN6EFF_TO_DTEffective To Datenvarchar80
118OIUX3Y_TX_MASTERTax Reporting - Texas Master Data PPN11EFF_TO_DTEffective To Datenvarchar80
119OIUX3_RPT_PROFTax Reporting - Reporting Profile5EFF_TO_DTEffective To Datenvarchar80
120OIUX3_TX_BATXIDTax Reporting - Texas BA Tax ID5EFF_TO_DTEffective To Datenvarchar80
121OIUX3_TX_MASTERTax Reporting - Texas Master Data10EFF_TO_DTEffective To Datenvarchar80
122OIUX4_RESP_IDTaxes Payable Responsibility ID8EFF_TO_DTEffective To Datenvarchar80
123OIUX5Y_OK_BATXIDTax 2.0 - Oklahoma BA Tax ID PPN6EFF_TO_DTEffective To Datenvarchar80
124OIUX5Y_OK_MASTERTax 2.0 - Oklahoma Master Data PPN10EFF_TO_DTEffective To Datenvarchar80
125OIUX5_OK_BATXIDTax 2.0 - Oklahoma BA Tax ID5EFF_TO_DTEffective To Datenvarchar80
126OIUX5_OK_MASTERTax 2.0 - Oklahoma Master Data9EFF_TO_DTEffective To Datenvarchar80
127OIUX6Y_WY_BAOPIDTax 2.0 - Wyoming BA Operator ID PPN6EFF_TO_DTEffective To Datenvarchar80
128OIUX6Y_WY_MASTERTax 2.0 - Wyoming Master Data PPN10EFF_TO_DTEffective To Datenvarchar80
129OIUX6_WY_BAOPIDTax 2.0 - Wyoming BA Operator ID5EFF_TO_DTEffective To Datenvarchar80
130OIUX6_WY_LCDOVRTax 2.0 - Wyoming Lease Condensate Override9EFF_TO_DTEffective To Datenvarchar80
131OIUX6_WY_MASTERTax 2.0 - Wyoming Master Data10EFF_TO_DTEffective To Datenvarchar80
132OIUX6_WY_RATE_CDTax 2.0 - Wyoming Rate Codes4EFF_TO_DTEffective To Datenvarchar80
133OIUX6_WY_STAX_RTTax 2.0 - Wyoming Severance Rate Codes5EFF_TO_DTEffective To Datenvarchar80
134OIUX7_WY_MKTOVRTax 2.0 - WYGP Marketing Type Xref Override7EFF_TO_DTEffective To Datenvarchar80
TOPValuation
135OIURV_DOC_RUNTKTValuation Transaction - Run Ticket8EFF_TO_DTEffective To Datenvarchar80
136OIURV_TAXCONFHState tax configuration header8EFF_TO_DTEffective To Datenvarchar80
137OIURV_TCDTax calculation data10EFF_TO_DTEffective To Datenvarchar80
138OIUVL_GASRPTDGas statement report detail8EFF_TO_DTEffective To Datenvarchar80
139OIUVL_MTAHMarketing Cost Tax Exemption - Header9EFF_TO_DTEffective To Datenvarchar80
140OIUVL_OILRPTDOil statement report detail6EFF_TO_DTEffective To Datenvarchar80
141OIUVL_OILTKT_CUROil Ticket Detail8EFF_TO_DTEffective To Datenvarchar80
142OIUVL_OILTKT_HSTOil Ticket Current8EFF_TO_DTEffective To Datenvarchar80
143OIUVL_PLTRWeighted average plant reimbursement header4EFF_TO_DTEffective To Datenvarchar80
144OIUVL_RPAHRoyalty Processing Allowance Header6EFF_TO_DTEffective To Datenvarchar80
145OIUVL_STTRState Tax Rates10EFF_TO_DTEffective To Datenvarchar80
146OIUVL_TCJVTax Class - Venture DOI's7EFF_TO_DTEffective To Datenvarchar80
147OIUVL_TCMPTax Class Measurement Points5EFF_TO_DTEffective To Datenvarchar80
148OIUVL_TCWCTax Class - Well Completion6EFF_TO_DTEffective To Datenvarchar80
149OIUVL_TPAHTax Processing Allowance7EFF_TO_DTEffective To Datenvarchar80