OIUX2_PUIDLOG SAP table for – Tax Reporting PUID log

Here we would like to draw your attention to OIUX2_PUIDLOG 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). OIUX2_PUIDLOG is a SAP standard transp table used for storing Tax Reporting PUID log related data in SAP. It comes under the package OIU.

SAP OIUX2_PUIDLOG table

Table OIUX2_PUIDLOG technical data

TableOIUX2_PUIDLOG
Data storingTax Reporting PUID log
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUX2_PUIDLOG 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 OIUX2_PUIDLOG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RSG : Report Submission Group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • OGIND : Oil and Gas Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • PUID : Production Unit ID for tax reporting
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • RPT_YYYYMM : Reporting Year and Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SALES_YYYYMM : Sales YYYYMM
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • DB_ACTION : Type of change (Insert, Delete or Update)
    Its data type is CHAR (Character String) with field length 1
  • OPERATOR : Operator
    Its data type is CHAR (Character String) with field length 10
  • FIELD : Field ID
    Its data type is CHAR (Character String) with field length 10
  • PUID_TYPE : Production unit type
    Its data type is CHAR (Character String) with field length 2
  • PUID_GRP : Production unit group
    Its data type is CHAR (Character String) with field length 4
  • LEASE_SHARE : Lease share
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EXEMPT_DEC : exempt decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • USERNAME : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • TIMESTAMP : Time stamp in Numeric Character
    Its data type is NUMC (Character String with Digits Only) with field length 14