OIUX2_LNK_LOG SAP table for – Tax Reporting log table for the link

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

SAP OIUX2_LNK_LOG table

Table OIUX2_LNK_LOG technical data

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

SAP OIUX2_LNK_LOG 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_LNK_LOG 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
  • 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
  • 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
  • ALLOC_FAC : Lease Allocation Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SEC_GEO_LOC : Secondary geographic location
    Its data type is CHAR (Character String) with field length 3
  • LEASE_SHARE : Lease share
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • EX_ALLOC_FAC : Exempt allocation Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • REALLOC_EXEMPT : Exemption reallocation flag
    Its data type is CHAR (Character String) with field length 1
  • REF_NO : Reference no
    Its data type is CHAR (Character String) with field length 30
  • 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
  • API : Well API
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • LEASE_TYPE : Lease Type
    Its data type is CHAR (Character String) with field length 1