SAP ABAP Table ROIUREP_AGY_LSE_U (structure ROIUREP_AGY_LSE_U)

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_AGY_LSE_U	Table Relationship Diagram
Short Description	structure ROIUREP_AGY_LSE_U

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

Foreign Keys

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

History

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