Available Stock status (MM) - which table should I take and what are the fields ??

[Former Member]

Kindly Suggest Me !!!

Report that outputs stock, grouped by Material type and Plant. The output shows Material no, Storage location, unit of measure and description in addition to group table using ALV.

Thanks in adv.

Bunty ( New to SAP )

[mwallace · Accepted solution]

Hi Bunty

Does MC.5 suit your requirements?  You can adjust the layout of the report once you have run it.

Michael

[Former Member · Accepted solution]

Hello Mr.Wallace,

Thanks for ur valuable answer . It almost suits my requirements ; but can you tell me which fields are for STOCK and UNIT OF MEASURE ???!!!

Rgds,

Bunty

[mwallace · Accepted solution]

Hello Bunty

When you run the report put in current month in date fields, then when you are in the report you can add the different fields you need.

At the top there is a button called 'Switch Drilldown', this enables you to view by Material Type etc. Fourth from the right is another button that looks like the standard variant button, here you can add or remove different figures for valuing the stock.

Don't forget that this report views periods so you can use average stock etc by changing the month.  Also make sure that any stock reports you are using reconcile with each other.

Michael