Skip to Content

Calculation of Annual Total Stock Turn Value (MC.9 field) from S031 & s032 tables in SAP

Hi,

Our requirement is to create mc.9 report in BI. We have loaded s031 & s032 tables into HANA & are currently looking for calculation of average stock; annual total stock turn values.
I am not exactly sure what fields to used to those calculations.

I read many articles about inventory turnovers and the formula for inentory turnover of a particular stock is:

total usage / average stock.

Total usage would be WGVBR field in S031, how do i get average stock?


Thank you,
Shravya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 15, 2016 at 12:52 PM

    Hi ,

    You have to benefit from 0IC_C03 cube in BW side.. You can calculate avarage ***** what you want with formulas ...

    This thread must be discussed in BW Community..

    Regards.

    M.Ozgur Unal

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2016 at 01:31 PM

    Thank you! Posted in BW space, but we are aiming for HANA models

    Add comment
    10|10000 characters needed characters exceeded