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
1	ERP EHP7	6.0	OIUH_RV_STS	65	2	Severence Tax Subsidiary	Revenue

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	*	MANDT	Allow NULL?
2	DUMMY_SEQ_FIELD	OIUH_CHAR10	nvarchar	10	0	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
3	STS_SEV_SYS_NO	Severance tax number	nvarchar	20	0	NUMC	(N'00000000000000000000')	No		OIUVL_SEV_NO	Allow NULL?
4	STS_TAX_TYPE	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
5	STS_TAX_PAY_FL	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
6	STS_TAX_RPT_FL	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
7	TAX_CALC_BS_CD	OIUH_CHAR1	char	1	0	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
8	VL_TAX_RATE_PC	OIUH_DEC7_6	decimal	7	6	DEC	((0))	No		OIUH_DEC7_6
9	VAL_TAX_RAT_PC	OIUH_DEC7_6	decimal	7	6	DEC	((0))	No		OIUH_DEC7_6
10	STS_TAX_VAL_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
11	STS_TAX_VL_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
12	S_OVRD_TAXVA_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
13	S_OVRD_TAXVL_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
14	S_FX_MKD_RAT_PC	OIUH_DEC5_2	decimal	5	2	DEC	((0))	No		OIUH_DEC5_2
15	STS_FX_MKD_AM	Local amount	decimal	7	2	CURR	((0))	No		OIUH_CURR7_2
16	STS_TOT_TAX_PC	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
17	EXEN_TYPE_1_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
18	EXEN_TYPE_2_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
19	EXEN_TYPE_3_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
20	EXEN_TYPE_4_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
21	EXEN_TYPE_5_CD	OIUH_CHAR2	nvarchar	2	0	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
22	S_EXIN_DEC_1_AM	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
23	S_EXIN_DEC_2_AM	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
24	S_EXIN_DEC_3_AM	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
25	S_EXIN_DEC_4_AM	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
26	S_EXIN_DEC_5_AM	OIUH_DEC9_8	decimal	9	8	DEC	((0))	No		OIUH_DEC9_8
27	ACTL_EXVL_1_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
28	ACTL_EXVL_2_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
29	ACTL_EXVL_3_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
30	ACTL_EXVL_4_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
31	ACTL_EXVL_5_AM	OIUH_DEC11_2	decimal	11	2	DEC	((0))	No		OIUH_DEC11_2
32	ACTL_EXVA_1_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
33	ACTL_EXVA_2_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
34	ACTL_EXVA_3_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
35	ACTL_EXVA_4_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
36	ACTL_EXVA_5_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
37	S_TAX_MKCT_1_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
38	S_TAX_MKCT_2_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
39	S_TAX_MKCT_3_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
40	S_TAX_MKCT_4_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
41	S_TAX_MKCT_5_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
42	S_TAX_MKCT_6_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
43	S_TAX_MKCT_7_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
44	S_TAX_MKCT_8_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
45	S_TAX_MKCT_9_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
46	TAX_MKCT_10_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
47	TS_TAX_MCR_1_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
48	TS_TAX_MCR_2_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
49	TS_TAX_MCR_3_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
50	TS_TAX_MCR_4_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
51	TS_TAX_MCR_5_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
52	TS_TAX_MCR_6_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
53	TS_TAX_MCR_7_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
54	TS_TAX_MCR_8_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
55	TS_TAX_MCR_9_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
56	S_TAX_MCR_10_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
57	STS_ACTL_STX_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
58	TS_ACTL_STXR_AM	Local amount	decimal	11	2	CURR	((0))	No		OIUH_CURR11_2
59	STS_VER_NO	OIUH_DEC5	decimal	5	0	DEC	((0))	No		OIUH_DEC5
60	STS_USER_ID	OIUH_CHAR8	nvarchar	8	0	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
61	STS_TIMESTAMP	OIUH_CHAR14	nvarchar	14	0	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?
62	TAX_FREE_05_VAL	Tax free 05 value	decimal	15	2	CURR	((0))	Yes		OIUVL_TAX_FREE_VAL
63	TAX_FREE_05_VL	Tax free 05 volume	decimal	13	3	QUAN	((0))	Yes		OIUVL_TAX_FREE_VL
64	TAX_FREE_05_WLR	Tax free 05 wet-less-residue	decimal	13	3	QUAN	((0))	Yes		OIUVL_TAX_FREE_WLR
65	ST_TAX_PROC_ALLW	State tax processing allowance	decimal	15	2	CURR	((0))	Yes		OIUVL_ST_TAX_PROC_ALLOW

Name	Primary	Unique	Type	Columns
OIUH_RV_STS~0	Yes	Yes	CLUSTERED	DUMMY_SEQ_FIELD, MANDT
OIUH_RV_STS~I01	No	Yes	NONCLUSTERED	STS_TAX_TYPE, STS_SEV_SYS_NO, 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

65 COLUMNS | 2 INDEXES | ERP 6.0 | OIUH_RV_STS TABLE

TOP ERP 6.0 | OIUH_RV_STS COLUMNS

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

65 COLUMNS | 2 INDEXES | ERP 6.0 | OIUH_RV_STS TABLE

TOPERP 6.0 | OIUH_RV_STS COLUMNS

TOPERP 6.0 | OIUH_RV_STS INDEXES

TOP ERP 6.0 | OIUH_RV_STS COLUMNS

TOP ERP 6.0 | OIUH_RV_STS INDEXES