Skip to Content
avatar image
Former Member

Query on using MC40 report.

Dear All,

I was going through the MC40 report.

I have a query regarding the output of MC40 report.

When I run MC40 I understand that based on the past usage of the material ABC curve will be computed.

After viewing the output ,when we click on double - line ,it shows us the consumption quantity and value.

Can any one of you please explain on how(logic for computing) this consumption quantity is calculated.??

It would be of great help.

Value is anways (quantity* price in material master).

Thanks in Advance,

Sowmya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Nov 02, 2015 at 09:36 AM

    Hi Jurgen,

    Thanks for the SAP note.It was quite helpful.

    I have taken a test material for a plant and tested MC40 with various number of days:

    For ex:

    My list of Relevant Entries for Consumption were :

    Mov. type     Posting Date     Quantity

    201               02.11.2015          3

    201               31.10.2015          5

    201               26.10.2015          1

    201               01.10.2015          1

    601                09.09.2015          5

    When I give the number of days as 0 then the quantity shown when we click on double analysis is : 3

    When I give the number of days as 1 then the quantity shown when we click on double analysis is : 3

    When I give the number of days as 2 then the quantity shown when we click on double analysis is : 10

    When I give the number of days as 35 then the quantity shown when we click on double analysis is : 15

    Can any one please explain the logic for this,it would be of great help.

    Thanks and Regards,

    Sowmya Varanasy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jürgen Lins

      Hey Jurgen,

      Wow.Thanks a lot for your valuable inputs .

      I missed this link regarding period indicator in MRP3 view.

      So that means if I want for day to day basis, the fiscal year variant has to be configured for 365 days. 😊 which is practically not used ,only then we can see the consumed quantity on day to day basis.

      Thanks a lot once again.

      Regards,

      Sowmya Varanasy

  • Oct 26, 2015 at 01:15 PM

    Hi, Generally there are two types of consumptions . Planned and unplanned .system will fetch the moments happened in that period and finds whather they are defined as consumption based upon the consunption indicator set in the moment type definition and gives the consumption values qty * value .


    CONS.jpg (12.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 05:45 AM

    Hi Jurgen,

    The user wants to check for an existing material.

    I have gone to MSEG to indentify the relevant movements.

    List of movements included : 383,315,601,301,453,657,343,962.

    For consumption : I considered movement types 601,657 and 201.

    Even now if I can check total consumed quantity it is not matching with one showed in MC40.

    Is there anything that I am missing.

    Regards,

    Sowmya Varanasy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 10:28 AM

    Can any one please advice.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 11:44 AM

    Hi Sowmya,

    It can be calculated through i.e., annual demand*unit cost = Total Consumption Quality

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi sowmya,

      I am given here annual consumption value is calculated annual demand * unit cost. Normally it was identified by the supplying manager in the inventory.

      Normally, Steps as follows:

      1. To find out unit cost and the usage of each material over a given period of time.

      2. we have to multiply the unit cost by estimated annual usage to obtain the net value.

      3. finally, we list out all the items and arrange them in descending value( Annual value).

      4. Accumulate value and add up no. of items and calculated percentage on total inventory in        value and in number.

      in above the ways be the logic behind it.

      Thanks,

      Vivek

  • avatar image
    Former Member
    Oct 28, 2015 at 12:01 PM

    Hi Jurgen,

    I will go through the note and get back to you.

    Thanks a lot for your support.

    Regards,

    Sowmya Varanasy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 08:29 AM

    No Mallinath, I haven't checked that field.

    Add comment
    10|10000 characters needed characters exceeded