SAP ABAP Table ROIUY1_TX_UT1A_D (Structure to store detail records for UT1A Report)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y1 (Package) PRA Royalty Reporting - Migration To New Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUY1_TX_UT1A_D	Table Relationship Diagram
Short Description	Structure to store detail records for UT1A Report

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	ST_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
2	PROD_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
3	OIL_GAS	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
4	BEGSTK_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
5	BEGSTK_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
6	GROSSPROD_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
7	GROSSPROD_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
8	PIPELINE_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
9	PIPELINE_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
10	TRUCKS_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
11	TRUCKS_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
12	CODE1	☐	OIU_VL_TYPE_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume Type Code	*
13	CIR_OIL_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
14	CIR_OIL_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
15	CODE2	☐	OIU_VL_TYPE_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume Type Code	*
16	SKIM_OIL_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
17	SKIM_OIL_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
18	CODE3	☐	OIU_VL_TYPE_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume Type Code	*
19	TANK_CLEAN_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
20	TANK_CLEAN_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
21	CODE4	☐	OIU_VL_TYPE_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume Type Code	*
22	BASIC_SEDIMENT_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
23	BASIC_SEDIMENT_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
24	CODE5	☐	OIU_VL_TYPE_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume Type Code	*
25	LOST_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
26	LOST_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
27	CODE6	☐	OIU_VL_TYPE_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume Type Code	*
28	ENDSTK_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
29	ENDSTK_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
30	TIK_WIO_O	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
31	TIK_WIO_N	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
32	NETBARLS_N	☐			DEC	13	2
33	NETBARLS_O	☐			DEC	13	2
34	API_N	☐			DEC	5	1
35	API_O	☐			DEC	5	1
36	MARVALUE_O	☐	OIUY1_STD_VAL		DEC	13	2	Value
37	MARVALUE_N	☐	OIUY1_STD_VAL		DEC	13	2	Value
38	ROYDEC_N	☐	OIUY1_ROYALTY_DEC	OIUH_DEC9_6	DEC	9	6	Royalty Decimal
39	ROYDEC_O	☐	OIUY1_ROYALTY_DEC	OIUH_DEC9_6	DEC	9	6	Royalty Decimal
40	ROYDUE_O	☐	OIUY1_STD_VAL		DEC	13	2	Value
41	ROYDUE_N	☐	OIUY1_STD_VAL		DEC	13	2	Value
42	REC_COUNT	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
43	SALES_DATE	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
44	PUR_ID	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
45	RRC_LEASE_NO	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
46	EXCEEDS_PRD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1

History

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