SAP Standard Report for Stock Balances

[Former Member]

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

[JL23 · Accepted solution]

Have a look into MB5L

[Former Member]

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

[Former Member]

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