SAP ABAP Table ROIUREP_RE_SCREEN (Structure for 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	INTTAB	Structure
Structure	ROIUREP_RE_SCREEN	Table Relationship Diagram
Short Description	Structure for reporting entities

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Entities for Royalty Reporting
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	YEAR_MONTH	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
4	ORG_LEVEL1_NO	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	AGENCY	☐	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_ROY_AGY
6	OIL_GAS_IND	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
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_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.	OIUREP_AGY_LSE
13	LSE_ALLOC_FAC	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
14	UNIT_PROP_FLAG	☐	OIUREP_UNIT_PROP_FLAG	CHAR1	CHAR	1	0	Unit Property Flag
15	PAYOR_FRACTION	☐	OIUREP_REPORT_FACTOR	OIUREP_PAYOR_FRACTION	DEC	9	8	Report factor for royalty reporting
16	ENTL_FLAG	☐	OIUY1_ENTL_FLAG	OIUY1_FLAG	CHAR	1	0	Entitlement Flag
17	ROY_OBLIGATION	☐	OIUY1_ROY_OBLG	OIUY1_FLAG	CHAR	1	0	Royalty Obligation (Y/N)
18	.INCLUDE	☐				0	0	Creator and date/time created
19	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
21	PERCENT_REPORTED	☐	OIUREP_REPORT_FACTOR	OIUREP_PAYOR_FRACTION	DEC	9	8	Report factor for royalty reporting
22	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
23	VNAME_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
24	DOI_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
25	MP_NO_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
26	WL_NO_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
27	WC_NO_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
28	LEASE_SHTXT	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text

Foreign Keys

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

History

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