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
MATNRPlanning materialPLMATCHAR40(0) MATN1MATNRMAT
PWWRKProduction Plant in Planned OrderPWWRKCHAR4(0) WERKS
LGORTStorage locationLGORT_DCHAR4(0) LGORTLAG
OBARTObject typeOBARTCHAR1(0) OBART
PLNUMPlanned OrderPLNUMCHAR10(0) ALPHAPLNUMPAFPLNUMPLNUM
PAARTPlanned Order TypePAARTCHAR4(0) PAART
BESKZProcurement TypeBESKZCHAR1(0) BESKZMBS
SOBESSpecial procurement typeSOBESCHAR1(0) SOBES
GSMNGPlanned Total Order QuantityGSMNGQUAN13(3) MENG13
TLMNGPartial Lot QuantityTLMNGQUAN13(3) MENG13
AVMNGPlanned Scrap QuantityAVMNGQUAN13(3) MENG13
LAGMEBase Unit of MeasureMEINSUNIT3(0) CUNITMEINS
PSTTRPlanned Order Start DatePSTTRDATS8(0) DATUM
PEDTRPlanned Order End DatePEDTRDATS8(0) DATUM
UMSKZPlanned Order Conversion IndicatorPLUMSCHAR1(0) XFELD
KNTTPAccount Assignment CategoryKNTTPCHAR1(0) KNTTPKNT
SOBKZSpecial Stock IndicatorSOBKZCHAR1(0) SOBKZ
KZVBRConsumption postingKZVBRCHAR1(0) KZVBR
KZBWSValuation of Special StockKZBWSCHAR1(0) KZBWS
KDAUFSales Order NumberKDAUFCHAR10(0) ALPHAVBELNAUN
KDPOSItem number in Sales OrderKDPOSNUMC6(0) NUM06KPO
KDEINDelivery schedule for sales orderKDEINNUMC4(0) NUM04
PSPELWBS ElementPS_POSNRNUMC8(0) ABPSPPS_POSNR
SERNRBOM explosion numberSERNRCHAR8(0) SERNR
PALTRExplosion datePALTRDATS8(0) DATUM
TECHSParameter Variant/Standard VariantTECHSCHAR12(0) TECHS
REVLVRevision levelREVLVCHAR2(0) NUMCVREVLVRVS
VERIDProduction VersionVERIDCHAR4(0) VERIDVER
STLANBOM UsageSTLANCHAR1(0) STLANCSV
STALTAlternative BOMSTALTCHAR2(0) ALPHAALTNR
STSTABill of Material StatusSTLSTNUMC2(0) STLST
FRTHWProduction note in the planned orderFRTHWCHAR1(0) FRTHW
AENNRChange NumberAENNRCHAR12(0) AENNRAENNRAEN
CUOBJConfiguration (internal object number)CUOBJNUMC18(0) CUOBJCUX
CUARTSingle-Character FlagCHAR1CHAR1(0) CHAR1
VERTODistribution key for quantity producedSA_VERTOCHAR4(0) SA_VERTL
AUSSLException message keyAUSSLCHAR2(0) AUSSL
OLDSLException message keyAUSSLCHAR2(0) AUSSL
RSNUMNumber of reservation/dependent requirementsRSNUMNUMC10(0) RSNUMRES
RSPOSItem Number of Reservation / Dependent RequirementsRSPOSNUMC4(0) RSPOSRPO
AUFSTOrder levelAUFSTNUMC2(0) AUFST
AUFWGOrder pathAUFWGNUMC2(0) AUFWG
BAUSTAssembly Order LevelBAUSTNUMC2(0) AUFST
BAUWGAssembly Order PathBAUWGNUMC2(0) AUFWG
DISSTLow-Level CodeDISSTCHAR3(0) DISST
ALTSLMethod for Selecting Alternative Bills of MaterialALTSLCHAR1(0) ALTSL
STLTYBOM categorySTLTYCHAR1(0) STLTY
STLNRBill of MaterialSTNUMCHAR8(0) NUMCVSTNUMSTLNRSTLNR
PRNKZInd.: Leading order in collective order is planned ordrePRNKZCHAR1(0) KREUZ
SBNUMSimulation requirements numberSBNUMNUMC10(0) SBNUM
SBPOSSimulation requirements item numberSBPOSNUMC4(0) RSPOS
GSBTRPlanned Order Total Commitment Date According to ATP CheckGSBTR_PLAFDATS8(0) DATUM
VFMNGPlanned order: committed quantityVFMNGQUAN13(3) MENG13
MDPBVPlanned order: confirmation of availabilityMDPBVCHAR1(0) MDPBV
KZAVCIndicator for type of availability checkKZAVCCHAR1(0) KZAVC
MTVFPChecking Group for Availability CheckMTVFPCHAR2(0) MTVFP
VRPLAIndicator: planning without final assemblyVRPLACHAR1(0) XFELD
KFPOSIndicator: Configurable ItemKFPOSCHAR1(0) XFLAG
DUMPSPhantom item indicatorDUMPSCHAR1(0) XFELD
AUFPL_ORDRouting number of operations in the orderCO_AUFPLNUMC10(0) AUFPL
APLZL_ORDGeneral counter for orderCO_APLZLNUMC8(0) CO_APLZL
WAMNGIssued QuantityWAMNGQUAN13(3) MENG13
WEMNGQuantity of Goods ReceivedWEMNGQUAN13(3) MENG13
EDGNOInternal number for edge of object dependencies treeEDGNONUMC17(0) EDGNO
FLIEFFixed vendorFLIEFCHAR10(0) ALPHALIFNR
PLSCNPlanning Scenario in Long-Term PlanningPLSCNNUMC3(0) PLSCNPLS
PLWRKPlanning PlantPLWRKCHAR4(0) WERKSWRK
BERIDMRP AreaBERIDCHAR10(0) BERIDBERID
ARSNRSettlement reservation numberARSNRNUMC10(0) MDNUM
EMLIFSupplier to be Supplied/Who is to Receive DeliveryEMLIFCHAR10(0) ALPHALIFNR
STAEXStatus information on BOM explosion in planned orderMD_STAEXCHAR2(0) MD_STAEX
SGT_SCATStock SegmentSGT_SCATCHAR40(0) SGT_SRCASGT_SSGT_CAT_FIELD_POPUPVALUE
DELVRMRP elementDELKZCHAR2(0) DELKZ
EBNVRPurchasing Document NumberEBELNCHAR10(0) ALPHAEBELNBESMEKK_CEBELN
POSVRItem Number of Purchasing DocumentEBELPNUMC5(0) EBELPBSP
BOM_VERSNBOM VersionCS_VERSNCHAR4(0) CS_VERSN
.INCLU--AP0(0)
SERRUType of subcontractingSERRUCHAR1(0) SERRUSERRU
ANZSNNumber of serial numbersANZSNINT410(0) INT4
DISUB_SOBKZSpecial stock indicator SubcontractingDISUB_SOBKZ_LBCHAR1(0) DISUB_SOBKZ_LB
DISUB_PSPNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC8(0) Assigned to domainABPSPPS_POSNR
DISUB_KUNNRCustomer NumberKUNNRCHAR10(0) ALPHAKUNNRKUNC_KUNNRKUNNR
DISUB_VBELNSales and Distribution Document NumberVBELNCHAR10(0) ALPHAVBELNAUN
DISUB_POSNRItem number of the SD documentPOSNRNUMC6(0) Assigned to domainPOSNR
DISUB_OWNEROwner of stockOWNER_DCHAR10(0) Assigned to domainALPHALIFNR
PSTYPItem category in purchasing documentPSTYPCHAR1(0) Assigned to domainPSTYP




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!