	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

	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

	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

103 COLUMNS | 7 INDEXES | ERP 6.0 | OIUH_RV_RP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Revenue
1	ERP EHP7	6.0	OIUH_RV_RP	103	7	MMS Royalty Pending	Revenue

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, RP_SYS_NO, RP_SH_LE_NO, RP_SH_LE_SEQ_NO, RP_PAYOR_CD, P_FED_INDIAN_CD, RP_ACCT_ID_NO, RP_MMS_PD_CD, RP_SLL_ARGMT_NO, RP_SA_DT, RP_TXN_CD, RP_SA_MP_NO9, RP_SA_MP_NO, RP_WL_NO9, RP_WL_NO, RP_WC_NO9, RP_WC_NO, RP_DOI_PR_NO9, RP_DOI_PR_NO, RP_DOI_SEQ_NO9, RP_DOI_SEQ_NO, RP_PU_NO9, RP_PU_NO, RP_PU_SEQ_NO9, RP_PU_SEQ_NO, RP_CT_NO9, RP_CT_NO, RP_PD_CD, RP_RPT_DT, RP_SALES_QY, RP_GRV_QY, RP_BTU_QY, RP_SALES_AM, RP_ROY_QY, RP_ROY_AM, RP_DED_MFR_AM, P_DED_TRANSP_AM, RP_DED_RMB_AM, RP_TAX_AM, RP_TAX_RMB_AM, RP_RVRS_RSN_CD, RP_PS_BASE_QY, RP_AFFIL_FL, RP_OR_LVL_1_NO, RP_ACCT_PERD_DT, RP_BATCH_NO, RP_VOU_NO, RP_LE_NO, RP_ACCT_NO, RP_CT_TYPE_CD, RP_RPT_PTFC_PC, P_TRIB_ALLOT_CD, RP_GULF_MEX_FL, RP_COMP_ROY_FL, RP_OCS_FL, RP_MMS_PMETH_CD, RP_DFLT_CALC_CD, RP_MMS_SA_QY, RP_MMS_SA_AM, RP_MMS_ROY_QY, RP_MMS_ROY_AM, RP_MMS_ADJ_CD, RP_MMS_CALC_CD, RP_ADJ_FL, RP_SUSPENSE_FL, MMS_ADJ_SLL_QY, MMS_ADJ_ROY_QY, MMS_PS_BASE_QY, MMS_ADJ_BTU_QY, RP_STATUS_FL, RP_OWN_NO9, RP_OWN_NO, RP_OWN_SEQ_NO9, RP_OWN_SEQ_NO, ROY_IN_KIND_FL, RP_INDN_TRIB_NO, RP_STATE_CD, RP_OI_DECM_QY, RP_OI_TYPE_CD, RP_OI_SEQ_NO, RP_SUS_RSN_CD, RP_PAY_CD, P_TRIAL_ACTL_FL, RP_UNIT_PR_NO, RP_PHASE_NO, RP_PPA_H_ROY_QY, RP_PPA_H_SA_QY, RP_PPA_H_ROY_AM, RP_PPA_H_SA_AM, RP_NWK_NO9, RP_NWK_NO, RP_SUB_NWK_NO9, RP_SUB_NWK_NO, RP_SECT_PR_NO9, RP_SECT_PR_NO, RP_SECT_SEQ_NO9, RP_SECT_SEQ_NO, RP_HIST_FL, RP_VER_NO, RP_USER_ID, RP_TIMESTAMP, RP_CHV_RPT_CD, RP_VL_TYPE_CD FROM OIUH_RV_RP

TOP ERP 6.0 | OIUH_RV_RP COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RP_SYS_NO	OIUH_DEC18	decimal	18	0
3	RP_SH_LE_NO	OIUH_CHAR7	nvarchar	7	0	Allow NULL?
4	RP_SH_LE_SEQ_NO	OIUH_CHAR1	char	1	0	Allow NULL?
5	RP_PAYOR_CD	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
6	P_FED_INDIAN_CD	OIUH_CHAR1	char	1	0	Allow NULL?
7	RP_ACCT_ID_NO	OIUH_CHAR13	nvarchar	13	0	Allow NULL?
8	RP_MMS_PD_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
9	RP_SLL_ARGMT_NO	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
10	RP_SA_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
11	RP_TXN_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
12	RP_SA_MP_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
13	RP_SA_MP_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
14	RP_WL_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
15	RP_WL_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
16	RP_WC_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
17	RP_WC_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
18	RP_DOI_PR_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
19	RP_DOI_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
20	RP_DOI_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
21	RP_DOI_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
22	RP_PU_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
23	RP_PU_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
24	RP_PU_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
25	RP_PU_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
26	RP_CT_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
27	RP_CT_NO	Contract ID	nvarchar	6	0	Allow NULL?
28	RP_PD_CD	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
29	RP_RPT_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
30	RP_SALES_QY	OIUH_DEC11_2	decimal	11	2
31	RP_GRV_QY	OIUH_DEC3_1	decimal	3	1
32	RP_BTU_QY	OIUH_DEC7_3	decimal	7	3
33	RP_SALES_AM	Local amount	decimal	11	2
34	RP_ROY_QY	OIUH_DEC11_2	decimal	11	2
35	RP_ROY_AM	Local amount	decimal	11	2
36	RP_DED_MFR_AM	Local amount	decimal	11	2
37	P_DED_TRANSP_AM	Local amount	decimal	11	2
38	RP_DED_RMB_AM	Local amount	decimal	11	2
39	RP_TAX_AM	Local amount	decimal	11	2
40	RP_TAX_RMB_AM	Local amount	decimal	11	2
41	RP_RVRS_RSN_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
42	RP_PS_BASE_QY	OIUH_DEC6_3	decimal	6	3
43	RP_AFFIL_FL	OIUH_CHAR1	char	1	0	Allow NULL?
44	RP_OR_LVL_1_NO	OIUH_CHAR3	nvarchar	3	0	Allow NULL?
45	RP_ACCT_PERD_DT	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
46	RP_BATCH_NO	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
47	RP_VOU_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
48	RP_LE_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
49	RP_ACCT_NO	OIUH_CHAR10	nvarchar	10	0	Allow NULL?
50	RP_CT_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
51	RP_RPT_PTFC_PC	OIUH_DEC8_8	decimal	8	8
52	P_TRIB_ALLOT_CD	OIUH_CHAR1	char	1	0	Allow NULL?
53	RP_GULF_MEX_FL	OIUH_CHAR1	char	1	0	Allow NULL?
54	RP_COMP_ROY_FL	OIUH_CHAR1	char	1	0	Allow NULL?
55	RP_OCS_FL	OIUH_CHAR1	char	1	0	Allow NULL?
56	RP_MMS_PMETH_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
57	RP_DFLT_CALC_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
58	RP_MMS_SA_QY	OIUH_DEC11_2	decimal	11	2
59	RP_MMS_SA_AM	Local amount	decimal	11	2
60	RP_MMS_ROY_QY	OIUH_DEC11_2	decimal	11	2
61	RP_MMS_ROY_AM	Local amount	decimal	11	2
62	RP_MMS_ADJ_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
63	RP_MMS_CALC_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
64	RP_ADJ_FL	OIUH_CHAR1	char	1	0	Allow NULL?
65	RP_SUSPENSE_FL	OIUH_CHAR1	char	1	0	Allow NULL?
66	MMS_ADJ_SLL_QY	OIUH_DEC11_2	decimal	11	2
67	MMS_ADJ_ROY_QY	OIUH_DEC11_2	decimal	11	2
68	MMS_PS_BASE_QY	OIUH_DEC6_3	decimal	6	3
69	MMS_ADJ_BTU_QY	OIUH_DEC7_3	decimal	7	3
70	RP_STATUS_FL	OIUH_CHAR1	char	1	0	Allow NULL?
71	RP_OWN_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
72	RP_OWN_NO	OIUH_CHAR6	nvarchar	6	0	Allow NULL?
73	RP_OWN_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
74	RP_OWN_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
75	ROY_IN_KIND_FL	OIUH_CHAR1	char	1	0	Allow NULL?
76	RP_INDN_TRIB_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
77	RP_STATE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
78	RP_OI_DECM_QY	OIUH_DEC9_8	decimal	9	8
79	RP_OI_TYPE_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
80	RP_OI_SEQ_NO	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
81	RP_SUS_RSN_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
82	RP_PAY_CD	OIUH_CHAR2	nvarchar	2	0	Allow NULL?
83	P_TRIAL_ACTL_FL	OIUH_CHAR1	char	1	0	Allow NULL?
84	RP_UNIT_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
85	RP_PHASE_NO	OIUH_CHAR1	char	1	0	Allow NULL?
86	RP_PPA_H_ROY_QY	OIUH_DEC11_2	decimal	11	2
87	RP_PPA_H_SA_QY	OIUH_DEC11_2	decimal	11	2
88	RP_PPA_H_ROY_AM	Local amount	decimal	11	2
89	RP_PPA_H_SA_AM	Local amount	decimal	11	2
90	RP_NWK_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
91	RP_NWK_NO	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
92	RP_SUB_NWK_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
93	RP_SUB_NWK_NO	OIUH_CHAR4	nvarchar	4	0	Allow NULL?
94	RP_SECT_PR_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
95	RP_SECT_PR_NO	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
96	RP_SECT_SEQ_NO9	OIUH_CHAR1	char	1	0	Allow NULL?
97	RP_SECT_SEQ_NO	OIUH_CHAR5	nvarchar	5	0	Allow NULL?
98	RP_HIST_FL	OIUH_CHAR1	char	1	0	Allow NULL?
99	RP_VER_NO	OIUH_DEC5	decimal	5	0
100	RP_USER_ID	OIUH_CHAR8	nvarchar	8	0	Allow NULL?
101	RP_TIMESTAMP	OIUH_CHAR14	nvarchar	14	0	Allow NULL?
102	RP_CHV_RPT_CD	PRA Cost Center	nvarchar	10	0	Allow NULL?
103	RP_VL_TYPE_CD	Volume Type Code	nvarchar	2	0	Allow NULL?

TOP ERP 6.0 | OIUH_RV_RP INDEXES

Name	Primary	Unique	Type	Columns
OIUH_RV_RP~0	Yes	Yes	CLUSTERED	RP_SYS_NO, MANDT
OIUH_RV_RP~I01	No	No	NONCLUSTERED	RP_STATUS_FL, RP_SUSPENSE_FL, RP_SH_LE_SEQ_NO, RP_SH_LE_NO, P_FED_INDIAN_CD, RP_PAYOR_CD, RP_OR_LVL_1_NO, MANDT
OIUH_RV_RP~I02	No	No	NONCLUSTERED	RP_OCS_FL, RP_SA_DT, RP_MMS_PD_CD, RP_ACCT_ID_NO, RP_PAYOR_CD, MANDT
OIUH_RV_RP~I03	No	No	NONCLUSTERED	RP_TXN_CD, RP_SH_LE_NO, RP_ACCT_NO, RP_LE_NO, RP_VOU_NO, RP_BATCH_NO, RP_ACCT_PERD_DT, RP_OR_LVL_1_NO, MANDT
OIUH_RV_RP~I04	No	No	NONCLUSTERED	RP_OWN_SEQ_NO, RP_OWN_NO, RP_MMS_PMETH_CD, RP_PAYOR_CD, RP_OR_LVL_1_NO, MANDT
OIUH_RV_RP~I05	No	Yes	NONCLUSTERED	RP_SH_LE_SEQ_NO, RP_SH_LE_NO, MANDT
OIUH_RV_RP~I06	No	No	NONCLUSTERED	RP_SA_DT, RP_OWN_SEQ_NO, RP_OWN_NO, RP_DOI_SEQ_NO, RP_DOI_PR_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

103 COLUMNS | 7 INDEXES | ERP 6.0 | OIUH_RV_RP TABLE

TOP ERP 6.0 | OIUH_RV_RP COLUMNS

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

103 COLUMNS | 7 INDEXES | ERP 6.0 | OIUH_RV_RP TABLE

TOPERP 6.0 | OIUH_RV_RP COLUMNS

TOPERP 6.0 | OIUH_RV_RP INDEXES

TOP ERP 6.0 | OIUH_RV_RP COLUMNS

TOP ERP 6.0 | OIUH_RV_RP INDEXES