	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

108 columns | ERP 6.0 | SALES_DT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	OIUX8_NM_OOSHST	Tax 2.0 - NM - Out-Of-Statute Transaction History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
2	OIUX8_NM_OOSTXN	Tax 2.0 - NM - Out-Of-Statute Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
3	OIUX8_NM_PRDT	Tax 2.0 - NM - PRA Detail Transactions	4	SALES_DT	Sales Date / Month	nvarchar	8	0
4	OIUX8_NM_REVSTG	Tax 2.0 - NM - Tax Reversals (Staging)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
5	OIUX8_NM_REVTXN	Tax 2.0 - NM - Tax Reversals	3	SALES_DT	Sales Date / Month	nvarchar	8	0
6	OIUX8_NM_SOL	Tax 2.0 - NM - Statute of Limitation	5	SALES_DT	Sales Date / Month	nvarchar	8	0
7	OIUX8_NM_TAXHST	Tax 2.0 - NM - Tax Transaction History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
8	OIUX8_NM_TAXSTG	Tax 2.0 - NM - Tax Transactions (Staging)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
9	OIUX8_NM_TAXTXN	Tax 2.0 - NM - Tax Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
10	OIUY3_MIG_DN	Royalty 2.0 - TX GLO/A&M - Migration - DNs	4	SALES_DT	Sales Date / Month	nvarchar	8	0
11	OIUY3_TX_INTSTG	Royalty 2.0 - TX GLO - Royalty Trans Interface Staging	7	SALES_DT	Sales Date / Month	nvarchar	8	0
12	OIUY3_TX_INTTXN	Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface	7	SALES_DT	Sales Date / Month	nvarchar	8	0
13	OIUY3_TX_OOSHST	Royalty 2.0 - TX - Out of Statute Royalty Transaction Hist	3	SALES_DT	Sales Date / Month	nvarchar	8	0
14	OIUY3_TX_OOSTXN	Royalty 2.0 - TX GLO - Out of Statute Royalty Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
15	OIUY3_TX_OPSL	Roy 2.0 TX - OPSL Summary Data for a Run	7	SALES_DT	Sales Date / Month	nvarchar	8	0
16	OIUY3_TX_PRDT	Royalty 2.0 - TX GLO - Royalty PRA Details	4	SALES_DT	Sales Date / Month	nvarchar	8	0
17	OIUY3_TX_PRDTA	Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated)	4	SALES_DT	Sales Date / Month	nvarchar	8	0
18	OIUY3_TX_REVSTG	Royalty 2.0 - TX GLO - Royalty Reversals (Staging)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
19	OIUY3_TX_REVTXN	Royalty 2.0 - TX GLO - Royalty Reversals	3	SALES_DT	Sales Date / Month	nvarchar	8	0
20	OIUY3_TX_ROYHST	Royalty 2.0 - TX GLO - Royalty Transaction History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
21	OIUY3_TX_ROYHSTA	Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
22	OIUY3_TX_ROYSTG	Royalty 2.0 - TX GLO - Royalty Transactions (Staging)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
23	OIUY3_TX_ROYTXN	Royalty 2.0 - TX GLO - Royalty Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
24	OIUY3_TX_ROYTXNA	Royalty 2.0 - TX GLO - Royalty Transactions (Allocated)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
25	OIUY3_TX_RPDTM	Royalty 2.0 - TX GLO/TAMU - Report Detail - Masters	17	SALES_DT	Sales Date / Month	nvarchar	8	0
26	OIUY3_TX_RPDTP	Royalty 2.0 - TX GLO/TAMU- Report Detail - Production	13	SALES_DT	Sales Date / Month	nvarchar	8	0
27	OIUY3_TX_SOL	Royalty 2.0 - Texas GLO Statute of Limitation	7	SALES_DT	Sales Date / Month	nvarchar	8	0
28	OIUY6_MIG_DN	Royalty 2.0 - WY - Migration - DNs	4	SALES_DT	Sales Date / Month	nvarchar	8	0
29	OIUY6_WY_INTSTG	Royalty 2.0 - WY - Royalty Transaction Interface (Staging)	7	SALES_DT	Sales Date / Month	nvarchar	8	0
30	OIUY6_WY_INTTXN	Royalty 2.0 - WY - Royalty Transaction Interface	7	SALES_DT	Sales Date / Month	nvarchar	8	0
31	OIUY6_WY_OOSHST	Royalty 2.0 - WY - Out of Statute Royalty Transaction Hist	3	SALES_DT	Sales Date / Month	nvarchar	8	0
32	OIUY6_WY_OOSTXN	Royalty 2.0 - WY - Out of Statute Royalty Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
33	OIUY6_WY_OPSL	Roy 2.0 WY - OPSL Summary Data for a Run	7	SALES_DT	Sales Date / Month	nvarchar	8	0
34	OIUY6_WY_PRDT	Royalty 2.0 - WY - Royalty PRA Details	4	SALES_DT	Sales Date / Month	nvarchar	8	0
35	OIUY6_WY_PRDTA	Royalty 2.0 - WY - Royalty PRA Details (Allocated)	4	SALES_DT	Sales Date / Month	nvarchar	8	0
36	OIUY6_WY_REVSTG	Royalty 2.0 - WY - Royalty Reversals (Staging)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
37	OIUY6_WY_REVTXN	Royalty 2.0 - WY - Royalty Reversals	3	SALES_DT	Sales Date / Month	nvarchar	8	0
38	OIUY6_WY_ROYHST	Royalty 2.0 - WY - Royalty Transaction History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
39	OIUY6_WY_ROYHSTA	Royalty 2.0 - WY - Royalty Transaction History (Allocated)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
40	OIUY6_WY_ROYSTG	Royalty 2.0 - WY - Royalty Transactions (Staging)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
41	OIUY6_WY_ROYTXN	Royalty 2.0 - WY - Royalty Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
42	OIUY6_WY_ROYTXNA	Royalty 2.0 - WY - Royalty Transactions (Allocated)	3	SALES_DT	Sales Date / Month	nvarchar	8	0
43	OIUY6_WY_RPDTC	Royalty 2.0 - WY - Lease/Unit Report Detail - CA	16	SALES_DT	Sales Date / Month	nvarchar	8	0
44	OIUY6_WY_RPDTM	Royalty 2.0 - WY - Lease/Unit Report Detail - Masters	17	SALES_DT	Sales Date / Month	nvarchar	8	0
45	OIUY6_WY_RPDTP	Royalty 2.0 - WY - Lease/Unit Report Detail - Production	12	SALES_DT	Sales Date / Month	nvarchar	8	0
46	OIUY6_WY_SOL	Royalty 2.0 - Wyoming Statute of Limitation	7	SALES_DT	Sales Date / Month	nvarchar	8	0
TOPProduction and Revenue Accounting
47	OIU_DO_TRGRI	Tract Gross Revenue Interest	5	SALES_DT	Sales Date / Month	nvarchar	8	0
TOPTax Reporting
48	OIUX3_TX_OOSHST	Tax Reporting - Texas Out Of Statute Transaction History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
49	OIUX3_TX_OOSTXN	Tax Reporting - Texas Out Of Statute Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
50	OIUX3_TX_PRDTB	Tax Reporting - Texas PRA Detail Txns-Tier Tax Below	4	SALES_DT	Sales Date / Month	nvarchar	8	0
51	OIUX3_TX_PRDTI	Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental	4	SALES_DT	Sales Date / Month	nvarchar	8	0
52	OIUX3_TX_PRDTN	Tax Reporting - Texas PRA Detail Txns - No Tier Tax	4	SALES_DT	Sales Date / Month	nvarchar	8	0
53	OIUX3_TX_REVSTG	Tax Reporting - Texas Tax Transaction Reversal Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
54	OIUX3_TX_REVTXN	Tax Reporting - Texas Tax Transaction Reversals	3	SALES_DT	Sales Date / Month	nvarchar	8	0
55	OIUX3_TX_SOL	Tax Reporting - Statute of Limitation	6	SALES_DT	Sales Date / Month	nvarchar	8	0
56	OIUX3_TX_TAXHST	Tax Reporting - Texas Tax History Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
57	OIUX3_TX_TAXSTG	Tax Reporting - Texas Tax Transaction Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
58	OIUX3_TX_TAXTXN	Tax Reporting - Texas Tax Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
59	OIUX5_OK_OOSHST	Tax 2.0 - Oklahoma Out Of Statute Transactions History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
60	OIUX5_OK_OOSTXN	Tax 2.0 - Oklahoma Out Of Statute Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
61	OIUX5_OK_PRDT	Tax 2.0 - Oklahoma PRA Detail Tax Transactions	4	SALES_DT	Sales Date / Month	nvarchar	8	0
62	OIUX5_OK_PRDTC	Tax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count	4	SALES_DT	Sales Date / Month	nvarchar	8	0
63	OIUX5_OK_REVSTG	Tax 2.0 - Oklahoma Tax Reversals Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
64	OIUX5_OK_REVTXN	Tax 2.0 - Oklahoma Tax Reversals	3	SALES_DT	Sales Date / Month	nvarchar	8	0
65	OIUX5_OK_SOL	Tax 2.0 - Oklahoma Statute of Limitation	5	SALES_DT	Sales Date / Month	nvarchar	8	0
66	OIUX5_OK_TAXHST	Tax 2.0 - Oklahoma Tax Transactions History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
67	OIUX5_OK_TAXHSTC	Tax 2.0 - Oklahoma Tax Transactions History Multi-Counties	3	SALES_DT	Sales Date / Month	nvarchar	8	0
68	OIUX5_OK_TAXSTG	Tax 2.0 - Oklahoma Tax Transactions Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
69	OIUX5_OK_TAXTXN	Tax 2.0 - Oklahoma Tax Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
70	OIUX5_OK_TAXTXNC	Tax 2.0 - Oklahoma Tax Transactions Multiple Counties	3	SALES_DT	Sales Date / Month	nvarchar	8	0
71	OIUX6_WY_CAPRDT	Tax 2.0 - Wyoming Conservation CA PRA Detail Transactions	7	SALES_DT	Sales Date / Month	nvarchar	8	0
72	OIUX6_WY_CASTG	Tax 2.0 - Wyoming Conservation CA Transactions Staging	6	SALES_DT	Sales Date / Month	nvarchar	8	0
73	OIUX6_WY_CATXN	Tax 2.0 - Wyoming Conservation CA Transactions	6	SALES_DT	Sales Date / Month	nvarchar	8	0
74	OIUX6_WY_COOSHST	Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist	3	SALES_DT	Sales Date / Month	nvarchar	8	0
75	OIUX6_WY_COOSTXN	Tax 2.0 - Wyoming Out Of Statute Conservation Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
76	OIUX6_WY_CPRDT	Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions	4	SALES_DT	Sales Date / Month	nvarchar	8	0
77	OIUX6_WY_CREVSTG	Tax 2.0 - Wyoming Conservation Tax Reversals Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
78	OIUX6_WY_CREVTXN	Tax 2.0 - Wyoming Conservation Tax Reversals	3	SALES_DT	Sales Date / Month	nvarchar	8	0
79	OIUX6_WY_CRPDT	Tax 2.0 - Wyoming Conservation Tax Report Detail	4	SALES_DT	Sales Date / Month	nvarchar	8	0
80	OIUX6_WY_CRPDTDT	Tax 2.0 - Wyoming Conservation Tax Report Detail Detail	4	SALES_DT	Sales Date / Month	nvarchar	8	0
81	OIUX6_WY_CTAXHST	Tax 2.0 - Wyoming Conservation Tax Transactions History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
82	OIUX6_WY_CTAXSTG	Tax 2.0 - Wyoming Conservation Tax Transactions Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
83	OIUX6_WY_CTAXTXN	Tax 2.0 - Wyoming Conservation Tax Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
84	OIUX6_WY_FORM2	Tax 2.0 - Wyoming Conservation Summarized FORM 2 Data	3	SALES_DT	Sales Date / Month	nvarchar	8	0
85	OIUX6_WY_GTAXSTG	Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
86	OIUX6_WY_GTAXTXN	Tax 2.0 - Wyoming Gross Prod Tax Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
87	OIUX6_WY_SOL	Tax 2.0 - Wyoming Statute of Limitation	6	SALES_DT	Sales Date / Month	nvarchar	8	0
88	OIUX6_WY_SOOSHST	Tax 2.0 - Wyoming Out Of Statute Severance Trans History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
89	OIUX6_WY_SOOSTXN	Tax 2.0 - Wyoming Out Of Statute Severance Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
90	OIUX6_WY_SPRDT	Tax 2.0 - Wyoming Severance Tax PRA Detail Transactions	4	SALES_DT	Sales Date / Month	nvarchar	8	0
91	OIUX6_WY_SREVSTG	Tax 2.0 - Wyoming Severance Tax Reversals Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
92	OIUX6_WY_SREVTXN	Tax 2.0 - Wyoming Severance Tax Reversals	3	SALES_DT	Sales Date / Month	nvarchar	8	0
93	OIUX6_WY_STAXHST	Tax 2.0 - Wyoming Severance Tax Transactions History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
94	OIUX6_WY_STAXSTG	Tax 2.0 - Wyoming Severance Tax Transactions Staging	3	SALES_DT	Sales Date / Month	nvarchar	8	0
95	OIUX6_WY_STAXTXN	Tax 2.0 - Wyoming Severance Tax Transactions	3	SALES_DT	Sales Date / Month	nvarchar	8	0
96	OIUX7_WY_DN_CON	Tax 2.0 - WYGP DN Consistency	6	SALES_DT	Sales Date / Month	nvarchar	8	0
97	OIUX7_WY_GSALES	Tax 2.0 - WYGP Sales	3	SALES_DT	Sales Date / Month	nvarchar	8	0
98	OIUX7_WY_GSALHST	Tax 2.0 - WYGP Sales History	2	SALES_DT	Sales Date / Month	nvarchar	8	0
99	OIUX7_WY_GSALTXN	Tax 2.0 - WYGP Sales	2	SALES_DT	Sales Date / Month	nvarchar	8	0
100	OIUX7_WY_GTAX	Tax 2.0 - Wyoming Gross Prod Tax Transactions	4	SALES_DT	Sales Date / Month	nvarchar	8	0
101	OIUX7_WY_GTAXHST	Tax 2.0 - Wyoming Gross Prod Tax Transactions History	3	SALES_DT	Sales Date / Month	nvarchar	8	0
102	OIUX7_WY_GVOL	Tax 2.0 - WYGP Volume	3	SALES_DT	Sales Date / Month	nvarchar	8	0
103	OIUX7_WY_GVOLHST	Tax 2.0 - WYGP Volume History	2	SALES_DT	Sales Date / Month	nvarchar	8	0
104	OIUX7_WY_GVOLTXN	Tax 2.0 - WYGP Volumes	2	SALES_DT	Sales Date / Month	nvarchar	8	0
105	OIUXC_PP	Tax 2.0 - Parallel Processing Control	4	SALES_DT	Sales Date / Month	nvarchar	8	0
TOPValuation
106	OIURV_CRH_HST	Combined Run Header History	4	SALES_DT	OIUH_CHAR14	nvarchar	14	0
107	OIURV_DOC_OOBJE	Out Of Balance JEs	8	SALES_DT	OIUH_CHAR14	nvarchar	14	0
108	OIURV_DUAL_JEBR	Dual Accounting JE Backout / Rebook	7	SALES_DT	OIUH_CHAR14	nvarchar	14	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

108 columns | ERP 6.0 | SALES_DT