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	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

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	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

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Revenue :: Valuation
1	ERP EHP7	6.0	OIUVL_STS	62	1	Severance tax statistics	Valuation

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	SEV_NO	Severance tax number	nvarchar	20	0	NUMC	(N'00000000000000000000')	No		OIUVL_SEV_NO	Allow NULL?
3	TAX_TYPE	Severance Tax Type	nvarchar	2	0	CHAR	(N' ')	No	*	OIU_SEVT_TAX_TY	Allow NULL?
4	SEVT_PAY_FL	Tax Severance Tax Calculation Payment Obligations Types	char	1	0	CHAR	(N' ')	Yes		OIU_SEVT_PAY_FL	Allow NULL?
5	SEVT_RPT_FL	State Severance Tax Reporting Indicators	char	1	0	CHAR	(N' ')	Yes		OIU_SEVT_RPT_FL	Allow NULL?
6	VL_TAX_RAT	Volume tax rate	decimal	7	6	DEC	((0))	Yes		OIUVL_VL_TAX_RAT
7	VAL_TAX_RAT	Value tax rate	decimal	7	6	DEC	((0))	Yes		OIUVL_VAL_TAX_RAT
8	ACTL_TXVAL	Actual taxable value	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_TXVAL
9	ACTL_TXVL	Actual taxable volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_ACTL_TXVL
10	ACTL_OVRD_TAX_VA	Actual override taxable value	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_OVRD_TAX_VAL
11	ACTL_OVRD_TAX_VL	Actual override taxable volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_ACTL_OVRD_TAX_VL
12	FX_MCD	Fixed marketing cost deduction	decimal	15	2	CURR	((0))	Yes		OIUVL_FX_MCD
13	FX_MCD_RAT	Fixed marketing cost deduction rate	decimal	5	2	DEC	((0))	Yes		OIUVL_FX_MCD_RAT
14	TOTAL_TAX_PC	Total tax percentage	decimal	9	8	DEC	((0))	Yes		OIUVL_TOTAL_TAX_PC
15	EXMP_CD_1	Exempt Entity Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUVL_EXMP_CD	Allow NULL?
16	EXMP_CD_2	Exempt Entity Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUVL_EXMP_CD	Allow NULL?
17	EXMP_CD_3	Exempt Entity Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUVL_EXMP_CD	Allow NULL?
18	EXMP_CD_4	Exempt Entity Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUVL_EXMP_CD	Allow NULL?
19	EXMP_CD_5	Exempt Entity Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUVL_EXMP_CD	Allow NULL?
20	EXMP_INT_DEC_1	Exempt interest decimal	decimal	9	8	DEC	((0))	Yes		OIUVL_EXMP_INT_DEC
21	EXMP_INT_DEC_2	Exempt interest decimal	decimal	9	8	DEC	((0))	Yes		OIUVL_EXMP_INT_DEC
22	EXMP_INT_DEC_3	Exempt interest decimal	decimal	9	8	DEC	((0))	Yes		OIUVL_EXMP_INT_DEC
23	EXMP_INT_DEC_4	Exempt interest decimal	decimal	9	8	DEC	((0))	Yes		OIUVL_EXMP_INT_DEC
24	EXMP_INT_DEC_5	Exempt interest decimal	decimal	9	8	DEC	((0))	Yes		OIUVL_EXMP_INT_DEC
25	EXMP_VL_1	Exempt volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_EXMP_VL
26	EXMP_VL_2	Exempt volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_EXMP_VL
27	EXMP_VL_3	Exempt volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_EXMP_VL
28	EXMP_VL_4	Exempt volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_EXMP_VL
29	EXMP_VL_5	Exempt volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_EXMP_VL
30	EXMP_VAL_1	Exempt value	decimal	15	2	CURR	((0))	Yes		OIUVL_EXMP_VAL
31	EXMP_VAL_2	Exempt value	decimal	15	2	CURR	((0))	Yes		OIUVL_EXMP_VAL
32	EXMP_VAL_3	Exempt value	decimal	15	2	CURR	((0))	Yes		OIUVL_EXMP_VAL
33	EXMP_VAL_4	Exempt value	decimal	15	2	CURR	((0))	Yes		OIUVL_EXMP_VAL
34	EXMP_VAL_5	Exempt value	decimal	15	2	CURR	((0))	Yes		OIUVL_EXMP_VAL
35	ACTL_MKCT_1	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
36	ACTL_MKCT_2	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
37	ACTL_MKCT_3	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
38	ACTL_MKCT_4	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
39	ACTL_MKCT_5	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
40	ACTL_MKCT_6	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
41	ACTL_MKCT_7	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
42	ACTL_MKCT_8	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
43	ACTL_MKCT_9	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
44	ACTL_MKCT_10	Actual marketing cost	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MKCT
45	ACTL_MCR_1	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
46	ACTL_MCR_2	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
47	ACTL_MCR_3	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
48	ACTL_MCR_4	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
49	ACTL_MCR_5	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
50	ACTL_MCR_6	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
51	ACTL_MCR_7	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
52	ACTL_MCR_8	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
53	ACTL_MCR_9	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
54	ACTL_MCR_10	Actual marketing cost reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_MCR
55	ACTL_ST_TAX_AM	Actual state tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_ST_TAX_AM
56	ACTL_ST_TAX_REIM	Actual state tax reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_ACTL_ST_TAX_REIMB
57	OIU_CRUSER	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
58	OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0	DEC	((0))	Yes		TZNTSTMPS
59	TAX_FREE_05_VAL	Tax free 05 value	decimal	15	2	CURR	((0))	Yes		OIUVL_TAX_FREE_VAL
60	TAX_FREE_05_VL	Tax free 05 volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_TAX_FREE_VL
61	TAX_FREE_05_WLR	Tax free 05 wet-less-residue	decimal	13	3	QUAN	((0))	Yes		OIUVL_TAX_FREE_WLR
62	ST_TAX_PROC_ALLW	State tax processing allowance	decimal	15	2	CURR	((0))	Yes		OIUVL_ST_TAX_PROC_ALLOW

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

62 COLUMNS | 1 INDEXES | ERP 6.0 | OIUVL_STS TABLE

TOP ERP 6.0 | OIUVL_STS COLUMNS

TOP ERP 6.0 | OIUVL_STS 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

62 COLUMNS | 1 INDEXES | ERP 6.0 | OIUVL_STS TABLE

TOPERP 6.0 | OIUVL_STS COLUMNS

TOPERP 6.0 | OIUVL_STS INDEXES

TOP ERP 6.0 | OIUVL_STS COLUMNS

TOP ERP 6.0 | OIUVL_STS INDEXES