P_Prdscm_Mdma_Mdlv

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

Tables used: MDLV, MDMA

🔑 Keys
💰 Amounts (1)
∑ Quantities (17)
📅 Dates (1)
☰ Categorical (10)
Other (26)
🔗 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_conhap	Handling Capacity Consumption in Unit of Measure (Gds Rcpt)
scm_conhap_out	Handling Capacity Consumption in Unit of Measure (Gds Issue)
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
scm_coninp	Consumption of Storage Capacity per Unit of Material

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
maxdos_flg	Is Max Dos Active	Show values
saftystock_method	Method for Calculating Safety Stock	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_target_dur	Target Days' Supply in Workdays	TSTRDURAG
scm_grprt	Goods Receipt Processing Time	TSTRDURAG
scm_giprt	Goods Issue Processing Time	TSTRDURAG
scm_rrp_type	PP Planning Procedure
scm_heur_id	PPC Heuristics
scm_package_id	Planning Package to Which Product Belongs
scm_reord_dur	Reorder Days' Supply (in Workdays)	TSTRDURAG
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
maxdos_pen	Penalty exceeding time dependent Max Days' of Supply	/SAPAPO/DEC13

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