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

Stock report based on stock type with a storage location

Is there a standard SAP report that will give me the stock information based on the storage location and stock type (unrestricted, QI, blocked, etc?)...for instance if I want to find all QI stock in a certain plant/storage location? I want it to show a list of materials and their quantities, not on an individual basis as in MMBE.

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2008 at 09:14 PM

    MB52,MB5B,MB5T,MBBS

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2008 at 09:22 PM

    Thanks for your response. Unfortunately none of those reports are really what we're looking for. I need a report that has the stock type (QI stock, unrestricted, etc) as a selection parameter, so if I only want to see the materials that are in QI stock I can select where the field is not equal to blank. Does that make sense?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2008 at 09:30 PM

    Those won't work either because they are reports for material documents, not for material stock.

    Maybe I'm not explaining this well. What I really need is a report that includes the QI stock field (MARD-INSME) as a selection parameter. Does this report exist or will I have to write something?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2008 at 09:33 PM

    I was trying to find a canned report but if one doesn't exist I'll just create an ABAP program since my user's want the output emailed to them.

    Thanks again.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2008 at 12:28 PM

    Thanks again for your response. I've used your last mentioned method before but with MMBE you have to enter a material number. We want a report of all materials in a particular stock type.

    I was able to achieve this by goign to MB52 and setting up a filter on a layout. My users can now select that filter on the selection screen to get the desired result.

    Thanks again for you attempts to help!

    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.