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 :: Reporting :: Royalty Reporting
1	ERP EHP7	6.0	OIUREP_RT_HIST	94	2	MMS-2014 - Royalty Transaction (Pending) History	Royalty Reporting

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	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
3	SALES_YEAR	MMS-2014 - Year	nvarchar	4	0	NUMC	(N'0000')	No		OIUREP_MMS_2014_YEAR	Allow NULL?
4	SALES_MONTH	MMS-2014 - Month	nvarchar	2	0	NUMC	(N'00')	No		OIUREP_MMS_2014_MONTH	Allow NULL?
5	RTP_LINE_NUM	MMS-2014 - Line Number	nvarchar	10	0	NUMC	(N'0000000000')	No		OIUREP_MMS_2014_LINE_NO	Allow NULL?
6	PAYOR_NO	Production: MMS-2014 - Payor	nvarchar	5	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_PAYOR	Allow NULL?
7	FED_INDIAN_CD	Production: MMS-2014 - Federal or Indian Code	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_FED_INDIAN_CD	Allow NULL?
8	INDIAN_TRIBE_NO	Production: MMS-2014 - Indian Tribe Number	nvarchar	2	0	CHAR	(N' ')	Yes	OIUREP_INDIAN_TR	OIUREP_MMS_2014_INDN_TRIBE_NO	Allow NULL?
9	API_WELL_NO	API well number	nvarchar	12	0	CHAR	(N' ')	Yes		OIU_WLAPI	Allow NULL?
10	API_WELL_CM_NO	API well completion number	nvarchar	3	0	CHAR	(N' ')	Yes		OIU_API_WC_NO	Allow NULL?
11	LEASE_NO	MMS-2014 - Lease Number	nvarchar	11	0	CHAR	(N' ')	Yes	OIUREP_FEDINDIAN	OIUREP_MMS_2014_LEASE_NO	Allow NULL?
12	AGREEMENT_NO	Production: MMS-2014 - Agreement Number	nvarchar	11	0	CHAR	(N' ')	Yes	OIUREP_LEASE	OIUREP_MMS_2014_AGREEMENT_NO	Allow NULL?
13	MMS_PROD_CD	Production: MMS Product Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUREP_MMS_PRODUCT_CODE	Allow NULL?
14	SALES_TYPE_CD	Production: MMS-2014 - Sales Type Code	nvarchar	4	0	CHAR	(N' ')	Yes	OIUREP_SALESTY	OIUREP_MMS_2014_SALES_TYPE_CD	Allow NULL?
15	SALES_DATE	Sales Date / Month	nvarchar	8	0	DATS	(N'00000000')	Yes		OIU_SALE_DT	Allow NULL?
16	TRANS_CD	Production: MMS-2014 - Transaction Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_TRANS_CD	Allow NULL?
17	PAY_METHOD_CD	Production: MMS-2014 - Payment Method Code	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_PAY_METHOD_CD	Allow NULL?
18	WL_NO	Well ID number	nvarchar	15	0	CHAR	(N' ')	Yes	OIU_PR_WELL	OIU_WL_NO	Allow NULL?
19	WC_NO	Well Completion Number	nvarchar	5	0	CHAR	(N' ')	Yes	OIU_PR_WC	OIU_WC_NO	Allow NULL?
20	VNAME	MMS-2014 - Venture	nvarchar	6	0	CHAR	(N' ')	Yes	OIU_DO_JV	OIUREP_MMS_2014_PROPERTY	Allow NULL?
21	DOI_NO	Division of interest (DOI)	nvarchar	5	0	CHAR	(N' ')	Yes	OIU_DO_DI	OIU_DOI_NO	Allow NULL?
22	PU_NO	Purchaser	nvarchar	10	0	CHAR	(N' ')	Yes	*	OIU_PU_NO	Allow NULL?
23	PU_SEQ_NO	Purchasing Representative Interest Sequence No	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_PU_REP_ISQ_NO	Allow NULL?
24	PU_AFFIL_FL	Production: MMS-2014 - Purchaser Affiliation Flag	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_PU_AFFIL_FL	Allow NULL?
25	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	OIU_CM_MAT_PRCD	MATNR	Allow NULL?
26	OWN_NO	PRA owner	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	OIU_OWN_NO	Allow NULL?
27	OWN_ISQ_NO	Owner Interest Sequence Number	nvarchar	2	0	CHAR	(N' ')	Yes		OIU_OWN_ISQ_NO	Allow NULL?
28	CT_NO	Contract Number	nvarchar	10	0	CHAR	(N' ')	Yes	OIUCM_CONTRACT	OIU_CT_NO	Allow NULL?
29	GL_ACCTID_NO	Account ID	nvarchar	10	0	CHAR	(N' ')	Yes		OIUH_ACCTID	Allow NULL?
30	NWK_NO	Network Number	nvarchar	4	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_NWK_NO	Allow NULL?
31	SUB_NWK_NO	Sub Network Number	nvarchar	4	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_SUB_NWK_NO	Allow NULL?
32	INT_TYPE_CD	Interest Type Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_INT_TYPE_CD	Allow NULL?
33	INT_SEQ_NO	Interest Sequence Number	nvarchar	2	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_INT_SEQ_NO	Allow NULL?
34	SALES_QY	Sales Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_SALES_QY
35	SALES_QY_U	Production: MMS-2014 - Sales Qty Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_SALES_QY_U	Allow NULL?
36	SALES_GV_QY	Production: MMS-2014 - Sales Gravity Qty	decimal	4	1	QUAN	((0))	Yes		OIUREP_MMS_2014_SALES_GV_QY
37	SALES_GV_QY_U	Production: MMS-2014 - Sales Gravity Qty Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_SALES_GV_QY_U	Allow NULL?
38	SALES_BTU_QY	Production: MMS-2014 - Sales BTU Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_SALES_BTU_QY
39	SALES_BTU_QY_U	Production: MMS-2014 - Sales BTU Qty Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_SALES_BTU_QY_U	Allow NULL?
40	SALES_PS_BASE_QY	Pressure Base	decimal	13	3	QUAN	((0))	Yes		OIU_PS_BASE
41	SALES_PS_BASE_U	Pressure Base Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIU_PS_BASE_U	Allow NULL?
42	SALES_AMT	Production: MMS-2014 - Sales Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_SALES_AMT
43	SALES_CUR	Production: MMS-2014 - Sales Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_SALES_CUR	Allow NULL?
44	ROY_PR_ALW_AMT	Production: MMS-2014 - Royalty Value Prior to Allows. Amt	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_ROY_PR_ALW_AMT
45	ROY_PR_ALW_CUR	Production: MMS-2014 - Royalty Value Prior to Allows. Curr	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_ROY_PR_ALW_CUR	Allow NULL?
46	TRNSP_ALW_DE_AMT	Production: MMS-2014 - Transportation Allowance Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_TRNSP_ALLW_AMT
47	TRNSP_ALW_DE_CUR	MMS-2014 - Transportation Allowance Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_TRNSP_ALLW_CUR	Allow NULL?
48	PROC_ALW_DE_AMT	Production: MMS-2014 - Manufacturing UOM Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_MFRING_UOM_AMT
49	PROC_ALW_DE_CUR	Production: MMS-2014 - Manufacturing UOM Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_MFRING_UOM_CUR	Allow NULL?
50	ROY_LS_ALLOW_AMT	Production: MMS-2014 - Royalty Value Less Allows. Amt	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_ROY_LS_ALW_AMT
51	ROY_LS_ALLOW_CUR	Production: MMS-2014 - Royalty Value Less Allows Curr	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_ROY_LS_ALW_CUR	Allow NULL?
52	ROY_QY	Production: MMS-2014 - Royalty Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_ROY_QY
53	ROY_QY_U	Production: MMS-2014 - Royalty Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_ROY_QY_U	Allow NULL?
54	DED_REMB_AMT	Production: MMS-2014 - Deduction Reimbursement Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_DED_REMB_AMT
55	DED_REMB_CUR	Production: MMS-2014 - Deduction Reimbursement Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_DED_REMB_CUR	Allow NULL?
56	TAX_AMT	Production: MMS-2014 - Tax Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_TAX_AMT
57	TAX_CUR	Production: MMS-2014 - Tax Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_TAX_CUR	Allow NULL?
58	TAX_REMB_AMT	Production: MMS-2014 - Tax Reimbursement Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_TAX_REMB_AMT
59	TAX_REMB_CUR	Production: MMS-2014 - Tax Reimbursement Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_TAX_REMB_CUR	Allow NULL?
60	MMS_ROY_QY	Production: MMS-2014 - MMS Royalty Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_MMS_ROY_QY
61	MMS_ROY_QY_U	Production: MMS-2014 - MMS Royalty Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_MMS_ROY_QY_U	Allow NULL?
62	MMS_PS_BASE_QY	Pressure Base	decimal	13	3	QUAN	((0))	Yes		OIU_PS_BASE
63	MMS_PS_BASE_QY_U	Pressure Base Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIU_PS_BASE_U	Allow NULL?
64	MMS_ROY_AMT	MMS-2014 - JE Offset Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_MMS_ROY_AMT
65	MMS_ROY_CUR	MMS-2014 - JE Offset Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_MMS_ROY_CUR	Allow NULL?
66	MMS_SA_QY	Production: MMS-2014 - MMS Sales Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_MMS_SA_QY
67	MMS_SA_QY_U	Production: MMS-2014 - MMS Sales Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_MMS_SA_QY_U	Allow NULL?
68	MMS_SA_AMT	Production: MMS-2014 - MMS Sales Amount	decimal	15	2	CURR	((0))	Yes		OIUREP_MMS_2014_MMS_SA_AMT
69	MMS_SA_CUR	Production: MMS-2014 - MMS Sales Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	OIUREP_MMS_2014_MMS_SA_CUR	Allow NULL?
70	SUSPEND_RSN_CD	Suspense Reason Code	nvarchar	3	0	CHAR	(N' ')	Yes	OIU_CM_SUSP	OIU_SUSP_CD	Allow NULL?
71	ADJ_CD	Production: MMS-2014 - Adjustment Reason Code	nvarchar	2	0	NUMC	(N'00')	Yes		OIUREP_MMS_2014_ADJ_CD	Allow NULL?
72	ADJ_SA_QY	Production: MMS-2014 - Adjusted Sales Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_ADJ_SA_QY
73	ADJ_SA_QY_U	Production: MMS-2014 - Adjusted Sales Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_ADJ_SA_QY_U	Allow NULL?
74	ADJ_ROY_QY	Production: MMS-2014 - Adjusted Royalty Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_ADJ_ROY_QY
75	ADJ_ROY_QY_U	Production: MMS-2014 - Adjusted Royalty Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_ADJ_ROY_QY_U	Allow NULL?
76	ADJ_BTU_QY	Production: MMS-2014 - Adjusted BTU Quantity	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_ADJ_BTU_QY
77	ADJ_BTU_QY_U	Production: MMS-2014 - Adjusted BTU Quantity Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_ADJ_BTU_QY_U	Allow NULL?
78	GAS_MMBTU_QY	Production: MMS-2014 - Gas MMBTU Qty	decimal	13	3	QUAN	((0))	Yes		OIUREP_MMS_2014_GAS_MMBTU_QY
79	GAS_MMBTU_QY_U	Production: MMS-2014 - Gas MMBTU Qty Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIUREP_MMS_2014_GAS_MMBTU_QY_U	Allow NULL?
80	HISTORY_FL	Production: MMS-2014 - History Flag	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_HISTORY_FL	Allow NULL?
81	REPORT_PART_FAC	Production: MMS-2014 - Report Participation Factor	decimal	9	8	DEC	((0))	Yes		OIUREP_MMS_2014_RPT_PART_FAC
82	TRIBAL_ALLOT_CD	Production: MMS-2014 - Tribal/Allottee Code	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_TRIB_ALLOT_CD	Allow NULL?
83	COMP_ROY_FL	Production: MMS-2014 - Compensatory Royalty Flag	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_COMP_ROY_FL	Allow NULL?
84	ROY_IN_KIND_FL	Production: MMS-2014 - Royalty In Kind Flag	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_ROY_IN_KIND_FL	Allow NULL?
85	PAY_CD	Production: MMS-2014 - Payment Code	nvarchar	2	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_PAY_CD	Allow NULL?
86	EXTRACTED_FL	MMS-2014: Extracted	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_EXTRACTED_FL	Allow NULL?
87	EXTRACT_RUN_TYPE	Defines whether the run is direct pay or not	char	1	0	CHAR	(N' ')	Yes		OIUREP_MMS_2014_RUN_TYPE	Allow NULL?
88	MANUAL_CREATE_FL		char	1	0		(N' ')	Yes			Allow NULL?
89	OIU_CRUSER	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
90	OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0	DEC	((0))	Yes		TZNTSTMPS
91	CHANGE_USER	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
92	CHANGE_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0	DEC	((0))	Yes		TZNTSTMPS
93	COST_CENTER	PRA Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes		OIUCM_KOSTL	Allow NULL?
94	VL_TYPE_CD	Volume Type Code	nvarchar	2	0	CHAR	(N' ')	Yes	*	OIU_VL_TYPE_CD	Allow NULL?

Name	Primary	Unique	Type	Columns
OIUREP_RT_HIST~0	Yes	Yes	CLUSTERED	RTP_LINE_NUM, SALES_MONTH, SALES_YEAR, BUKRS, MANDT
OIUREP_RT_HIST~001	No	No	NONCLUSTERED	SALES_DATE, DOI_NO, VNAME, 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

94 COLUMNS | 2 INDEXES | ERP 6.0 | OIUREP_RT_HIST TABLE

TOP ERP 6.0 | OIUREP_RT_HIST COLUMNS

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

94 COLUMNS | 2 INDEXES | ERP 6.0 | OIUREP_RT_HIST TABLE

TOPERP 6.0 | OIUREP_RT_HIST COLUMNS

TOPERP 6.0 | OIUREP_RT_HIST INDEXES

TOP ERP 6.0 | OIUREP_RT_HIST COLUMNS

TOP ERP 6.0 | OIUREP_RT_HIST INDEXES