OIUX1_PRD_UIDB SAP table for – Base table for Production Units/Leases

Here we would like to draw your attention to OIUX1_PRD_UIDB 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_PRD_UIDB is a SAP standard transp table used for storing Base table for Production Units/Leases related data in SAP. It comes under the package OIU_X1.

SAP OIUX1_PRD_UIDB table

Table OIUX1_PRD_UIDB technical data

TableOIUX1_PRD_UIDB
Data storingBase table for Production Units/Leases
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_PRD_UIDB 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_PRD_UIDB 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 fields for the PUID
    Its a key field.
  • PUID : Production Unit ID for tax reporting
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Non-key fields for PUID
  • 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
  • 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