ABC Analysis from transaction MC40 - Qty field

[Former Member]

Hi All,

I recently got to know about MC40 and i dont understand some areas of it.

After executing MC40, i will get the list of materials sorted already for A, B , and C.

However, when i click on double line, it then shows me Qty field as well. Now when i look at this quantity field, i dont understand where system is getting it or how!

When i check MB51, the quantity system proposed does not equal to the total consumption, total receipt, or the difference between both.

I also noticed that if i increase the number of days for analysis, the quantity increases.

Please can somebody tell me the formula SAP is using to get the Quantity here.

Much appreciated.

[Former Member]

This message was moderated.

[Former Member]

Hi,

Im still not getting a clear picture.

From that forum post, it is just explaining which field is related to MIBC (CC phys inv ind) and MC40 (ABC Indicator).

What im wondering is, now in MC40, i inserted a whole bunch of materials and also the number of days.

When i check the results in double line, the quantity that SAP proposes is very weird. I cannot seem to find it anywhere. I checked previous consumption, totaled it up and it still does not come to that figure.

Someone please explain to me how SAP is calculating the Quantity field in MC40 output.

[JL23]

SAP reads all consumption movements from MSEG table for the given number of days

[Former Member]

Hi,

Thank you for your feedback.

It is true that the quantity equals to quantity in MSEG. However, this does not apply to all materials.

Some materials, the quantity in MC40 is larger than the one shown in MSEG. Im very confused as to how this is possible. I noticed that it increases as my "Period to analyze - number of days" increases. Sometimes, the figures proposed does not equal to total consumption figure in MSEG also.

E.g. proposed by MC40 = 544 quantity.

But in MSEG, total consumption = 458 quantity.

[JL23]

But in MSEG, total consumption = 458 quantity.

how did you determine the total consumption in MSEG? maybe SAP uses a different logic than you. What movements did you exclude?

[Former Member]

Hi Jurgen,

Thank you very much for your reply.

I did another round of checking today to get an answer for your post, and i realized that my calculation included reversal documents as well. This was why there were discrepancies in the results.

Thanks again. It is fine now.

[Former Member]

hi

check the above link.It is already answered.

Regards

Antony