OIUY3_TX_RPGDT SAP table for – Royalty 2.0 – TX GLO/TAMU – Gas Report

Here we would like to draw your attention to OIUY3_TX_RPGDT table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUY3_TX_RPGDT is a SAP standard transp table used for storing Royalty 2.0 – TX GLO/TAMU – Gas Report related data in SAP. It comes under the package OIU_Y3.

SAP OIUY3_TX_RPGDT table

Table OIUY3_TX_RPGDT technical data

TableOIUY3_TX_RPGDT
Data storingRoyalty 2.0 – TX GLO/TAMU – Gas Report
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_Y3
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUY3_TX_RPGDT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUY3_TX_RPGDT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Royalty 2.0 – Texas GLO/TAMU – Gas Report Key
    Its a key field.
  • RUN_ID : Tax Reporting – Run ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • PROD_YEAR_MO : Royalty 2.0 – Texas GLO/TAMU – Production Year/Month YYYYMM
    Its a key field. Its data type is ACCP (Posting period YYYYMM) with field length 6
  • GLO_LEASE : Royalty 2.0 – TX GLO/TAMU Lease
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • RRC_DISTRICT_NO : Royalty 2.0 – TX GLO/TAMU – District Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • RRC_OIL_LEASE_NO : Royalty 2.0 – TX GLO/TAMU – RRC Oil Lease Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • RRC_GAS_WELL_ID : Royalty 2.0 – TX GLO/TAMU – RRC Gas Well ID
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • RRC_DRILL_PERMIT : Royalty 2.0 – TX GLO/TAMU – RRC Drilling Permit
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • PURCHASER_ID : Royalty 2.0 – Texas GLO/TAMU – Purchaser ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 11
  • REV_BOOK_ADJ_IND : Royalty 2.0 – TX – Reversal/Booking/Reversal Adjustment/Adjs
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Royalty 2.0 – Texas GLO/TAMU – Gas Report Non-Key
  • RRC_FIELD_NAME : Royalty 2.0 – TX GLO/TAMU – RRC Field Name
    Its data type is CHAR (Character String) with field length 32
  • RRC_LEASE_NAME : Royalty 2.0 – TX GLO/TAMU – RRC Lease Name
    Its data type is CHAR (Character String) with field length 32
  • PROP_ALIAS_NAME : Royalty 2.0 – TX GLO/TAMU – Property Alias Name
    Its data type is CHAR (Character String) with field length 32
  • REPORT_TYPE : Royalty 2.0 – Texas GLO/TAMU – Report Type
    Its data type is CHAR (Character String) with field length 1
  • GLO_UNIT_NO : Royalty 2.0 – Texas GLO/TAMU – Unit Number
    Its data type is CHAR (Character String) with field length 4
  • TRACT_PART_FACT : Royalty 2.0 – Texas GLO – Tract Participation Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OVERRIDE_CODE : Royalty 2.0 – TX GLO/TAMU – Override Code
    Its data type is CHAR (Character String) with field length 5
  • OPERATOR_ID : Royalty 2.0 – TX GLO – Operator ID
    Its data type is CHAR (Character String) with field length 10
  • PROD_DISP_RPT : Royalty 2.0 – TX GLO/TAMU – Production Disp Report Indicator
    Its data type is CHAR (Character String) with field length 1
  • AFFILIATED_SALE : Royalty 2.0 – TX GLO – Affiliated Sale Indicator
    Its data type is CHAR (Character String) with field length 1
  • GLO_TIK : Royalty 2.0 – Texas GLO/TAMU – GLO TIK
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Royalty 2.0 – Texas GLO/TAMU – Gas Report Non-Key Prod Vol
  • FORM_PROD_VOL : Royalty 2.0 – TX GLO/TAMU – Formation Production Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • NONFORM_PROD_VOL : Royalty 2.0 – TX GLO/TAMU – Non-Formation Production Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • FLASH_GAS_PROD : Royalty 2.0 – TX GLO/TAMU – Flash Gas Production Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • LEASE_FUEL_USE : Royalty 2.0 – TX GLO/TAMU – 1A Lease Fuel Use
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OFF_LEASE_FUEL : Royalty 2.0 – TX GLO/TAMU – 1B Field (Off Lease) Fuel Use
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TRANSMISSION_LN : Royalty 2.0 – TX GLO/TAMU – 2 Transmission Line
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • RESIDUE_GAS_SALE : Royalty 2.0 – TX GLO/TAMU – 3A Residue Gas Sales
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OTHER_PLANT_PROC : Royalty 2.0 – TX GLO/TAMU – 3C Other Plant Processed
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • VENTED_OR_FLARED : Royalty 2.0 – TX GLO/TAMU – 4A Vented or Flared
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • CO2 : Royalty 2.0 – TX GLO/TAMU – 4B CO2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • H2S : Royalty 2.0 – TX GLO/TAMU – 4C H2S
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GAS_LIFT : Royalty 2.0 – TX GLO/TAMU – 5 Gas Lift
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • REPRESS_PRESS : Royalty 2.0 – TX GLO/TAMU – 6 Repressure / Pressure Maint
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • UNDERGROUND_STOR : Royalty 2.0 – TX GLO/TAMU – 8 Underground Storage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • FLASH_GAS : Royalty 2.0 – TX GLO/TAMU – Flash Gas
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • ETHANES : Royalty 2.0 – TX GLO/TAMU – Ethanes
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PROPANES : Royalty 2.0 – TX GLO/TAMU – Propanes
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • NORMAL_BUTANES : Royalty 2.0 – TX GLO/TAMU – Normal Butanes
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • ISO_BUTANES : Royalty 2.0 – TX GLO/TAMU – Iso-Butanes
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • NATURAL_GASOLINE : Royalty 2.0 – TX GLO/TAMU – Natural Gasoline
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PLANT_CONDENSATE : Royalty 2.0 – TX GLO/TAMU – Plant Condensate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • SULFUR : Royalty 2.0 – TX GLO/TAMU – Sulfur
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OTHER_NGLS : Royalty 2.0 – TX GLO/TAMU – Other NGLs Single Stream
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OTHER_PRODUCTS : Royalty 2.0 – TX GLO/TAMU – Other Products (Incl Carbon Blk)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PLANT_SHRINK : Royalty 2.0 – TX GLO/TAMU – 3B Plant Shrink
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • CARBON_BLACK : Royalty 2.0 – TX GLO/TAMU – 7 Carbon Black
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • ENTIRE_ROY_OB : Royalty 2.0 – TX GLO/TAMU – Entire Royalty Obligation
    Its data type is CHAR (Character String) with field length 1
  • LFU_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • LFU_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • LFU_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • LFU_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • OLFU_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OLFU_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OLFU_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • OLFU_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • TL_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TL_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TL_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • TL_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • RGS_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • RGS_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • RGS_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • RGS_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • OPP_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OPP_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OPP_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • OPP_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • VF_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • VF_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • VF_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • VF_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • CO2_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • CO2_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CO2_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • CO2_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • H2S_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • H2S_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • H2S_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • H2S_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • GL_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GL_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • GL_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • GL_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • RPM_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • RPM_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • RPM_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • RPM_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • US_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • US_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • US_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • US_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • FG_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • FG_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • FG_RDB : Royalty 2.0 – TX GLO/TAMU – BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • FG_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • E_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • E_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • E_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • P_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • P_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • P_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • NB_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • NB_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • NB_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • IB_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • IB_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • IB_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • NG_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • NG_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • NG_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • PC_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PC_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PC_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • S_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • S_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • S_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • ONSS_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • ONSS_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ONSS_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • OP_RD : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OP_RDP : Royalty 2.0 – Texas GLO/TAMU – Unit Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OP_RDV : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • GR_VAL_ALL_PROD : Royalty 2.0 – TX GLO/TAMU – Gross Value All Products
    Its data type is CURR (Currency Field) with field length 11
  • ADDITIONAL_VAL : Royalty 2.0 – TX GLO/TAMU – Additional Value
    Its data type is CURR (Currency Field) with field length 11
  • ADDITIONAL_VALKW : Royalty 2.0 – TX GLO/TAMU – Additional Value KW
    Its data type is CURR (Currency Field) with field length 11
  • GROSS_VALUE : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • ROYALTY_DECIMAL : Royalty 2.0 – Texas GLO – Royalty Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ROYALTY_DUE : Royalty 2.0 – Texas GLO/TAMU – Royalty Due
    Its data type is CURR (Currency Field) with field length 11
  • COMMENT_FL : Royalty 2.0 – Texas GLO/TAMU – Comment Flag
    Its data type is CHAR (Character String) with field length 1
  • ORIGINAL_REPORT : Royalty 2.0 – TX GLOTAMU – Original Report
    Its data type is CHAR (Character String) with field length 1
  • ZERO_VOL : Royalty 2.0 – Texas GLO/TAMU – Zero Volume Flag
    Its data type is CHAR (Character String) with field length 1
  • PAY_REPORT_FLAG : Royalty 2.0 – TX GLO/TAMU – Pay/Report Flag
    Its data type is CHAR (Character String) with field length 1
  • EXPECTED_RPT_EXC : Royalty 2.0 – Texas GLO/TAMU No of Expected Reports Exceeded
    Its data type is CHAR (Character String) with field length 1
  • MULTI_PURCHASER : Royalty 2.0 – Texas GLO/TAMU – Multiple Purchasers Flag
    Its data type is CHAR (Character String) with field length 1
  • REPORT_NUM : Roy 2.0 TX – Report Number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15