SAP MDPA Table in S/4 HANA - View of planned order/dummy conponents for BOM explosion
MDPA is a standard SAP Table which is used to store View of planned order/dummy conponents for BOM explosion data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MDPA table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MDPA
MDPA table structure field list
Below is the full MDPA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MATNR | Planning material | PLMAT | CHAR | 40(0) | MATN1 | MATNR | MAT | |||
PWWRK | Production Plant in Planned Order | PWWRK | CHAR | 4(0) | WERKS | |||||
LGORT | Storage location | LGORT_D | CHAR | 4(0) | LGORT | LAG | ||||
OBART | Object type | OBART | CHAR | 1(0) | OBART | |||||
PLNUM | Planned Order | PLNUM | CHAR | 10(0) | ALPHA | PLNUM | PAF | PLNUM | PLNUM | |
PAART | Planned Order Type | PAART | CHAR | 4(0) | PAART | |||||
BESKZ | Procurement Type | BESKZ | CHAR | 1(0) | BESKZ | MBS | ||||
SOBES | Special procurement type | SOBES | CHAR | 1(0) | SOBES | |||||
GSMNG | Planned Total Order Quantity | GSMNG | QUAN | 13(3) | MENG13 | |||||
TLMNG | Partial Lot Quantity | TLMNG | QUAN | 13(3) | MENG13 | |||||
AVMNG | Planned Scrap Quantity | AVMNG | QUAN | 13(3) | MENG13 | |||||
LAGME | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
PSTTR | Planned Order Start Date | PSTTR | DATS | 8(0) | DATUM | |||||
PEDTR | Planned Order End Date | PEDTR | DATS | 8(0) | DATUM | |||||
UMSKZ | Planned Order Conversion Indicator | PLUMS | CHAR | 1(0) | XFELD | |||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1(0) | KNTTP | KNT | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1(0) | SOBKZ | |||||
KZVBR | Consumption posting | KZVBR | CHAR | 1(0) | KZVBR | |||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1(0) | KZBWS | |||||
KDAUF | Sales Order Number | KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
KDPOS | Item number in Sales Order | KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
KDEIN | Delivery schedule for sales order | KDEIN | NUMC | 4(0) | NUM04 | |||||
PSPEL | WBS Element | PS_POSNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
SERNR | BOM explosion number | SERNR | CHAR | 8(0) | SERNR | |||||
PALTR | Explosion date | PALTR | DATS | 8(0) | DATUM | |||||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12(0) | TECHS | |||||
REVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
VERID | Production Version | VERID | CHAR | 4(0) | VERID | VER | ||||
STLAN | BOM Usage | STLAN | CHAR | 1(0) | STLAN | CSV | ||||
STALT | Alternative BOM | STALT | CHAR | 2(0) | ALPHA | ALTNR | ||||
STSTA | Bill of Material Status | STLST | NUMC | 2(0) | STLST | |||||
FRTHW | Production note in the planned order | FRTHW | CHAR | 1(0) | FRTHW | |||||
AENNR | Change Number | AENNR | CHAR | 12(0) | AENNR | AENNR | AEN | |||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18(0) | CUOBJ | CUX | ||||
CUART | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4(0) | SA_VERTL | |||||
AUSSL | Exception message key | AUSSL | CHAR | 2(0) | AUSSL | |||||
OLDSL | Exception message key | AUSSL | CHAR | 2(0) | AUSSL | |||||
RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC | 10(0) | RSNUM | RES | ||||
RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4(0) | RSPOS | RPO | ||||
AUFST | Order level | AUFST | NUMC | 2(0) | AUFST | |||||
AUFWG | Order path | AUFWG | NUMC | 2(0) | AUFWG | |||||
BAUST | Assembly Order Level | BAUST | NUMC | 2(0) | AUFST | |||||
BAUWG | Assembly Order Path | BAUWG | NUMC | 2(0) | AUFWG | |||||
DISST | Low-Level Code | DISST | CHAR | 3(0) | DISST | |||||
ALTSL | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1(0) | ALTSL | |||||
STLTY | BOM category | STLTY | CHAR | 1(0) | STLTY | |||||
STLNR | Bill of Material | STNUM | CHAR | 8(0) | NUMCV | STNUM | STLNR | STLNR | ||
PRNKZ | Ind.: Leading order in collective order is planned ordre | PRNKZ | CHAR | 1(0) | KREUZ | |||||
SBNUM | Simulation requirements number | SBNUM | NUMC | 10(0) | SBNUM | |||||
SBPOS | Simulation requirements item number | SBPOS | NUMC | 4(0) | RSPOS | |||||
GSBTR | Planned Order Total Commitment Date According to ATP Check | GSBTR_PLAF | DATS | 8(0) | DATUM | |||||
VFMNG | Planned order: committed quantity | VFMNG | QUAN | 13(3) | MENG13 | |||||
MDPBV | Planned order: confirmation of availability | MDPBV | CHAR | 1(0) | MDPBV | |||||
KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1(0) | KZAVC | |||||
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2(0) | MTVFP | |||||
VRPLA | Indicator: planning without final assembly | VRPLA | CHAR | 1(0) | XFELD | |||||
KFPOS | Indicator: Configurable Item | KFPOS | CHAR | 1(0) | XFLAG | |||||
DUMPS | Phantom item indicator | DUMPS | CHAR | 1(0) | XFELD | |||||
AUFPL_ORD | Routing number of operations in the order | CO_AUFPL | NUMC | 10(0) | AUFPL | |||||
APLZL_ORD | General counter for order | CO_APLZL | NUMC | 8(0) | 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(0) | EDGNO | |||||
FLIEF | Fixed vendor | FLIEF | CHAR | 10(0) | ALPHA | LIFNR | ||||
PLSCN | Planning Scenario in Long-Term Planning | PLSCN | NUMC | 3(0) | PLSCN | PLS | ||||
PLWRK | Planning Plant | PLWRK | CHAR | 4(0) | WERKS | WRK | ||||
BERID | MRP Area | BERID | CHAR | 10(0) | BERID | BERID | ||||
ARSNR | Settlement reservation number | ARSNR | NUMC | 10(0) | MDNUM | |||||
EMLIF | Supplier to be Supplied/Who is to Receive Delivery | EMLIF | CHAR | 10(0) | ALPHA | LIFNR | ||||
STAEX | Status information on BOM explosion in planned order | MD_STAEX | CHAR | 2(0) | MD_STAEX | |||||
SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 40(0) | SGT_SRCA | SGT_S | SGT_CAT_FIELD_POPUP | VALUE | ||
DELVR | MRP element | DELKZ | CHAR | 2(0) | DELKZ | |||||
EBNVR | Purchasing Document Number | EBELN | CHAR | 10(0) | ALPHA | EBELN | BES | MEKK_C | EBELN | |
POSVR | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EBELP | BSP | ||||
BOM_VERSN | BOM Version | CS_VERSN | CHAR | 4(0) | CS_VERSN | |||||
.INCLU--AP | 0(0) | |||||||||
SERRU | Type of subcontracting | SERRU | CHAR | 1(0) | SERRU | SERRU | ||||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10(0) | INT4 | |||||
DISUB_SOBKZ | Special stock indicator Subcontracting | DISUB_SOBKZ_LB | CHAR | 1(0) | DISUB_SOBKZ_LB | |||||
DISUB_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | Assigned to domain | ABPSP | PS_POSNR | |||
DISUB_KUNNR | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
DISUB_VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
DISUB_POSNR | Item number of the SD document | POSNR | NUMC | 6(0) | Assigned to domain | POSNR | ||||
DISUB_OWNER | Owner of stock | OWNER_D | CHAR | 10(0) | Assigned to domain | ALPHA | LIFNR | |||
PSTYP | Item category in purchasing document | PSTYP | CHAR | 1(0) | Assigned to domain | PSTYP |
Search for further information about these or an SAP related objects