MDPM SAP (View of Material Components in the Planned Order) Structure details
Description: View of Material Components in the Planned Order
Structure field list including key, data, relationships and ABAP select examples
MDPM 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 Material Components in the Planned Order" 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_MDPM TYPE MDPM.
The MDPM table consists of various fields, each holding specific information or linking keys about View of Material Components in the Planned Order data available in SAP. These include AUFWG (Order path), PMSOR (Internal sort key), XPOSN (BOM Item Number), PMSO1 (Sort fiels 1 for discontinued and substitute parts).. 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 MDPM 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 |
AUFST | Order level | AUFST | NUMC | 2 | AUFST | ||||
AUFWG | Order path | AUFWG | NUMC | 2 | AUFWG | ||||
PMSOR | Internal sort key | PMSOR | NUMC | 4 | RSPOS | ||||
XPOSN | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
PMSO1 | Sort fiels 1 for discontinued and substitute parts | PMSO1 | CHAR | 2 | CHAR2 | ||||
EPOSN | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
STSOR | Sort String | SORTP | CHAR | 10 | CHAR10 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
BDART | Requirement type | BDART | CHAR | 2 | BDART | BDA | |||
POSTP | Item Category (Bill of Material) | POSTP | CHAR | 1 | T418 | POSTP | |||
POSNR | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1 | XFELD | ||||
DUMPS | Phantom item indicator | DUMPS | CHAR | 1 | XFELD | ||||
TXTPS | Item text indicator | TXTPS | CHAR | 1 | XFELD | ||||
INPOS | Indicator: intra material | INPOS | CHAR | 1 | XFELD | ||||
SGTPS | Bulk material indicator | SGTPS | CHAR | 1 | XFELD | ||||
KFPOS | Indicator: 'configurable item' | KFPOS | CHAR | 1 | XFLAG | ||||
KZKUP | Indicator: co-product | KZKUP | CHAR | 1 | XFELD | ||||
KLPOS | Indicator: class item | KLPOS | CHAR | 1 | XFELD | ||||
CLAKZ | Indicator: classification exists | CLAKZ | CHAR | 1 | XFELD | ||||
DBSKZ | Direct procurement indicator | DBSKZ | CHAR | 1 | DBSKZ | ||||
MTKFM | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
KMPKA | Indicator for Relevancy to Costing | CK_SELKZ | CHAR | 1 | TCK08 | CK_SELKZ | |||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1 | Assigned to domain | BEIKZ | |||
ERSKZ | Indicator: spare part | ERSKZ | CHAR | 1 | T413 | ERSKZ | |||
BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | ||||
VMENG | Confirmed quantity for availability check in SKU | VMENG | QUAN | 15(3) | MENG15 | ||||
LAGME | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ESMNG | Usage quantity per order unit of measure | ESMNG | FLTP | 16(16) | ESMNG | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T158B | BWART | BWA | ||
KZEAR | Final Issue for This Reservation | KZEAR | CHAR | 1 | XFELD | ||||
ERFMG | Requirement quantity of the component | CO_MENGE | QUAN | 13(3) | MENGV13 | ||||
ERFME | Unit of Entry | ERFME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
ENMNG | Quantity Withdrawn | ENMNG | QUAN | 13(3) | MENG13 | ||||
FMENG | Quantity is Fixed | FMENG | CHAR | 1 | XFELD | ||||
ALTPS | Alternative item indicator | ALTPS | 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 | ||||
BDTER | Requirement Date for the Component | BDTER | DATS | 8 | DATUM | ||||
SBTER | Latest requirements date | SBTER | DATS | 8 | DATUM | ||||
NLFZT | Lead-time offset | NLFZT | DEC | 3 | NLFZT | ||||
ASTTR | Order start date | ASTTR | DATS | 8 | DATUM | ||||
VERTI | Distribution key for component consumption | SA_VERTI | CHAR | 4 | Assigned to domain | SA_VERTL | |||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
ROHPS | Variable-sized item indicator | ROHPS | CHAR | 1 | XFELD | ||||
ROANZ | Number of variable-size items | ROANZ | QUAN | 13(3) | MENG13 | ||||
ROAME | Unit of measure for variable-size items | ROAME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
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 | ||
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 | |||
LGPRO | Issue Storage Location | LGPRO | CHAR | 4 | T001L | LGORT | |||
PRVBE | Production Supply Area | PRVBE | CHAR | 10 | PVBE | PRVBE | PVB | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCHA | CHARG | CHA | ||
AUSME | Unit of issue | AUSME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STLTX | Language: The long text was stored in this language | LTXSP | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
SGTX1 | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
SGTX2 | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
NFPKZ | Indicator: Follow-Up Item | CS_KZNFP | CHAR | 1 | XFELD | ||||
KZAUS | Discontinuation type | AUSLF | CHAR | 1 | AUSLF | ||||
NFEAG | Discontinuation group | CS_NFEAG | CHAR | 2 | CHAR2 | ||||
NFGRP | Follow-up group | CS_NFGRP | CHAR | 2 | CHAR2 | ||||
NAFKZ | Indicator: follow-up material active/not active | NAFKZ | CHAR | 1 | XFELD | ||||
NFMAT | Follow-Up Material | NFMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
NOMNG | Required quantity | NOMNG | QUAN | 13(3) | MENG13 | ||||
NFUML | NOT USED: Quantity transfer factor for follow-up material | NFUML | DEC | 5(4) | NFUML | ||||
AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
BAUGR | Material number of higher-level assembly | BAUGR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
BAUST | Assembly order level | BAUST | NUMC | 2 | AUFST | ||||
BAUWG | Assembly order path | BAUWG | NUMC | 2 | AUFWG | ||||
STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
STKNR | BOM item node number | STLKN | NUMC | 8 | KNTNR | ||||
STKZA | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
STVKN | Inherited node number of BOM item | STVKN | NUMC | 8 | KNTNR | ||||
SERNR | BOM explosion number | SERNR | CHAR | 8 | Assigned to domain | SERNR | |||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
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 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
SAKTO | Cost element | SAKTO | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
DISMM | MRP Type | DISMM | CHAR | 2 | Assigned to domain | DISMM | |||
DISVF | MRP procedure | DISVF | CHAR | 1 | DISVF | ||||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
MISKZ | Mixed MRP indicator | MISKZ | CHAR | 1 | MISKZ | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
SBDKZ | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1 | SBDKZ | ||||
KZBED | Indicator for Requirements Grouping | KZBED | CHAR | 1 | KZBED | ||||
EPRIO | Withdrawal sequence group for stocks | EPRIO | CHAR | 4 | Assigned to domain | EPRIO | |||
XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
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 | |
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
RSART | Record type | RSART | CHAR | 1 | RSART | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
APLZL | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
SMBLN | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
SMBLP | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
VSTAT | Processing Status | VSTAT_D | CHAR | 1 | VSTAT | ||||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
IMDCI | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
ACENQ | Material block in availability check with transfer of qties | ACENQ | CHAR | 1 | XFELD | ||||
IFIXX | Internal fixing indicator when fixing phantom assemblies | IFIXX | CHAR | 1 | CHAR1 | ||||
STALT | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2 | Assigned to domain | MTVFP | |||
PUMNG | Required quantity | NOMNG | QUAN | 13(3) | MENG13 | ||||
VRPLA | Indicator: planning without final assembly | VRPLA | CHAR | 1 | XFELD | ||||
PBDNR | Requirements Plan Number | PBDNR | CHAR | 10 | CHAR10 | PBN | |||
NOSRQ | No individual requirements in table RESB | EINBD | CHAR | 1 | CHAR1 | ||||
DBKZG | Requirement as total record in table RQIT | DBKZG | CHAR | 1 | CHAR1 | ||||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
OBNUM | Object reference: Document log - repetitive manufacturing | OBNUM | CHAR | 20 | OBNUM | ||||
EDGNO | Internal number for edge of object dependencies tree | EDGNO | NUMC | 17 | Assigned to domain | EDGNO | |||
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 | ||
APOKZ | Indicator: Is material relevant for APO | APOKZ | CHAR | 1 | APOKZ | ||||
MB_GRUND | Reason for Movement | MB_GRBEW | NUMC | 4 | T157D | MB_GRBEW | |||
XFEHL | Missing Part | XFEHL | CHAR | 1 | XFELD | ||||
NODSP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1 | NO_DISP_PLUS | ||||
MLSCR | Multilevel Subcontracting Indicator | MLSC_RELEVANT | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
NO_DISP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1 | NO_DISP_PLUS | ||||
DISUB_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
DISUB_KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
DISUB_VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
DISUB_POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
DISUB_OWNER | Owner of stock | OWNER_D | CHAR | 10 | Assigned to domain | ALPHA | LIFNR |
Key field | Non-key field |
How do I retrieve data from SAP structure MDPM using ABAP code?
As MDPM 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 MDPM as there is no data to select.How to access SAP table MDPM
Within an ECC or HANA version of SAP you can also view further information about MDPM 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