Inventory Consumption/usage calculation in BI for cube 0IC_C03

[former_member690359]

What is the standard SAP formula for Inventory usage or consumption in BI? How is in calculated using the key figures provided in the standard business content cube Material Stocks / Movements (0IC_C03)? We were using the old version of an inventory cube Material movements: Plant and periodical plant stocks(0IC_C01) to track usage and turnover but that cube is now obsolete.

[former_member690359]

Thanks Henri and Suresh. Both your answers were very helpful and put us in the right direction. We ended up using the 2LIS_03_S196 data source for the 4 key figures needed.

[Former Member]

Dear Susane,

Can you tell me how you got the key figure for inventory consumption .

thanks

[former_member690359]

We never found a way to track consumption in the new versions of the inventory cube and have maintained the cube in the 3.5 versions on a 7.0 server.  The consumption values are found in the 2LIS_03_S196 data source which is no longer supported in SAP

[former_member690359]

Thanks! We'll try this out and let you know our results.

[Former Member]

none

Edited by: montagnier henri on Oct 27, 2011 5:44 AM

[former_member690359]

Hi,

The problem arises from the fact that there doesn't seem to be any values provided in the data source that address usage the way there were in the old cube, so it seems there is nothing to work with in attempting to build a report to track usage. We used to have Total quantity consumed and Total value consumed. Those or anything like those are missing. The only key figured that addresses consumption is the Vendor consignment stock consumption which represents an extremely small portion of usage for us.

[former_member197610]

Susan,

We are using Movement types 921 and 922 .

Since there is no standard KF we can use a custom one to define it in BW and restrict with these movement types.

Hope this helps.

Edited by: suresh on Sep 22, 2011 9:10 PM

[former_member197610]

Susan,

You can get the usage/consumption by,

Create a RKF with movement type = 921 & stocktype = A ie unrestricted stock on total stock.

Hope this helps....

[Former Member]

Hi Susan,

The word consumption is defined widely in Inventory module according to the Business practice. First check with the Functional Team what are they looking in consumption like are they looking for vendor consignment consumtion or any other values? this would be easier to you to understand what relevant Kefigures are to be used for this formula.

Regards,

Geeta