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 | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SCHGT
Indicator: Bulk Material
|
SCHGT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
TXTPS
Item text indicator
|
TXTPS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
INPOS
Indicator: intra material
|
INPOS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
DUMPS
Phantom item indicator
|
DUMPS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
KFPOS
Indicator: "configurable item"
|
KFPOS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
NODSP
Ind: Reserv. not applicable to MRP;Purc. req. not created
|
NODISP |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
DBSKZ
Direct procurement indicator
|
DBSKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ALPOS
Alternative item indicator
|
ALTPS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
AUSCH
Component scrap in percent
|
KAUSF |
DEC
|
5 | 2 | ||||||||||||||||||
|
AVOAU
Operation scrap
|
AVOAU |
DEC
|
5 | 2 | ||||||||||||||||||
|
NETAU
Indicator: Net scrap
|
NETAU |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
KZAUS
Discontinuation indicator
|
KZAUS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SANKA
Indicator: item relevant to costing
|
SANKA |
CHAR
|
1 | 0 | ||||||||||||||||||
|
KZKUP
Indicator: co-product
|
KZKUP |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
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 | ||||||||||||||||||
|
||||||||||||||||||||||
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 | KDAUF |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| MDSM | KDAUF | MDSM | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| 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 | MANDT |
T006
Units of Measurement
|
MANDT |
| MDSM | MEINS | MDSM | MEINS |
T006
Units of Measurement
|
MSEHI |
| MDSM | OBJNR | MDSM | OBJNR |
ONR00
General Object Number
|
OBJNR |
| MDSM | OBJNR | MDSM | MANDT |
ONR00
General Object Number
|
MANDT |
| MDSM | PLNUM | MDSM | MANDT |
PLAF
Planned Order
|
MANDT |
| MDSM | PLNUM | MDSM | PLNUM |
PLAF
Planned Order
|
PLNUM |
| MDSM | PLSCN | MDSM | MANDT |
PLSC
Planning scenarios in long-term planning
|
MANDT |
| MDSM | PLSCN | MDSM | PLSCN |
PLSC
Planning scenarios in long-term planning
|
PLSCN |
| MDSM | POSTP | MDSM | POSTP |
T418
Item Categories
|
POSTP |
| MDSM | POSTP | MDSM | MANDT |
T418
Item Categories
|
MANDT |
| MDSM | PRVBE | MDSM | MANDT |
PVBE
Production Supply Area
|
MANDT |
| MDSM | PRVBE | MDSM | WERKS |
PVBE
Production Supply Area
|
WERKS |
| MDSM | PRVBE | MDSM | PRVBE |
PVBE
Production Supply Area
|
PRVBE |
| 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 | MANDT |
T001W
Plants/Branches
|
MANDT |
| MDSM | WERKS | MDSM | WERKS |
T001W
Plants/Branches
|
WERKS |