1. SAP Tutorial
  2. Oil & Gas

OIUY6_WY_REVTXN SAP table for – Royalty 2.0 – WY – Royalty Reversals

Here we would like to draw your attention to OIUY6_WY_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). OIUY6_WY_REVTXN is a SAP standard transp table used for storing Royalty 2.0 – WY – Royalty Reversals related data in SAP. It comes under the package OIU_Y6.

SAP OIUY6_WY_REVTXN table

Table OIUY6_WY_REVTXN technical data

TableOIUY6_WY_REVTXN
Data storingRoyalty 2.0 – WY – Royalty Reversals
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_Y6
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUY6_WY_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 OIUY6_WY_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 – WY – 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 – WY – 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

    • OIUY6_WY_REVTXN related tables

    • OIUY6_WY_ROYHST : Royalty 2.0 – WY – Royalty Transaction History
    • OIUY6_WY_SOLEDT : Royalty 2.0 – WY Statute of Limitation Exception Detail
    • OIUY6_WY_RPDTC : Royalty 2.0 – WY – Lease/Unit Report Detail – CA
    • OIUY6_WY_ROYSTG : Royalty 2.0 – WY – Royalty Transactions (Staging)
    • OIUY6_WY_ROYTXN : Royalty 2.0 – WY – Royalty Transactions
    • OIUY6_WY_PRICE : Royalty 2.0 – WY – Report Pricing
    • OIUY6_WY_SOLEHD : Royalty 2.0 – WY Statute of Limitation Exception Header
    • OIUY6_WY_RPDTL : Royalty 2.0 – WY – Report Details Lease
    • OIUY6_WY_OOSHST : Royalty 2.0 – WY – Out of Statute Royalty Transaction Hist
    • OIUY6_WY_MKTXRF : Royalty 2.0 – WY – Marketing Type Xref
    • OIUY6_WY_OPSL : Roy 2.0 WY – OPSL Summary Data for a Run
    • OIUY6_WY_OOSWO : Royalty 2.0 – Wyoming Out Of Statute Write Off
    • OIUY6_WY_ROYTXNA : Royalty 2.0 – WY – Royalty Transactions (Allocated)
    • OIUY6_WY_PDCXRF : Royalty 2.0 – WY – Product Code Xref
    • OIUY6_WY_REJT : Royalty 2.0 – WY – Reject Code Text
    • OIUY6_WY_OOSTXN : Royalty 2.0 – WY – Out of Statute Royalty Transactions
    • OIUY6_MIG_DN : Royalty 2.0 – WY – Migration – DNs
    • OIUY6_WY_RPDTM : Royalty 2.0 – WY – Lease/Unit Report Detail – Masters
    • OIUY6_WY_ROYHSTA : Royalty 2.0 – WY – Royalty Transaction History (Allocated)
    • OIUY6Y_WY_MASTER : Royalty 2.0 – WY – Master Data PPN

    OIUY6_WY_REVTXN related transaction codes under SAP package OIU_Y6

    • O3UY6_WY_ASU : Maintain Wyoming Auto Suspend Master
    • O3UY6_DISP_WY_ROYTXN : Display Wyoming Royalty Transactions
    • O3UY6_WY_LEASE : Maintain Wyoming Lease Master
    • O3UY6_DISP_WY_OOSWO : List of WY Out-of-Statute Write-Offs
    • O3UY6_UPD_WY_ROYTXN : Maintain Wyoming User Roy Trans
    • O3UY6_WY_MASTER : Maintain Wyoming Master Data
    • O3UY6_MIGRATION_006 : WY Gas Royalty Migration Workbench
    • O3UY6_WY_CAPOVR : Maintain Wyoming CA Percent Override
    • O3UY6_UPD_WY_ROYHST : Update Wyoming Royalty History
    • O3UY6_WY_SOLE : Maintain Wyoming SOL Exceptions
    • O3UY6_WY_ZVOL : Wyoming Royalty Zero Volume Master
    • S_YEP_48000002 : IMG activity: OIUY6_WY_PDCXRF
    • S_YEP_48000004 : IMG activity: V_OIUY6_WY_REJ
    • O3UY6_DISP_WY_ROYHST : Up-to-Date Reported Wyoming Trans
    • S_YEP_48000006 : IMG activity: V_OIUY6_RPT_CFG
    • S_YEP_48000003 : IMG activity: OIUY6_WY_MKTXRF
    • O3UY6_WY_SOL : Maintain Wyoming Statute of Limit
    • O3UY6_DISP_PAY_RECON : Wyoming OPSL Balancing Report
    • S_YEP_48000005 : IMG activity: V_OIUY6_WY_REJC
    • O3UY6_DISP_WY_RPTVAR : Wyoming Royalty Variance Report

    Related References

    Related Tutorials

    OIUY6_WY_REVSTG SAP table for – Royalty 2.0 – WY – Royalty Reversals (Staging)

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

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

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

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

    OIUY6_WY_REJ SAP table for – Royalty 2.0 – WY – Reject Codes

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

    OIUY6_WY_SOLEHD SAP table for – Royalty 2.0 – WY Statute of Limitation Exception Header

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

    OIUY6_WY_OOSWO SAP table for – Royalty 2.0 – Wyoming Out Of Statute Write Off

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

    O3UY6_DISP_WY_ROYTXN SAP tcode for – Display Wyoming Royalty Transactions

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

    «
    »