1. Home
  2. Resources
  3. SAP Tables
  4. MDPA - View of planned order/dummy conponents for BOM explosion

SAP Table MDPA

View of planned order/dummy conponents for BOM explosion

MDPA (View of planned order/dummy conponents for BOM explosion) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MDPA to other SAP tables.

MDPA table fields

Field Data element Checktable Datatype Length Decimals
MATNR Planning material PLMAT CHAR 18 0
PWWRK Production plant in planned order PWWRK CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
OBART Object type OBART CHAR 1 0
1 Planned order
2 Purchase requisition
3 Reservation
4 Production order
6 Simulation order
PLNUM Planned order number PLNUM CHAR 10 0
PAART Order type PAART CHAR 4 0
NB Standard purchase order
LA Stock order
RS Reservation
KD Individual customer order
KB Consignment order
PE Run schedule quantity
VP Planned independent requirements
PR Project order
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBES Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
GSMNG Total planned order quantity GSMNG QUAN 13 3
TLMNG Partial lot quantity TLMNG QUAN 13 3
AVMNG Fixed quantity of scrap from production AVMNG QUAN 13 3
LAGME Base Unit of Measure MEINS UNIT 3 0
PSTTR Order start date in planned order PSTTR DATS 8 0
PEDTR Order finish date in the planned order PEDTR DATS 8 0
UMSKZ Conversion indicator for planned order PLUMS CHAR 1 0
X Yes
NULL No
KNTTP Account Assignment Category KNTTP CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
PSPEL WBS Element PS_POSNR NUMC 8 0
SERNR BOM explosion number SERNR CHAR 8 0
PALTR Explosion date PALTR DATS 8 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
REVLV Revision Level REVLV CHAR 2 0
VERID Production Version VERID CHAR 4 0
STLAN BOM Usage STLAN CHAR 1 0
STALT Alternative BOM STALT CHAR 2 0
STSTA BOM status STLST NUMC 2 0
FRTHW Production note in the planned order FRTHW CHAR 1 0
1 Initiate procurements of non-stock components !
2 Purch.req.with unknown acct assig. for non-stock component !
AENNR Change Number AENNR CHAR 12 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
CUART Single-Character Indicator CHAR1 CHAR 1 0
VERTO Distribution key for quantity produced SA_VERTO CHAR 4 0
AUSSL Exception message key AUSSL CHAR 2 0
OLDSL Exception message key AUSSL CHAR 2 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
AUFST Order level AUFST NUMC 2 0
AUFWG Order path AUFWG NUMC 2 0
BAUST Assembly order level BAUST NUMC 2 0
BAUWG Assembly order path BAUWG NUMC 2 0
DISST Low-Level Code DISST CHAR 3 0
ALTSL Method for Selecting Alternative Bills of Material ALTSL CHAR 1 0
NULL Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLNR Bill of material STNUM CHAR 8 0
PRNKZ Ind.: Leading order in collective order is planned ordre PRNKZ CHAR 1 0
X
NULL
SBNUM Simulation requirements number SBNUM NUMC 10 0
SBPOS Simulation requirements item number SBPOS NUMC 4 0
GSBTR Total commitment date of plnd ord. after ATP check f.comps. GSBTR_PLAF DATS 8 0
VFMNG Planned order: committed quantity VFMNG QUAN 13 3
MDPBV Planned order: confirmation of availability MDPBV CHAR 1 0
NULL Availability not checked
1 Availability checked, not confirmed
2 Availability checked, partially confirmed
3 Availability checked, fully confirmed
KZAVC Indicator for type of availability check KZAVC CHAR 1 0
1 ATP check
2 Check against preliminary planning
MTVFP Checking Group for Availability Check MTVFP CHAR 2 0
VRPLA Indicator: planning without final assembly VRPLA CHAR 1 0
X Yes
NULL No
KFPOS Indicator: "configurable item" KFPOS CHAR 1 0
NULL Blank
. Radio button
X Selection
DUMPS Phantom item indicator DUMPS CHAR 1 0
X Yes
NULL No
AUFPL_ORD Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL_ORD General counter for order CO_APLZL NUMC 8 0
WAMNG Issued Quantity WAMNG QUAN 13 3
WEMNG Quantity of Goods Received WEMNG QUAN 13 3
EDGNO Internal number for edge of object dependencies tree EDGNO NUMC 17 0
FLIEF Fixed Vendor FLIEF CHAR 10 0
PLSCN Planning Scenario of Long-Term Planning PLSCN NUMC 3 0
PLWRK Planning Plant PLWRK CHAR 4 0
BERID MRP Area BERID CHAR 10 0
ARSNR Settlement reservation number ARSNR NUMC 10 0
EMLIF Vendor to be supplied/who is to receive delivery EMLIF CHAR 10 0
STAEX Status information on BOM explosion in planned order MD_STAEX CHAR 2 0
01 Alternative explosion (IPPE) active
02 Bulk material items not exploded
SERRU Type of subcontracting SERRU CHAR 1 0
NULL Subcontracting
1 Refurbishment with unchanged material number
2 Refurbishment with changed material number
3 Replacement
ANZSN Number of serial numbers ANZSN INT4 10 0
DISUB_SOBKZ Special stock indicator Subcontracting DISUB_SOBKZ_LB CHAR 1 0
NULL Normal stock
E Orders on hand
M Ret.trans.pkg vendor
K Consignment (vendor)
Q Project stock
DISUB_PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
DISUB_KUNNR Customer Number KUNNR CHAR 10 0
DISUB_VBELN Sales and Distribution Document Number VBELN CHAR 10 0
DISUB_POSNR Item number of the SD document POSNR NUMC 6 0
DISUB_OWNER Owner of stock OWNER_D CHAR 10 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0