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

SAP Standard Report for Stock Balances

Hi All,

Do we have a standard SAP report that gives the output in this format (or something close to this)

Date Stock Plant 1 Plant 2

Material 1 Material 2 Material 3 Material 1 Material 2 Material 3

1/1/2008 Opening Stock

GR

GI

Closing Stock

1/2/2008 Opening Stock

GR

GI

Closing Stock

1/3/2008 Opening Stock

GR

GI

Closing Stock

Regards

Tom

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 29, 2008 at 08:57 PM

    Have a look into MB5L

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:32 PM

    Use MB5B with selection date format of day format than you will get the report you are looking

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:39 PM

    Hi Jack,

    As per your report requirement, there is no standard transaction available in SAP.

    You have develop Z- Report for your requirement.

    But keeping in mind the follwoing constarints

    1) If it is a huge number of materials, Then the report will hours together. It may be lead to performance issue of the System. Because it has to get huge data from different tables as per you logic.

    2) The report is not suitable for print. Because it will run pages together.Since you are including Opening balance, GR details, GI details and Closing balance for each materail.

    Thanks & Best Regards

    Girisha M S

    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.