OIU_SB_NIMB SAP table for – Marketing representative imbalance volumes

Here we would like to draw your attention to OIU_SB_NIMB 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). OIU_SB_NIMB is a SAP standard transp table used for storing Marketing representative imbalance volumes related data in SAP. It comes under the package OIU.

SAP OIU_SB_NIMB table

Table OIU_SB_NIMB technical data

TableOIU_SB_NIMB
Data storingMarketing representative imbalance volumes
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DN_NO : Delivery network number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • SA_DT : Sales date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FREQ_CD : Frequency
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • MK_REP_NO : Marketing Representative No
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MK_REP_ISQ_NO : Marketing Representative Interest Sequence No
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • QY_U : Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ORIG_BEG_IMB_QY : Beginning imbalance from NMR table (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • NEW_BEG_IMB_QY : New beginning imbalance calculated in CABS700
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • UNAPPL_PPA_QY : Unapplied Prior Period Adjustment (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • APPL_PPA_QY : Applied Prior Period Adjustment (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • UNAPPL_MAN_QY : Unapplied Manual (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • APPL_MAN_QY : Applied Manual (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • MK_REP_IMB_QY : Marketing representative imbalance (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • IMB_MKUP_QY : Imbalance Makeup (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • PHASE_5_IMB_QY : Phase 5 Imbalance (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • ORIG_END_IMB_QY : Original Ending Imbalance (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • NEW_END_IMB_QY : New Ending Imbalance (Volumetric or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • ADJ_ENTL_QY : Adjusted Entitlement (Volumetric or Energy)
    Its data type is QUAN (Quantity field) with field length 13
  • SALE_QY : Sales (Volumetric or Energy)
    Its data type is QUAN (Quantity field) with field length 13
  • PPA_IMB_ADJ_QY : Prior Period Adjustment Imbalance Adjustment (Vol or Energy)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) 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