1. SAP Tutorial
  2. Oil & Gas

OIUY3_TX_REVTXN SAP table for – Royalty 2.0 – TX GLO – Royalty Reversals

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

SAP OIUY3_TX_REVTXN table

Table OIUY3_TX_REVTXN technical data

TableOIUY3_TX_REVTXN
Data storingRoyalty 2.0 – TX GLO – Royalty Reversals
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_REVTXN 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_REVTXN table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Royalty 2.0 – TX GLO – Royalty Reversal Key Fields
    Its a key field.
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SALES_DT : Sales Date / Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PDCD : Full three char. product code (Major and Detail Products)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • 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
  • 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
  • DN_NO : Delivery network number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • CT_NO : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • DOC_NO : Val. document number
    Its data type is CHAR (Character String) with field length 20
  • DOC_YEAR : Document year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • INTERFACE_FL : Royalty 2.0 – TX GLO – Interface Flag
    Its data type is CHAR (Character String) with field length 1
  • OPTION1 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • OPTION2 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • OPTION3 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • .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_REVTXN related tables

    • OIUY3_TX_SOL : Royalty 2.0 – Texas GLO Statute of Limitation
    • OIUY3_TX_PRDTA : Royalty 2.0 – TX GLO – Royalty PRA Details (Allocated)
    • OIUY3_TX_REVSTG : Royalty 2.0 – TX GLO – Royalty Reversals (Staging)
    • OIUY3Y_TX_MASTER : Royalty 2.0 – TX GLO/TAMU – Master Data PPN
    • OIUY3_TX_MASTER : Royalty 2.0 – TX GLO/TAMU – Master Data
    • OIUY3_TX_OOSHST : Royalty 2.0 – TX – Out of Statute Royalty Transaction Hist
    • OIUY3_TX_SOLEHD : Royalty 2.0 – TX GLO/TAMU SOL Exception Header
    • OIUY3_TX_LEASE : Royalty 2.0 – TX GLO – Lease Master
    • OIUY3_TX_INTTXN : Royalty 2.0 – TX GLO/TAMU – Royalty Transaction Interface
    • OIUY3_TX_RPDTS : Royalty 2.0 – TX GLO/TAMU- Report Detail – Summary
    • OIUY3_TX_SOLEDT : Royalty 2.0 – TX GLO/TAMU SOL Exception Detail
    • OIUY3_TX_OOSTXN : Royalty 2.0 – TX GLO – Out of Statute Royalty Transactions
    • OIUY3_TX_RDCXRF : Royalty 2.0 – TX GLO/TAMU – Royalty Disposition XRef
    • OIUY3_TX_RRC : Royalty 2.0 – TX GLO/TAMU – RRC Master
    • OIUY3_TX_OWNOVR : Royalty 2.0 – TX GLO/TAMU Owner Level Reporting Override
    • OIUY3_TX_ROYHST : Royalty 2.0 – TX GLO – Royalty Transaction History
    • OIUY3_TX_GLO2_TH : Royalty 2.0 – TX GLO/TAMU – GLO2 Threshold
    • OIUY3_TX_ASU_HD : Royalty 2.0 – TX GLO/TAMU – Auto Suspend Header
    • OIUY3_TX_ASU_DT : Royalty 2.0 – TX GLO/TAMU – Auto Suspend Detail
    • OIUY3_TX_PRDT : Royalty 2.0 – TX GLO – Royalty PRA Details

    OIUY3_TX_REVTXN related transaction codes under SAP package OIU_Y3

    • S_YEP_42000002 : IMG activity: V_OIUY3_GRPPX
    • S_YEP_42000001 : IMG activity: OIUY3_SN_NR_TX
    • O3UY3_DISP_TX_OOSWO : List of Texas GLO OOS Write-Offs
    • S_YEP_42000003 : IMG activity: V_OIUY3_TX_REJ
    • S_YEP_42000004 : IMG activity: V_OIUY3_TX_REJC
    • O3UY3_TX_CTRL : Maintain Texas GLO/TAMU Rpt Ctrl Mst
    • O3UY3_MIGRATION_GAS : TX GLO/TAMU Roy Gas Migration
    • O3UY3_TX_SOL : Maintain Texas GLO/TAMU SOL Master
    • O3UY3_TX_SOLE : Maintain TX GLO/TAMU SOL Exception
    • O3UY3_TX_OWNOVR : Maintain TX GLO/TAMU Own Lvl Rpt Ovr
    • O3UY3_TX_RRC : Maintain Texas GLO/TAMU RRC Master
    • S_YEP_42000005 : IMG activity: V_OIUY3_RPT_CFG
    • O3UY3_DISP_TX_ROYTXN : Display TX GLO/TAMU Royalty Trans
    • O3UY3_TX_RDCXRF : Maintain Royalty Disposition XRef
    • O3UY3_TX_LEASE : Maintain Texas GLO/TAMU Lease Master
    • O3UY3_TX_BAXRF : Maintain Texas GLO/TAMU BA XRef
    • O3UY3_TX_UNIT : Maintain Texas GLO/TAMU Unit Master
    • O3UY3_DISP_BAL_RPT : Texas GLO/TAMU Balancing Report
    • O3UY3_TX_MASTER : Maintain Texas GLO/TAMU Master Data
    • O3UY3_DISP_TX_ROYHST : Up-to-Date Reported Texas GLO Trans

    Related References

    Related Tutorials

    OIUY3_TX_REVSTG SAP table for – Royalty 2.0 – TX GLO – Royalty Reversals (Staging)

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

    OIUY3_TX_REJ SAP table for – Royalty 2.0 – TX GLO/TAMU – Reject Codes

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

    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_REJT SAP table for – Royalty 2.0 – Texas GLO – Reject Code Text

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

    OIUY3_TX_GLO2_TH SAP table for – Royalty 2.0 – TX GLO/TAMU – GLO2 Threshold

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

    O3UY3_DISP_TX_ROYTXN SAP tcode for – Display TX GLO/TAMU Royalty Trans

    O3UY3_DISP_TX_ROYTXN tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Display TX...

    «
    »