on 06-14-2007 4:52 PM
Hi All.
What is the best way to deal with local currency in demand planning?
In my scenario, the client requires to adjust demand plan based on a forecast valuation versus budget in <u></u>local currency<u></u>. i.e., Sweden in SEK, UK in GBP
Thanks for any advice, tips or hard messages.
Mark.
Mark
There is a macro function called CURR_CONV_FAC() that you can try to use to calculate the conversion into a new KF
CURR_CONV_FAC( 'source currency' ; 'target currency' ; 'exchange rate type' ; DATE ) returns the currency conversion factor for the specified source currency, target currency and exchange rate type on the specified date. This date can be TODAY (that is, the system date) or another (see the functions DATE() and TODAY). TODAY is a function, so you do not need to put it in inverted commas. Example: CURR_CONV_FAC( 'USD' ; 'EUR' ; 'M' ; TODAY ).
You need to maintain the currency in the IMG which is checked by the macro. I think there is a macro in the SAP Example Macro book
you can further enhance the macro to use differenct currency based on a check of the USER() or ACT_LOCATION()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harish.
That's excellant, thanks for that, it may well prove to be useful.
There is still a lot of design discussion to be had and I am trying to gather different approaches. Worst case scenario I face is having to load invoice value history in local currency.
Does anyone have experience of using the 0LOC_CURRCY unit of measure for a scenario like this.
Thanks, Mark
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.