PPH_DD_MAT_CTRL_0

DD Materials | view: V_PPH_DD_MAT_C0 | Extraction: Not supported | Component: Material Requirements Planning

Tables used: PPH_DBVM, MARA, MDMA, T438A, MARA, T460A, T460A, MARA, MARC, MDLV, MDMA, MARC, SDM_AOR

🔑 Keys (3)
💰 Amounts
∑ Quantities (2)
📅 Dates
☰ Categorical (10)
Other (15)
🔗 Relations (13)

Column Name	Description
matnr	Material Number
werks	Plant
berid	MRP Area

Column Name	Description

Column Name	Description
marc_mabst	Maximum Stock Level
mdma_mabst	Maximum Stock Level

Column Name	Description

Column Name	Description
berty	Type of MRP Area	Show values
loekz	Deletion Indicator	Show values
plifzx	Consider Planned Delivery Time of the MRP Area	Show values
beskz	Procurement Type	Show values
attyp	Material Category	Show values
miskz	Mixed MRP indicator	Show values
marc_ahdis	MRP relevancy for dependent requirements	Show values
mdma_ahdis	MRP relevancy for dependent requirements	Show values
marc_shflg	Safety time indicator (with or without safety time)	Show values
mdma_shflg	Safety time indicator (with or without safety time)	Show values

Column Name	Description	Domain name
mdma_eisbe	null
marc_eisbe	null
wzeit	Total replenishment lead time (in workdays)	DEC3
mdma_plifz	Planned Delivery Time in Days	DEC3
marc_plifz	Planned Delivery Time in Days	DEC3
dzeit	In-house production time	DEC3
t460a_def_u_sobsl	null
t460a_def_b_sobsl	null
webaz	Goods receipt processing time in days	DEC3
marc_shzet	Safety Time (in Workdays)	NUMC2
mdma_shzet	Safety Time (in Workdays)	NUMC2
marc_minbe	null
mdma_minbe	null
disgr_marc	MRP Group	DISGR
kzaus	null

Master Data Relations	Join Conditions
Material Requirements Planning (MRP) Group Plant MRP Group MRP Group Client	`PPH_DD_MAT_CTRL_0.WERKS == T438M.WERKS` `PPH_DD_MAT_CTRL_0.MARC_DISGR == T438M.MTART` `PPH_DD_MAT_CTRL_0.MDMA_DISGR == T438M.MTART` `PPH_DD_MAT_CTRL_0.MANDT == T438M.MANDT`
MRP type MRP Type MRP Type Client	`PPH_DD_MAT_CTRL_0.MARC_DISMM == T438A.DISMM` `PPH_DD_MAT_CTRL_0.MDMA_DISMM == T438A.DISMM` `PPH_DD_MAT_CTRL_0.MANDT == T438A.MANDT`
MRP controller MRP Controller MRP Controller Plant Client	`PPH_DD_MAT_CTRL_0.MDMA_DISPO == T024D.DISPO` `PPH_DD_MAT_CTRL_0.MARC_DISPO == T024D.DISPO` `PPH_DD_MAT_CTRL_0.WERKS == T024D.WERKS` `PPH_DD_MAT_CTRL_0.MANDT == T024D.MANDT`
Period Profile for Safety Time Period Profile for Safety Time Period Profile for Safety Time Plant Client	`PPH_DD_MAT_CTRL_0.MDMA_SHPRO == T438V.SHPRO` `PPH_DD_MAT_CTRL_0.MARC_SHPRO == T438V.SHPRO` `PPH_DD_MAT_CTRL_0.WERKS == T438V.WERKS` `PPH_DD_MAT_CTRL_0.MANDT == T438V.MANDT`
Special procurement key Special procurement type ? Special procurement type ? Plant Client	`PPH_DD_MAT_CTRL_0.MDMA_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.T460A_DEF_U_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.MARC_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.T460A_DEF_B_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.WERKS == T460A.WERKS` `PPH_DD_MAT_CTRL_0.MANDT == T460A.MANDT`
Material Group Material Group Client	`PPH_DD_MAT_CTRL_0.MATKL == T023.MATKL` `PPH_DD_MAT_CTRL_0.MANDT == T023.MANDT`
MRP Group Plant MRP Group MRP Group Client	`PPH_DD_MAT_CTRL_0.WERKS == T438M.WERKS` `PPH_DD_MAT_CTRL_0.MARC_DISGR == T438M.MTART` `PPH_DD_MAT_CTRL_0.MDMA_DISGR == T438M.MTART` `PPH_DD_MAT_CTRL_0.MANDT == T438M.MANDT`
MRP Type MRP Type MRP Type Client	`PPH_DD_MAT_CTRL_0.MARC_DISMM == T438A.DISMM` `PPH_DD_MAT_CTRL_0.MDMA_DISMM == T438A.DISMM` `PPH_DD_MAT_CTRL_0.MANDT == T438A.MANDT`
MRP Controller MRP Controller MRP Controller Plant Client	`PPH_DD_MAT_CTRL_0.MDMA_DISPO == T024D.DISPO` `PPH_DD_MAT_CTRL_0.MARC_DISPO == T024D.DISPO` `PPH_DD_MAT_CTRL_0.WERKS == T024D.WERKS` `PPH_DD_MAT_CTRL_0.MANDT == T024D.MANDT`
Period Profile for Safety Time Period Profile for Safety Time Period Profile for Safety Time Plant Client	`PPH_DD_MAT_CTRL_0.MDMA_SHPRO == T438V.SHPRO` `PPH_DD_MAT_CTRL_0.MARC_SHPRO == T438V.SHPRO` `PPH_DD_MAT_CTRL_0.WERKS == T438V.WERKS` `PPH_DD_MAT_CTRL_0.MANDT == T438V.MANDT`
Special procurement type Special procurement type ? Special procurement type ? Plant Client	`PPH_DD_MAT_CTRL_0.MDMA_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.T460A_DEF_U_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.MARC_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.T460A_DEF_B_SOBSL == T460A.SOBSL` `PPH_DD_MAT_CTRL_0.WERKS == T460A.WERKS` `PPH_DD_MAT_CTRL_0.MANDT == T460A.MANDT`
Unit of Measure Client Base Unit of Measure	`PPH_DD_MAT_CTRL_0.MANDT == T006.MANDT` `PPH_DD_MAT_CTRL_0.MEINS == T006.MSEHI`
Material type Material type Client	`PPH_DD_MAT_CTRL_0.MTART == T134.MTART` `PPH_DD_MAT_CTRL_0.MANDT == T134.MANDT`