ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Reporting :: Tax Reporting
1	ERP EHP7	6.0	OIUX1_PUID_TAXH	39	2	Tax transaction header for reporting	Tax Reporting

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RPT_YYYYMM	Reporting Year and Month	nvarchar	6	0	Allow NULL?
3	RSG	Report Submission Group	nvarchar	4	0	Allow NULL?
4	AGENCY	Agency for Reporting	nvarchar	3	0	Allow NULL?
5	OGIND	Oil and Gas Indicator	char	1	0	Allow NULL?
6	SALES_YYYYMM	Sales YYYYMM	nvarchar	6	0	Allow NULL?
7	PUID	Production Unit ID for tax reporting	nvarchar	20	0	Allow NULL?
8	AGENCY_VOL_TYPE	Agency defined Volume type	nvarchar	2	0	Allow NULL?
9	AGENCY_TAX_CODE	Agency defined Tax Code for Reporting	nvarchar	4	0	Allow NULL?
10	PDIND	Purchaser/Producer Indicator	char	1	0	Allow NULL?
11	AFFL_COMP	Company Code	nvarchar	4	0	Allow NULL?
12	UNIT_VNAME	Joint Venture	nvarchar	6	0	Allow NULL?
13	SEC_GEO_LOC	Secondary geographic location	nvarchar	3	0	Allow NULL?
14	GRV_AM	Oil/gas density at standard/base conditions	float	15	16
15	ACTL_TXVL	Actual taxable volume	decimal	13	3
16	ACTL_OVRD_TAXVL	Actual override taxable volume	decimal	13	3
17	ACTL_GR_VL	Actual Gross Volume Amount	decimal	13	3
18	TAX_FREE_05_VL	Tax free 05 volume	decimal	13	3
19	BLPS_GR_VL	Before lease plant split gross volume	decimal	13	3
20	ACTL_GR_VL_U	Measurement unit	nvarchar	3	0	Allow NULL?
21	ACTL_WLR_VL_AM	Act. Wet-less-Residue Vol. Amount	decimal	13	3
22	TAX_FREE_05_WLR	Tax free 05 wet-less-residue	decimal	13	3
23	ACTL_WLR_VL_AM_U	Measurement unit	nvarchar	3	0	Allow NULL?
24	ACTL_ENERGY	Actual Energy	decimal	13	3
25	ACTL_ENERGY_U	Actual Energy Unit	nvarchar	3	0	Allow NULL?
26	FX_MCD	Fixed marketing cost deduction	decimal	15	2
27	ACTL_GR_VAL_AM	Actual Gross Value Amount	decimal	13	2
28	TAX_FREE_05_VAL	Tax free 05 value	decimal	15	2
29	BLPS_GR_VAL	Before lease plant split gross value	decimal	15	2
30	ST_TAX_PROC_ALLW	State tax processing allowance	decimal	15	2
31	ACTL_TXVAL	Actual taxable value	decimal	15	2
32	ACTL_OVRD_TAXVAL	Actual override taxable value	decimal	15	2
33	ACTL_ST_TAX_AM	Actual state tax amount	decimal	15	2
34	ACTL_ST_TAX_RMB	Actual state tax reimbursement	decimal	15	2
35	GR_VAL_CURR	Currency Key	nvarchar	5	0	Allow NULL?
36	USERNAME	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
37	TIMESTAMP	Time stamp in Numeric Character	nvarchar	14	0	Allow NULL?
38	PU_NO	Purchaser	nvarchar	10	0	Allow NULL?
39	UPLOAD	General Flag	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
OIUX1_PUID_TAXH~0	Yes	Yes	CLUSTERED	AFFL_COMP, PDIND, AGENCY_TAX_CODE, AGENCY_VOL_TYPE, PUID, SALES_YYYYMM, OGIND, AGENCY, RSG, RPT_YYYYMM, MANDT
OIUX1_PUID_TAXH~I0	No	No	NONCLUSTERED	PUID, SALES_YYYYMM, OGIND, AGENCY, RSG, MANDT

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

39 COLUMNS | 2 INDEXES | ERP 6.0 | OIUX1_PUID_TAXH TABLE

TOP ERP 6.0 | OIUX1_PUID_TAXH COLUMNS

TOP ERP 6.0 | OIUX1_PUID_TAXH INDEXES

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

39 COLUMNS | 2 INDEXES | ERP 6.0 | OIUX1_PUID_TAXH TABLE

TOPERP 6.0 | OIUX1_PUID_TAXH COLUMNS

TOPERP 6.0 | OIUX1_PUID_TAXH INDEXES

TOP ERP 6.0 | OIUX1_PUID_TAXH COLUMNS

TOP ERP 6.0 | OIUX1_PUID_TAXH INDEXES