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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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 :: Revenue :: Valuation
1	ERP EHP7	6.0	OIUVL_SCAUDIT	83	1	Settlement statement batch	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	*	MANDT	Allow NULL?
2	DOC_NO	Val. document number	nvarchar	20	0	CHAR	(N' ')	No	*	OIURV_DOCNR	Allow NULL?
3	DOC_YEAR	Document year	nvarchar	4	0	NUMC	(N'0000')	No		OIU_DOC_YEAR	Allow NULL?
4	LINE_ITEM_NO	Document Line Item Number	nvarchar	6	0	NUMC	(N'000000')	No		OIUVL_LINE_ITEM_NO	Allow NULL?
5	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
6	VNAME	Joint Venture	nvarchar	6	0	CHAR	(N' ')	No	OIU_DO_JV	JV_NAME	Allow NULL?
7	DOI_NO	Division of interest (DOI)	nvarchar	5	0	CHAR	(N' ')	No	OIU_DO_DI	OIU_DOI_NO	Allow NULL?
8	SALE_DT	Sales Date / Month	nvarchar	8	0	DATS	(N'00000000')	No		OIU_SALE_DT	Allow NULL?
9	WI_OWN_NO	Working Interest Owner	nvarchar	10	0	CHAR	(N' ')	No	KNA1	OIU_WI_OWN_NO	Allow NULL?
10	WI_INT_TYPE_CD	Participant Interest Type	nvarchar	2	0	CHAR	(N' ')	No	OIU_CM_PINTTY	OIU_PART_INT_TYPE	Allow NULL?
11	WI_OWN_ISQ_NO	Owner Interest Sequence Number	nvarchar	2	0	CHAR	(N' ')	No		OIU_OWN_ISQ_NO	Allow NULL?
12	TRANSACT_TYPE	Transaction Type	char	1	0	CHAR	(N' ')	Yes		OIUVL_TRANS_TYPE	Allow NULL?
13	SYSTEM_SRCE_CD	Valuation Transaction Source Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_VL_SRCE_CD	Allow NULL?
14	SALE_MONTH	Sales Month	nvarchar	8	0	DATS	(N'00000000')	Yes		OIUVL_SALE_MONTH	Allow NULL?
15	TXN_PRCS_CD	Transaction Process Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_TXN_PRCS_CD	Allow NULL?
16	CT_NO	Contract Number	nvarchar	10	0	CHAR	(N' ')	Yes	OIUCM_CONTRACT	OIU_CT_NO	Allow NULL?
17	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	OIU_CM_MAT_PRCD	MATNR	Allow NULL?
18	VL_TYPE_CD	Volume type code	nvarchar	2	0	CHAR	(N' ')	Yes	OIU_PR_VLTYP	OIU_VT_CD	Allow NULL?
19	DOI_SUM_FL	Summarize RD to DOI Level Flag	char	1	0	CHAR	(N' ')	Yes		OIU_DOI_SUM_FL	Allow NULL?
20	PURCH_NO	Purchaser	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	OIU_PU_NO	Allow NULL?
21	CT_DECM	Contract Decimal	decimal	9	8	DEC	((0))	Yes		OIU_CT_DECM
22	HEAT_VAL_FCT_U	Measurement unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIU_MEAS_U	Allow NULL?
23	ACT_HEAT_VAL_FCT	Actual Heating Factor	decimal	13	3	QUAN	((0))	Yes		OIU_ACT_HEAT_VAL_FCT
24	GRV	Oil/gas density at standard/base conditions	float	15	16	FLTP	((0))	Yes		OIB_BDICH
25	DENSITY_U	Unit for densities at standard/base conditions	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIB_BDNEH	Allow NULL?
26	DNTYP	Density Type	char	1	0	CHAR	(N' ')	Yes		OIB_DNTYP	Allow NULL?
27	TOT_GR_VL_U	Measurement unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIU_MEAS_U	Allow NULL?
28	ACTL_GR_VL	Actual Gross Volume Amount	decimal	13	3	QUAN	((0))	Yes		OIU_ACTL_GR_VL_AM
29	WLR_VL_U	Measurement unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIU_MEAS_U	Allow NULL?
30	ACTL_WLR_VL	Act. Wet-less-Residue Vol. Amount	decimal	13	3	QUAN	((0))	Yes		OIU_ACTL_WLR_VL_AM
31	GR_VAL_CURR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
32	ACTL_GR_VAL	Actual Gross Value Amount	decimal	13	2	CURR	((0))	Yes		OIU_ACTL_GR_VAL_AM
33	MKCT_1	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
34	MKCT_2	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
35	MKCT_3	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
36	MKCT_4	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
37	MKCT_5	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
38	MKCT_6	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
39	MKCT_7	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
40	MKCT_8	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
41	MKCT_9	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
42	MKCT_10	Marketing cost amount	decimal	15	2	CURR	((0))	Yes		OIUVL_MKCT
43	MK_RMB_1	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
44	MK_RMB_2	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
45	MK_RMB_3	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
46	MK_RMB_4	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
47	MK_RMB_5	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
48	MK_RMB_6	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
49	MK_RMB_7	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
50	MK_RMB_8	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
51	MK_RMB_9	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
52	MK_RMB_10	Marketing Reimbursement	decimal	15	2	CURR	((0))	Yes		OIUVL_MK_RMB
53	TAX_CALC_FL	Calculate Tax Flag	char	1	0	CHAR	(N' ')	Yes		OIU_TAX_CALC_FL	Allow NULL?
54	SEVT_TYPE_CD_1	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
55	SEVT_TYPE_CD_2	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
56	SEVT_TYPE_CD_3	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
57	SEVT_TYPE_CD_4	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
58	SEVT_TYPE_CD_5	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
59	SEVT_TYPE_CD_6	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
60	SEVT_TYPE_CD_7	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
61	SEVT_TYPE_CD_8	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
62	SEVT_TYPE_CD_9	Severance tax type code	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_SEVT_TYPE_CD	Allow NULL?
63	SVTR_1	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
64	SVTR_2	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
65	SVTR_3	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
66	SVTR_4	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
67	SVTR_5	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
68	SVTR_6	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
69	SVTR_7	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
70	SVTR_8	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
71	SVTR_9	Tax or reimbursement amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SVTR
72	SEVT_1	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
73	SEVT_2	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
74	SEVT_3	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
75	SEVT_4	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
76	SEVT_5	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
77	SEVT_6	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
78	SEVT_7	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
79	SEVT_8	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
80	SEVT_9	Severance tax amount	decimal	15	2	CURR	((0))	Yes		OIUVL_SEVT
81	PPA_RSN_CD	Prior Period Adjustment Reason Code	nvarchar	2	0	CHAR	(N' ')	Yes	OIU_CM_PPARSN	OIU_PPA_RSN_CD	Allow NULL?
82	OIU_CRUSER	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
83	OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0	DEC	((0))	Yes		TZNTSTMPS

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

83 COLUMNS | 1 INDEXES | ERP 6.0 | OIUVL_SCAUDIT TABLE

TOP ERP 6.0 | OIUVL_SCAUDIT COLUMNS

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

83 COLUMNS | 1 INDEXES | ERP 6.0 | OIUVL_SCAUDIT TABLE

TOPERP 6.0 | OIUVL_SCAUDIT COLUMNS

TOPERP 6.0 | OIUVL_SCAUDIT INDEXES

TOP ERP 6.0 | OIUVL_SCAUDIT COLUMNS

TOP ERP 6.0 | OIUVL_SCAUDIT INDEXES