OIUY3_TX_ASU_DT SAP table for – Royalty 2.0 – TX GLO/TAMU – Auto Suspend Detail

Here we would like to draw your attention to OIUY3_TX_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). OIUY3_TX_ASU_DT is a SAP standard transp table used for storing Royalty 2.0 – TX GLO/TAMU – Auto Suspend Detail related data in SAP. It comes under the package OIU_Y3.

SAP OIUY3_TX_ASU_DT table

Table OIUY3_TX_ASU_DT technical data

TableOIUY3_TX_ASU_DT
Data storingRoyalty 2.0 – TX GLO/TAMU – Auto Suspend Detail
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_Y3
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUY3_TX_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 OIUY3_TX_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
  • GLO_LEASE : Royalty 2.0 – TX GLO/TAMU Lease
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • 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