OII_DIP_MVMT SAP table for – Related stock derived from SOC material assignment

Here we would like to draw your attention to OII_DIP_MVMT table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OII_DIP_MVMT is a SAP standard transp table used for storing Related stock derived from SOC material assignment related data in SAP. It comes under the package OII.

SAP OII_DIP_MVMT table

Table OII_DIP_MVMT technical data

TableOII_DIP_MVMT
Data storingRelated stock derived from SOC material assignment
ModuleIS-OIL
Sub ModuleIS-OIL-DS-BDR
SAP PackageOII
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SOCNR : SOC: Storage object characteristic segment number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • TIMESTAMP_FROM : From/start time stamp (BDRP)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • TIMESTAMP_TO : To/end timestamp (BDRP)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • CHARG : Batch Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BSTAR : Stock type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SOBKZ : Special Stock Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SOBKZ_ADD : Special stock identifier (sales order, vendor, project)
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • VERSION : Version number of dip material movement analysis
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DEBIT_QUAN : Goods receipt quantity (from material movement analysis)
    Its data type is QUAN (Quantity field) with field length 13
  • CREDIT_QUAN : Goods issue quantity (from material movement analysis)
    Its data type is QUAN (Quantity field) with field length 13
  • DEBIT_COUNT : Goods receipt mvmt count (from material movement analysis)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • CREDIT_COUNT : Goods issue mvmt.count (from material movement analysis)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CHANGE_FLAG : Mark changed base for dip analysis (new mat.mvmts)
    Its data type is CHAR (Character String) with field length 1
  • ERDAT : Date record created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time record created
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : User who created record
    Its data type is CHAR (Character String) with field length 12