OIUBL01_ADJ SAP table for – Balancing Adjustments

Here we would like to draw your attention to OIUBL01_ADJ 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). OIUBL01_ADJ is a SAP standard transp table used for storing Balancing Adjustments related data in SAP. It comes under the package OIU_BL01.

SAP OIUBL01_ADJ table

Table OIUBL01_ADJ technical data

TableOIUBL01_ADJ
Data storingBalancing Adjustments
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-BL
SAP PackageOIU_BL01
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • .INCLUDE : Balancing Adjustments Key Fields
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • 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
  • PRODUCT_GRP : Balancing product group
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • RPT_MO : Report Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OWN_NO : PRA owner
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OWN_INT_TYPE_CD : Participant Interest Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OWN_ISQ_NO : Owner Interest Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • DN_NO : Delivery network number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • ADJ_TYPE : Adjustment Type
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PRD_MO : Production date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADJ_NO : Adjustment No
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Balancing Adjustments Non-Key Fields
  • KEEP_W_ORIG_OWN : Keep With Original Owner Flag
    Its data type is CHAR (Character String) with field length 1
  • QY_U : Quantity Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ADJ_QY : Balancing – Adjustment Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ADJ_RSN : Balancing transaction reasons
    Its data type is CHAR (Character String) with field length 3
  • ADJ_TEXT : Balancing – Adjustment Text
    Its data type is CHAR (Character String) with field length 30
  • TEMP_FLAG : Balancing – temporary flag for manual adjustments
    Its data type is CHAR (Character String) with field length 1
  • OLD_ENTL : Entitled Volume
    Its data type is QUAN (Quantity field) with field length 13
  • OLD_ACTL : Actual Volume
    Its data type is QUAN (Quantity field) with field length 13
  • NEW_ENTL : Entitled Volume
    Its data type is QUAN (Quantity field) with field length 13
  • NEW_ACTL : Actual Volume
    Its data type is QUAN (Quantity field) with field length 13
  • BTU_U : Heating Value Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BTU : Heating value
    Its data type is QUAN (Quantity field) with field length 13
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15