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

Dictionary Type: Structure
Description: View of BOM items and material master for gross reqmts plng




ABAP Code to SELECT data from MDSP
Related tables to MDSP
Access table MDSP




Structure field list including key, data, relationships and ABAP select examples

MDSP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "View of BOM items and material master for gross reqmts plng" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MDSP TYPE MDSP.

The MDSP table consists of various fields, each holding specific information or linking keys about View of BOM items and material master for gross reqmts plng data available in SAP. These include DATUV (Valid-From Date), DATUB (Valid-to date), TECHV (Technical status from), TECHB (Technical status to).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MDSP structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
STKZAInternal counter CIM_COUNTNUMC8CIM_COUNT
DATUVValid-From Date DATUVDATS8DATUM
DATUBValid-to date DATUBDATS8DATUM
TECHVTechnical status from TECHVCHAR12TECHS
TECHBTechnical status to TECHBCHAR12TECHS
AENNRChange Number AENNRCHAR12Assigned to domainAENNRAENNRAEN
STSORSort String SORTPCHAR10CHAR10
POSNRBOM Item Number SPOSNCHAR4NUMCVSPOSN
POSTPItem Category (Bill of Material) POSTPCHAR1Assigned to domainPOSTP
UPSKZIndicator: sub-items exist UPSKZCHAR1XFELD
SCHGTIndicator: Bulk Material SCHGTCHAR1XFELD
KMPFEIndicator: item relevant to production SANFECHAR1XFELD
KMPKAIndicator for Relevancy to Costing CK_SELKZCHAR1Assigned to domainCK_SELKZ
KMPMTBOM component IDNRKCHAR18Assigned to domainMATN1MATNR
KMPMEComponent unit of measure KMPMEUNIT3Assigned to domainCUNITMEINS
KMPMGComponent quantity KMPMGQUAN13(3) MENGV13
FMENGQuantity is Fixed FMENGCHAR1XFELD
ALPOSIndicator: alternative item ALPOSCHAR1XFELD
EWAHRUsage probability in % (alternative item) EWAHRDEC3DEC3
ALPGRAlternative item: group CS_ALPGRCHAR2CHAR2
ALPRFAlternative item: ranking order CS_ALPRFNUMC2NUM2
ALPSTAlternative item: strategy CS_ALPSTCHAR1CS_ALPST
KMPASComponent scrap in percent KAUSFDEC5(2) DEC3_2
AVOASOperation scrap AVOAUDEC5(2) DEC3_2
AVONTIndicator: Net scrap NETAUCHAR1XFELD
BEIKZMaterial Provision Indicator BEIKZCHAR1Assigned to domainBEIKZ
ERSKZIndicator: spare part ERSKZCHAR1Assigned to domainERSKZ
REKRIIndicator: BOM is recursive REKRICHAR1XFELD
REKRSIndicator: recursiveness allowed REKRSCHAR1XFELD
KZDUMIndicator: phantom assembly off CS_KZDUMCHAR1XFELD
KZMFGIndicator: switch off direct production/direct procurement CS_KZMFGCHAR1XFELD
KZVPLIndicator: switch off planning CS_KZVPLCHAR1XFELD
KZLFPIndicator: switch off long-term planning CS_KZLFPCHAR1XFELD
NLFZTLead-time offset NLFZTDEC3NLFZT
KFPOSIndicator: 'configurable item' KFPOSCHAR1XFLAG
KNOBJNumber of Object with Assigned Dependencies KNOBJNUMC18KNOBJ
KLPOSIndicator: class item KLPOSCHAR1XFELD
KZCLBIndicator: classification as selection condition CS_KZCLBCHAR1XFELD
KLARTClass Type KLASSENARTCHAR3Assigned to domainKLASSENARTKAR
KFKLAClass number KLASSE_DCHAR18KLASSEKLA
CLSZUClassification number CS_CLSZUNUMC8NUM8
ROMNGQuantity of variable-size item ROMENQUAN13(3) MENG13
ROMEIUnit of measure for sizes 1 to 3 ROMEIUNIT3Assigned to domainCUNITMEINS
ROANZNumber of variable-size items ROANZQUAN13(3) MENG13
ROMS1Size 1 ROMS1QUAN13(3) MENG13
ROMS2Size 2 ROMS2QUAN13(3) MENG13
ROMS3Size 3 ROMS3QUAN13(3) MENG13
RFORMFormula key RFORMCHAR2Assigned to domainRFORM
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
PRVBEProduction Supply Area PRVBECHAR10Assigned to domainPRVBEPVB
NFPKZIndicator: Follow-Up Item CS_KZNFPCHAR1XFELD
NFEAGDiscontinuation group CS_NFEAGCHAR2CHAR2
NFGRPFollow-up group CS_NFGRPCHAR2CHAR2
STLTXLanguage: The long text was stored in this language LTXSPLANG1Assigned to domainISOLASPRAS
STTX1Text, length 40 TXT40CHAR40TEXT40
STTX2Text, length 40 TXT40CHAR40TEXT40
EKGRPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
LIFZTDelivery time in days LIFZTDEC3DEC3
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
PREISPrice PREISCURR11(2) WERT11
PEINHPrice Unit PEINHDEC5PACK3
VERTIDistribution key for component consumption SA_VERTICHAR4Assigned to domainSA_VERTL
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SAKTOCost element SAKTOCHAR10Assigned to domainALPHASAKNR
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
STVKNInherited node number of BOM item STVKNNUMC8KNTNR
STKNRBOM item node number STLKNNUMC8KNTNR
TXPOSIndicator: text item TXPOSCHAR1XFELD
RTPOSIndicator: variable-size item RTPOSCHAR1XFELD
INPOSIndicator: intra material INPOSCHAR1XFELD
KZKUPIndicator: co-product KZKUPCHAR1XFELD
KZBSFInventory management indicator KZBSFCHAR1XFELD
MTMTAMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
MTWRKPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MTLMEBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MTAMEUnit of issue AUSMEUNIT3Assigned to domainCUNITMEINS
MTURZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
MTURNDenominator for conversion to base units of measure UMRENDEC5UMBSN
MTDIMMRP Type DISMMCHAR2Assigned to domainDISMM
MTMISMixed MRP indicator MISKZCHAR1MISKZ
MTDVFMRP procedure DISVFCHAR1DISVF
MTDSTLow-Level Code DISSTCHAR3DISST
MTBESProcurement Type BESKZCHAR1BESKZMBS
MTSOBSpecial procurement type SOBSLCHAR2Assigned to domainSOBSL
MTCHABatch management requirement indicator XCHPFCHAR1XFELD
MTSEKDependent requirements ind. for individual and coll. reqmts SBDKZCHAR1SBDKZ
MTALTMethod for Selecting Alternative Bills of Material ALTSLCHAR1ALTSL
MTAUSAssembly scrap in percent AUSSSDEC5(2) DEC3_2
MTKFMConfigurable Material KZKFGCHAR1XFELD
MTREVRevision Level Has Been Assigned to the Material KZREVCHAR1XFELD
MTDZTIn-house production time DZEITDEC3DEC3
MTPZTPlanned Delivery Time in Days PLIFZDEC3DEC3
MTWZTGoods Receipt Processing Time in Days WEBAZDEC3DEC3
MTBZTProcessing time BEARZDEC5(2) DEC3_2
MTRZTSetup and teardown time RUEZTDEC5(2) DEC3_2
MTTZTInteroperation time TRANZDEC5(2) DEC3_2
MTBMGBase quantity BASMGQUAN13(3) MENG13
MTAKZDiscontinuation indicator KZAUSCHAR1KZAUS
MTADTEffective-Out Date AUSDTDATS8DATUM
MTNMTFollow-Up Material NFMATCHAR18Assigned to domainMATN1MATNRMAT
MTLPRIssue Storage Location LGPROCHAR4Assigned to domainLGORT
MTEPRWithdrawal sequence group for stocks EPRIOCHAR4Assigned to domainEPRIO
MTSGTIndicator: Bulk Material SCHGTCHAR1XFELD
MTMNGQuantity Updating in Material Master Record MENGUCHAR1XFELD
MTWRTValue Update in Material Master Record WERTUCHAR1XFELD
MTPIOPipeline Handling Mandatory KZPIPCHAR1XFELD
MTPIZPipeline handling allowed XPIZUCHAR1XFELD
MTRCDSingle-Character Indicator CHAR1CHAR1CHAR1
MTVFPChecking Group for Availability Check MTVFPCHAR2Assigned to domainMTVFP
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
KZBEDIndicator for Requirements Grouping KZBEDCHAR1KZBED
DSPSTExplosion type CS_DISPOCHAR2Assigned to domainCS_DISPO
MTPVBProduction Supply Area PRVBECHAR10Assigned to domainPRVBEPVB
APOKZIndicator: Is material relevant for APO APOKZCHAR1APOKZ
NLFZVLead-time offset for operation CS_NLFZVDEC3NLFZT
NLFMVUnit for lead-time offset for operation CS_NLFMVUNIT3Assigned to domainCUNITMEINS
ITSOBSpecial procurement type for BOM item CS_SOBSLCHAR2Assigned to domainSOBSL

Key field Non-key field



How do I retrieve data from SAP structure MDSP using ABAP code?

As MDSP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MDSP as there is no data to select.

How to access SAP table MDSP

Within an ECC or HANA version of SAP you can also view further information about MDSP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!