Skip to Content
Jan 27, 2020 at 01:41 PM

Material quantity calculation for component


We have a requirement where the component values are calculated in excel and then process order values are changed.

Business wants to explore the use of Material quantity calculation option in SAP

The calculations for components are as below,

{new MAT1 qty} = {original MAT1 qty} * 75/{batch characteristic for MAT1}

{new MAT2 qty} = {original MAT2 qty} * {batch characteristic for MAT1}/75

Here the factor 75 is derived by business from trial and error method over period of time

The concern here is system does not allow to assign formula to a material itself in MQC

Please share insights if anybody has encountered such scenario