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

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

SAP OIUY6_WY_LEASE table

Table OIUY6_WY_LEASE technical data

TableOIUY6_WY_LEASE
Data storingRoyalty 2.0 – WY – Lease Data
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_LEASE 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_LEASE 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 – Lease Data Key Fields
    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
  • TRACT_ALLOC_LSE : Royalty 2.0 – Wyoming – Tract Allocation to Lease
    Its a key field. 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 a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • .INCLUDE : Tax Reporting – Last Changed Structure
  • CHANGE_USER : Tax Reporting – Last Changed User
    Its data type is CHAR (Character String) with field length 12
  • CHANGE_DATE : Tax Reporting – Last Changed Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGE_TIME : Tax Reporting – Last Changed Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6