1. SAP Tutorial
  2. Oil & Gas

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

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

SAP OIUY6_WY_RPDTU table

Table OIUY6_WY_RPDTU technical data

TableOIUY6_WY_RPDTU
Data storingRoyalty 2.0 – WY – Report Details Unit
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_RPDTU 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_RPDTU table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Royalty 2.0 – Wyoming – Report Detail Unit Key
    Its a key field.
  • RUN_ID : Tax Reporting – Run ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • OPERATOR_CODE : Royalty 2.0 – Wyoming – Operator Code
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • 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
  • UNIQUE_ID : Royalty 2.0 – Wyoming – PSA
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • WY_PDCD : Royalty 2.0 – Wyoming – Product Code
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • GENERATED : General Flag
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Royalty 2.0 – Wyoming – Report Detail Unit Non-Key
  • UOM : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PRODUCTION_VOL : Royalty 2.0 – WY – Production Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GROSS_VOL : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GROSS_VAL : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • PROCESSING : Royalty 2.0 – WY – Processing Costs
    Its data type is CURR (Currency Field) with field length 11
  • TRANSPORTATION : Royalty 2.0 – WY – Transportation Costs
    Its data type is CURR (Currency Field) with field length 11
  • NET_SALES_VALUE : Royalty 2.0 – WY – Net Sales Value
    Its data type is CURR (Currency Field) with field length 11
  • REPORT_ONLY : Royalty 2.0 – WY – Report Only Flag
    Its data type is CHAR (Character String) with field length 1
  • ORIGINAL_REPORT : Royalty 2.0 – WY – Original Report
    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_RPDTU related tables

    • OIUY6_WY_PRDT : Royalty 2.0 – WY – Royalty PRA Details
    • OIUY6_WY_OOSHST : Royalty 2.0 – WY – Out of Statute Royalty Transaction Hist
    • OIUY6_WY_PDCXRF : Royalty 2.0 – WY – Product Code Xref
    • OIUY6_WY_REVTXN : Royalty 2.0 – WY – Royalty Reversals
    • OIUY6_WY_MKTXRF : Royalty 2.0 – WY – Marketing Type Xref
    • OIUY6_WY_RPDTM : Royalty 2.0 – WY – Lease/Unit Report Detail – Masters
    • OIUY6_WY_ZVOL : Royalty 2.0 – WY – Zero Volume Master
    • OIUY6_WY_ROYTXN : Royalty 2.0 – WY – Royalty Transactions
    • OIUY6_WY_ROYHSTA : Royalty 2.0 – WY – Royalty Transaction History (Allocated)
    • OIUY6_WY_RPDTS : Royalty 2.0 – WY – Lease/Unit Report Detail – PR/CA Summar
    • OIUY6_WY_OOSWO : Royalty 2.0 – Wyoming Out Of Statute Write Off
    • OIUY6_WY_INTTXN : Royalty 2.0 – WY – Royalty Transaction Interface
    • OIUY6_WY_ASU_HD : Royalty 2.0 – WY – Auto Suspend Header
    • OIUY6_WY_RPDTU : Royalty 2.0 – WY – Report Details Unit
    • OIUY6_WY_ROYTXNA : Royalty 2.0 – WY – Royalty Transactions (Allocated)
    • OIUY6_WY_LEASE : Royalty 2.0 – WY – Lease Data
    • OIUY6_WY_RPDTP : Royalty 2.0 – WY – Lease/Unit Report Detail – Production
    • OIUY6_WY_INTSTG : Royalty 2.0 – WY – Royalty Transaction Interface (Staging)
    • OIUY6_WY_REJT : Royalty 2.0 – WY – Reject Code Text
    • OIUY6_MIG_DN : Royalty 2.0 – WY – Migration – DNs

    OIUY6_WY_RPDTU related transaction codes under SAP package OIU_Y6

    • O3UY6_DISP_WY_ROYHST : Up-to-Date Reported Wyoming Trans
    • O3UY6_UPD_WY_ROYTXN : Maintain Wyoming User Roy Trans
    • O3UY6_WY_MASTER : Maintain Wyoming Master Data
    • O3UY6_WY_SOLE : Maintain Wyoming SOL Exceptions
    • O3UY6_WY_CAPOVR : Maintain Wyoming CA Percent Override
    • S_YEP_48000002 : IMG activity: OIUY6_WY_PDCXRF
    • O3UY6_DISP_WY_RPTVAR : Wyoming Royalty Variance Report
    • O3UY6_WY_CBMOVR : Maintain WY Coal Bed Methane Overrid
    • O3UY6_UPD_WY_OOS_WO : Wyoming Out-of-Statute Write-Off
    • S_YEP_48000003 : IMG activity: OIUY6_WY_MKTXRF
    • O3UY6_WY_ASU : Maintain Wyoming Auto Suspend Master
    • S_YEP_48000006 : IMG activity: V_OIUY6_RPT_CFG
    • O3UY6_UPD_WY_ROYHST : Update Wyoming Royalty History
    • O3UY6_DISP_PAY_RECON : Wyoming OPSL Balancing Report
    • O3UY6_DISP_WY_OOSWO : List of WY Out-of-Statute Write-Offs
    • O3UY6_WY_SOL : Maintain Wyoming Statute of Limit
    • O3UY6_WY_ZVOL : Wyoming Royalty Zero Volume Master
    • O3UY6_MIGRATION_005 : WY Oil Royalty Migration Workbench
    • O3UY6_DISP_BAL_RPT : Wyoming Royalty Balancing Report
    • O3UY6_WY_LEASE : Maintain Wyoming Lease Master

    Related References

    Related Tutorials

    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_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_RPDTP SAP table for – Royalty 2.0 – WY – Lease/Unit Report Detail – Production

    OIUY6_WY_RPDTP 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_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_RPDTD SAP table for – Royalty 2.0 – WY – Report Details

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

    OIUY6_WY_PRICE SAP table for – Royalty 2.0 – WY – Report Pricing

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

    «
    »