Stock report

[Former Member]

Hello everyone,

We need to get from the system a detailed stock report - material, plant/storage location, bins, quantities and type of stock (unrestriucted, in QC, scheduled for delivery etc), units of measure (we have bulk so kg/lbs as well as warehouse managed locations - drums and other pack sizes), and if possible the unit cost cost and value also.

Is there any standard report or logical database that can be queried for this? If not, what tables would be needed?

Many thanks.

[former_member218067 · Accepted solution]

Hi Yogesh,

There is no standard report available as such

You can querry tables MARD and MBEW which should fulfill your requirement

BR

Diwakar

reward if useful

[Former Member]

Dear Yogesh

You can get this by standard report. Transaction code MB52. go to change layout and change your column accordingly.

Pl reward if Useful.

Shobana

[Former Member]

Hello,

I suppose LX03 is your fried except the values for the stock.

Call it an hit the button "Current layout" there you can see all the additional fields you can put into the resultset.

If the values arer necessarily needed, I would go for an ABAP report.

If this was helpful, please contibure

Best regards

Uwe Neumann