1. Home
  2. Resources
  3. SAP Tables
  4. MDSM - Simulative dependent requirements

SAP Table MDSM

Simulative dependent requirements

MDSM (Simulative dependent requirements) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MDSM to other SAP tables.

MDSM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SBNUM Simulation requirements number SBNUM NUMC 10 0
SBPOS Simulation requirements item number SBPOS NUMC 4 0
SBART Record type RSART CHAR 1 0
AUFST Order level AUFST NUMC 2 0
AUFWG Order path AUFWG NUMC 2 0
POSNR BOM item number APOSN CHAR 4 0
SORTF Sort String SORTP CHAR 10 0
PLSCN Planning Scenario of Long-Term Planning PLSCN PLSC NUMC 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
PRVBE Production Supply Area PRVBE PVBE CHAR 10 0
BDART Requirement type BDART CHAR 2 0
POSTP Item Category (Bill of Material) POSTP T418 CHAR 1 0
UPSKZ Indicator: sub-items exist UPSKZ CHAR 1 0
X Yes
NULL No
SCHGT Indicator: Bulk Material SCHGT CHAR 1 0
X Yes
NULL No
TXTPS Item text indicator TXTPS CHAR 1 0
X Yes
NULL No
INPOS Indicator: intra material INPOS CHAR 1 0
X Yes
NULL No
DUMPS Phantom item indicator DUMPS CHAR 1 0
X Yes
NULL No
KFPOS Indicator: "configurable item" KFPOS CHAR 1 0
NULL Blank
. Radio button
X Selection
NODSP Ind: Reserv. not applicable to MRP;Purc. req. not created NODISP CHAR 1 0
X Yes
NULL No
DBSKZ Direct procurement indicator DBSKZ CHAR 1 0
NULL No direct procurement or direct production
E Direct production
F Direct procurement
BDMNG Requirement Quantity BDMNG QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ESMNG Usage quantity per order unit of measure ESMNG FLTP 16 16
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BEIKZ Material Provision Indicator BEIKZ T417 CHAR 1 0
ERSKZ Indicator: spare part ERSKZ T413 CHAR 1 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME T006 UNIT 3 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
FMENG Quantity is Fixed FMENG CHAR 1 0
X Yes
NULL No
ALPOS Alternative item indicator ALTPS CHAR 1 0
X Yes
NULL No
EWAHR Usage probability in % (alternative item) EWAHR DEC 3 0
ALPGR Alternative item: group CS_ALPGR CHAR 2 0
ALPRF Alternative item: ranking order CS_ALPRF NUMC 2 0
ALPST Alternative item: strategy CS_ALPST CHAR 1 0
1 Manual maintenance/by usage probability
2 100% check
AUSCH Component scrap in percent KAUSF DEC 5 2
AVOAU Operation scrap AVOAU DEC 5 2
NETAU Indicator: Net scrap NETAU CHAR 1 0
X Yes
NULL No
BDTER Requirement Date for the Component BDTER DATS 8 0
SBTER Latest requirements date SBTER DATS 8 0
VERTI MRP Distribution Key SA_VERTL CHAR 4 0
NLFZT Lead-time offset NLFZT DEC 3 0
BDZTP Time that reservation quantity required BDZTP TIMS 6 0
ROHPS Variable-sized item indicator ROHPS CHAR 1 0
X Yes
NULL No
ROANZ Number of variable-size items ROANZ QUAN 13 3
ROMEN Quantity of variable-size item ROMEN QUAN 13 3
ROMEI Unit of measure for sizes 1 to 3 ROMEI T006 UNIT 3 0
ROMS1 Size 1 ROMS1 QUAN 13 3
ROMS2 Size 2 ROMS2 QUAN 13 3
ROMS3 Size 3 ROMS3 QUAN 13 3
RFORM Formula key RFORM T418F CHAR 2 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
NFPKZ Indicator: Follow-Up Item CS_KZNFP CHAR 1 0
X Yes
NULL No
KZAUS Discontinuation indicator KZAUS CHAR 1 0
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
NFEAG Discontinuation group CS_NFEAG CHAR 2 0
NFGRP Follow-up group CS_NFGRP CHAR 2 0
NAFKZ Indicator: follow-up material active/not active NAFKZ CHAR 1 0
X Yes
NULL No
NOMNG Required quantity NOMNG QUAN 13 3
NOMAT Follow-Up/Original Material NOMAT CHAR 18 0
NFUML NOT USED: Quantity transfer factor for follow-up material NFUML DEC 5 4
LTXSP Language: The long text was stored in this language LTXSP T002 LANG 1 0
POTX1 BOM Item Text (Line 1) POTX1 CHAR 40 0
POTX2 BOM item text (line 2) POTX2 CHAR 40 0
PLNUM Planned order number PLNUM PLAF CHAR 10 0
BAUGR Material number of higher-level assembly BAUGR MARA CHAR 18 0
BAUST Assembly order level BAUST NUMC 2 0
BAUWG Assembly order path BAUWG NUMC 2 0
SERNR BOM explosion number SERNR CHAR 8 0
AENNR Change Number AENNR AENR CHAR 12 0
REVLV Revision Level REVLV CHAR 2 0
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLNR Bill of material STNUM CHAR 8 0
STLKN BOM item node number STLKN NUMC 8 0
STPOZ Internal counter CIM_COUNT NUMC 8 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
FLGAT Sequence category FOLGENART TCA07 CHAR 1 0
PLNFL Sequence PLNFOLGE CHAR 6 0
VORNR Operation/Activity Number VORNR CHAR 4 0
APLZL Internal counter CIM_COUNT NUMC 8 0
STVKN Inherited node number of BOM item STVKN NUMC 8 0
VRPLA Indicator: planning without final assembly VRPLA CHAR 1 0
X Yes
NULL No
PBDNR Requirements Plan Number PBDNR CHAR 10 0
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
PSPEL WBS Element PS_POSNR PRPS NUMC 8 0
CLAKZ Indicator: classification exists CLAKZ CHAR 1 0
X Yes
NULL No
SANKA Indicator: item relevant to costing SANKA CHAR 1 0
KZKUP Indicator: co-product KZKUP CHAR 1 0
X Yes
NULL No
STLAL Alternative BOM STLAL CHAR 2 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
EDGNO Internal number for edge of object dependencies tree EDGNO M60I NUMC 17 0
NLFZV Lead-time offset for operation CS_NLFZV DEC 3 0
NLFMV Unit for lead-time offset for operation CS_NLFMV UNIT 3 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document

MDSM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDSM AENNR MDSM MANDT AENR Change Master MANDT
MDSM AENNR MDSM AENNR AENR Change Master AENNR
MDSM BAUGR MDSM MANDT MARA General Material Data MANDT
MDSM BAUGR MDSM BAUGR MARA General Material Data MATNR
MDSM BEIKZ MDSM MANDT T417 Material Provision Indicators MANDT
MDSM BEIKZ MDSM BEIKZ T417 Material Provision Indicators BEIKZ
MDSM EDGNO MDSM MANDT M60I Object dependencies tree structure for chars planning MANDT
MDSM EDGNO MDSM EDGNO M60I Object dependencies tree structure for chars planning EDGNO
MDSM ERFME MDSM MANDT T006 Units of Measurement MANDT
MDSM ERFME MDSM ERFME T006 Units of Measurement MSEHI
MDSM ERSKZ MDSM MANDT T413 Spare Part Indicators MANDT
MDSM ERSKZ MDSM ERSKZ T413 Spare Part Indicators ERSKZ
MDSM FLGAT MDSM FLGAT TCA07 Sequence categories FLGAT
MDSM KDAUF MDSM MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MDSM KDAUF MDSM KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
MDSM KNTTP MDSM MANDT T163K Account Assignment Categories in Purchasing Document MANDT
MDSM KNTTP MDSM KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
MDSM LGORT MDSM MANDT T001L Storage Locations MANDT
MDSM LGORT MDSM WERKS T001L Storage Locations WERKS
MDSM LGORT MDSM LGORT T001L Storage Locations LGORT
MDSM LIFNR MDSM MANDT LFA1 Vendor Master (General Section) MANDT
MDSM LIFNR MDSM LIFNR LFA1 Vendor Master (General Section) LIFNR
MDSM LTXSP MDSM LTXSP T002 Language Keys (Component BC-I18) SPRAS
MDSM MANDT MDSM MANDT T000 Clients MANDT
MDSM MATNR MDSM MANDT MARA General Material Data MANDT
MDSM MATNR MDSM MATNR MARA General Material Data MATNR
MDSM MEINS MDSM MEINS T006 Units of Measurement MSEHI
MDSM MEINS MDSM MANDT T006 Units of Measurement MANDT
MDSM OBJNR MDSM MANDT ONR00 General Object Number MANDT
MDSM OBJNR MDSM OBJNR ONR00 General Object Number OBJNR
MDSM PLNUM MDSM MANDT PLAF Planned Order MANDT
MDSM PLNUM MDSM PLNUM PLAF Planned Order PLNUM
MDSM PLSCN MDSM PLSCN PLSC Planning scenarios in long-term planning PLSCN
MDSM PLSCN MDSM MANDT PLSC Planning scenarios in long-term planning MANDT
MDSM POSTP MDSM MANDT T418 Item Categories MANDT
MDSM POSTP MDSM POSTP T418 Item Categories POSTP
MDSM PRVBE MDSM PRVBE PVBE Production Supply Area PRVBE
MDSM PRVBE MDSM MANDT PVBE Production Supply Area MANDT
MDSM PRVBE MDSM WERKS PVBE Production Supply Area WERKS
MDSM PSPEL MDSM MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
MDSM PSPEL MDSM PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
MDSM RFORM MDSM MANDT T418F Variable-Size Item Formulas MANDT
MDSM RFORM MDSM RFORM T418F Variable-Size Item Formulas RFORM
MDSM ROMEI MDSM MANDT T006 Units of Measurement MANDT
MDSM ROMEI MDSM ROMEI T006 Units of Measurement MSEHI
MDSM SOBKZ MDSM MANDT T148 Special Stock Indicator MANDT
MDSM SOBKZ MDSM SOBKZ T148 Special Stock Indicator SOBKZ
MDSM WERKS MDSM WERKS T001W Plants/Branches WERKS
MDSM WERKS MDSM MANDT T001W Plants/Branches MANDT