Skip to Content
avatar image
Former Member

Report the monthly for material current requirements/stock

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

mcbz1.jpg (79.3 kB)
mcbz2.jpg (81.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Add comment
    10|10000 characters needed characters exceeded

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

    Add comment
    10|10000 characters needed characters exceeded