OIUY6_WY_ASU_DT SAP table for – Royalty 2.0 – WY – Auto Suspend Detail

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

SAP OIUY6_WY_ASU_DT table

Table OIUY6_WY_ASU_DT technical data

TableOIUY6_WY_ASU_DT
Data storingRoyalty 2.0 – WY – Auto Suspend Detail
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_ASU_DT 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_ASU_DT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ASU_NO : Tax Reporting – ASU/SOL Criteria Number
    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
  • 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
  • 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
  • SA_DT_CRITERIA : Sales Date Criteria for Auto-Suspension
    Its data type is CHAR (Character String) with field length 1
  • FROM_SA_DT : From Sales Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TO_SA_DT : To Sales Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8