	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

149 columns | ERP 6.0 | EFF_TO_DT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	OIUX6Y_WY_MSTPLT	Tax 2.0 - Wyoming Plant Master Data PPN	12	EFF_TO_DT	Effective To Date	nvarchar	8	0
2	OIUX6_WY_MSTPLT	Tax 2.0 - Wyoming Plant Master Data	11	EFF_TO_DT	Effective To Date	nvarchar	8	0
3	OIUX8Y_NM_MASTER	Tax 2.0 - NM - Master Data PPN	11	EFF_TO_DT	Effective To Date	nvarchar	8	0
4	OIUX8_NM_MASTER	Tax 2.0 - NM - Master Data	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
5	OIUX8_NM_SUFFDEC	Tax 2.0 - New Mexico Suffix Decimal	12	EFF_TO_DT	Effective To Date	nvarchar	8	0
6	OIUX8_NM_SUFFXRF	Tax 2.0 - New Mexico Suffix and tax rate x-ref	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
7	OIUY3Y_TX_MASTER	Royalty 2.0 - TX GLO/TAMU - Master Data PPN	13	EFF_TO_DT	Effective To Date	nvarchar	8	0
8	OIUY3Y_TX_RRC	Royalty 2.0 - TX GLO/TAMU - RRC Master PPN	11	EFF_TO_DT	Effective To Date	nvarchar	8	0
9	OIUY3_TX_BAXRF	Royalty 2.0 - TX GLO/TAU - BA Xref	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
10	OIUY3_TX_MASTER	Royalty 2.0 - TX GLO/TAMU - Master Data	12	EFF_TO_DT	Effective To Date	nvarchar	8	0
11	OIUY3_TX_OWNOVR	Royalty 2.0 - TX GLO/TAMU Owner Level Reporting Override	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
12	OIUY3_TX_RRC	Royalty 2.0 - TX GLO/TAMU - RRC Master	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
13	OIUY3_TX_UNIT	Royalty 2.0 - TX GLO - Unit Master	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
14	OIUY6Y_WY_MASTER	Royalty 2.0 - WY - Master Data PPN	13	EFF_TO_DT	Effective To Date	nvarchar	8	0
15	OIUY6_WY_MASTER	Royalty 2.0 - WY - Master Data	12	EFF_TO_DT	Effective To Date	nvarchar	8	0
16	OIUY6_WY_PRICE	Royalty 2.0 - WY - Report Pricing	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPBalancing
17	OIUBL01_PBA	Product Balancing Agreement	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
18	OIUBL01_PBAXREF	PBA to Well Completion/Measurement Point Cross-ref	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
19	OIUBL_PBAMP	Cross reference for measurement point and PBA	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
20	OIUBL_PBAWC	Cross Reference for Well Completion and PBA	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPCheck Input
21	OIUCI_PDX	Purchaser DOI Cross Reference	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
22	OIUCI_PDXLOCK	Incoming Check Usage of Property/DOI xref master data	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPContractual Allocation
23	OIUCA_CTMP	PRA: Transporter Contract Measurement Point XRef	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
24	OIUCA_CTWC	PRA: Transporter Contract Well Completion XRef	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
25	OIUCA_PRPH	Stores the Percent Returned to Producer Header Data	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
26	OIUCA_PSP	Plant Component Options for Selective Processing	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPOwnership
27	OIUOW_DOH_WK	Ownership History Workable	17	EFF_TO_DT	Effective To Date	nvarchar	8	0
28	OIUOW_DORH	DO Owner Request History	12	EFF_TO_DT	Effective To Date	nvarchar	8	0
29	OIUOW_DTCH	DOI Transfer Change Header	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
30	OIUOW_ESTDT	Escheated Transfer Date	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
31	OIUOW_ESTDT_WK	Escheated Transfer Date Worktable	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
32	OIUOW_INTOH	Interface Owner Header	11	EFF_TO_DT	Effective To Date	nvarchar	8	0
33	OIUOW_INTOH_WK	Interface Owner Header Worktable	11	EFF_TO_DT	Effective To Date	nvarchar	8	0
34	OIUOW_PUC_WK	Property Unit Use Control - work table	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
35	OIUOW_RETDT	Royalty Escrow Transfer Date	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
36	OIUOW_RETDT_WK	Royalty Escrow Transfer Date	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
37	OIUOW_RTCH	RD DOI Transfer Change Header	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
38	OIUOW_RTCH_WK	RD DOI Transfer Change Header Worktable	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
39	OIUOW_RTD	RD DOI Transferee Detail	16	EFF_TO_DT	Effective To Date	nvarchar	8	0
40	OIUOW_RTD_WK	RD DOI Transferee Detail Worktable	16	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPProduct Control
41	OIUPC_AVGRP	Availability Group Header	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPProduction
42	OIUPR_SSH	Supply Source Header	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPProduction and Revenue Accounting
43	OIUP_PR_MPVL	PRA: Measurement Point Volumetric Data (PDM Shadow)	20	EFF_TO_DT	Effective To Date	nvarchar	8	0
44	OIUP_PR_WCDVLH	WC Disposition Volumes Header (PDM Shadow)	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
45	OIU_DO_BGUC	Bearer Group Use Control	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
46	OIU_DO_BGUC_WK	Bearer Group Use Control	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
47	OIU_DO_DO	Division of Interest Ownership	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
48	OIU_DO_DOH	Ownership History	17	EFF_TO_DT	Effective To Date	nvarchar	8	0
49	OIU_DO_DO_WK	Division of Interest Ownership Worktable	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
50	OIU_DO_DP	DOI Accounting Information	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
51	OIU_DO_DPIC	DOI Product Interest Control	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
52	OIU_DO_DPIC_WK	DOI Product Interest Control	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
53	OIU_DO_DPUC	DOI Product Use Control	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
54	OIU_DO_DPUC_WK	DOI Product Use Control	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
55	OIU_DO_PUC	Property Unit Use Control	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
56	OIU_PR_CHAH	Chemical Analysis Header	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
57	OIU_PR_CHATH	Component Typification Header	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
58	OIU_PR_CTPAMH	Contract to Gas Plant Allocation Method Xref Header	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
59	OIU_PR_CUSPAMH	Custom Plant Allocation Methods Header	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
60	OIU_PR_CXREF	Component Crossreference	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
61	OIU_PR_DNAPH	Network Allocation Profile Header	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
62	OIU_PR_DNTCM	Delivery Network Theoretical Calculation Method	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
63	OIU_PR_DNVD	Delivery Network Variable Data	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
64	OIU_PR_DN_LINK	Delivery Network Links	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
65	OIU_PR_FRMH	Formula Rules Maintenance Header	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
66	OIU_PR_LWGOR	Lease Wide Gas/Oil Ratio	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
67	OIU_PR_MPALB	PRA: Measurement Point Allocation Base	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
68	OIU_PR_MPAPH	Measure Point Allocation Profile Header	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
69	OIU_PR_MPFUSH	Measure Point Fuel Use Specification	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
70	OIU_PR_MPHV	Measurement Point Heating Value	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
71	OIU_PR_MPRMAT	Measurement Point Reproduced Materials	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
72	OIU_PR_MPTRNH	PRA: Measurement Point Transporter Xref	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
73	OIU_PR_MPVD	PRA: Measurement Point Variable Data	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
74	OIU_PR_MPVL	PRA: Measurement Point Volumetric Data	19	EFF_TO_DT	Effective To Date	nvarchar	8	0
75	OIU_PR_TWCDVH	Temporary Well Completion Volumes	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
76	OIU_PR_WCALB	PRA: Well Completion Allocation Base	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
77	OIU_PR_WCDHH	Downhole Commingled Well Completion	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
78	OIU_PR_WCDVLH	Well Completion Disposition Volumes Header	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
79	OIU_PR_WCHAH	PRA: Weighted Average Chemical Analysis Header	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
80	OIU_PR_WCHV	Well Completion Heading Value	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
81	OIU_PR_WCOLH	PRA: Well Completion Offset Lease	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
82	OIU_PR_WCRMAT	Well Completion Reproduced Materials	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
83	OIU_PR_WCSSH	Well Completion Supply Source Dated Header	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
84	OIU_PR_WCTCM	PRA: Well Completion Theoretical Calculation Method	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
85	OIU_PR_WCTRNH	PRA: Well Completion Transporter Xref	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
86	OIU_PR_WCVD	Well Completion Variable Data	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
87	OIU_RV_CGPT	Contract General Price Terms	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
88	OIU_RV_CMCC	Contract Marketing Cost Control Header	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
89	OIU_RV_CPTR	Contract Product Tax Reimbursement Header	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
90	OIU_RV_DMCH	Property/DOI Marketing Cost Header	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
91	OIU_RV_FRMLD	Valuation Formula Detail	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
92	OIU_RV_GRVD	Gravity Scale Adjustment Detail	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
93	OIU_RV_MR_MP	Marketing Rate Header for MP	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
94	OIU_RV_MR_WC	Marketing Rate Header for WC	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
95	OIU_RV_PBD	Price Bulletin Posting Table	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
96	OIU_RV_PDXSS	Settlement Statements/Purchaser - DOI Cross Reference	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
97	OIU_RV_TCLD	Tax Class	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
98	OIU_RV_VCR	Valuation Cross Reference	13	EFF_TO_DT	Effective To Date	nvarchar	8	0
99	OIU_SB_ACRH	header table for the Allocation Cross Reference	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
100	OIU_SB_DOIMP	Cross-reference for MP and DOI	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
101	OIU_SB_DOIWC	DOI/WC Cross Reference	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
102	OIU_SB_MGDD	Marketing Group Determination Detail	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
103	OIU_SB_MGKW	Marketing Group Keep Whole	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPRevenue
104	OIUAR_RESPID	Accounts Receivable Responsibility ID	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
105	OIUE2_RUN_HDR	Proc 2.0 - Run Header	13	EFF_TO_DT	Effective To Date	nvarchar	8	0
106	OIURV02_ADA_HD	Alternative Dual Accounting Multipliers Header	3	EFF_TO_DT	End Date	nvarchar	8	0
TOPRoyalty Reporting
107	OIUREPP_LEASE	MMS-2014 - Lease PPA	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
108	OIUREPP_SALETYPE	MMS-2014 - Sales Type PPA	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
109	OIUREP_LEASE	MMS-2014 - Lease	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
110	OIUREP_MASTER	Regulatory Reporting Master Data	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
111	OIUREP_MASTER_MP	Re.Reporting - MP related Reg ID	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
112	OIUREP_PRPAYXREF	MMS-2014 - Property / Payor XRef	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
113	OIUREP_REG_OPER	Regulatory Reporting Operator and Contact Xref EFF Dated	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
114	OIUREP_SALESTYPE	MMS-2014 - Sales Type	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
115	OIUREP_WCPAYXREF	MMS-2014 - Well Completion / Payor XRef	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
116	OIUY1_GEN_CD_VAL	Maintain Code with Effective Dated	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPTax Reporting
117	OIUX3Y_TX_BATXID	Tax Reporting - Texas BA Tax ID PPN	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
118	OIUX3Y_TX_MASTER	Tax Reporting - Texas Master Data PPN	11	EFF_TO_DT	Effective To Date	nvarchar	8	0
119	OIUX3_RPT_PROF	Tax Reporting - Reporting Profile	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
120	OIUX3_TX_BATXID	Tax Reporting - Texas BA Tax ID	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
121	OIUX3_TX_MASTER	Tax Reporting - Texas Master Data	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
122	OIUX4_RESP_ID	Taxes Payable Responsibility ID	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
123	OIUX5Y_OK_BATXID	Tax 2.0 - Oklahoma BA Tax ID PPN	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
124	OIUX5Y_OK_MASTER	Tax 2.0 - Oklahoma Master Data PPN	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
125	OIUX5_OK_BATXID	Tax 2.0 - Oklahoma BA Tax ID	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
126	OIUX5_OK_MASTER	Tax 2.0 - Oklahoma Master Data	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
127	OIUX6Y_WY_BAOPID	Tax 2.0 - Wyoming BA Operator ID PPN	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
128	OIUX6Y_WY_MASTER	Tax 2.0 - Wyoming Master Data PPN	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
129	OIUX6_WY_BAOPID	Tax 2.0 - Wyoming BA Operator ID	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
130	OIUX6_WY_LCDOVR	Tax 2.0 - Wyoming Lease Condensate Override	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
131	OIUX6_WY_MASTER	Tax 2.0 - Wyoming Master Data	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
132	OIUX6_WY_RATE_CD	Tax 2.0 - Wyoming Rate Codes	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
133	OIUX6_WY_STAX_RT	Tax 2.0 - Wyoming Severance Rate Codes	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
134	OIUX7_WY_MKTOVR	Tax 2.0 - WYGP Marketing Type Xref Override	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
TOPValuation
135	OIURV_DOC_RUNTKT	Valuation Transaction - Run Ticket	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
136	OIURV_TAXCONFH	State tax configuration header	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
137	OIURV_TCD	Tax calculation data	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
138	OIUVL_GASRPTD	Gas statement report detail	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
139	OIUVL_MTAH	Marketing Cost Tax Exemption - Header	9	EFF_TO_DT	Effective To Date	nvarchar	8	0
140	OIUVL_OILRPTD	Oil statement report detail	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
141	OIUVL_OILTKT_CUR	Oil Ticket Detail	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
142	OIUVL_OILTKT_HST	Oil Ticket Current	8	EFF_TO_DT	Effective To Date	nvarchar	8	0
143	OIUVL_PLTR	Weighted average plant reimbursement header	4	EFF_TO_DT	Effective To Date	nvarchar	8	0
144	OIUVL_RPAH	Royalty Processing Allowance Header	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
145	OIUVL_STTR	State Tax Rates	10	EFF_TO_DT	Effective To Date	nvarchar	8	0
146	OIUVL_TCJV	Tax Class - Venture DOI's	7	EFF_TO_DT	Effective To Date	nvarchar	8	0
147	OIUVL_TCMP	Tax Class Measurement Points	5	EFF_TO_DT	Effective To Date	nvarchar	8	0
148	OIUVL_TCWC	Tax Class - Well Completion	6	EFF_TO_DT	Effective To Date	nvarchar	8	0
149	OIUVL_TPAH	Tax Processing Allowance	7	EFF_TO_DT	Effective To Date	nvarchar	8	0

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

149 columns | ERP 6.0 | EFF_TO_DT