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

Standard report for GR in specific storage location

Hi experts,

Is there any standard report that displays amount produced monthly (GR) by storage location?

I'm trying to extract this information using tcode MB51 with moviment type 101, 102, 131 and 132, (We have discrete and repetitive manufacturing) but there are many data and occurs runtime error.

I also tried MCP5, but it works with material and plant level.

Thanks in advance.

Marcos

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Dec 30, 2013 at 08:19 AM

    Hi Marcos,

    You can use MB51, MB59 with some selection criteria like posting date movement type and Trans./Event Type like WF and WS etc.

    Also you can try the report like MCP8.

    Apart from that you can develop your own report by using standard report RM07DOCS.


    Regards,

    R.Brahmankar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rupesh,

      Thanks for help!

      I tried MCP8 (items produced with Repetitive Manufacturing) and MCRO (items produced with Discrete Production) but both t-codes work with material and plant as selection criteria.

      I created a Query to extract MSEG and performed in background mode with some selection criteria like you said. Then there was a bit of rework but it solved the problem.

      We haven't developed a Z report because it would be used only once.

      Is possible create a report like this using flexible analysis?

      Regards,

      Marcos

  • Posted on Dec 31, 2013 at 06:01 AM

    Dear Marcos,

    Easy way is to generate a Z report😊.

    You can implement below notes.

    To implement the below notes in sequence to optimize MB51 transaction execution.

    1. 1516684--MKPF fields added to MSEG – Performance Optimization

    2. 1550000 --- Redesign of selection for performance optimization

    3. 1558298 MB5B: Redesign of selection for performance optimization

    4. Note 1481757 - MB5B: Access to archived MM documents

    5 Verify data conversion according to note 1516684

    6. 1567602--DB dependent steps to support the redesign of MB51

    We have implemented this in our client system and the advantages are;

    1. MB51 processing time would be reduced further.

    2. Easy to retrieve the data quickly.

    3. Run time errors are prevented for large volume data execution.

    4. If the material documents for the restricted period under review have already been archived, transaction MB5B returns incorrect results before implementation of Note1481757.

    Try this. It will work.

    Success.

    Regards,

    Krish.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2013 at 09:18 AM

    Hi Marcos

    If you wants see the produced materials against storage location and movement type the execute Tcode COOIS in list select the documented goods movement. Then execute by inputs required plants and dates. In the information you can filter by movement type and storage location wise.


    Regards

    Kesava

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 19, 2013 at 12:55 AM

    runtime errors come due to the size of MSEG - usually it is huge

    if you need such report on regular basis talk to abaper, custom one may play the trick...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 19, 2013 at 01:58 AM

    Hi Marcos Favoni,

    Ask your technical team to create a new report with the copy of MB51 and ask them to display the details report directly instead of going header and then detail.

    Then you can execute the report in background.

    Arivazhagan S

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2013 at 05:32 AM

    Dear Marcos,

    If run time error occurs, you can try by executing the report in background.

    In MB51 enter the input details and goto Program --> Execute in Background (F9).

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

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.