SAP table MDSP (View of BOM items and material master for gross reqmts plng)

Field Description Data Type Length Decimals Checktable Data Element
STKZA Internal counter NUMC 8 0 CIM_COUNT
DATUV Valid-From Date DATS 8 0 DATUV
DATUB Valid-to date DATS 8 0 DATUB
TECHV Technical status from CHAR 12 0 TECHV
TECHB Technical status to CHAR 12 0 TECHB
AENNR Change Number CHAR 12 0 AENNR
STSOR Sort String CHAR 10 0 SORTP
POSNR BOM Item Number CHAR 4 0 SPOSN
POSTP Item category (bill of material) CHAR 1 0 POSTP
UPSKZ Indicator: sub-items exist CHAR 1 0 UPSKZ
SCHGT Indicator: bulk material CHAR 1 0 SCHGT
KMPFE Indicator: item relevant to production CHAR 1 0 SANFE
KMPKA Indicator for Relevancy to Costing CHAR 1 0 CK_SELKZ
KMPMT BOM component CHAR 40 0 IDNRK
KMPME Component Unit of Measure UNIT 3 0 KMPME
KMPMG Component Quantity QUAN 13 3 KMPMG
FMENG Quantity is fixed CHAR 1 0 FMENG
ALPOS Indicator: alternative item CHAR 1 0 ALPOS
EWAHR Usage Probability in % (Alternative Item) DEC 3 0 EWAHR
ALPGR Alternative item: group CHAR 2 0 CS_ALPGR
ALPRF Alternative item: ranking order NUMC 2 0 CS_ALPRF
ALPST Alternative item: strategy CHAR 1 0 CS_ALPST
1 Manual maintenance/by usage probability
2 100% check
KMPAS Component Scrap in Percent DEC 5 2 KAUSF
AVOAS Operation Scrap DEC 5 2 AVOAU
AVONT Net Scrap Indicator CHAR 1 0 NETAU
BEIKZ Material Provision Indicator CHAR 1 0 BEIKZ
ERSKZ Indicator: Spare Part CHAR 1 0 ERSKZ
REKRI Indicator: BOM is recursive CHAR 1 0 REKRI
REKRS Indicator: recursiveness allowed CHAR 1 0 REKRS
KZDUM Indicator: phantom assembly off CHAR 1 0 CS_KZDUM
KZMFG Indicator: switch off direct production/direct procurement CHAR 1 0 CS_KZMFG
KZVPL Indicator: switch off planning CHAR 1 0 CS_KZVPL
KZLFP Indicator: switch off long-term planning CHAR 1 0 CS_KZLFP
NLFZT Lead-time offset DEC 3 0 NLFZT
KFPOS Indicator: Configurable Item CHAR 1 0 KFPOS
KNOBJ Number of Object with Assigned Dependencies NUMC 18 0 KNOBJ
KLPOS Indicator: class item CHAR 1 0 KLPOS
KZCLB Indicator: classification as selection condition CHAR 1 0 CS_KZCLB
KLART Class Type CHAR 3 0 KLASSENART
KFKLA Class number CHAR 18 0 KLASSE_D
CLSZU Classification number NUMC 8 0 CS_CLSZU
ROMNG Variable-Size Item Quantity per Piece (PC) QUAN 13 3 ROMEN
ROMEI Unit of measure for sizes 1 to 3 UNIT 3 0 ROMEI
ROANZ Required Number of Variable-Size Items QUAN 13 3 ROANZ
ROMS1 Size 1 QUAN 13 3 ROMS1
ROMS2 Size 2 QUAN 13 3 ROMS2
ROMS3 Size 3 QUAN 13 3 ROMS3
RFORM Formula Key for Variable-Size Items CHAR 2 0 RFORM
LGORT Storage location CHAR 4 0 LGORT_D
PRVBE Production Supply Area CHAR 10 0 PRVBE
NFPKZ Indicator: Follow-Up Item CHAR 1 0 CS_KZNFP
NFEAG Discontinuation group CHAR 2 0 CS_NFEAG
NFGRP Follow-up group CHAR 2 0 CS_NFGRP
STLTX Language: The long text was stored in this language LANG 1 0 LTXSP
STTX1 Text, Length 40 CHAR 40 0 TXT40
STTX2 Text, Length 40 CHAR 40 0 TXT40
EKGRP Purchasing Group CHAR 3 0 EKGRP
LIFZT Delivery time in days DEC 3 0 LIFZT
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
PREIS Price CURR 11 2 PREIS
PEINH Price unit DEC 5 0 PEINH
VERTI Distribution key for component consumption CHAR 4 0 SA_VERTI
WAERS Currency Key CUKY 5 0 WAERS
SAKTO Cost element CHAR 10 0 SAKTO
EKORG Purchasing organization CHAR 4 0 EKORG
STVKN Inherited node number of BOM item NUMC 8 0 STVKN
STKNR BOM item node number NUMC 8 0 STLKN
TXPOS Indicator: text item CHAR 1 0 TXPOS
RTPOS Indicator: variable-size item CHAR 1 0 RTPOS
INPOS Indicator: Intra Material CHAR 1 0 INPOS
KZKUP Indicator: co-product CHAR 1 0 KZKUP
KZBSF Inventory management indicator CHAR 1 0 KZBSF
MTMTA Material type CHAR 4 0 MTART
MATKL Material Group CHAR 9 0 MATKL
MTWRK Plant CHAR 4 0 WERKS_D
MTLME Base Unit of Measure UNIT 3 0 MEINS
MTAME Unit of issue UNIT 3 0 AUSME
MTURZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
MTURN Denominator for conversion to base units of measure DEC 5 0 UMREN
MTDIM MRP Type CHAR 2 0 DISMM
MTMIS Mixed MRP indicator CHAR 1 0 MISKZ
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
MTDVF MRP Procedure CHAR 1 0 DISVF
B Reorder Point Planning
C Demand-Driven Replenishment
D Material Requirements Planning
M Master Production Scheduling
N No MRP
R Time-Phased Materials Planning
S Forecast-Based Planning
W Replenishment (IS Retail)
X Without MRP, with BOM Explosion
MTDST Low-Level Code CHAR 3 0 DISST
MTBES Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
MTSOB Special procurement type CHAR 2 0 SOBSL
MTCHA Batch Management Requirement Indicator CHAR 1 0 XCHPF
MTSEK Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
MTALT Method for Selecting Alternative Bills of Material CHAR 1 0 ALTSL
Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
MTAUS Assembly scrap in percent DEC 5 2 AUSSS
MTKFM Configurable Material CHAR 1 0 KZKFG
MTREV Revision Level Has Been Assigned to the Material CHAR 1 0 KZREV
MTDZT In-house production time DEC 3 0 DZEIT
MTPZT Planned Delivery Time in Days DEC 3 0 PLIFZ
MTWZT Goods receipt processing time in days DEC 3 0 WEBAZ
MTBZT Processing time DEC 5 2 BEARZ
MTRZT Setup and teardown time DEC 5 2 RUEZT
MTTZT Interoperation time DEC 5 2 TRANZ
MTBMG Base quantity QUAN 13 3 BASMG
MTAKZ Discontinuation indicator CHAR 1 0 KZAUS
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
MTADT Effective-Out Date DATS 8 0 AUSDT
MTNMT Follow-Up Material CHAR 40 0 NFMAT
MTLPR Issue Storage Location CHAR 4 0 LGPRO
MTEPR Withdrawal Sequence Group for Stocks CHAR 4 0 EPRIO
MTSGT Indicator: bulk material CHAR 1 0 SCHGT
MTMNG Quantity Updating in Material Master Record CHAR 1 0 MENGU
MTWRT Value Updating in Material Master Record CHAR 1 0 WERTU
MTPIO Pipeline Handling Mandatory CHAR 1 0 KZPIP
MTPIZ Pipeline handling allowed CHAR 1 0 XPIZU
MTRCD Single-Character Flag CHAR 1 0 CHAR1
MTVFP Checking Group for Availability Check CHAR 2 0 MTVFP
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
KZBED Indicator for Requirements Grouping CHAR 1 0 KZBED
0 In rep. mfg, individual record in addn to total requirements
T Display of dependent requirements as a daily total
DSPST Explosion type CHAR 2 0 CS_DISPO
MTPVB Production Supply Area CHAR 10 0 PRVBE
APOKZ Indicator: Is material relevant for APO CHAR 1 0 APOKZ
Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
NLFZV Lead-time offset for operation DEC 3 0 CS_NLFZV
NLFMV Unit for lead-time offset for operation UNIT 3 0 CS_NLFMV
ITSOB Special Procurement Type for BOM Item CHAR 2 0 CS_SOBSL
SGT_CMKZ Segmentation Maintained for BOM Components CHAR 1 0 SGT_CMKZ
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
FSH_CRITICAL_COMP Critical Component Indicator CHAR 1 0 FSH_CRITICAL_COMP
Not Critical
A Critical and automatic selection of stock
M Critical and manual selection of stock
FSH_CRITICAL_LEVEL Crtical Level of a Component in BoM DEC 2 0 FSH_CRITICAL_LEVEL