OIUY6_WY_OPSL SAP table for – Roy 2.0 WY – OPSL Summary Data for a Run

Here we would like to draw your attention to OIUY6_WY_OPSL 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_OPSL is a SAP standard transp table used for storing Roy 2.0 WY – OPSL Summary Data for a Run related data in SAP. It comes under the package OIU_Y6.

SAP OIUY6_WY_OPSL table

Table OIUY6_WY_OPSL technical data

TableOIUY6_WY_OPSL
Data storingRoy 2.0 WY – OPSL Summary Data for a Run
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_OPSL 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_OPSL 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
  • 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
  • OWNER_IDENTIFIER : Royalty 2.0 – Owner Identifier
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • 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
  • TRANS_AM : JE Transaction Amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11