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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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_RTPEND	94	1	MMS-2014 - Royalty Transaction Pending	Royalty Reporting

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
3	SALES_YEAR	MMS-2014 - Year	nvarchar	4	0	Allow NULL?
4	SALES_MONTH	MMS-2014 - Month	nvarchar	2	0	Allow NULL?
5	RTP_LINE_NUM	MMS-2014 - Line Number	nvarchar	10	0	Allow NULL?
6	PAYOR_NO	Production: MMS-2014 - Payor	nvarchar	5	0	Allow NULL?
7	FED_INDIAN_CD	Production: MMS-2014 - Federal or Indian Code	char	1	0	Allow NULL?
8	INDIAN_TRIBE_NO	Production: MMS-2014 - Indian Tribe Number	nvarchar	2	0	Allow NULL?
9	API_WELL_NO	API well number	nvarchar	12	0	Allow NULL?
10	API_WELL_CM_NO	API well completion number	nvarchar	3	0	Allow NULL?
11	LEASE_NO	MMS-2014 - Lease Number	nvarchar	11	0	Allow NULL?
12	AGREEMENT_NO	Production: MMS-2014 - Agreement Number	nvarchar	11	0	Allow NULL?
13	MMS_PROD_CD	Production: MMS Product Code	nvarchar	2	0	Allow NULL?
14	SALES_TYPE_CD	Production: MMS-2014 - Sales Type Code	nvarchar	4	0	Allow NULL?
15	SALES_DATE	Sales Date / Month	nvarchar	8	0	Allow NULL?
16	TRANS_CD	Production: MMS-2014 - Transaction Code	nvarchar	2	0	Allow NULL?
17	PAY_METHOD_CD	Production: MMS-2014 - Payment Method Code	char	1	0	Allow NULL?
18	WL_NO	Well ID number	nvarchar	15	0	Allow NULL?
19	WC_NO	Well Completion Number	nvarchar	5	0	Allow NULL?
20	VNAME	MMS-2014 - Venture	nvarchar	6	0	Allow NULL?
21	DOI_NO	Division of interest (DOI)	nvarchar	5	0	Allow NULL?
22	PU_NO	Purchaser	nvarchar	10	0	Allow NULL?
23	PU_SEQ_NO	Purchasing Representative Interest Sequence No	nvarchar	2	0	Allow NULL?
24	PU_AFFIL_FL	Production: MMS-2014 - Purchaser Affiliation Flag	char	1	0	Allow NULL?
25	MATNR	Material Number	nvarchar	18	0	Allow NULL?
26	OWN_NO	PRA owner	nvarchar	10	0	Allow NULL?
27	OWN_ISQ_NO	Owner Interest Sequence Number	nvarchar	2	0	Allow NULL?
28	CT_NO	Contract Number	nvarchar	10	0	Allow NULL?
29	GL_ACCTID_NO	Account ID	nvarchar	10	0	Allow NULL?
30	NWK_NO	Network Number	nvarchar	4	0	Allow NULL?
31	SUB_NWK_NO	Sub Network Number	nvarchar	4	0	Allow NULL?
32	INT_TYPE_CD	Interest Type Code	nvarchar	2	0	Allow NULL?
33	INT_SEQ_NO	Interest Sequence Number	nvarchar	2	0	Allow NULL?
34	SALES_QY	Sales Quantity	decimal	13	3
35	SALES_QY_U	Production: MMS-2014 - Sales Qty Unit	nvarchar	3	0	Allow NULL?
36	SALES_GV_QY	Production: MMS-2014 - Sales Gravity Qty	decimal	4	1
37	SALES_GV_QY_U	Production: MMS-2014 - Sales Gravity Qty Unit	nvarchar	3	0	Allow NULL?
38	SALES_BTU_QY	Production: MMS-2014 - Sales BTU Quantity	decimal	13	3
39	SALES_BTU_QY_U	Production: MMS-2014 - Sales BTU Qty Unit	nvarchar	3	0	Allow NULL?
40	SALES_PS_BASE_QY	Pressure Base	decimal	13	3
41	SALES_PS_BASE_U	Pressure Base Unit	nvarchar	3	0	Allow NULL?
42	SALES_AMT	Production: MMS-2014 - Sales Amount	decimal	15	2
43	SALES_CUR	Production: MMS-2014 - Sales Currency	nvarchar	5	0	Allow NULL?
44	ROY_PR_ALW_AMT	Production: MMS-2014 - Royalty Value Prior to Allows. Amt	decimal	15	2
45	ROY_PR_ALW_CUR	Production: MMS-2014 - Royalty Value Prior to Allows. Curr	nvarchar	5	0	Allow NULL?
46	TRNSP_ALW_DE_AMT	Production: MMS-2014 - Transportation Allowance Amount	decimal	15	2
47	TRNSP_ALW_DE_CUR	MMS-2014 - Transportation Allowance Currency	nvarchar	5	0	Allow NULL?
48	PROC_ALW_DE_AMT	Production: MMS-2014 - Manufacturing UOM Amount	decimal	15	2
49	PROC_ALW_DE_CUR	Production: MMS-2014 - Manufacturing UOM Currency	nvarchar	5	0	Allow NULL?
50	ROY_LS_ALLOW_AMT	Production: MMS-2014 - Royalty Value Less Allows. Amt	decimal	15	2
51	ROY_LS_ALLOW_CUR	Production: MMS-2014 - Royalty Value Less Allows Curr	nvarchar	5	0	Allow NULL?
52	ROY_QY	Production: MMS-2014 - Royalty Quantity	decimal	13	3
53	ROY_QY_U	Production: MMS-2014 - Royalty Quantity Unit	nvarchar	3	0	Allow NULL?
54	DED_REMB_AMT	Production: MMS-2014 - Deduction Reimbursement Amount	decimal	15	2
55	DED_REMB_CUR	Production: MMS-2014 - Deduction Reimbursement Currency	nvarchar	5	0	Allow NULL?
56	TAX_AMT	Production: MMS-2014 - Tax Amount	decimal	15	2
57	TAX_CUR	Production: MMS-2014 - Tax Currency	nvarchar	5	0	Allow NULL?
58	TAX_REMB_AMT	Production: MMS-2014 - Tax Reimbursement Amount	decimal	15	2
59	TAX_REMB_CUR	Production: MMS-2014 - Tax Reimbursement Currency	nvarchar	5	0	Allow NULL?
60	MMS_ROY_QY	Production: MMS-2014 - MMS Royalty Quantity	decimal	13	3
61	MMS_ROY_QY_U	Production: MMS-2014 - MMS Royalty Quantity Unit	nvarchar	3	0	Allow NULL?
62	MMS_PS_BASE_QY	Pressure Base	decimal	13	3
63	MMS_PS_BASE_QY_U	Pressure Base Unit	nvarchar	3	0	Allow NULL?
64	MMS_ROY_AMT	MMS-2014 - JE Offset Amount	decimal	15	2
65	MMS_ROY_CUR	MMS-2014 - JE Offset Currency	nvarchar	5	0	Allow NULL?
66	MMS_SA_QY	Production: MMS-2014 - MMS Sales Quantity	decimal	13	3
67	MMS_SA_QY_U	Production: MMS-2014 - MMS Sales Quantity Unit	nvarchar	3	0	Allow NULL?
68	MMS_SA_AMT	Production: MMS-2014 - MMS Sales Amount	decimal	15	2
69	MMS_SA_CUR	Production: MMS-2014 - MMS Sales Currency	nvarchar	5	0	Allow NULL?
70	SUSPEND_RSN_CD	Suspense Reason Code	nvarchar	3	0	Allow NULL?
71	ADJ_CD	Production: MMS-2014 - Adjustment Reason Code	nvarchar	2	0	Allow NULL?
72	ADJ_SA_QY	Production: MMS-2014 - Adjusted Sales Quantity	decimal	13	3
73	ADJ_SA_QY_U	Production: MMS-2014 - Adjusted Sales Quantity Unit	nvarchar	3	0	Allow NULL?
74	ADJ_ROY_QY	Production: MMS-2014 - Adjusted Royalty Quantity	decimal	13	3
75	ADJ_ROY_QY_U	Production: MMS-2014 - Adjusted Royalty Quantity Unit	nvarchar	3	0	Allow NULL?
76	ADJ_BTU_QY	Production: MMS-2014 - Adjusted BTU Quantity	decimal	13	3
77	ADJ_BTU_QY_U	Production: MMS-2014 - Adjusted BTU Quantity Unit	nvarchar	3	0	Allow NULL?
78	GAS_MMBTU_QY	Production: MMS-2014 - Gas MMBTU Qty	decimal	13	3
79	GAS_MMBTU_QY_U	Production: MMS-2014 - Gas MMBTU Qty Unit	nvarchar	3	0	Allow NULL?
80	HISTORY_FL	Production: MMS-2014 - History Flag	char	1	0	Allow NULL?
81	REPORT_PART_FAC	Production: MMS-2014 - Report Participation Factor	decimal	9	8
82	TRIBAL_ALLOT_CD	Production: MMS-2014 - Tribal/Allottee Code	char	1	0	Allow NULL?
83	COMP_ROY_FL	Production: MMS-2014 - Compensatory Royalty Flag	char	1	0	Allow NULL?
84	ROY_IN_KIND_FL	Production: MMS-2014 - Royalty In Kind Flag	char	1	0	Allow NULL?
85	PAY_CD	Production: MMS-2014 - Payment Code	nvarchar	2	0	Allow NULL?
86	EXTRACTED_FL	MMS-2014: Extracted	char	1	0	Allow NULL?
87	EXTRACT_RUN_TYPE	Defines whether the run is direct pay or not	char	1	0	Allow NULL?
88	MANUAL_CREATE_FL		char	1	0	Allow NULL?
89	OIU_CRUSER	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
90	OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
91	CHANGE_USER	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
92	CHANGE_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
93	COST_CENTER	PRA Cost Center	nvarchar	10	0	Allow NULL?
94	VL_TYPE_CD	Volume Type Code	nvarchar	2	0	Allow NULL?

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 | 1 INDEXES | ERP 6.0 | OIUREP_RTPEND TABLE

TOP ERP 6.0 | OIUREP_RTPEND COLUMNS

TOP ERP 6.0 | OIUREP_RTPEND 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 | 1 INDEXES | ERP 6.0 | OIUREP_RTPEND TABLE

TOPERP 6.0 | OIUREP_RTPEND COLUMNS

TOPERP 6.0 | OIUREP_RTPEND INDEXES

TOP ERP 6.0 | OIUREP_RTPEND COLUMNS

TOP ERP 6.0 | OIUREP_RTPEND INDEXES