Skip to Content
author's profile photo Former Member
Former Member

Consumption Report - Day & monthly

Dear SAP experts,


We need in our plant Consumption & receipt month wise & daily basis material group wise. We tried MC.A , we are not getting separate consumption & Receipt month wise & day wise in T-Code MC.A like MB51.

We required only bellow given elements to get this report.

  1. 1) Material code from - to
  2. 2) Plant from - to
  3. 3) Material group from - to
  4. 4) Movement type from - to
  5. 5) Posting date from – to

Positive reply pls.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Jan 04, 2014 at 10:51 AM

    Hi,

    Did you try MB5B? I think this will satisfy your requirements.

    Regards,

    Sudeep.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 04, 2014 at 11:19 AM

    Hi,

    If you want the consumption / receipt & Issues with movement type, MB51 is the best report. As of my knowledge, there is no other similar standard report. You may develop custom report if the requirement cant full fill by MB51.

    If you want based on movement type, then you have to refer MSEG & MKPF tables.

    If you are maintaining forecasting view with period indicator as date/week/month, then you can get the corresponding consumption data from MVER table, but not with movement types. MVER will be updated with period indicator in material master and the consumption indicator in movement type.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 04, 2014 at 12:38 PM

    Hi,

    Check with following t.codes:

    S_P00_07000139

    MCRE

    MCRX

    MC45

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 04, 2014 at 10:57 AM

    Hi Mr.Alagan ;

    Can you check this path?

    *Go to SE16

    *Table MVER

    *Select your period indicator

    *Run

    I can report consumptions based on Daily etc.

    Regards.

    M.Ozgur Unal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 11:18 AM

    Hi,

    Reports are available as MB5B,MC.9,S_P00_07000139 etc. You can get detail day wise/monthwise receipts & consumption.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      You can find out the material consumption report through MB51 transaction code such as :

      1. Material : from XXXXXXX to XXXXXXX

      2. Plant : XXXXX

      3. Storage location : XXXXX

      4. Mvt Type : 261-262

      5. Posting date : XX.XX.XXX to XX.XX.XXX

      I hope you understand.

      Regards,

      Santosh Sharma

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.