SAP ABAP Table OIUREP_ROY_DATA (Reported Royalty and Volume Data by Reporting Entities)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_REP (Package) Production, Tax & Royalty Reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUREP_ROY_DATA	Table Relationship Diagram
Short Description	Reported Royalty and Volume Data by Reporting Entities

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	YEAR_MONTH	☑	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
3	ORG_LEVEL1_NO	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	AGENCY	☑	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_ROY_AGY
5	OIL_GAS_IND	☑	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
6	YEAR_MONTH_AMND	☑	OIUREP_AMND_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Year and Month for Amended Reports
7	PROPERTY_NO	☑	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
8	DOI_NO	☑	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
9	WL_NO	☑	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
10	WC_NO	☑	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
11	MP_NO	☑	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
12	AGENCY_PROD_CODE	☑	OIUREP_AGENCY_PDCD	OIUREP_AGENCY_PDCD	CHAR	3	0	Agency defined product code	OIUREP_AGY_PDCD
13	AGENCY_VOL_TYPE	☑	OIUREP_AGENCY_VOL_TYPE	CHAR2	CHAR	2	0	Agency defined Volume type	OIUREP_AGY_VLTP
14	GRAVITY_QTY	☑	OIUREP_GRV_QY_NUMC4	NUMC4	NUMC	4	0	Gravity Quantity
15	UNIT_PROPERTY_NO	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
16	GROSS_VOLUME	☐	OIUREP_GROSS_VOLUME	MENGE	QUAN	13	3	Gross Volume
17	NGL_VOLUME	☐	OIUY1_NGL_VOLUME	MENGE	QUAN	13	3	NGL Volume
18	NET_VOLUME	☐	OIUREP_NET_VOLUME	MENGE	QUAN	13	3	Net Volume
19	STD_VOL_U	☐	OIU_STD_VOL_U	MEINS	UNIT	3	0	Standard volume unit	*
20	GROSS_VALUE	☐	OIUREP_GROSS_VALUE	OIUREP_VALUE	CURR	13	2	Gross Value From a Contract/Well
21	NET_VALUE	☐	OIUREP_NET_VALUE	OIUREP_VALUE	CURR	13	2	Net Value From a Contract/Well
22	TRANSPORT_COST	☐	OIUREP_TRANSPORT_COST	OIUREP_VALUE	CURR	13	2	Transportation Cost
23	TAX_AMT	☐	OIUREP_TAX_AMOUNT	OIUH_CURR11_2	CURR	11	2	Tax Amount
24	MARKETING_TOT	☐	OIUREP_MKT_AMOUNT	OIUH_CURR11_2	CURR	11	2	Marketing Amount
25	DEDUCTION_AMT1	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
26	DEDUCTION_AMT2	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
27	DEDUCTION_AMT3	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
28	DEDUCTION_AMT4	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
29	ROYALTY_DUE	☐	OIUREP_ROYALTY_DUE	OIUREP_VALUE	CURR	13	2	Royalty Amount due to the State Agency
30	CURRENCY	☐	OIUREP_CURRENCY	WAERS	CUKY	5	0	Currency	*
31	ENERGY	☐	OIUREP_ENERGY	OIUH_DEC21_8	QUAN	21	8	energy
32	ENERGY_U	☐	OIU_ENERGY_U	MEINS	UNIT	3	0	Energy quantity unit	*
33	TRACT_PF	☐	OIU_TR_PART_FACT_PC	OIU_PERCENT98	DEC	9	8	Tract Participation Factor Decimal
34	API_GRV	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
35	UPLOAD_FLAG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
36	.INCLUDE	☐				0	0	Creator and date/time created
37	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
38	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_ROY_DATA	AGENCY	OIUREP_ROY_AGY	AGENCY		1	CN
2	OIUREP_ROY_DATA	AGENCY_PROD_CODE	OIUREP_AGY_PDCD	AGENCY_PROD_CODE
3	OIUREP_ROY_DATA	AGENCY_VOL_TYPE	OIUREP_AGY_VLTP	AGENCY_VOL_TYPE		1	CN
4	OIUREP_ROY_DATA	DOI_NO	OIU_DO_DI	DOI_NO
5	OIUREP_ROY_DATA	MANDT	T000	MANDT
6	OIUREP_ROY_DATA	MP_NO	OIU_PR_MP	MP_NO
7	OIUREP_ROY_DATA	ORG_LEVEL1_NO	T001	BUKRS
8	OIUREP_ROY_DATA	PROPERTY_NO	OIU_DO_JV	VNAME
9	OIUREP_ROY_DATA	WC_NO	OIU_PR_WC	WC_NO
10	OIUREP_ROY_DATA	WL_NO	OIU_PR_WELL	WL_NO

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C