MDSM

Simulative dependent requirements | #masterdata | Component: Master Data
Column Name Description
MANDT FK Client
SBNUM Simulation requirements number
SBPOS Simulation requirements item number
SBART Record type
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
BDMNG Requirement Quantity
ERFMG Quantity in unit of entry
ROANZ Required Number of Variable-Size Items
ROMEN Variable-Size Item Quantity per Piece (PC)
ROMS3 Size 3
NOMNG Input Quantity
📏 Unit of measure for sizes 1 to 3 (RESB.ROMEI):
ROMS1 Size 1
ROMS2 Size 2
Column Name Description
BDTER Requirements date for the component
SBTER Latest requirements date
BDZTP Time that reservation quantity required
Column Name Description
UPSKZ Indicator: sub-items exist Show values
SCHGT Indicator: bulk material Show values
TXTPS Item is Text indicator Show values
INPOS Indicator: Intra Material Show values
DUMPS Phantom item indicator Show values
KFPOS Indicator: Configurable Item Show values
NODSP Ind: Reserv. not applicable to MRP;Purc. req. not created Show values
DBSKZ Direct procurement indicator Show values
SHKZG Debit/Credit Indicator Show values
FMENG Quantity is fixed Show values
ALPOS Alternative Item Indicator Show values
ALPST Alternative item: strategy Show values
NETAU Net Scrap Indicator Show values
ROHPS Variable-Sized Item Indicator Show values
NFPKZ Indicator: Follow-Up Item Show values
KZAUS Discontinuation indicator Show values
NAFKZ Indicator: follow-up material active/not active Show values
STLTY BOM category Show values
VRPLA Indicator: planning without final assembly Show values
KZVBR Consumption posting Show values
CLAKZ Indicator: Classification Exists Show values
KZKUP Indicator: co-product Show values
KZBWS Valuation of Special Stock Show values
Column Name Description Domain name
AUFST Order level AUFST
AUFWG Order path AUFWG
POSNR BOM item number SPOSN
SORTF Sort String CHAR10
BDART Requirement type BDART
ESMNG Usage quantity per order unit of measure ESMNG
UMREZ Numerator for Conversion to Base Units of Measure UMBSZ
UMREN Denominator for conversion to base units of measure UMBSN
EWAHR Usage Probability in % (Alternative Item) DEC3
ALPGR Alternative item: group CHAR2
ALPRF Alternative item: ranking order NUM2
AUSCH Component Scrap in Percent DEC3_2
AVOAU Operation Scrap DEC3_2
VERTI MRP Distribution Key SA_VERTL
NLFZT Lead-time offset NLFZT
CUOBJ Configuration (internal object number) CUOBJ
NFEAG Discontinuation group CHAR2
NFGRP Follow-up group CHAR2
NOMAT Follow-Up/Original Material MATNR
NFUML NOT USED: Quantity transfer factor for follow-up material NFUML
POTX1 BOM Item Text (Line 1) TEXT40
POTX2 BOM Item Text (Line 2) TEXT40
BAUST Assembly Order Level AUFST
BAUWG Assembly Order Path AUFWG
SERNR BOM explosion number SERNR
REVLV Revision Level REVLV
STLNR Bill of Material STNUM
STLKN BOM item node number KNTNR
STPOZ Internal counter CIM_COUNT
PLNFL Sequence PLNFOLGE
VORNR Operation/Activity Number VORNR
APLZL Internal counter CIM_COUNT
STVKN Inherited node number of BOM item KNTNR
PBDNR Requirements Plan CHAR10
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
KDEIN Delivery schedule for sales order NUM04
SANKA Indicator: Item Relevant to Costing KAREL
STLAL Alternative BOM ALTNR
TECHS Parameter Variant/Standard Variant TECHS
NLFZV Lead-time offset for operation NLFZT
BOM_VERSN BOM Version CS_VERSN
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • MDSM.AENNR == AENR.AENNR
  • MDSM.MANDT == AENR.MANDT
Higher-Level Assembly Material
  • Higher-Level Assembly Material
  • Client
  • MDSM.BAUGR == MARA.MATNR
  • MDSM.MANDT == MARA.MANDT
Material Provision Indicator
  • Material Provision Indicator
  • Client
  • MDSM.BEIKZ == T417.BEIKZ
  • MDSM.MANDT == T417.MANDT
Internal number for edge of object dependencies tree
  • MDSM.MANDT == M60I.MANDT
  • MDSM.EDGNO == M60I.EDGNO
Unit of entry
  • MDSM.MANDT == T006.MANDT
  • MDSM.ERFME == T006.MSEHI
Indicator: Spare Part
  • MDSM.MANDT == T413.MANDT
  • MDSM.ERSKZ == T413.ERSKZ
Sequence Category MDSM.FLGAT == TCA07.FLGAT
Account Assignment Category
  • MDSM.MANDT == T163K.MANDT
  • MDSM.KNTTP == T163K.KNTTP
Storage location
  • Storage location
  • Client
  • Plant
  • MDSM.LGORT == T001L.LGORT
  • MDSM.MANDT == T001L.MANDT
  • MDSM.WERKS == T001L.WERKS
Account Number of Supplier
  • MDSM.MANDT == LFA1.MANDT
  • MDSM.LIFNR == LFA1.LIFNR
Language: The long text was stored in this language MDSM.LTXSP == T002.SPRAS
Client MDSM.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MDSM.MATNR == MARA.MATNR
  • MDSM.MANDT == MARA.MANDT
Base Unit of Measure
  • MDSM.MANDT == T006.MANDT
  • MDSM.MEINS == T006.MSEHI
Planned Order
  • MDSM.MANDT == PLAF.MANDT
  • MDSM.PLNUM == PLAF.PLNUM
Planning Scenario in Long-Term Planning
  • MDSM.MANDT == PLSC.MANDT
  • MDSM.PLSCN == PLSC.PLSCN
Item category (bill of material)
  • Item category (bill of material)
  • Client
  • MDSM.POSTP == T418.POSTP
  • MDSM.MANDT == T418.MANDT
Production Supply Area
  • Production Supply Area
  • Plant
  • Client
  • MDSM.PRVBE == PVBE.PRVBE
  • MDSM.WERKS == PVBE.WERKS
  • MDSM.MANDT == PVBE.MANDT
Formula Key for Variable-Size Items
  • Formula Key for Variable-Size Items
  • Client
  • MDSM.RFORM == T418F.RFORM
  • MDSM.MANDT == T418F.MANDT
Unit of measure for sizes 1 to 3
  • MDSM.MANDT == T006.MANDT
  • MDSM.ROMEI == T006.MSEHI
Special Stock Indicator
  • MDSM.MANDT == T148.MANDT
  • MDSM.SOBKZ == T148.SOBKZ
Plant
  • MDSM.MANDT == T001W.MANDT
  • MDSM.WERKS == T001W.WERKS