1. SAP Tutorial
  2. Oil & Gas

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

    • OIUY3_TX_RPODT related tables

    • OIUY3_TX_OOSTXN : Royalty 2.0 – TX GLO – Out of Statute Royalty Transactions
    • OIUY3_TX_OPSL : Roy 2.0 TX – OPSL Summary Data for a Run
    • OIUY3_TX_REJT : Royalty 2.0 – Texas GLO – Reject Code Text
    • OIUY3_TX_PRDT : Royalty 2.0 – TX GLO – Royalty PRA Details
    • OIUY3_TX_REJ : Royalty 2.0 – TX GLO/TAMU – Reject Codes
    • OIUY3_TX_RPDTS : Royalty 2.0 – TX GLO/TAMU- Report Detail – Summary
    • OIUY3_TX_REVTXN : Royalty 2.0 – TX GLO – Royalty Reversals
    • OIUY3_MIG_DN : Royalty 2.0 – TX GLO/A&M – Migration – DNs
    • OIUY3_TX_INTSTG : Royalty 2.0 – TX GLO – Royalty Trans Interface Staging
    • OIUY3_TX_ASU_DT : Royalty 2.0 – TX GLO/TAMU – Auto Suspend Detail
    • OIUY3_TX_ROYTXNA : Royalty 2.0 – TX GLO – Royalty Transactions (Allocated)
    • OIUY3_TX_ROYHST : Royalty 2.0 – TX GLO – Royalty Transaction History
    • OIUY3_TX_RPODT : Royalty 2.0 – TX GLO/TAMU – Oil Report
    • OIUY3_TX_RPDTP : Royalty 2.0 – TX GLO/TAMU- Report Detail – Production
    • OIUY3_TX_MASTER : Royalty 2.0 – TX GLO/TAMU – Master Data
    • OIUY3_TX_SOLEHD : Royalty 2.0 – TX GLO/TAMU SOL Exception Header
    • OIUY3_TX_BAXRF : Royalty 2.0 – TX GLO/TAU – BA Xref
    • OIUY3_TX_PDCXRF : Royalty 2.0 – TX GLO/TAMU – Production Disposition XRef
    • OIUY3_TX_RRC : Royalty 2.0 – TX GLO/TAMU – RRC Master
    • OIUY3_TX_OOSHST : Royalty 2.0 – TX – Out of Statute Royalty Transaction Hist

    OIUY3_TX_RPODT related transaction codes under SAP package OIU_Y3

    • O3UY3_TX_RRC : Maintain Texas GLO/TAMU RRC Master
    • O3UY3_MIGRATION_OIL : TX GLO/TAMU Roy Oil Migration
    • O3UY3_TX_UNIT : Maintain Texas GLO/TAMU Unit Master
    • O3UY3_DISP_TX_ROYTXN : Display TX GLO/TAMU Royalty Trans
    • O3UY3_TX_PDCXRF : Maintain Production Disposition XRef
    • O3UY3_UPD_TX_ROYHST : Update TX GLO/TAMU Royalty History
    • O3UY3_DISP_BAL_RPT : Texas GLO/TAMU Balancing Report
    • O3UY3_DISP_PAY_RECON : Texas GLO/TAMU Payables Recon
    • O3UY3_TX_CTRL : Maintain Texas GLO/TAMU Rpt Ctrl Mst
    • S_YEP_42000001 : IMG activity: OIUY3_SN_NR_TX
    • O3UY3_TX_MASTER : Maintain Texas GLO/TAMU Master Data
    • O3UY3_TX_SOLE : Maintain TX GLO/TAMU SOL Exception
    • O3UY3_MIGRATION_GAS : TX GLO/TAMU Roy Gas Migration
    • O3UY3_TX_ASU : Maintain Texas GLO/TAMU ASU Master
    • S_YEP_42000003 : IMG activity: V_OIUY3_TX_REJ
    • O3UY3_UPD_TX_OOS_WO : TX GLO/TAMU Out-of-Statute Write-Off
    • O3UY3_DISP_TX_OOSWO : List of Texas GLO OOS Write-Offs
    • O3UY3_TX_RDCXRF : Maintain Royalty Disposition XRef
    • O3UY3_UPD_TX_ROYTXN : Maintain Texas GLO User Roy Trans
    • O3UY3_TX_LEASE : Maintain Texas GLO/TAMU Lease Master

    Related References

    Related Tutorials

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

    OIUY3_TX_RPGDT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUY3_TX_RPDTS SAP table for – Royalty 2.0 – TX GLO/TAMU- Report Detail – Summary

    OIUY3_TX_RPDTS table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUY3_TX_RPDTP SAP table for – Royalty 2.0 – TX GLO/TAMU- Report Detail – Production

    OIUY3_TX_RPDTP table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUY3_TX_RPDTM SAP table for – Royalty 2.0 – TX GLO/TAMU – Report Detail – Masters

    OIUY3_TX_RPDTM table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUY3_TX_RPSM SAP table for – Royalty 2.0 – TX GLO/TAMU – Report Summary

    OIUY3_TX_RPSM table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    O3UY3_DISP_TX_RPTVAR SAP tcode for – TX GLO/TAMU Royalty Variance Report

    O3UY3_DISP_TX_RPTVAR tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for TX GLO/TAMU...

    OIUY3_TX_INTTXN SAP table for – Royalty 2.0 – TX GLO/TAMU – Royalty Transaction Interface

    OIUY3_TX_INTTXN table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »