cancel
Showing results for 
Search instead for 
Did you mean: 

Stock Productivity Index report

Former Member
0 Kudos


Hi,

To better manage our Inventory, we are required to report the Stock Productivity Index (SPI).

I'm sure there is no standard that will report the SPI.

Fomula to calculate the Stock Productivity Index= Gross Profit margin * Stockturn

I can calculate the Gross profit margin, as we already have a report that does this.

I just need to get the Stock turn for every material per plant.

I'm so lost when it comes to the logic behind calculation of Stock Turn.

I know the Inventory Turnover value= Total usage value/ Mean valuated stock value.

Apparently, I have seen the LIS reports for Stock turns. MCBC, MC.B etc.

I can get the Total usage value in Info structure S031.

The trick is when it comes to the logic for Mean valuated stock value.

I have seen the formula for Avg. valuated stock as: Value of beginning stock + n value of stock at month's end

                                                                                                                  n + 1

When debugged MCBC, I can understand how the      Value of beginning stock is being calculated- I could marry up to MB5B  beginning stock value (per the right selection under Category), but somehow cannot marry up the Clposing stock at month's end to apply  the logic in our custom program. Can the closing balance, for a given time period (say 01.2013 to 12.2013) be otained or rather compared with MB5B or likes??

Will anyone be able to pitch in and shed some light here?

I'm sure there will be heaps of businesses that has required to come uo with such a report..

Really looking forward to prompt replies.

Regards,

Shilpa

Phew, looks like no one has ever aske about such a report!

Accepted Solutions (1)

Accepted Solutions (1)

Prasoon
Active Contributor
0 Kudos

Hi,

   I hope you are able to track the opening stock for a period. If you get the opening stock, you can find the closing stock as = Opening stock + Total Receipt in the period - Total Goods Issue in the period.

The details can be obtained from S031 table.

Valuated stock receipts (Qty) : S031 - MZUBB

Valuated Stock receipts Value : S031 - WZUBB

Valuated Stock Issue Qty : S031 - MAGBB

Valuated stock Issues Value : S031 -WAGBB

   If it it include multiple periods, then you have to take the sum of stock receipt or issues for that period interval.

   So inorder to find the closing stock for a period, you may use the logic as :

Closing stock qty = opening stock qty + (S031 - MZUBB) - (S031 - MAGBB)

Closing stock value = Opening stock val + (S031 - WZUBB) - (S031 -WAGBB)

   You may consider consignment stock also if required.

You may refer the FM logic also: Copy of Opening and closing stock on a date - Code Gallery - SCN Wiki

Regards,

AKPT

Former Member
0 Kudos

That was super quick- Thanks for the info...

I will sit with my ABAPer and try this logic out.

If I were to get the Opening balance, say if I am running the report for 01.2013 -12.2013, can you give the logic for Opening balance calculation as well?

Just to match our logic (what we have arrived at, based on debugging the MCBC program).

Thanks,

Shilpa

Prasoon
Active Contributor
0 Kudos

Hi,

   The opening stock of 01.2013 is nothing but the closing stock of 12.2012. You may use the same logic to find the closing stock of 12.2012, which will be the opening stock of 01.2013.

Regards,

AKPT

ajitkumar
Active Contributor
0 Kudos

If you want from the main tables the you get the opening stock value from MBEWH and stk from Mardh

if it is 0113 ( when the period is not current) , it should be the value in MBEWH for 1212 or the last earlier period which has an entry in the table; if you dont find any value in MBEWH then it is the value in mbew

Answers (0)