Report the monthly for material current requirements/stock

[Former Member]

Hi gurus,

I am trying to create a report in MCBZ for a list of materials. where I want the stock to displayed month wise bucket. ( like Jan, feb, March.....so on till December), but when i select the drill-down as month wise, its adding up all the list quantities and showing as one figure for one month. Please help. Is there any other tcode for this..??

[JL23]

I don't really see any thing wrong. If you have in January 158827 EA and no new receipt and no issue from January to December then you have each month a stock of 158827 EA

And as we have just 01/2018, it is clear that you have no other total for the months from January to June 2018.

[NTeunckens]

First off, a Valuable Reference is this Blog "Material Stock and Valuation History tables – how to read them" : link

Some Standard Trx. you could use :

• MB5L
• MB5B (info on this Report and Difference with MRN9 in SAP-KBA 2313756)
• MC.9
• MRN9 (info on this Report in SAP-KBA 590699)
• ...

If this does not Provide your Desired Result, check whether you can use the LIS-Structures to get your values as SAPQuery (trx. "SQVI") => See SAP-KBA 512416 on tables "S032" "S031" "S035" (Current and Past Stock) and the like ...

Finally, you could develop a Custom Report using the Logic mentioned in SAP-KBA 193554 and SAP-KBA 415349 ...