	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

121 columns | ERP 6.0 | VL_TYPE_CD

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	OIUX8_NM_OOSHST	Tax 2.0 - NM - Out-Of-Statute Transaction History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
2	OIUX8_NM_OOSTXN	Tax 2.0 - NM - Out-Of-Statute Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
3	OIUX8_NM_PDCXRF	Tax 2.0 - NM - Product Code Xref	3	VL_TYPE_CD	Volume type code	nvarchar	2	0
4	OIUX8_NM_PRDT	Tax 2.0 - NM - PRA Detail Transactions	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
5	OIUX8_NM_TAXHST	Tax 2.0 - NM - Tax Transaction History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
6	OIUX8_NM_TAXSTG	Tax 2.0 - NM - Tax Transactions (Staging)	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
7	OIUX8_NM_TAXTXN	Tax 2.0 - NM - Tax Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
8	OIUY3_TX_INTSTG	Royalty 2.0 - TX GLO - Royalty Trans Interface Staging	16	VL_TYPE_CD	Volume type code	nvarchar	2	0
9	OIUY3_TX_INTTXN	Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface	16	VL_TYPE_CD	Volume type code	nvarchar	2	0
10	OIUY3_TX_OOSHST	Royalty 2.0 - TX - Out of Statute Royalty Transaction Hist	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
11	OIUY3_TX_OOSTXN	Royalty 2.0 - TX GLO - Out of Statute Royalty Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
12	OIUY3_TX_PRDT	Royalty 2.0 - TX GLO - Royalty PRA Details	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
13	OIUY3_TX_PRDTA	Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated)	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
14	OIUY3_TX_RDCXRF	Royalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef	5	VL_TYPE_CD	Volume type code	nvarchar	2	0
15	OIUY3_TX_ROYHST	Royalty 2.0 - TX GLO - Royalty Transaction History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
16	OIUY3_TX_ROYHSTA	Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
17	OIUY3_TX_ROYSTG	Royalty 2.0 - TX GLO - Royalty Transactions (Staging)	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
18	OIUY3_TX_ROYTXN	Royalty 2.0 - TX GLO - Royalty Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
19	OIUY3_TX_ROYTXNA	Royalty 2.0 - TX GLO - Royalty Transactions (Allocated)	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
20	OIUY6_WY_INTSTG	Royalty 2.0 - WY - Royalty Transaction Interface (Staging)	16	VL_TYPE_CD	Volume type code	nvarchar	2	0
21	OIUY6_WY_INTTXN	Royalty 2.0 - WY - Royalty Transaction Interface	16	VL_TYPE_CD	Volume type code	nvarchar	2	0
22	OIUY6_WY_OOSHST	Royalty 2.0 - WY - Out of Statute Royalty Transaction Hist	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
23	OIUY6_WY_OOSTXN	Royalty 2.0 - WY - Out of Statute Royalty Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
24	OIUY6_WY_PRDT	Royalty 2.0 - WY - Royalty PRA Details	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
25	OIUY6_WY_PRDTA	Royalty 2.0 - WY - Royalty PRA Details (Allocated)	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
26	OIUY6_WY_ROYHST	Royalty 2.0 - WY - Royalty Transaction History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
27	OIUY6_WY_ROYHSTA	Royalty 2.0 - WY - Royalty Transaction History (Allocated)	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
28	OIUY6_WY_ROYSTG	Royalty 2.0 - WY - Royalty Transactions (Staging)	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
29	OIUY6_WY_ROYTXN	Royalty 2.0 - WY - Royalty Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
30	OIUY6_WY_ROYTXNA	Royalty 2.0 - WY - Royalty Transactions (Allocated)	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
31	OIU_RV_LOAD_OIL	Valuation Load Oil Transactions	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
TOPCheck Input
32	OIUCI_JE	Incoming Check Journalized. Temporary hold	22	VL_TYPE_CD	Volume Type	nvarchar	2	0
TOPCheck Write
33	OIUCW_EXTD	Extended Details from Payment Run	19	VL_TYPE_CD	Volume Type	nvarchar	2	0
34	OIUCW_PAYMENT	Payment Details from Payment Run	12	VL_TYPE_CD	Volume Type	nvarchar	2	0
35	OIU_CW_SUM_PAY	Summarized Payable Table for Check Write	16	VL_TYPE_CD	Volume Type	nvarchar	2	0
TOPOwnership
36	OIUOW_DOACC	DOI Owner Override Account Codes	6	VL_TYPE_CD	Volume type code	nvarchar	2	0
37	OIUOW_DOACC_WK	DOI Owner Override Account Codes Worktable	6	VL_TYPE_CD	Volume type code	nvarchar	2	0
TOPProduction and Revenue Accounting
38	OIUREP_TAXBACKUP	Backup tax table for old tax reporting SOL	14	VL_TYPE_CD	Volume type code	nvarchar	2	0
39	OIUREP_TIKBACKUP	Backup tik table for old tax reporting SOL	14	VL_TYPE_CD	Volume type code	nvarchar	2	0
40	OIU_CM_VLTYPGRP	Volume Category Type Group	3	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
41	OIU_PR_VLTCX	Volume Type Xref To Volume Category	1	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
42	OIU_PR_VLTYP	Volume Type Table - Tblcm010	1	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
43	OIU_PR_VLTYP_TX	Volume Type Table - Tblcm010 - Text	2	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
44	OIU_PR_VTRCLS	Volume Type Gas Lift Gas Reclassification	2	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
45	OIU_PR_VTXRG	VOLUME TYPE XREF TO REPRODUCED GAS - TBLCM042	2	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
46	OIU_RV_FRML	Valuation Formula Id	5	VL_TYPE_CD	Volume type code	nvarchar	2	0
47	OIU_RV_MULT_DN	Multiple DN for same well	8	VL_TYPE_CD	Volume type code	nvarchar	2	0
TOPRevenue
48	OIUE1_LSSL_SUM	Legal Suspense Summary	20	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
49	OIUE2_ESCH_DTL	Proc 2.0 - Escheat - Owner Details	21	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
50	OIUE2_ESCH_DTLH	Proc 2.0 - Escheat - Owner Detail History	21	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
51	OIUE2_ESCROW_DTL	Proc 2.0 - WY Escrow - Owner Details	21	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
52	OIUE2_JEINTF	Proc 2.0 - JE Interface Table	23	VL_TYPE_CD	Volume Type	nvarchar	2	0
53	OIUH_RV_ARINTF	PRA Journal Entries to A/R interface table	21	VL_TYPE_CD	Volume Type	nvarchar	2	0
54	OIUH_RV_JEINTF	PRA Journal Entries	22	VL_TYPE_CD	Volume Type	nvarchar	2	0
55	OIUH_RV_TCD	Tax Calc Data	3	VL_TYPE_CD	Volume type code	nvarchar	2	0
56	OIURV03_DTL_ZE	Valuation Transactions Level 1 - Zero Volume	22	VL_TYPE_CD	Volume type code	nvarchar	2	0
57	OIURV03_VOLDTL	Valuation Transaction Level 2 -Volume	39	VL_TYPE_CD	Volume type code	nvarchar	2	0
TOPRoyalty Reporting
58	OIUREP_MMS_REJS	MMS-2014 - Extraction Rejects	95	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
59	OIUREP_RTPEND	MMS-2014 - Royalty Transaction Pending	94	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
60	OIUREP_RT_HIST	MMS-2014 - Royalty Transaction (Pending) History	94	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
TOPTax Reporting
61	OIUX1_ADJ_TAXHC	Tax adjustments header for reporting	11	VL_TYPE_CD	Volume type code	nvarchar	2	0
62	OIUX1_TRN_TAXHC	Tax transaction header for reporting	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
63	OIUX1_TRN_TAXHL	Tax transaction header for reporting	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
64	OIUX3_JEINTF	Tax Reporting - JE Interface Table	16	VL_TYPE_CD	Volume Type	nvarchar	2	0
65	OIUX3_TX_COMXRF	Tax Reporting - Texas Commodity XRef	3	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
66	OIUX3_TX_OOSHST	Tax Reporting - Texas Out Of Statute Transaction History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
67	OIUX3_TX_OOSTXN	Tax Reporting - Texas Out Of Statute Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
68	OIUX3_TX_PRDTB	Tax Reporting - Texas PRA Detail Txns-Tier Tax Below	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
69	OIUX3_TX_PRDTI	Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
70	OIUX3_TX_PRDTN	Tax Reporting - Texas PRA Detail Txns - No Tier Tax	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
71	OIUX3_TX_REVSTG	Tax Reporting - Texas Tax Transaction Reversal Staging	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
72	OIUX3_TX_REVTXN	Tax Reporting - Texas Tax Transaction Reversals	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
73	OIUX3_TX_TAXHST	Tax Reporting - Texas Tax History Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
74	OIUX3_TX_TAXSTG	Tax Reporting - Texas Tax Transaction Staging	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
75	OIUX3_TX_TAXTXN	Tax Reporting - Texas Tax Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
76	OIUX5_OK_OOSHST	Tax 2.0 - Oklahoma Out Of Statute Transactions History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
77	OIUX5_OK_OOSTXN	Tax 2.0 - Oklahoma Out Of Statute Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
78	OIUX5_OK_PRDT	Tax 2.0 - Oklahoma PRA Detail Tax Transactions	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
79	OIUX5_OK_PRDTC	Tax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
80	OIUX5_OK_TAXHST	Tax 2.0 - Oklahoma Tax Transactions History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
81	OIUX5_OK_TAXHSTC	Tax 2.0 - Oklahoma Tax Transactions History Multi-Counties	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
82	OIUX5_OK_TAXSTG	Tax 2.0 - Oklahoma Tax Transactions Staging	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
83	OIUX5_OK_TAXTXN	Tax 2.0 - Oklahoma Tax Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
84	OIUX5_OK_TAXTXNC	Tax 2.0 - Oklahoma Tax Transactions Multiple Counties	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
85	OIUX6_WY_COOSHST	Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
86	OIUX6_WY_COOSTXN	Tax 2.0 - Wyoming Out Of Statute Conservation Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
87	OIUX6_WY_CPRDT	Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
88	OIUX6_WY_CTAXHST	Tax 2.0 - Wyoming Conservation Tax Transactions History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
89	OIUX6_WY_CTAXSTG	Tax 2.0 - Wyoming Conservation Tax Transactions Staging	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
90	OIUX6_WY_CTAXTXN	Tax 2.0 - Wyoming Conservation Tax Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
91	OIUX6_WY_GTAXSTG	Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
92	OIUX6_WY_GTAXTXN	Tax 2.0 - Wyoming Gross Prod Tax Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
93	OIUX6_WY_SOOSHST	Tax 2.0 - Wyoming Out Of Statute Severance Trans History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
94	OIUX6_WY_SOOSTXN	Tax 2.0 - Wyoming Out Of Statute Severance Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
95	OIUX6_WY_SPRDT	Tax 2.0 - Wyoming Severance Tax PRA Detail Transactions	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
96	OIUX6_WY_STAXHST	Tax 2.0 - Wyoming Severance Tax Transactions History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
97	OIUX6_WY_STAXSTG	Tax 2.0 - Wyoming Severance Tax Transactions Staging	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
98	OIUX6_WY_STAXTXN	Tax 2.0 - Wyoming Severance Tax Transactions	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
99	OIUX7_WY_GTAX	Tax 2.0 - Wyoming Gross Prod Tax Transactions	13	VL_TYPE_CD	Volume type code	nvarchar	2	0
100	OIUX7_WY_GTAXHST	Tax 2.0 - Wyoming Gross Prod Tax Transactions History	12	VL_TYPE_CD	Volume type code	nvarchar	2	0
101	OIUX7_WY_GVOL	Tax 2.0 - WYGP Volume	8	VL_TYPE_CD	Volume type code	nvarchar	2	0
102	OIUX7_WY_GVOLHST	Tax 2.0 - WYGP Volume History	7	VL_TYPE_CD	Volume type code	nvarchar	2	0
103	OIUX7_WY_GVOLTXN	Tax 2.0 - WYGP Volumes	7	VL_TYPE_CD	Volume type code	nvarchar	2	0
104	OIUX7_WY_PDVLXRF	Tax 2.0 - WYGP Product Code/Volume Type/Product Type Xref	3	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
105	OIUX7_WY_VLXRF	Tax 2.0 - WYGP Volume Type Xref	2	VL_TYPE_CD	Volume Type Code	nvarchar	2	0
TOPValuation
106	OIURV_DOC_DTL_ZE	Valuation Transactions Level 1 - Zero Volume	22	VL_TYPE_CD	Volume type code	nvarchar	2	0
107	OIURV_DOC_JEINTF	Revenue Document Concept - JEINTF temp table	24	VL_TYPE_CD	Volume Type	nvarchar	2	0
108	OIURV_DOC_RDSUM	RD summary(VL interface records to RD)	52	VL_TYPE_CD	Volume type code	nvarchar	2	0
109	OIURV_DOC_VOLDTL	Valuation Transaction Level 2 -Volume	39	VL_TYPE_CD	Volume type code	nvarchar	2	0
110	OIURV_DOC_VOLUNT	Valuation Document Concept - Volume Unit	11	VL_TYPE_CD	Volume type code	nvarchar	2	0
111	OIURV_SSTD	Settlement statement detail	18	VL_TYPE_CD	Volume type code	nvarchar	2	0
112	OIURV_TAXCONFD	State tax configuration detail	4	VL_TYPE_CD	Volume type code	nvarchar	2	0
113	OIURV_TAXCONFH	State tax configuration header	4	VL_TYPE_CD	Volume type code	nvarchar	2	0
114	OIURV_TCD	Tax calculation data	6	VL_TYPE_CD	Volume type code	nvarchar	2	0
115	OIUVL_GASDTL_CUR	Gas statement Detail	11	VL_TYPE_CD	Volume type code	nvarchar	2	0
116	OIUVL_GASDTL_HST	Gas statement Detail	11	VL_TYPE_CD	Volume type code	nvarchar	2	0
117	OIUVL_GASRPTD	Gas statement report detail	9	VL_TYPE_CD	Volume type code	nvarchar	2	0
118	OIUVL_OILRPTD	Oil statement report detail	7	VL_TYPE_CD	Volume type code	nvarchar	2	0
119	OIUVL_SCAUDIT	Settlement statement batch	18	VL_TYPE_CD	Volume type code	nvarchar	2	0
120	OIUVL_SEV	Severance tax	4	VL_TYPE_CD	Volume type code	nvarchar	2	0
121	OIUVL_TTVLTY	Tier tax volume type	3	VL_TYPE_CD	Volume type code	nvarchar	2	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

121 columns | ERP 6.0 | VL_TYPE_CD