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
1	ERP EHP7	6.0	OIUH_RV_SCD	91	4	Obsolete (4.72)-keep for 1 minor release - Suspended Check	Revenue

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	DUMMY_SEQ_FIELD	OIUH_CHAR10	nvarchar	10	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
3	SCD_OR_LVL_1_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
4	SCD_ACCT_DT	OIUH_CHAR14	nvarchar	14	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?
5	SCD_BTCH_NO	OIUH_CHAR4	nvarchar	4	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
6	D_BTCH_DETLE_NO	OIUH_CHAR5	nvarchar	5	CHAR	(N' ')	No		OIUH_CHAR5	Allow NULL?
7	SCD_BTCH_DE9	OIUH_CHAR1	char	1	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
8	SCD_BTCH_DE	OIUH_CHAR48	nvarchar	48	CHAR	(N' ')	No		OIUH_CHAR48	Allow NULL?
9	SCD_BTCH_STS_CD	OIUH_CHAR2	nvarchar	2	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
10	SCD_DPO_CO_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
11	CD_BTCH_TYPE_CD	OIUH_CHAR2	nvarchar	2	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
12	SCD_PU_NO	OIUH_CHAR6	nvarchar	6	CHAR	(N' ')	No		OIUH_CHAR6	Allow NULL?
13	SCD_PU_SEQ_NO	OIUH_CHAR2	nvarchar	2	CHAR	(N' ')	No		OIUH_CHAR2	Allow NULL?
14	SCD_PU_CK_NO	OIUH_CHAR10	nvarchar	10	CHAR	(N' ')	No		OIUH_CHAR10	Allow NULL?
15	SCD_PU_CK_DT	OIUH_CHAR14	nvarchar	14	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?
16	SCD_CK_LYT_NO	OIUH_CHAR4	nvarchar	4	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
17	SCD_SUSP_RSN_CD	Check Input Suspense Reason codes	nvarchar	2	CHAR	(N' ')	No		OIUH_CI_SUSP_RSN	Allow NULL?
18	SCD_WRT_OFF_FL	OIUH_CHAR1	char	1	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
19	CD_CASH_RCPT_FL	OIUH_CHAR1	char	1	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
20	SCD_PRCS_FL	OIUH_CHAR1	char	1	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
21	CKDETL_FL01_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
22	CKDETL_FL02_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
23	CKDETL_FL03_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
24	CKDETL_FL04_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
25	CKDETL_FL05_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
26	CKDETL_FL06_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
27	CKDETL_FL07_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
28	CKDETL_FL08_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
29	CKDETL_FL09_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
30	CKDETL_FL10_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
31	CKDETL_FL11_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
32	CKDETL_FL12_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
33	CKDETL_FL13_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
34	CKDETL_FL14_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
35	CKDETL_FL15_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
36	CKDETL_FL16_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
37	CKDETL_FL17_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
38	CKDETL_FL18_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
39	CKDETL_FL19_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
40	CKDETL_FL20_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
41	CKDETL_FL21_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
42	CKDETL_FL22_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
43	CKDETL_FL23_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
44	CKDETL_FL24_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
45	CKDETL_FL25_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
46	CKDETL_FL26_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
47	CKDETL_FL27_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
48	CKDETL_FL28_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
49	CKDETL_FL29_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
50	CKDETL_FL30_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
51	CKDETL_FL31_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
52	CKDETL_FL32_NO	OIUH_CHAR3	nvarchar	3	CHAR	(N' ')	No		OIUH_CHAR3	Allow NULL?
53	CKDETL_FL01_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
54	CKDETL_FL02_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
55	CKDETL_FL03_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
56	CKDETL_FL04_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
57	CKDETL_FL05_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
58	CKDETL_FL06_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
59	CKDETL_FL07_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
60	CKDETL_FL08_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
61	CKDETL_FL09_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
62	CKDETL_FL10_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
63	CKDETL_FL11_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
64	CKDETL_FL12_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
65	CKDETL_FL13_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
66	CKDETL_FL14_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
67	CKDETL_FL15_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
68	CKDETL_FL16_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
69	CKDETL_FL17_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
70	CKDETL_FL18_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
71	CKDETL_FL19_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
72	CKDETL_FL20_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
73	CKDETL_FL21_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
74	CKDETL_FL22_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
75	CKDETL_FL23_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
76	CKDETL_FL24_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
77	CKDETL_FL25_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
78	CKDETL_FL26_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
79	CKDETL_FL27_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
80	CKDETL_FL28_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
81	CKDETL_FL29_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
82	CKDETL_FL30_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
83	CKDETL_FL31_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
84	CKDETL_FL32_CD	OIUH_CHAR18	nvarchar	18	CHAR	(N' ')	No		OIUH_CHAR18	Allow NULL?
85	CD_CD_CC_SYS_NO	OIUH_DEC18	decimal	18	DEC	((0))	No		OIUH_DEC18
86	SCD_FL_NO	OIUH_CHAR4	nvarchar	4	CHAR	(N' ')	No		OIUH_CHAR4	Allow NULL?
87	SCD_CMT_FL	OIUH_CHAR1	char	1	CHAR	(N' ')	No		OIUH_CHAR1	Allow NULL?
88	CD_CASH_RCPT_DT	OIUH_CHAR14	nvarchar	14	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?
89	SCD_VER_NO	OIUH_DEC5	decimal	5	DEC	((0))	No		OIUH_DEC5
90	SCD_USER_ID	OIUH_CHAR8	nvarchar	8	CHAR	(N' ')	No		OIUH_CHAR8	Allow NULL?
91	SCD_TIMESTAMP	OIUH_CHAR14	nvarchar	14	CHAR	(N' ')	No		OIUH_CHAR14	Allow NULL?

Name	Primary	Unique	Type	Columns
OIUH_RV_SCD~0	Yes	Yes	CLUSTERED	DUMMY_SEQ_FIELD, MANDT
OIUH_RV_SCD~I01	No	No	NONCLUSTERED	D_BTCH_DETLE_NO, SCD_PU_CK_NO, SCD_BTCH_NO, SCD_ACCT_DT, MANDT
OIUH_RV_SCD~I02	No	Yes	NONCLUSTERED	SCD_PU_CK_NO, SCD_OR_LVL_1_NO, D_BTCH_DETLE_NO, SCD_BTCH_NO, SCD_ACCT_DT, MANDT
OIUH_RV_SCD~I03	No	No	NONCLUSTERED	D_BTCH_DETLE_NO, SCD_BTCH_NO, SCD_ACCT_DT, SCD_OR_LVL_1_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

91 COLUMNS | 4 INDEXES | ERP 6.0 | OIUH_RV_SCD TABLE

TOP ERP 6.0 | OIUH_RV_SCD COLUMNS

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

91 COLUMNS | 4 INDEXES | ERP 6.0 | OIUH_RV_SCD TABLE

TOPERP 6.0 | OIUH_RV_SCD COLUMNS

TOPERP 6.0 | OIUH_RV_SCD INDEXES

TOP ERP 6.0 | OIUH_RV_SCD COLUMNS

TOP ERP 6.0 | OIUH_RV_SCD INDEXES