SNP function in Macro

[Former Member]

Hi Everybody,

Can anybody explain the logic behind the SNP function COVER_CALC() .

Regards,

[Former Member · Accepted solution]

Hi,

The function COVER_CALC() is mainly used in calculating the actual day's supply.

For example :

1).Step: Days Supply (from initial to end of horizon)

2).Row u2018Actual Days Supplyu2019 = Cover_Calc (stock on hand, demand, workdays)

(This function returns the no. of days the stock can last based on the current stock levels and future demand)

For more detail you can see the link :

http://help.sap.com/saphelp_scm50/helpdata/en/17/a5216532a111d398260000e8a49608/frameset.htm

Regards,

Prabhu

[Former Member]

Hi,

COVER_CALC() returns the actual number of days of supply you have in any bucket based on the demand in preceeding buckets. It basically checks how much stock is available in hand and based on that it sees that how many days demand can be satisfied by that stock on hand.

Consider this

Week1 Week2 Week3 Week4 Week5

Tot Dmnd 20 30 40 50 10

Stock on Hand 70 40 60 10

Days Supply 14 7 14 7

The days supply for week 1 is calculated as the stock on hand is 70. It can satisfy the demand for the next 2 weeks (Week2 Week3) (3040). Similar logic applies to the rest of the buckets.

The argument to this function is the Stock on Hand and Total Demand Key figures.

Refer to help.sap.com for further details.

Hope this completely answers your query.

Regards,

Abhi