MDSM SAP table for – Simulative dependent requirements

Here we would like to draw your attention to MDSM table in SAP. As we know it is being mainly used with the SAP PP-MRP (Material Requirements Planning – PP) component which is coming under PP module (Production Planning). MDSM is a SAP standard transparent table used for storing Simulative dependent requirements related data in SAP. It comes under the package MD03.

SAP MDSM table

Table MDSM technical data

TableMDSM
Data storingSimulative dependent requirements
ModulePP
ComponentPP-MRP
SAP PackageMD03
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MDSM Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MDSM table.

  • NLFZV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • PRVBE : Production Supply Area
    Its data type is C (Character String) with field length 10
  • POSTP
    Its data type is C (Character String) with field length 1
  • SCHGT
    Its data type is C (Character String) with field length 1
  • INPOS
    Its data type is C (Character String) with field length 1
  • SBNUM
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • KFPOS
    Its data type is C (Character String) with field length 1
  • DBSKZ
    Its data type is C (Character String) with field length 1
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • ERSKZ
    Its data type is C (Character String) with field length 1
  • ERFME : Unit of entry
    Its data type is C (Character String) with field length 3
  • UMREN : Denominator for conversion to base units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • ALPOS
    Its data type is C (Character String) with field length 1
  • ALPGR
    Its data type is C (Character String) with field length 2
  • ALPST
    Its data type is C (Character String) with field length 1
  • SBART
    Its a key field. Its data type is C (Character String) with field length 1
  • AVOAU
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • BDTER
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VERTI
    Its data type is C (Character String) with field length 4
  • BDZTP
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ROANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ROMEI
    Its data type is C (Character String) with field length 3
  • ROMS2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • RFORM
    Its data type is C (Character String) with field length 2
  • NFPKZ
    Its data type is C (Character String) with field length 1
  • NFEAG
    Its data type is C (Character String) with field length 2
  • AUFWG
    Its data type is N (Character String with Digits Only) with field length 2
  • NAFKZ
    Its data type is C (Character String) with field length 1
  • NOMAT
    Its data type is C (Character String) with field length 18
  • LTXSP : Language: The long text was stored in this language
    Its data type is C (Character String) with field length 1
  • POTX2
    Its data type is C (Character String) with field length 40
  • BAUGR
    Its data type is C (Character String) with field length 18
  • BAUWG
    Its data type is N (Character String with Digits Only) with field length 2
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • STLTY : BOM Category
    Its data type is C (Character String) with field length 1
  • STLKN
    Its data type is N (Character String with Digits Only) with field length 8
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • SORTF
    Its data type is C (Character String) with field length 10
  • PLNFL : Sequence
    Its data type is C (Character String) with field length 6
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • VRPLA
    Its data type is C (Character String) with field length 1
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • PLSCN
    Its data type is N (Character String with Digits Only) with field length 3
  • KDPOS : Item number in Sales Order
    Its data type is N (Character String with Digits Only) with field length 6
  • PSPEL
    Its data type is N (Character String with Digits Only) with field length 8
  • SANKA
    Its data type is C (Character String) with field length 1
  • STLAL : Alternative BOM
    Its data type is C (Character String) with field length 2
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10