This website is not affiliated with, sponsored by, or approved by SAP AG.

Validation against multiple Local Currencies

All postings related to SEM only

Moderators: Snowy, thx4allthefish

Validation against multiple Local Currencies

Postby TheScotsman » Mon Oct 09, 2006 10:59 am

Hi All,
I want to validate against a constant value in multiple local currencies - can anyone advise / help?

I am loading data to many consolidation units, each has its own Local Currency.

We wish to validate selections of Items to within a limit in local currency, say 10,000.

So if the unit is Dutch, we'd make sure the validation was within 10,000 euros.
If it was Japanese we'd validate to within 10,000 Yen
British to 10,000 GBP, American to 10,000 USD.
etc.

I am aware of how to validate to a fixed value in a fixed currency (eg all validated to 10,000 GBP) by translating in the validation.
However I do not want to translate due to performance impact.

I just want to validate to the absolute value for each unit's currency. However this doesn't seem possible unless you assign a seperate method to each unit (and the nightmare maintenance scenario going forward).

Is there a way to do this?
Please let me know if I can clarify the problem for you.
TheScotsman
 
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London

Postby TheScotsman » Mon Oct 09, 2006 11:52 am

To clarify, we want to do this:
VAL_YTD (Selection) >= 10000

but BCS 4.0 and above requires this:
VAL_YTD (Selection) >= CONST (10000, currency key, rate type)

Is it possible to have the currency key as some sort of variable or user exit that changes according to the Consolidation Unit's own local currency?
(thereby removing any requirement to perform currency translation during the validation).
TheScotsman
 
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London

Postby dans » Tue Oct 10, 2006 6:45 am

Have you tried LC_YTD instead of VAL_YTD?

I think that should work.
dans
 
Posts: 197
Joined: Fri Mar 07, 2003 10:26 am

Postby TheScotsman » Mon Oct 16, 2006 6:53 am

Thanks dans,
This doesn't help, OSS note 870169 explains:

"VAL_YTD (Selection) >= 10,000
A formula of this type can be used up to Release 3.5 but as of Release 4.0, only the following syntax is permitted:
VAL_YTD (Selection) >= CONST (100, currency key, rate type)"

I am investigating other possibilities - will come back if I get something useful.
TheScotsman
 
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London

Postby TheScotsman » Fri Dec 01, 2006 6:06 am

In the end the requirement changed, so we went with a check against 10,000 USD for all Consolidation Units, which makes more sense anyway!
TheScotsman
 
Posts: 102
Joined: Fri Nov 19, 2004 9:32 am
Location: London


Return to SEM

Who is online

Users browsing this forum: No registered users and 1 guest





This website is not affiliated with, sponsored by, or approved by SAP AG.