SAP ABAP Table ROIUY1_TX_AM1_DL (Download for A&M oil 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_AM1_DL	Table Relationship Diagram
Short Description	Download for A&M oil 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	OPERATOR_NO	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
2	REPORTER	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
3	PREP_BY	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
4	TEL_NO	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
5	EMAIL	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
6	ST_LEASE	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
7	PROD_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
8	RPT_TYPE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
9	UNIT_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
10	TR_NO	☐	OIU_TR_NO	OIU_TR_NO	CHAR	6	0	Tract Number
11	ANNUAL_REPORT	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
12	OPER_TAXID	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
13	PUR_TAXID	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
14	ROY_PAYTAXID	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
15	OIL_COND	☐	OIUY1_PRD_REPORTED	CHAR1	CHAR	1	0	Production Reported (oil/condensate)
16	SW_SWEET_FL	☐	OIUY1_SW_FLAG	OIUY1_SR	CHAR	1	0	Sweet or Sour Flag(Y/N)
17	ROY_OBLIGATION	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
18	BEG_STK	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
19	GROSS_PROD	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
20	PIPELINE	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
21	TRKS_CAR	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
22	TANK_CLEAN	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
23	CIR_OIL	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
24	LOST	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
25	BASIC_SEDIMENT	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
26	OTHER_ROY_DUE	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
27	NO_ROY_DUE	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
28	SKIM_SALES	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
29	SCRUBBER	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
30	TIK	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
31	END_STOCK	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
32	NET_BARRELS	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
33	API_GRV	☐	OIUH_CHAR9	CHAR9	CHAR	9	0	OIUH_CHAR9
34	PRICE	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
35	GROSS_VALUE	☐	OIUH_CHAR12	CHAR12	CHAR	12	0	OIUH_CHAR12
36	ROY_DEC	☐	OIUH_CHAR16	CHAR16	CHAR	16	0	OIUH_CHAR16
37	ROY_DUE	☐	OIUH_CHAR12	CHAR12	CHAR	12	0	OIUH_CHAR12
38	FL_NM1	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
39	LSE_NM1	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
40	RRC_OIL_NO1	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
41	RRC_WL_LSE_NO1	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
42	RRC_OIL_NO2	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
43	RRC_WL_LSE_NO2	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
44	RRC_OIL_NO3	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
45	RRC_WL_LSE_NO3	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
46	RRC_OIL_NO4	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
47	RRC_WL_LSE_NO4	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
48	RRC_OIL_NO5	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
49	RRC_WL_LSE_NO5	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
50	RRC_OIL	☐			CHAR	700	0
51	RRC_GAS	☐			CHAR	700	0

History

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