Skip to Content

Report the monthly for material current requirements/stock

Jan 18 at 06:42 PM


avatar image
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, 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..??

mcbz1.jpg (79.3 kB)
mcbz2.jpg (81.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jürgen L
Jan 18 at 08:30 PM

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.

10 |10000 characters needed characters left characters exceeded
Nic Teunckens Jan 18 at 08:08 PM

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 :

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 ...

10 |10000 characters needed characters left characters exceeded