1. SAP Tutorial
  2. Oil & Gas

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

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

SAP OIUY3_TX_RPDTM table

Table OIUY3_TX_RPDTM technical data

TableOIUY3_TX_RPDTM
Data storingRoyalty 2.0 – TX GLO/TAMU – Report Detail – Masters
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_RPDTM 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_RPDTM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • 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
  • 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
  • WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MP_NO : Measurement point number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VNAME : Joint venture
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DERIVED_WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • DERIVED_WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : Royalty 2.0 – TX GLO/TAMU – Report Detail Master Non-Key
  • SALES_DT : Sales Date / Month
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .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_RPDTM related tables

    • OIUY3_TX_REVSTG : Royalty 2.0 – TX GLO – Royalty Reversals (Staging)
    • OIUY3_TX_GLO1_TH : Royalty 2.0 – TX GLO/TAMU – GLO1 Threshold
    • OIUY3_TX_PRDTA : Royalty 2.0 – TX GLO – Royalty PRA Details (Allocated)
    • OIUY3_TX_ROYSTG : Royalty 2.0 – TX GLO – Royalty Transactions (Staging)
    • OIUY3_TX_REJ : Royalty 2.0 – TX GLO/TAMU – Reject Codes
    • OIUY3_TX_RRC : Royalty 2.0 – TX GLO/TAMU – RRC Master
    • OIUY3_TX_BAXRF : Royalty 2.0 – TX GLO/TAU – BA Xref
    • OIUY3_TX_REVTXN : Royalty 2.0 – TX GLO – Royalty Reversals
    • OIUY3_TX_OOSTXN : Royalty 2.0 – TX GLO – Out of Statute Royalty Transactions
    • OIUY3_TX_ROYTXNA : Royalty 2.0 – TX GLO – Royalty Transactions (Allocated)
    • OIUY3_TX_SOL : Royalty 2.0 – Texas GLO Statute of Limitation
    • OIUY3_TX_UNIT : Royalty 2.0 – TX GLO – Unit Master
    • OIUY3_TX_RDCXRF : Royalty 2.0 – TX GLO/TAMU – Royalty Disposition XRef
    • OIUY3_TX_CTRL : Royalty 2.0 – TX GLO/TAMU Reporting Control Record Master
    • OIUY3_TX_OPSL : Roy 2.0 TX – OPSL Summary Data for a Run
    • OIUY3_TX_GLO2_TH : Royalty 2.0 – TX GLO/TAMU – GLO2 Threshold
    • OIUY3_TX_LEASE : Royalty 2.0 – TX GLO – Lease Master
    • OIUY3_MIG_DN : Royalty 2.0 – TX GLO/A&M – Migration – DNs
    • OIUY3_TX_PDCXRF : Royalty 2.0 – TX GLO/TAMU – Production Disposition XRef
    • OIUY3_TX_OOSHST : Royalty 2.0 – TX – Out of Statute Royalty Transaction Hist

    OIUY3_TX_RPDTM related transaction codes under SAP package OIU_Y3

    • O3UY3_TX_BAXRF : Maintain Texas GLO/TAMU BA XRef
    • S_YEP_42000005 : IMG activity: V_OIUY3_RPT_CFG
    • O3UY3_MIGRATION_GAS : TX GLO/TAMU Roy Gas Migration
    • O3UY3_TX_RRC : Maintain Texas GLO/TAMU RRC Master
    • O3UY3_DISP_BAL_RPT : Texas GLO/TAMU Balancing Report
    • O3UY3_TX_PDCXRF : Maintain Production Disposition XRef
    • O3UY3_TX_LEASE : Maintain Texas GLO/TAMU Lease Master
    • O3UY3_TX_ASU : Maintain Texas GLO/TAMU ASU Master
    • S_YEP_42000004 : IMG activity: V_OIUY3_TX_REJC
    • O3UY3_MIGRATION_OIL : TX GLO/TAMU Roy Oil Migration
    • O3UY3_DISP_TX_RPTVAR : TX GLO/TAMU Royalty Variance Report
    • O3UY3_DISP_TX_ROYHST : Up-to-Date Reported Texas GLO Trans
    • O3UY3_DISP_TX_OOSWO : List of Texas GLO OOS Write-Offs
    • S_YEP_42000002 : IMG activity: V_OIUY3_GRPPX
    • O3UY3_UPD_TX_OOS_WO : TX GLO/TAMU Out-of-Statute Write-Off
    • O3UY3_TX_SOLE : Maintain TX GLO/TAMU SOL Exception
    • O3UY3_TX_CTRL : Maintain Texas GLO/TAMU Rpt Ctrl Mst
    • O3UY3_TX_UNIT : Maintain Texas GLO/TAMU Unit Master
    • O3UY3_UPD_TX_ROYTXN : Maintain Texas GLO User Roy Trans
    • O3UY3_TX_SOL : Maintain Texas GLO/TAMU SOL Master

    Related References

    Related Tutorials

    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...

    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_ASU_DT SAP table for – Royalty 2.0 – TX GLO/TAMU – Auto Suspend Detail

    OIUY3_TX_ASU_DT 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...

    OIUY3_TX_SOLEDT SAP table for – Royalty 2.0 – TX GLO/TAMU SOL Exception Detail

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

    OIUY3_TX_RDCXRF SAP table for – Royalty 2.0 – TX GLO/TAMU – Royalty Disposition XRef

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

    «
    »