	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

154 columns | ERP 6.0 | AGENCY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPCollectionsDisbursements
1	ITAGCYAGENCYFI	Agency Collections: Data for Transfer to Agency FI	8	AGENCY	Business Partner Number	nvarchar	10	0
2	ITAGCYINSCOMPSH	Agency Collections: Shares to Be Transferred to Insurance	5	AGENCY	Business Partner Number	nvarchar	10	0
3	ITAGCYSUBCOMMTRG	Trigger Table for Posting and Transferring Subcommission	13	AGENCY	Business Partner Number	nvarchar	10	0
TOPCross-Application Components
4	SEMPLOYES_APP	Employees: Enhancement by Append (4)	10	AGENCY	Travel Agency Number	nvarchar	8	0
5	SEMPLOYES_RB	Employees: Enhancement by No. of Agency (2)	10	AGENCY	Travel Agency Number	nvarchar	8	0
6	SEMPLOYES_TI	Employees: Enhancement by Time Field in Include (3)	10	AGENCY	Travel Agency Number	nvarchar	8	0
TOPE-Recruiting
7	T77RCF_AGENCY	Agencies in E-Recruiting	2	AGENCY	Agency (Pointer)	nvarchar	10	0
TOPKnowledge Warehouse
8	IWADM	Data for KEN Administration	16	AGENCY	Translation agency	nvarchar	30	0
TOPLocalization
9	J_1BLFA1_REC55	Information for generating record type 55 referred to GNRE	8	AGENCY	Archivo Magnetico record 55: GNRE Bank Agency Number	nvarchar	4	0
TOPNon Profit Organizations
10	PA0963	HR Master Record: Infotype 0963	25	AGENCY	Agency	nvarchar	10	0
TOPProduction and Revenue Accounting
11	OIUREP_ARCROYHIS	Archived Reported Royalty and Volume Data	4	AGENCY	Agency for Reporting	nvarchar	3	0
12	OIUREP_ARCVOLHIS	Archived Reported Volume Data by Reporting Entities	4	AGENCY	Agency for Reporting	nvarchar	3	0
13	OIUREP_ENTTY_LOG	Log table for master data entity changes	3	AGENCY	Agency for Reporting	nvarchar	3	0
14	OIUREP_OWNER_LOG	Log for master Data Owner Changes	3	AGENCY	Agency for Reporting	nvarchar	3	0
15	OIUREP_PRFL_LOG	Log for master data profile changes	3	AGENCY	Agency for Reporting	nvarchar	3	0
16	OIUREP_ROYHISTBK	Backup table for OIUREP_ROYHIST	4	AGENCY	Agency for Reporting	nvarchar	3	0
17	OIUREP_VOLHISTBK	Backup table for OIUREP_VOLHIST	4	AGENCY	Agency for Reporting	nvarchar	3	0
18	OIUREP_ZERO_REJS	Rejection Criteria for Zero volume records	2	AGENCY	Agency for Reporting	nvarchar	3	0
19	OIUX1_ARCH_MKTH	Reporting history for marketing costs for reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
20	OIUX1_ARCH_TAXH	Tax transaction header for reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
21	OIUX1_ARCH_VOLH	Reported Volume Data by PUID	4	AGENCY	Agency for Reporting	nvarchar	3	0
22	OIUX1_ARCH_XMPH	Reporting history for tax exemptions	4	AGENCY	Agency for Reporting	nvarchar	3	0
23	OIUX1_RPT_LOG	Tax reporting log table for rpt	3	AGENCY	Agency for Reporting	nvarchar	3	0
24	OIUX2_DOWNLOAD	Tax Reporting download table	3	AGENCY	Agency for Reporting	nvarchar	3	0
25	OIUX2_EXEC_STATD	Execution Statistics for Tax Reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
26	OIUX2_LNK_LOG	Tax Reporting log table for the link	3	AGENCY	Agency for Reporting	nvarchar	3	0
27	OIUX2_PUIDLOG	Tax Reporting PUID log	3	AGENCY	Agency for Reporting	nvarchar	3	0
28	OIUX2_PUID_MKTH	Reporting history for marketing costs for reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
29	OIUX2_PUID_TAXH	Tax transaction header for reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
30	OIUX2_PUID_XMPH	Reporting history for tax exemptions	4	AGENCY	Agency for Reporting	nvarchar	3	0
31	OIUX2_RE_LOG	Tax Reporting log table for the Log	3	AGENCY	Agency for Reporting	nvarchar	3	0
32	OIUX2_RSG_LOG	Tax reporting log table for rpt	3	AGENCY	Agency for Reporting	nvarchar	3	0
33	OIUY1_DOWNLOAD	The intermediate table for download	3	AGENCY	Agency for Reporting	nvarchar	3	0
34	OIUY1_EXEC_STATD	Execution Statistics for Royalty Reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
35	OIUY1_TXDOWNLOAD	The intermediate table for Texas download	3	AGENCY	Agency for Reporting	nvarchar	3	0
TOPRoyalty Reporting
36	OIUREP_ACTIVATE	Reg./Tax and Royalty Reporting - report activation	5	AGENCY	Agency for Reporting	nvarchar	3	0
37	OIUREP_ADD_DATA	Regulatory Reporting Config for Additional Master Data	2	AGENCY	Agency for Reporting	nvarchar	3	0
38	OIUREP_ADJ_DTLA	MMS OGOR A Adjustment Detail Record	2	AGENCY	Agency for Reporting	nvarchar	3	0
39	OIUREP_ADJ_DTLB	MMS OGOR B Adjustment Detail Record	2	AGENCY	Agency for Reporting	nvarchar	3	0
40	OIUREP_ADJ_DTLC	MMS OGOR C Adjustment Detail Record	2	AGENCY	Agency for Reporting	nvarchar	3	0
41	OIUREP_ADJ_HDR	Adjustment Header for MMS OGOR	2	AGENCY	Agency for Reporting	nvarchar	3	0
42	OIUREP_ADJ_PASR	MMS PASR Adjustment Detail Record	2	AGENCY	Agency for Reporting	nvarchar	3	0
43	OIUREP_ADJ_PASRH	MMS PASR Adjustment Header Record	2	AGENCY	Agency for Reporting	nvarchar	3	0
44	OIUREP_AGENCIES	Regulatory Reporting Agencies	1	AGENCY	Agency for Reporting	nvarchar	3	0
45	OIUREP_AGENCYTX	Regulatory Reporting Agencies	2	AGENCY	Agency for Reporting	nvarchar	3	0
46	OIUREP_AGY_LSE	Agency assigned Leases	2	AGENCY	Agency for Reporting	nvarchar	3	0
47	OIUREP_AGY_LSETX	Text Table for Agency assigned Leases	3	AGENCY	Agency for Reporting	nvarchar	3	0
48	OIUREP_AGY_PCDTX	Agency defined Product Code Text	2	AGENCY	Agency for Reporting	nvarchar	3	0
49	OIUREP_AGY_PDCD	Agency defined Product Code	1	AGENCY	Agency for Reporting	nvarchar	3	0
50	OIUREP_AGY_VLTP	Agency defined Volume Types	1	AGENCY	Agency for Reporting	nvarchar	3	0
51	OIUREP_AGY_VTPTX	Text table for Agency defined Volume Type	2	AGENCY	Agency for Reporting	nvarchar	3	0
52	OIUREP_AMND_STAT	Report Execution statistics for amended months	4	AGENCY	Agency for Reporting	nvarchar	3	0
53	OIUREP_BA_MASTER	Regulatory reporting: BA table to drive Partner reporting	2	AGENCY	Agency for Reporting	nvarchar	3	0
54	OIUREP_CODE_CMLB	Regulatory Reporting Common Table List Box Setup	1	AGENCY	Agency for Reporting	nvarchar	3	0
55	OIUREP_CODE_COMA	Common table to convert SAP codes to Ag. codes Apl.Table	2	AGENCY	Agency for Reporting	nvarchar	3	0
56	OIUREP_CODE_COMN	Common table for converting SAP codes to Agency codes	2	AGENCY	Agency for Reporting	nvarchar	3	0
57	OIUREP_CODE_FLDS	Fields available for customizing	1	AGENCY	Agency for Reporting	nvarchar	3	0
58	OIUREP_CODE_FLDT	Descriptions for Code Fields	1	AGENCY	Agency for Reporting	nvarchar	3	0
59	OIUREP_CODE_RDNG	Reg Reporting Rounding Configuration	2	AGENCY	Agency for Reporting	nvarchar	3	0
60	OIUREP_CODE_RPTC	Report Columns available for customizing	1	AGENCY	Agency for Reporting	nvarchar	3	0
61	OIUREP_CODE_RULE	Reg Reporting Rules for Column Data	2	AGENCY	Agency for Reporting	nvarchar	3	0
62	OIUREP_CODE_VALS	Code Values available for customizing Reg Reporting	2	AGENCY	Agency for Reporting	nvarchar	3	0
63	OIUREP_CODE_VLTX	Code Value Texts	2	AGENCY	Agency for Reporting	nvarchar	3	0
64	OIUREP_CODE_XREF	Reg Reporting Product/Volume Type to Report Code Cross Ref	2	AGENCY	Agency for Reporting	nvarchar	3	0
65	OIUREP_COMN_KEYS	Reg.Reporting - Field description for COMN table keys	1	AGENCY	Agency for Reporting	nvarchar	3	0
66	OIUREP_DN_XREF	Regulatory Reporting X-ref for Delivery Networks	2	AGENCY	Agency for Reporting	nvarchar	3	0
67	OIUREP_EXEC_COMB	Possible Combinations of Royalty Executions	3	AGENCY	Agency for Reporting	nvarchar	3	0
68	OIUREP_EXEC_STAT	Report Execution Statistics	4	AGENCY	Agency for Reporting	nvarchar	3	0
69	OIUREP_EXT_COMP	External Company by State Agency	2	AGENCY	Agency for Reporting	nvarchar	3	0
70	OIUREP_EXT_COMTX	Text Table for External Company Code	3	AGENCY	Agency for Reporting	nvarchar	3	0
71	OIUREP_FIELDS	Regulatory Report Master Data set up	2	AGENCY	Agency for Reporting	nvarchar	3	0
72	OIUREP_FIELDSTX	Regulatory Report Master Data set up	2	AGENCY	Agency for Reporting	nvarchar	3	0
73	OIUREP_FIN_LEVEL	Regulatory Reporting Operator and Contact Xref	2	AGENCY	Agency for Reporting	nvarchar	3	0
74	OIUREP_GEN_DATA	Reg. Reporting - Generic Transactional data	2	AGENCY	Agency for Reporting	nvarchar	3	0
75	OIUREP_KEY_XREFD	Regulatory Reporting SAP Key Cross Reference Detail	1	AGENCY	Agency for Reporting	nvarchar	3	0
76	OIUREP_KEY_XREFH	Regulatory Reporting SAP Key Cross Reference Header	1	AGENCY	Agency for Reporting	nvarchar	3	0
77	OIUREP_LGL_RPTS	Legal Reports for Tax and Royalty Reporting	2	AGENCY	Agency for Reporting	nvarchar	3	0
78	OIUREP_MASTER	Regulatory Reporting Master Data	2	AGENCY	Agency for Reporting	nvarchar	3	0
79	OIUREP_MASTER_MP	Re.Reporting - MP related Reg ID	2	AGENCY	Agency for Reporting	nvarchar	3	0
80	OIUREP_MP_XREF	Regulatory Reporting X-ref - MP to State Assigned ID	2	AGENCY	Agency for Reporting	nvarchar	3	0
81	OIUREP_PDCD_XREF	Cross Reference Between State Agency and PRA Material	2	AGENCY	Agency for Reporting	nvarchar	3	0
82	OIUREP_REG_OPER	Regulatory Reporting Operator and Contact Xref EFF Dated	2	AGENCY	Agency for Reporting	nvarchar	3	0
83	OIUREP_REG_OPERA	Regulatory Reporting Operator and Contact Xref	2	AGENCY	Agency for Reporting	nvarchar	3	0
84	OIUREP_REG_OUT	Regulatory Reporting Output Control	2	AGENCY	Agency for Reporting	nvarchar	3	0
85	OIUREP_REPORTS	Supported Regulatory reports	1	AGENCY	Agency for Reporting	nvarchar	3	0
86	OIUREP_REPORTSTX	Supported Regulatory reports	2	AGENCY	Agency for Reporting	nvarchar	3	0
87	OIUREP_ROYHIST	Reported Royalty and Volume Data by Reporting Entities	4	AGENCY	Agency for Reporting	nvarchar	3	0
88	OIUREP_ROY_AGY	Reporting Agencies for Tax and Royalty	1	AGENCY	Agency for Reporting	nvarchar	3	0
89	OIUREP_ROY_AGYTX	Regulatory Reporting Agencies	2	AGENCY	Agency for Reporting	nvarchar	3	0
90	OIUREP_ROY_DATA	Reported Royalty and Volume Data by Reporting Entities	4	AGENCY	Agency for Reporting	nvarchar	3	0
91	OIUREP_ROY_LOG	Changes to master data for reporting	6	AGENCY	Agency for Reporting	nvarchar	3	0
92	OIUREP_RPT_ENTTY	Entities for Royalty Reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
93	OIUREP_RPT_OWNER	Owners for royalty reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
94	OIUREP_RPT_PRFL	Report Profile	4	AGENCY	Agency for Reporting	nvarchar	3	0
95	OIUREP_RRST	Regulatory Reporting Status Table	2	AGENCY	Agency for Reporting	nvarchar	3	0
96	OIUREP_RRST_NEW	NEW Regulatory Reporting Status Table (with Version Number)	2	AGENCY	Agency for Reporting	nvarchar	3	0
97	OIUREP_RUN_GROUP	Reg.Reporting - Report Submission grouping	2	AGENCY	Agency for Reporting	nvarchar	3	0
98	OIUREP_RUN_REPNM	Reg.Reporting - Report run/submission names	1	AGENCY	Agency for Reporting	nvarchar	3	0
99	OIUREP_RWC	WCs that have been changed since previous report run	2	AGENCY	Agency for Reporting	nvarchar	3	0
100	OIUREP_STAT_SPLT	Regulatory Reporting: Well Status Split table	2	AGENCY	Agency for Reporting	nvarchar	3	0
101	OIUREP_STRUC	Regulatory Reporting Structures	1	AGENCY	Agency for Reporting	nvarchar	3	0
102	OIUREP_STRUCTX	Regulatory Reporting Structures	1	AGENCY	Agency for Reporting	nvarchar	3	0
103	OIUREP_TAB_IND	Agency related fields for master data maintainence	1	AGENCY	Agency for Reporting	nvarchar	3	0
104	OIUREP_TEXT_STDD	Regulatory Reporting Standard Texts Detail	2	AGENCY	Agency for Reporting	nvarchar	3	0
105	OIUREP_TEXT_STDH	Regulatory Reporting Valid Standard Texts Header	2	AGENCY	Agency for Reporting	nvarchar	3	0
106	OIUREP_TEXT_XREF	Regulatory Reporting Texts for Diff Reporting Levels	2	AGENCY	Agency for Reporting	nvarchar	3	0
107	OIUREP_UOM	Regulatory Report Unit of Measures	2	AGENCY	Agency for Reporting	nvarchar	3	0
108	OIUREP_VALTABC	Reporting general value table - Customizing	2	AGENCY	Agency for Reporting	nvarchar	3	0
109	OIUREP_VALTABCTX	Reporting general value table - Customizing	2	AGENCY	Agency for Reporting	nvarchar	3	0
110	OIUREP_VALTABM	Reporting general value table - Customizing	2	AGENCY	Agency for Reporting	nvarchar	3	0
111	OIUREP_VLTP_XREF	Cross reference between Agency defined & PRA volume types	1	AGENCY	Agency for Reporting	nvarchar	3	0
112	OIUREP_VOLHIST	Reported Volume Data by Reporting Entities	4	AGENCY	Agency for Reporting	nvarchar	3	0
113	OIUREP_VOL_DATA	Reported Volume Data by Reporting Entities	4	AGENCY	Agency for Reporting	nvarchar	3	0
114	OIUREP_XTRCT_ROY	Extract Royaty Data for the current reporting period	3	AGENCY	Agency for Reporting	nvarchar	3	0
115	OIUY1_CAT_CD	Generic Category Code in New Royalty	1	AGENCY	Agency for Reporting	nvarchar	3	0
116	OIUY1_CAT_CDTX	Descriptions for the categories	2	AGENCY	Agency for Reporting	nvarchar	3	0
117	OIUY1_CAT_CD_VAL	Descriptions for the codes	2	AGENCY	Agency for Reporting	nvarchar	3	0
118	OIUY1_GEN_CD_VAL	Maintain Code with Effective Dated	2	AGENCY	Agency for Reporting	nvarchar	3	0
119	OIUY1_REP_HIST	Reported data history	4	AGENCY	Agency for Reporting	nvarchar	3	0
TOPStructures Workbench
120	HRP1950	DB Table for Infotype 1950	24	AGENCY	Agency	nvarchar	1	0
TOPTax Reporting
121	OIUX1_ADJ_TAXHC	Tax adjustments header for reporting	15	AGENCY	Agency for Reporting	nvarchar	3	0
122	OIUX1_AGY_DEFN	Agency definition	2	AGENCY	Agency for Reporting	nvarchar	3	0
123	OIUX1_AGY_TCDTX	Agency tax code text table	2	AGENCY	Agency for Reporting	nvarchar	3	0
124	OIUX1_AGY_TXCD	Agency defined Tax Codes	1	AGENCY	Agency for Reporting	nvarchar	3	0
125	OIUX1_EXEC_COMB	Execution Combinations for Tax Reporting	3	AGENCY	Agency for Reporting	nvarchar	3	0
126	OIUX1_EXEC_STAT	Execution Statistics for Tax Reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
127	OIUX1_FLD_VALB	Base table for field level data	3	AGENCY	Agency for Reporting	nvarchar	3	0
128	OIUX1_FLD_VALL	Log for field level data	4	AGENCY	Agency for Reporting	nvarchar	3	0
129	OIUX1_LNK_REPUB	PUID and reporting entities link	3	AGENCY	Agency for Reporting	nvarchar	3	0
130	OIUX1_MAS_REB	Reporting entities base table	3	AGENCY	Agency for Reporting	nvarchar	3	0
131	OIUX1_PDCD_XREF	Cross Reference Between State Agency and PRA Material	2	AGENCY	Agency for Reporting	nvarchar	3	0
132	OIUX1_PRD_UIDB	Base table for Production Units/Leases	3	AGENCY	Agency for Reporting	nvarchar	3	0
133	OIUX1_PRD_UNITTX	Text table for Production Units/Leases	3	AGENCY	Agency for Reporting	nvarchar	3	0
134	OIUX1_PROC_CNTRL	Reporting process control table	3	AGENCY	Agency for Reporting	nvarchar	3	0
135	OIUX1_PROD_UNIT	Production Units/Leases	2	AGENCY	Agency for Reporting	nvarchar	3	0
136	OIUX1_PUID_MKTH	Reporting history for marketing costs for reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
137	OIUX1_PUID_TAXH	Tax transaction header for reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
138	OIUX1_PUID_VOLH	Reported Volume Data by PUID	4	AGENCY	Agency for Reporting	nvarchar	3	0
139	OIUX1_PUID_XMPH	Reporting history for tax exemptions	4	AGENCY	Agency for Reporting	nvarchar	3	0
140	OIUX1_RPT_IDB	Legal report time dependent base table	2	AGENCY	Agency for Reporting	nvarchar	3	0
141	OIUX1_RPT_MKTH	Reporting history for marketing costs for reporting	10	AGENCY	Agency for Reporting	nvarchar	3	0
142	OIUX1_RPT_MSTRL	Log for master data changes	4	AGENCY	Agency for Reporting	nvarchar	3	0
143	OIUX1_RPT_SGB	Report Submission Group base table	2	AGENCY	Agency for Reporting	nvarchar	3	0
144	OIUX1_RPT_TAXH	Tax transaction header for reporting	4	AGENCY	Agency for Reporting	nvarchar	3	0
145	OIUX1_RPT_VOLH	Reported Volume Data by Reporting Entities	4	AGENCY	Agency for Reporting	nvarchar	3	0
146	OIUX1_RPT_XMPH	Reporting history for tax exemptions	10	AGENCY	Agency for Reporting	nvarchar	3	0
147	OIUX1_TAX_SUSP	Records for suspension	3	AGENCY	Agency for Reporting	nvarchar	3	0
148	OIUX1_TRN_TAXDL	Tax transaction detail for reporting	33	AGENCY	Agency for Reporting	nvarchar	3	0
149	OIUX1_TRN_TAXHL	Tax transaction header for reporting	29	AGENCY	Agency for Reporting	nvarchar	3	0
150	OIUX1_TXCD_XREF	Cross reference between state tax codes and PRA entities	2	AGENCY	Agency for Reporting	nvarchar	3	0
151	OIUX1_VKEY_XREF	Table for variable key in Tax Reporting	2	AGENCY	Agency for Reporting	nvarchar	3	0
152	OIUX2_BA_LOG	Cross ref. betwn PRA prod/purchaser no. and its tax payer	3	AGENCY	Agency for Reporting	nvarchar	3	0
153	OIUX2_PUID_VOLH	Reported Volume Data by PUID	4	AGENCY	Agency for Reporting	nvarchar	3	0
TOPTerminologyGlossary
154	STERM_Q_CHECK_H	Header Table for Terminology Check	5	AGENCY	Character field, length 32	nvarchar	32	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

154 columns | ERP 6.0 | AGENCY