OIUY3_TX_RPODT SAP table for – Royalty 2.0 – TX GLO/TAMU – Oil Report

Here we would like to draw your attention to OIUY3_TX_RPODT 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_RPODT is a SAP standard transp table used for storing Royalty 2.0 – TX GLO/TAMU – Oil Report related data in SAP. It comes under the package OIU_Y3.

SAP OIUY3_TX_RPODT table

Table OIUY3_TX_RPODT technical data

TableOIUY3_TX_RPODT
Data storingRoyalty 2.0 – TX GLO/TAMU – Oil 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_RPODT 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_RPODT 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 – Oil 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 – Oil 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 – Oil Report Non-Key Prod Vol
  • BEGINNING_STOCK : Royalty 2.0 – TX GLO/TAMU – Beginning Stock
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • GROSS_PRODUCTION : Royalty 2.0 – TX GLO/TAMU – Gross Production
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PIPELINE : Royalty 2.0 – TX GLO/TAMU – Pipeline
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TRUCK : Royalty 2.0 – TX GLO/TAMU – Truck
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TANK_CAR_BARGE : Royalty 2.0 – TX GLO/TAMU – Tank Car Barge
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TANK_CLEANING : Royalty 2.0 – TX GLO/TAMU – Tank Cleaning
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CIRC_OIL_COND : Royalty 2.0 – TX GLO/TAMU – Circulating Oil/Condensate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LOST_STOLEN : Royalty 2.0 – TX GLO/TAMU – Lost/Stolen
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • BSW : Royalty 2.0 – TX GLO/TAMU – Basic Sediment / Water
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • OTHER_ROY_DUE : Royalty 2.0 – TX GLO/TAMU – Other Royalty Due
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • OTHER_NO_ROY_DUE : Royalty 2.0 – TX GLO/TAMU – Other No Royalty Due
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SKIM_LIQ_HYDRO : Royalty 2.0 – TX GLO/TAMU – Skim Liquid Hydrocarbon
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SCRUBBER_OIL : Royalty 2.0 – TX GLO/TAMU – Scrubber Oil
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ENDING_STOCK : Royalty 2.0 – TX GLO/TAMU – Ending Stock
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • DRIP_OIL : Royalty 2.0 – TX GLO/TAMU – Drip Oil
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ENTIRE_ROY_OB : Royalty 2.0 – TX GLO/TAMU – Entire Royalty Obligation
    Its data type is CHAR (Character String) with field length 1
  • ROY_DUE_NET_BBLS : Royalty 2.0 – TX GLO/TAMU – Royalty Due Net Barrels
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • API_GRAVITY : Royalty 2.0 – Texas GLO/TAMU – API Gravity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • UNIT_VALUE : 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
  • 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