SAP ABAP Table OIUREP_AGY_LSE (Agency assigned Leases)

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_AGY_LSE	Table Relationship Diagram
Short Description	Agency assigned Leases

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	AGENCY	☑	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_ROY_AGY
3	AGENCY_LEASE	☑	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
4	RRC_LEASE_NO	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
5	RRC_WL_LSE_NO	☐	OIUH_GAS_WELL_NO_RRC	CHAR9	CHAR	9	0	Gas Well Number (RRC)
6	RRC_DIST_CD	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
7	FIELD_ID	☐	OIU_FIELDID	OIU_FIELDID	CHAR	10	0	Field ID	*
8	OPERATOR_NO	☐	OIUCM_BUS_ASSOC	OIUCM_BUS_ASSOC	CHAR	6	0	Business Associate
9	SEQ_NO	☐	OIUREP_TXN_CD	OIUCM_SEQ_NO	CHAR	2	0	Transaction code for Royalty reporting
10	TRANSP_ORG_CD	☐	OIUY1_TRNSP_ORG_CD	CHAR4	CHAR	4	0	Transport Org Cd
11	LEASE_SHR_PCNT	☐	OIUY1_LSE_SHR_PCNT	OIUY1_LSE_SHR_PCNT	DEC	11	8	Lease Share Percentage
12	WELL_IND	☐	OIUY1_WELL_IND	CHAR1	CHAR	1	0	Well Indicator
13	SW_SWEET_FL	☐	OIUY1_SW_FLAG	OIUY1_SR	CHAR	1	0	Sweet or Sour Flag(Y/N)
14	REPORT_NO	☐	OIUY1_RPT_NO	CHAR4	CHAR	4	0	Plant Org Id
15	UNIT_NO	☐	OIUY1_UNIT_NO	CHAR6	CHAR	6	0	Unit Number
16	SEC	☐	OIUY1_SECTION_NO	CHAR6	CHAR	6	0	Section Number
17	TWP	☐	OIU_TWP_NO	CHAR3	CHAR	3	0	Township number
18	RGE	☐	OIUY1_RGE	CHAR3	CHAR	3	0	RGE
19	ROYALTY_DEC	☐	OIUY1_ROY_DEC	OIUY1_ROYALTY_DEC	DEC	9	8	Royalty Decimal
20	OPERATOR	☐	OIUY1_OPERATOR	LIFNR	CHAR	10	0	Operator	*
21	PUR_TAXID	☐	OIUY1_PURTAXID	CHAR13	CHAR	13	0	Purchaser Tax ID
22	OPER_TAXID	☐	OIUY1_OPERTAXID	CHAR13	CHAR	13	0	Operator TAX ID
23	TRACT_NO	☐	OIUY1_TRACT_NO	CHAR18	CHAR	18	0	Tract Number
24	.INCLUDE	☐				0	0	Creator and date/time created
25	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
26	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
27	LEASE_SHR_PCNTO	☐	OIUY1_LSE_SHR_PCNT	OIUY1_LSE_SHR_PCNT	DEC	11	8	Lease Share Percentage
28	TXN_CD_O	☐	OIUREP_TXN_CD	OIUCM_SEQ_NO	CHAR	2	0	Transaction code for Royalty reporting
29	TYPE_IND	☐	OIUY1_TYPE_IND	CHAR1	CHAR	1	0	RRC Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_AGY_LSE	AGENCY	OIUREP_ROY_AGY	AGENCY		1	CN
2	OIUREP_AGY_LSE	MANDT	T000	MANDT

History

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