OIUX1_LNK_REPUB SAP table for – PUID and reporting entities link

Here we would like to draw your attention to OIUX1_LNK_REPUB 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). OIUX1_LNK_REPUB is a SAP standard transp table used for storing PUID and reporting entities link related data in SAP. It comes under the package OIU_X1.

SAP OIUX1_LNK_REPUB table

Table OIUX1_LNK_REPUB technical data

TableOIUX1_LNK_REPUB
Data storingPUID and reporting entities link
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X1
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Execution combinations for Tax Reporting
    Its a key field.
  • 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
  • .INCLUDE : Key for PUID and Reporting Entities link
    Its a key field.
  • 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
  • .INCLUDE : Nonkey attributes of PUID and reporting entities link
  • 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
  • INACTIVE_FLAG : Inactive Flag
    Its data type is CHAR (Character String) with field length 1
  • 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