Skip to Content
0
Former Member
Nov 30, 2008 at 02:08 PM

Macros

132 Views

Hi Everybody,

Can someone direct to some good document on SNP standard macros- std planning books, std, ss, vmi,cap. I need the syntax and its excel translation for easy comprehension. More the examples merrier it is. I am not much bothered about the business context and config that influence the results of the macros but just to have a broad idea.

needless to say help.com has just nothing on macros- syntax, usage, library functions. In fact sometime back i discovered that days supply macro (COVER_CALC) is incorrectly explained in documentation.

Also if someone can explan the consumption logic syntax in total balance macro in standard planning book, would appreciate.

The requirement is to see reduced forecast fig (same key fig FA thats released from dp) and it shd be consumed by say 4-5 demand categories - sales orders, dependent demand, distr demand planned, confirmed, substitution demand, tlb confirmed and total demand should be = reduced fcst fa + sales orders + dependent demand, distr demand planned, confirmed, tlb confirmed, substitution demand.

How do i set this logic without the need for different key figure say " (un)consumed forecast. It would be a circular referencing else.

what does this syntax mean .DEMAND_CALC(ACT_PRODUCT, ACT_LOCATION, ACT_VERSION) .. this is a line from consumption step. where in help.com is this explained.

what does this mean

DET_LEVEL('9MATNR' ; 'X')=1

well i could write any condition and macro in excel easily but this syntax in sap is cryptic. its nothing more than basic arithmertic but still a lot confusing Let me know how to approach this quickly.

Regards,

Lok