Skip to Content
author's profile photo Former Member
Former Member

SNP function in Macro

Hi Everybody,

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

Regards,

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 09:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 10:14 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.