Skip to Content

Dis aggregation based on Currency Attribute

Hi Experts,

I have a requirement where I want to enter my ASP Value at Sub family level. when it dis aggregates it should copy values only to the combinations where we have Curr as USD. the challenge is i have my Planning objects for multiple currencies. for ex

PRD A, LOC L1 CUST C1 CURR USD

PRD A, LOC L1, CUST C1 ,CURR EUR

some planning objects are only with EUR and many of them have combinations with USD and EUR.

so now when i need to enter a ASP Value at Sub family level i want it to fall only to the combinations with CURR = USD.

How to achieve that? i am currently storing my ASP as Stored ASP KF and in Seperate KF i am writing IF statement that if my Curr ID = USD, then it should be Stored ASP else NULL. in this case only USD in populated but i have some combination with one Planning object with a non USD currency ,this also becomes NULL. I want to write a condition where in if there are 2 planning obj for 1 product for EUR and USD ,value should only fall to USD and not on EUR. but if i have only one entry with EUR then this should get populated with Stored ASP KF.

Can anybody suggest how can i achieve this condition.

Thanks for the help.

Regards,

Hari

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

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.