1. SAP Tutorial
  2. Oil & Gas

OIUY6Y_WY_MASTER SAP table for – Royalty 2.0 – WY – Master Data PPN

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

SAP OIUY6Y_WY_MASTER table

Table OIUY6Y_WY_MASTER technical data

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

SAP OIUY6Y_WY_MASTER 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 OIUY6Y_WY_MASTER 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 – Master Data Key Fields
    Its a key field.
  • .INCLUDE : Royalty 2.0 – WY – Master Data Main Key Fields
    Its a key field.
  • RPT_ID : Tax Reporting – Report ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • 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
  • .INCLUDE : Royalty 2,.0 – WY – Master Sub Key
    Its a key field.
  • STATE_LEASE_NO : Royalty 2.0 – Wyoming – State Lease Number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • UNIQUE_ID : Royalty 2.0 – Wyoming – PSA
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • BEFORE_CURRENT
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Royalty 2.0 – Wyoming Master Non-Key Fields
  • REPORT_ONLY : Royalty 2.0 – WY – Report Only Flag
    Its data type is CHAR (Character String) with field length 1
  • OVERRIDE_FL : Royalty 2.0 – WY – Override Operated Flag
    Its data type is CHAR (Character String) with field length 1
  • TRACT_ALLOC_LSE : Royalty 2.0 – Wyoming – Tract Allocation to Lease
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ROYALTY_RATE : Royalty 2.0 – Wyoming – Royalty Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ALLOC_PERCENT : Royalty 2.0 – Wyoming – Allocation Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • REFERENCE_FIELD : Royalty 2.0 – WY – Reference Field
    Its data type is CHAR (Character String) with field length 20
  • ALTERNATE_PSA : Royalty 2.0 – Wyoming – Alternate PSA
    Its data type is CHAR (Character String) with field length 20
  • DELETE_FL : Indicator for Meta Data in System Component Repository
    Its data type is CHAR (Character String) with field length 1

    • OIUY6Y_WY_MASTER related tables

    • OIUY6_WY_RPDTC : Royalty 2.0 – WY – Lease/Unit Report Detail – CA
    • OIUY6_WY_INTSTG : Royalty 2.0 – WY – Royalty Transaction Interface (Staging)
    • OIUY6_WY_REVSTG : Royalty 2.0 – WY – Royalty Reversals (Staging)
    • OIUY6Y_WY_MASTER : Royalty 2.0 – WY – Master Data PPN
    • OIUY6_WY_OOSWO : Royalty 2.0 – Wyoming Out Of Statute Write Off
    • OIUY6_WY_LEASE : Royalty 2.0 – WY – Lease Data
    • OIUY6_WY_CBMOVR : Royalty 2.0 – WY – Coal Bed Methane Override
    • OIUY6_WY_ROYHSTA : Royalty 2.0 – WY – Royalty Transaction History (Allocated)
    • OIUY6_WY_OOSHST : Royalty 2.0 – WY – Out of Statute Royalty Transaction Hist
    • OIUY6_WY_SOLEHD : Royalty 2.0 – WY Statute of Limitation Exception Header
    • OIUY6_WY_RPDTL : Royalty 2.0 – WY – Report Details Lease
    • OIUY6_WY_SOL : Royalty 2.0 – Wyoming Statute of Limitation
    • OIUY6_WY_PRDT : Royalty 2.0 – WY – Royalty PRA Details
    • OIUY6_WY_RPDTS : Royalty 2.0 – WY – Lease/Unit Report Detail – PR/CA Summar
    • OIUY6_MIG_DN : Royalty 2.0 – WY – Migration – DNs
    • OIUY6_WY_ROYTXNA : Royalty 2.0 – WY – Royalty Transactions (Allocated)
    • 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_CAPOVR : Roy 2.0 – Wyoming – CA Percent Override
    • OIUY6_WY_ROYSTG : Royalty 2.0 – WY – Royalty Transactions (Staging)

    OIUY6Y_WY_MASTER related transaction codes under SAP package OIU_Y6

    • O3UY6_WY_ZVOL : Wyoming Royalty Zero Volume Master
    • O3UY6_WY_CBMOVR : Maintain WY Coal Bed Methane Overrid
    • O3UY6_WY_SOLE : Maintain Wyoming SOL Exceptions
    • O3UY6_WY_ASU : Maintain Wyoming Auto Suspend Master
    • O3UY6_WY_SOL : Maintain Wyoming Statute of Limit
    • O3UY6_UPD_WY_ROYHST : Update Wyoming Royalty History
    • S_YEP_48000005 : IMG activity: V_OIUY6_WY_REJC
    • S_YEP_48000004 : IMG activity: V_OIUY6_WY_REJ
    • O3UY6_WY_CAPOVR : Maintain Wyoming CA Percent Override
    • O3UY6_WY_PRICE : Maintain Wyoming Reporting Price
    • O3UY6_DISP_WY_ROYHST : Up-to-Date Reported Wyoming Trans
    • S_YEP_48000003 : IMG activity: OIUY6_WY_MKTXRF
    • O3UY6_DISP_BAL_RPT : Wyoming Royalty Balancing Report
    • S_YEP_48000006 : IMG activity: V_OIUY6_RPT_CFG
    • O3UY6_UPD_WY_ROYTXN : Maintain Wyoming User Roy Trans
    • O3UY6_MIGRATION_005 : WY Oil Royalty Migration Workbench
    • O3UY6_WY_LEASE : Maintain Wyoming Lease Master
    • O3UY6_MIGRATION_006 : WY Gas Royalty Migration Workbench
    • O3UY6_DISP_WY_OOSWO : List of WY Out-of-Statute Write-Offs
    • O3UY6_DISP_WY_RPTVAR : Wyoming Royalty Variance Report

    Related References

    Related Tutorials

    OIUY3Y_TX_MASTER SAP table for – Royalty 2.0 – TX GLO/TAMU – Master Data PPN

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

    OIUY3Y_TX_RRC SAP table for – Royalty 2.0 – TX GLO/TAMU – RRC Master PPN

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

    OIUY6_WY_MASTER SAP table for – Royalty 2.0 – WY – Master Data

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

    OIUY6_WY_ZVOL SAP table for – Royalty 2.0 – WY – Zero Volume Master

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

    OIUX6Y_WY_MASTER SAP table for – Tax 2.0 – Wyoming Master Data PPN

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

    OIUY6_WY_LEASE SAP table for – Royalty 2.0 – WY – Lease Data

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

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

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

    «
    »