MDSP SAP (View of BOM items and material master for gross reqmts plng) Structure details
Description: View of BOM items and material master for gross reqmts plng
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 |
STKZA | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
DATUV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
DATUB | Valid-to date | DATUB | DATS | 8 | DATUM | ||||
TECHV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
TECHB | Technical status to | TECHB | CHAR | 12 | TECHS | ||||
AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
STSOR | Sort String | SORTP | CHAR | 10 | CHAR10 | ||||
POSNR | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
POSTP | Item Category (Bill of Material) | POSTP | CHAR | 1 | Assigned to domain | POSTP | |||
UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1 | XFELD | ||||
SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
KMPFE | Indicator: item relevant to production | SANFE | CHAR | 1 | XFELD | ||||
KMPKA | Indicator for Relevancy to Costing | CK_SELKZ | CHAR | 1 | Assigned to domain | CK_SELKZ | |||
KMPMT | BOM component | IDNRK | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
KMPME | Component unit of measure | KMPME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KMPMG | Component quantity | KMPMG | QUAN | 13(3) | MENGV13 | ||||
FMENG | Quantity is Fixed | FMENG | CHAR | 1 | XFELD | ||||
ALPOS | Indicator: alternative item | ALPOS | CHAR | 1 | XFELD | ||||
EWAHR | Usage probability in % (alternative item) | EWAHR | DEC | 3 | DEC3 | ||||
ALPGR | Alternative item: group | CS_ALPGR | CHAR | 2 | CHAR2 | ||||
ALPRF | Alternative item: ranking order | CS_ALPRF | NUMC | 2 | NUM2 | ||||
ALPST | Alternative item: strategy | CS_ALPST | CHAR | 1 | CS_ALPST | ||||
KMPAS | Component scrap in percent | KAUSF | DEC | 5(2) | DEC3_2 | ||||
AVOAS | Operation scrap | AVOAU | DEC | 5(2) | DEC3_2 | ||||
AVONT | Indicator: Net scrap | NETAU | CHAR | 1 | XFELD | ||||
BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1 | Assigned to domain | BEIKZ | |||
ERSKZ | Indicator: spare part | ERSKZ | CHAR | 1 | Assigned to domain | ERSKZ | |||
REKRI | Indicator: BOM is recursive | REKRI | CHAR | 1 | XFELD | ||||
REKRS | Indicator: recursiveness allowed | REKRS | CHAR | 1 | XFELD | ||||
KZDUM | Indicator: phantom assembly off | CS_KZDUM | CHAR | 1 | XFELD | ||||
KZMFG | Indicator: switch off direct production/direct procurement | CS_KZMFG | CHAR | 1 | XFELD | ||||
KZVPL | Indicator: switch off planning | CS_KZVPL | CHAR | 1 | XFELD | ||||
KZLFP | Indicator: switch off long-term planning | CS_KZLFP | CHAR | 1 | XFELD | ||||
NLFZT | Lead-time offset | NLFZT | DEC | 3 | NLFZT | ||||
KFPOS | Indicator: 'configurable item' | KFPOS | CHAR | 1 | XFLAG | ||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | KNOBJ | ||||
KLPOS | Indicator: class item | KLPOS | CHAR | 1 | XFELD | ||||
KZCLB | Indicator: classification as selection condition | CS_KZCLB | CHAR | 1 | XFELD | ||||
KLART | Class Type | KLASSENART | CHAR | 3 | Assigned to domain | KLASSENART | KAR | ||
KFKLA | Class number | KLASSE_D | CHAR | 18 | KLASSE | KLA | |||
CLSZU | Classification number | CS_CLSZU | NUMC | 8 | NUM8 | ||||
ROMNG | Quantity of variable-size item | ROMEN | QUAN | 13(3) | MENG13 | ||||
ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ROANZ | Number of variable-size items | ROANZ | QUAN | 13(3) | MENG13 | ||||
ROMS1 | Size 1 | ROMS1 | QUAN | 13(3) | MENG13 | ||||
ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | ||||
ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | ||||
RFORM | Formula key | RFORM | CHAR | 2 | Assigned to domain | RFORM | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
PRVBE | Production Supply Area | PRVBE | CHAR | 10 | Assigned to domain | PRVBE | PVB | ||
NFPKZ | Indicator: Follow-Up Item | CS_KZNFP | CHAR | 1 | XFELD | ||||
NFEAG | Discontinuation group | CS_NFEAG | CHAR | 2 | CHAR2 | ||||
NFGRP | Follow-up group | CS_NFGRP | CHAR | 2 | CHAR2 | ||||
STLTX | Language: The long text was stored in this language | LTXSP | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
STTX1 | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
STTX2 | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
LIFZT | Delivery time in days | LIFZT | DEC | 3 | DEC3 | ||||
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
PREIS | Price | PREIS | CURR | 11(2) | WERT11 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
VERTI | Distribution key for component consumption | SA_VERTI | CHAR | 4 | Assigned to domain | SA_VERTL | |||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
SAKTO | Cost element | SAKTO | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
STVKN | Inherited node number of BOM item | STVKN | NUMC | 8 | KNTNR | ||||
STKNR | BOM item node number | STLKN | NUMC | 8 | KNTNR | ||||
TXPOS | Indicator: text item | TXPOS | CHAR | 1 | XFELD | ||||
RTPOS | Indicator: variable-size item | RTPOS | CHAR | 1 | XFELD | ||||
INPOS | Indicator: intra material | INPOS | CHAR | 1 | XFELD | ||||
KZKUP | Indicator: co-product | KZKUP | CHAR | 1 | XFELD | ||||
KZBSF | Inventory management indicator | KZBSF | CHAR | 1 | XFELD | ||||
MTMTA | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MTWRK | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MTLME | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MTAME | Unit of issue | AUSME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MTURZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
MTURN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
MTDIM | MRP Type | DISMM | CHAR | 2 | Assigned to domain | DISMM | |||
MTMIS | Mixed MRP indicator | MISKZ | CHAR | 1 | MISKZ | ||||
MTDVF | MRP procedure | DISVF | CHAR | 1 | DISVF | ||||
MTDST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
MTBES | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
MTSOB | Special procurement type | SOBSL | CHAR | 2 | Assigned to domain | SOBSL | |||
MTCHA | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
MTSEK | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1 | SBDKZ | ||||
MTALT | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1 | ALTSL | ||||
MTAUS | Assembly scrap in percent | AUSSS | DEC | 5(2) | DEC3_2 | ||||
MTKFM | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
MTREV | Revision Level Has Been Assigned to the Material | KZREV | CHAR | 1 | XFELD | ||||
MTDZT | In-house production time | DZEIT | DEC | 3 | DEC3 | ||||
MTPZT | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
MTWZT | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
MTBZT | Processing time | BEARZ | DEC | 5(2) | DEC3_2 | ||||
MTRZT | Setup and teardown time | RUEZT | DEC | 5(2) | DEC3_2 | ||||
MTTZT | Interoperation time | TRANZ | DEC | 5(2) | DEC3_2 | ||||
MTBMG | Base quantity | BASMG | QUAN | 13(3) | MENG13 | ||||
MTAKZ | Discontinuation indicator | KZAUS | CHAR | 1 | KZAUS | ||||
MTADT | Effective-Out Date | AUSDT | DATS | 8 | DATUM | ||||
MTNMT | Follow-Up Material | NFMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
MTLPR | Issue Storage Location | LGPRO | CHAR | 4 | Assigned to domain | LGORT | |||
MTEPR | Withdrawal sequence group for stocks | EPRIO | CHAR | 4 | Assigned to domain | EPRIO | |||
MTSGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
MTMNG | Quantity Updating in Material Master Record | MENGU | CHAR | 1 | XFELD | ||||
MTWRT | Value Update in Material Master Record | WERTU | CHAR | 1 | XFELD | ||||
MTPIO | Pipeline Handling Mandatory | KZPIP | CHAR | 1 | XFELD | ||||
MTPIZ | Pipeline handling allowed | XPIZU | CHAR | 1 | XFELD | ||||
MTRCD | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2 | Assigned to domain | MTVFP | |||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
KZBED | Indicator for Requirements Grouping | KZBED | CHAR | 1 | KZBED | ||||
DSPST | Explosion type | CS_DISPO | CHAR | 2 | Assigned to domain | CS_DISPO | |||
MTPVB | Production Supply Area | PRVBE | CHAR | 10 | Assigned to domain | PRVBE | PVB | ||
APOKZ | Indicator: Is material relevant for APO | APOKZ | CHAR | 1 | APOKZ | ||||
NLFZV | Lead-time offset for operation | CS_NLFZV | DEC | 3 | NLFZT | ||||
NLFMV | Unit for lead-time offset for operation | CS_NLFMV | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ITSOB | Special procurement type for BOM item | CS_SOBSL | CHAR | 2 | Assigned to domain | SOBSL |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects