ScmPrd_Mdma_Mdlv

Join of MDMA and MDLV | view: SCMPRDMDMAMDLV | Extraction: Not supported | Component: Product

Tables used: MDLV, MDMA

🔑 Keys
💰 Amounts (1)
∑ Quantities (14)
📅 Dates (1)
☰ Categorical (12)
Other (21)
🔗 Relations (18)

Column Name	Description

Column Name	Description
losfx	Lot-Size-Independent Costs

Column Name	Description
minbe	Reorder Point
bstrf	Rounding value for purchase order quantity
bstmi	Minimum Lot Size
bstma	Maximum Lot Size
mabst	Maximum Stock Level
eisbe	Safety Stock
bstfe	Fixed lot size
scm_safty_v	Safety Stock for Virtual Child Location
scm_ppsaftystk	Safety Stock at Parent Location
scm_ppsaftystk_v	Safety Stock of Parent Location Virtual Child Location
scm_repsafty	Repair Safety Stock
scm_repsafty_v	Repair Safety Stock for Virtual Child Location
scm_reord_v	Reorder Point for Virtual Child Location
scm_maxstock_v	Maximum Stock Level for Virtual Child Locations

Column Name	Description
vrbdt	To date of the material to be copied for consumption

Column Name	Description
loekz	Deletion Indicator	Show values
ahdis	MRP relevancy for dependent requirements	Show values
autru	Reset Forecast Model Automatically	Show values
kzkfk	Indicator: take correction factors into account	Show values
shflg	Safety time indicator (with or without safety time)	Show values
apokz	Indicator: Is material relevant for APO	Show values
plifzx	Consider Planned Delivery Time of the MRP Area	Show values
scm_tpop	Third-Party Order Processing	Show values
period_factor_value	Period Factor for Calculating the Availability Date/Time	Show values
use_period_factor	Use Period Factor	Show values
target_stock_level_meth	Target Stock Level Method	Show values
period_factor_tds	Period factor Time dependent Stock Levels	Show values

Column Name	Description	Domain name
fxhor	Planning time fence	FXHOR
takzt	Takt time	DEC3
ausss	Assembly scrap in percent	DEC3_2
shzet	Safety Time (in Workdays)	NUMC2
lgrad	Service level	DEC2_1
propr	Forecast profile	PROPR
vrbmt	Reference material for consumption	MATNR
vrbdb	Reference MRP area - consumption	BERID
vrbfk	Multiplier for reference material for consumption	DEC2_2
pstat	Maintenance status	PSTAT
plifz	Planned Delivery Time in Days	DEC3
scm_matlocid_guid22	Internal Number (UID) for Location Product	/SAPAPO/MATLOCID
scm_reord_dur	Reorder Days' Supply (in Workdays)	TSTRDURAG
scm_target_dur	Target Days' Supply in Workdays	TSTRDURAG
scm_tstrid	Planning Calendar for Periodic Lot Sizing Procedure	/SAPAPO/TSTRID
scm_rrp_sel_group	Planning Group
scm_thruput_time	Throughput Time	TSTRDURAG
scm_scost_prcnt	Cost Factor for Stockholding Costs	/SAPAPO/PERCENT_SCOST
scm_proc_cost	Procurement Costs for Product	/SAPAPO/DEC13
scm_ndcostwe	Goods Receiving Costs
scm_ndcostwa	Goods Issue Costs

Master Data Relations	Join Conditions
MRP area ID MRP Area Client	`SCMPRD_MDMA_MDLV.BERID == MDLV.BERID` `SCMPRD_MDMA_MDLV.MANDT == MDLV.MANDT`
MRP Group MRP Group MRP Area: Plant Client	`SCMPRD_MDMA_MDLV.DISGR == T438M.MTART` `SCMPRD_MDMA_MDLV.WERKS == T438M.WERKS` `SCMPRD_MDMA_MDLV.MANDT == T438M.MANDT`
Lot Sizing Procedure within Materials Planning Lot Sizing Procedure within Materials Planning Client	`SCMPRD_MDMA_MDLV.DISLS == T439A.DISLS` `SCMPRD_MDMA_MDLV.MANDT == T439A.MANDT`
MRP Type MRP Type Client	`SCMPRD_MDMA_MDLV.DISMM == T438A.DISMM` `SCMPRD_MDMA_MDLV.MANDT == T438A.MANDT`
MRP Controller MRP Controller MRP Area: Plant Client	`SCMPRD_MDMA_MDLV.DISPO == T024D.DISPO` `SCMPRD_MDMA_MDLV.WERKS == T024D.WERKS` `SCMPRD_MDMA_MDLV.MANDT == T024D.MANDT`
Material: MRP profile Material: MRP profile Client	`SCMPRD_MDMA_MDLV.DISPR == MDIP.DISPR` `SCMPRD_MDMA_MDLV.MANDT == MDIP.MANDT`
Storage costs percentage MRP Area: Plant Storage Costs Percentage Code Client	`SCMPRD_MDMA_MDLV.WERKS == T439L.WERKS` `SCMPRD_MDMA_MDLV.LAGPR == T439L.LAGPR` `SCMPRD_MDMA_MDLV.MANDT == T439L.MANDT`
Planning Cycle Planning Cycle MRP Area: Plant Client	`SCMPRD_MDMA_MDLV.LFRHY == T439G.MRPPP` `SCMPRD_MDMA_MDLV.WERKS == T439G.WERKS` `SCMPRD_MDMA_MDLV.MANDT == T439G.MANDT`
Default storage location for external procurement MRP Area: Plant MRP Area Default storage location for external procurement Client	`SCMPRD_MDMA_MDLV.WERKS == MDLG.WERKS` `SCMPRD_MDMA_MDLV.BERID == MDLG.BERID` `SCMPRD_MDMA_MDLV.LGFSB == MDLG.LGORT` `SCMPRD_MDMA_MDLV.MANDT == MDLG.MANDT`
Production storage location MRP Area: Plant MRP Area Issue Storage Location Client	`SCMPRD_MDMA_MDLV.WERKS == MDLG.WERKS` `SCMPRD_MDMA_MDLV.BERID == MDLG.BERID` `SCMPRD_MDMA_MDLV.LGPRO == MDLG.LGORT` `SCMPRD_MDMA_MDLV.MANDT == MDLG.MANDT`
Material Number Client Material Number	`SCMPRD_MDMA_MDLV.MANDT == MARA.MANDT` `SCMPRD_MDMA_MDLV.MATNR == MARA.MATNR`
PPC Planning Calendar MRP Area: Plant PPC Planning Calendar Client	`SCMPRD_MDMA_MDLV.WERKS == T439G.WERKS` `SCMPRD_MDMA_MDLV.MRPPP == T439G.MRPPP` `SCMPRD_MDMA_MDLV.MANDT == T439G.MANDT`
Rounding Profile ? ? Client Rounding Profile	`SCMPRD_MDMA_MDLV.[column in domain "RDZAE"] == RDPR.RDZAE` `SCMPRD_MDMA_MDLV.[column in domain "WERKS_D"] == RDPR.WERKS` `SCMPRD_MDMA_MDLV.MANDT == RDPR.MANDT` `SCMPRD_MDMA_MDLV.RDPRF == RDPR.RDPRF`
Range of coverage profile MRP Area: Plant Range of coverage profile Client	`SCMPRD_MDMA_MDLV.WERKS == T438R.WERKS` `SCMPRD_MDMA_MDLV.RWPRO == T438R.RWPRO` `SCMPRD_MDMA_MDLV.MANDT == T438R.MANDT`
Period Profile for Safety Time MRP Area: Plant Period Profile for Safety Time Client	`SCMPRD_MDMA_MDLV.WERKS == T438V.WERKS` `SCMPRD_MDMA_MDLV.SHPRO == T438V.SHPRO` `SCMPRD_MDMA_MDLV.MANDT == T438V.MANDT`
Special procurement type Special procurement type MRP Area: Plant Client	`SCMPRD_MDMA_MDLV.SOBSL == T460A.SOBSL` `SCMPRD_MDMA_MDLV.WERKS == T460A.WERKS` `SCMPRD_MDMA_MDLV.MANDT == T460A.MANDT`
MRP Area: Plant MRP Area: Plant Client	`SCMPRD_MDMA_MDLV.WERKS == T001W.WERKS` `SCMPRD_MDMA_MDLV.MANDT == T001W.MANDT`
Plant Plant Client	`SCMPRD_MDMA_MDLV.WERZG == T001W.WERKS` `SCMPRD_MDMA_MDLV.MANDT == T001W.MANDT`