MDPA SAP (View of planned order/dummy conponents for BOM explosion) Structure details
Description: View of planned order/dummy conponents for BOM explosion
Structure field list including key, data, relationships and ABAP select examples
MDPA 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 planned order/dummy conponents for BOM explosion" 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_MDPA TYPE MDPA.
The MDPA table consists of various fields, each holding specific information or linking keys about View of planned order/dummy conponents for BOM explosion data available in SAP. These include PWWRK (Production plant in planned order), LGORT (Storage Location), OBART (Object type), PLNUM (Planned order number).. 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 MDPA 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 |
MATNR | Planning material | PLMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
PWWRK | Production plant in planned order | PWWRK | CHAR | 4 | Assigned to domain | WERKS | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
OBART | Object type | OBART | CHAR | 1 | OBART | ||||
PLNUM | Planned order number | PLNUM | CHAR | 10 | Assigned to domain | ALPHA | PLNUM | PAF | |
PAART | Order type | PAART | CHAR | 4 | PAART | ||||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
SOBES | Special procurement type | SOBES | CHAR | 1 | SOBES | ||||
GSMNG | Total planned order quantity | GSMNG | QUAN | 13(3) | MENG13 | ||||
TLMNG | Partial lot quantity | TLMNG | QUAN | 13(3) | MENG13 | ||||
AVMNG | Fixed quantity of scrap from production | AVMNG | QUAN | 13(3) | MENG13 | ||||
LAGME | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PSTTR | Order start date in planned order | PSTTR | DATS | 8 | DATUM | ||||
PEDTR | Order finish date in the planned order | PEDTR | DATS | 8 | DATUM | ||||
UMSKZ | Conversion indicator for planned order | PLUMS | CHAR | 1 | XFELD | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | Assigned to domain | 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 | ||||
KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
PSPEL | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
SERNR | BOM explosion number | SERNR | CHAR | 8 | Assigned to domain | SERNR | |||
PALTR | Explosion date | PALTR | DATS | 8 | DATUM | ||||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
VERID | Production Version | VERID | CHAR | 4 | Assigned to domain | VERID | VER | ||
STLAN | BOM Usage | STLAN | CHAR | 1 | Assigned to domain | STLAN | CSV | ||
STALT | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
STSTA | BOM status | STLST | NUMC | 2 | Assigned to domain | STLST | |||
FRTHW | Production note in the planned order | FRTHW | CHAR | 1 | FRTHW | ||||
AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
CUART | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4 | Assigned to domain | SA_VERTL | |||
AUSSL | Exception message key | AUSSL | CHAR | 2 | Assigned to domain | AUSSL | |||
OLDSL | Exception message key | AUSSL | CHAR | 2 | Assigned to domain | AUSSL | |||
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 | |||
AUFST | Order level | AUFST | NUMC | 2 | AUFST | ||||
AUFWG | Order path | AUFWG | NUMC | 2 | AUFWG | ||||
BAUST | Assembly order level | BAUST | NUMC | 2 | AUFST | ||||
BAUWG | Assembly order path | BAUWG | NUMC | 2 | AUFWG | ||||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
ALTSL | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1 | ALTSL | ||||
STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
PRNKZ | Ind.: Leading order in collective order is planned ordre | PRNKZ | CHAR | 1 | KREUZ | ||||
SBNUM | Simulation requirements number | SBNUM | NUMC | 10 | Assigned to domain | SBNUM | |||
SBPOS | Simulation requirements item number | SBPOS | NUMC | 4 | RSPOS | ||||
GSBTR | Total commitment date of plnd ord. after ATP check f.comps. | GSBTR_PLAF | DATS | 8 | DATUM | ||||
VFMNG | Planned order: committed quantity | VFMNG | QUAN | 13(3) | MENG13 | ||||
MDPBV | Planned order: confirmation of availability | MDPBV | CHAR | 1 | MDPBV | ||||
KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1 | KZAVC | ||||
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2 | Assigned to domain | MTVFP | |||
VRPLA | Indicator: planning without final assembly | VRPLA | CHAR | 1 | XFELD | ||||
KFPOS | Indicator: 'configurable item' | KFPOS | CHAR | 1 | XFLAG | ||||
DUMPS | Phantom item indicator | DUMPS | CHAR | 1 | XFELD | ||||
AUFPL_ORD | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL_ORD | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
WAMNG | Issued Quantity | WAMNG | QUAN | 13(3) | MENG13 | ||||
WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
EDGNO | Internal number for edge of object dependencies tree | EDGNO | NUMC | 17 | Assigned to domain | EDGNO | |||
FLIEF | Fixed Vendor | FLIEF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PLSCN | Planning Scenario of Long-Term Planning | PLSCN | NUMC | 3 | Assigned to domain | PLSCN | PLS | ||
PLWRK | Planning Plant | PLWRK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
BERID | MRP Area | BERID | CHAR | 10 | Assigned to domain | BERID | BERID | ||
ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | MDNUM | ||||
EMLIF | Vendor to be supplied/who is to receive delivery | EMLIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
STAEX | Status information on BOM explosion in planned order | MD_STAEX | CHAR | 2 | MD_STAEX | ||||
.INCLU--AP | 0 | ||||||||
SERRU | Type of subcontracting | SERRU | CHAR | 1 | SERRU | SERRU | |||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | INT4 | ||||
DISUB_SOBKZ | Special stock indicator Subcontracting | DISUB_SOBKZ_LB | CHAR | 1 | DISUB_SOBKZ_LB | ||||
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 | ||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP |
Key field | Non-key field |
How do I retrieve data from SAP structure MDPA using ABAP code?
As MDPA 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 MDPA as there is no data to select.How to access SAP table MDPA
Within an ECC or HANA version of SAP you can also view further information about MDPA 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