SAP ABAP Table OIUY3_TX_RPODT (Royalty 2.0 - TX GLO/TAMU - Oil Report)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y3 (Package) Royalty 2.0 - Texas GLO/TAMU
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUY3_TX_RPODT   Table Relationship Diagram
Short Description Royalty 2.0 - TX GLO/TAMU - Oil Report    
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 .INCLUDE       0   0   Royalty 2.0 - Texas GLO/TAMU - Oil Report Key  
3 RUN_ID OIUX3_RUN_ID NUMC10 NUMC 10   0   Tax Reporting - Run ID  
4 PROD_YEAR_MO OIUY3_TX_PROD_YEAR_MO OIU_PROD_MONTH ACCP 6   0   Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM  
5 GLO_LEASE OIUY3_TX_GLO_LEASE OIUY3_TX_GLO_LEASE NUMC 6   0   Royalty 2.0 - TX GLO/TAMU Lease OIUY3_TX_LEASE
6 RRC_DISTRICT_NO OIUY3_TX_GLO_DISTRICT_NO   CHAR 2   0   Royalty 2.0 - TX GLO/TAMU - District Number  
7 RRC_OIL_LEASE_NO OIUY3_TX_GLO_RRC_OIL_LEASE_NO   CHAR 5   0   Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number  
8 RRC_GAS_WELL_ID OIUY3_TX_GLO_RRC_GAS_WELL_ID   CHAR 6   0   Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID  
9 RRC_DRILL_PERMIT OIUY3_TX_GLO_RRC_DRILLING_PERM   CHAR 6   0   Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit  
10 PURCHASER_ID OIUY3_TX_PURCHASER_ID   NUMC 11   0   Royalty 2.0 - Texas GLO/TAMU - Purchaser ID  
11 REV_BOOK_ADJ_IND OIUY3_REV_BOOK_REVADJ_ADJ_IND OIUY3_REV_BOOK_REVADJ_ADJ_IND CHAR 1   0   Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs  
12 .INCLUDE       0   0   Royalty 2.0 - Texas GLO/TAMU - Oil Report Non-Key  
13 RRC_FIELD_NAME OIUY3_TX_GLO_RRC_FIELD_NAME   CHAR 32   0   Royalty 2.0 - TX GLO/TAMU - RRC Field Name  
14 RRC_LEASE_NAME OIUY3_TX_GLO_RRC_LEASE_NAME   CHAR 32   0   Royalty 2.0 - TX GLO/TAMU - RRC Lease Name  
15 PROP_ALIAS_NAME OIUY3_TX_GLO_PROP_ALIAS_NAME   CHAR 32   0   Royalty 2.0 - TX GLO/TAMU - Property Alias Name  
16 REPORT_TYPE OIUY3_TX_REPORT_TYPE OIUY3_TX_REPORT_TYPE CHAR 1   0   Royalty 2.0 - Texas GLO/TAMU - Report Type  
17 GLO_UNIT_NO OIUY3_TX_GLO_UNIT_NO   CHAR 4   0   Royalty 2.0 - Texas GLO/TAMU - Unit Number  
18 TRACT_PART_FACT OIUY3_TX_TRACT_PART_FACTOR OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Texas GLO - Tract Participation Factor  
19 OVERRIDE_CODE OIUY3_TX_OVERRIDE_CODE   CHAR 5   0   Royalty 2.0 - TX GLO/TAMU - Override Code  
20 OPERATOR_ID OIUY3_TX_OPERATOR_ID OIUY3_TX_ID CHAR 10   0   Royalty 2.0 - TX GLO - Operator ID  
21 PROD_DISP_RPT OIUY3_TX_PROD_DISP_RPT_IND YESNO CHAR 1   0   Royalty 2.0 - TX GLO/TAMU - Production Disp Report Indicator  
22 AFFILIATED_SALE OIUY3_TX_AFFILIATED_SALE_IND YESNO CHAR 1   0   Royalty 2.0 - TX GLO - Affiliated Sale Indicator  
23 GLO_TIK OIUY3_TX_GLO_TIK YESNO CHAR 1   0   Royalty 2.0 - Texas GLO/TAMU - GLO TIK  
24 .INCLUDE       0   0   Royalty 2.0 - Texas GLO/TAMU - Oil Report Non-Key Prod Vol  
25 BEGINNING_STOCK OIUY3_TX_BEGINNING_STOCK OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Beginning Stock  
26 GROSS_PRODUCTION OIUY3_TX_GROSS_PRODUCTION OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Gross Production  
27 PIPELINE OIUY3_TX_PIPELINE OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Pipeline  
28 TRUCK OIUY3_TX_TRUCK OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Truck  
29 TANK_CAR_BARGE OIUY3_TX_TANK_CAR_BARGE OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Tank Car Barge  
30 TANK_CLEANING OIUY3_TX_TANK_CLEANING OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Tank Cleaning  
31 CIRC_OIL_COND OIUY3_TX_CIRCULATING_OIL_COND OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Circulating Oil/Condensate  
32 LOST_STOLEN OIUY3_TX_LOST_STOLEN OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Lost/Stolen  
33 BSW OIUY3_TX_BASIC_SEDIMENT_WATER OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Basic Sediment / Water  
34 OTHER_ROY_DUE OIUY3_TX_OTHER_ROYALTY_DUE OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Other Royalty Due  
35 OTHER_NO_ROY_DUE OIUY3_TX_OTHER_NO_ROYALTY_DUE OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Other No Royalty Due  
36 SKIM_LIQ_HYDRO OIUY3_TX_SKIM_LIQUID_HYDRO OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Skim Liquid Hydrocarbon  
37 SCRUBBER_OIL OIUY3_TX_SCRUBBER_OIL OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Scrubber Oil  
38 ENDING_STOCK OIUY3_TX_ENDING_STOCK OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Ending Stock  
39 DRIP_OIL OIUY3_TX_DRIP_OIL OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Drip Oil  
40 ENTIRE_ROY_OB OIUY3_TX_ENTIRE_ROYALTY_OB OIUY3_TX_ENTIRE_ROYALTY_OB CHAR 1   0   Royalty 2.0 - TX GLO/TAMU - Entire Royalty Obligation  
41 ROY_DUE_NET_BBLS OIUY3_TX_ROY_DUE_NET_BARRELS OIUY3_SIGNED_DEC_15_6 DEC 15   6   Royalty 2.0 - TX GLO/TAMU - Royalty Due Net Barrels  
42 API_GRAVITY OIUY3_TX_API_GRAVITY   DEC 9   6   Royalty 2.0 - Texas GLO/TAMU - API Gravity  
43 UNIT_VALUE OIUY3_TX_UNIT_VALUE   DEC 9   6   Royalty 2.0 - Texas GLO/TAMU - Unit Value  
44 GROSS_VALUE OIUX3_GROSS_VALUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Gross Value  
45 ROYALTY_DECIMAL OIUY3_TX_ROYALTY_DECIMAL OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Texas GLO - Royalty Decimal  
46 ROYALTY_DUE OIUY3_TX_ROYALTY_DUE OIUX3_SIGNED_CURR_11_2 CURR 11   2   Royalty 2.0 - Texas GLO/TAMU - Royalty Due  
47 COMMENT_FL OIUY3_TX_COMMENT_FL YESNO CHAR 1   0   Royalty 2.0 - Texas GLO/TAMU - Comment Flag  
48 ORIGINAL_REPORT OIUY3_TX_ORIGINAL_REPORT OIUY3_TX_ORIGINAL_REPORT CHAR 1   0   Royalty 2.0 - TX GLOTAMU - Original Report  
49 ZERO_VOL OIUY3_TX_ZERO_VOL YESNO CHAR 1   0   Royalty 2.0 - Texas GLO/TAMU - Zero Volume Flag  
50 PAY_REPORT_FLAG OIUY3_TX_PAY_REPORT_FLAG OIUY3_TX_PAY_REPORT_FLAG CHAR 1   0   Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag  
51 EXPECTED_RPT_EXC OIUY3_TX_EXPECTED_RPT_EXCEEDED FLAG CHAR 1   0   Royalty 2.0 - Texas GLO/TAMU No of Expected Reports Exceeded  
52 MULTI_PURCHASER OIUY3_TX_MULTIPLE_PURCHASERS YESNO CHAR 1   0   Royalty 2.0 - Texas GLO/TAMU - Multiple Purchasers Flag  
53 REPORT_NUM OIUY3_TX_REPORT_NUM   NUMC 4   0   Roy 2.0 TX - Report Number  
54 .INCLUDE       0   0   Creator and date/time created  
55 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
56 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUY3_TX_RPODT GLO_LEASE OIUY3_TX_LEASE GLO_LEASE    
2 OIUY3_TX_RPODT MANDT T000 MANDT KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100