1. SAP Tutorial
  2. Oil & Gas

OIUY6_WY_RPDTP SAP table for – Royalty 2.0 – WY – Lease/Unit Report Detail – Production

Here we would like to draw your attention to OIUY6_WY_RPDTP 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_RPDTP is a SAP standard transp table used for storing Royalty 2.0 – WY – Lease/Unit Report Detail – Production related data in SAP. It comes under the package OIU_Y6.

SAP OIUY6_WY_RPDTP table

Table OIUY6_WY_RPDTP technical data

TableOIUY6_WY_RPDTP
Data storingRoyalty 2.0 – WY – Lease/Unit Report Detail – Production
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_RPDTP 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_RPDTP 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
  • SALES_MONTH : Royalty 2.0 – Wyoming – Sales Month (MMCCYY)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • 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
  • 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
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • VT_CD : Volume type code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • STD_VOL : Standard volume
    Its data type is QUAN (Quantity field) with field length 13
  • .INCLUDE : Royalty 2.0 – WY – Report Detail (Lease/Unit) Non-Key Fields
  • 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
  • SALES_DT : Sales Date / Month
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OVERRIDE_FL : Royalty 2.0 – WY – Override Operated Flag
    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_RPDTP related tables

    • OIUY6_WY_MASTER : Royalty 2.0 – WY – Master Data
    • OIUY6_WY_RPDTP : Royalty 2.0 – WY – Lease/Unit Report Detail – Production
    • OIUY6_WY_ASU_DT : Royalty 2.0 – WY – Auto Suspend Detail
    • OIUY6_WY_OPSL : Roy 2.0 WY – OPSL Summary Data for a Run
    • OIUY6_WY_REJ : Royalty 2.0 – WY – Reject Codes
    • OIUY6_WY_CBMOVR : Royalty 2.0 – WY – Coal Bed Methane Override
    • OIUY6_WY_REVTXN : Royalty 2.0 – WY – Royalty Reversals
    • OIUY6_WY_CAPOVR : Roy 2.0 – Wyoming – CA Percent Override
    • OIUY6_WY_REVSTG : Royalty 2.0 – WY – Royalty Reversals (Staging)
    • OIUY6_WY_RPDTS : Royalty 2.0 – WY – Lease/Unit Report Detail – PR/CA Summar
    • OIUY6_WY_ROYSTG : Royalty 2.0 – WY – Royalty Transactions (Staging)
    • OIUY6_WY_ZVOL : Royalty 2.0 – WY – Zero Volume Master
    • OIUY6Y_WY_MASTER : Royalty 2.0 – WY – Master Data PPN
    • OIUY6_WY_INTTXN : Royalty 2.0 – WY – Royalty Transaction Interface
    • OIUY6_WY_ASU_HD : Royalty 2.0 – WY – Auto Suspend Header
    • OIUY6_WY_REJT : Royalty 2.0 – WY – Reject Code Text
    • OIUY6_WY_MKTXRF : Royalty 2.0 – WY – Marketing Type Xref
    • OIUY6_WY_OOSWO : Royalty 2.0 – Wyoming Out Of Statute Write Off
    • OIUY6_WY_INTSTG : Royalty 2.0 – WY – Royalty Transaction Interface (Staging)
    • OIUY6_WY_RPDTL : Royalty 2.0 – WY – Report Details Lease

    OIUY6_WY_RPDTP related transaction codes under SAP package OIU_Y6

    • O3UY6_WY_MASTER : Maintain Wyoming Master Data
    • O3UY6_DISP_WY_RPTVAR : Wyoming Royalty Variance Report
    • O3UY6_WY_SOLE : Maintain Wyoming SOL Exceptions
    • O3UY6_WY_ASU : Maintain Wyoming Auto Suspend Master
    • O3UY6_DISP_BAL_RPT : Wyoming Royalty Balancing Report
    • S_YEP_48000006 : IMG activity: V_OIUY6_RPT_CFG
    • S_YEP_48000003 : IMG activity: OIUY6_WY_MKTXRF
    • S_YEP_48000005 : IMG activity: V_OIUY6_WY_REJC
    • O3UY6_UPD_WY_OOS_WO : Wyoming Out-of-Statute Write-Off
    • S_YEP_48000004 : IMG activity: V_OIUY6_WY_REJ
    • O3UY6_WY_CAPOVR : Maintain Wyoming CA Percent Override
    • O3UY6_DISP_WY_OOSWO : List of WY Out-of-Statute Write-Offs
    • S_YEP_48000002 : IMG activity: OIUY6_WY_PDCXRF
    • O3UY6_WY_CBMOVR : Maintain WY Coal Bed Methane Overrid
    • O3UY6_WY_ZVOL : Wyoming Royalty Zero Volume Master
    • O3UY6_WY_SOL : Maintain Wyoming Statute of Limit
    • O3UY6_DISP_WY_ROYTXN : Display Wyoming Royalty Transactions
    • O3UY6_WY_PRICE : Maintain Wyoming Reporting Price
    • O3UY6_WY_LEASE : Maintain Wyoming Lease Master
    • O3UY6_UPD_WY_ROYTXN : Maintain Wyoming User Roy Trans

    Related References

    Related Tutorials

    OIUY6_WY_RPDTC SAP table for – Royalty 2.0 – WY – Lease/Unit Report Detail – CA

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

    OIUY6_WY_RPDTM SAP table for – Royalty 2.0 – WY – Lease/Unit Report Detail – Masters

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

    OIUY6_WY_RPDTS SAP table for – Royalty 2.0 – WY – Lease/Unit Report Detail – PR/CA Summar

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

    OIUY6_WY_RPDTL SAP table for – Royalty 2.0 – WY – Report Details Lease

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

    OIUY6_WY_RPDTU SAP table for – Royalty 2.0 – WY – Report Details Unit

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

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

    «
    »