Hi Felipe,
The reason why it doesn't work is the following:
The Cubes doesn't share the same structure, in this case the multiplanning area in BPS can't provide, for the amount value (who might be access by organisation and product, .....) a currency stored on a different granularity . I had the same challenge few years ago on building distribution function for one of my customer.
We solved the issue by creating an abap function who was more appropriate to execute it properly.
Regards,
Pierre Maurice
| | | ---------------Original Message---------------
From: F_Lopes
Sent: Tuesday, May 03, 2011 4:21 PM
Subject: FOX BPS - Two variable product returns Zero
Hi everyone,
I believe that it might be a very simple problem, but I'm new in BPS and didn't find a way out yet.
I'm using Fox in SAP BPS to obtain a product between amounts from one keyfigure and exchange rates from another.
Each keyfigure is in a different planning area and using Fox operands I can get correct data from both.
Here's the two operands:
TAXA_CALC = {ZK_VALOR,MONTH,#,CURRENCY,ZPEHOTXCAMBIO,USD,VERSIO N,APEOHO13}.
VP_M_LOCAL = {0CS_TRN_LC,MONTH,CURKEY_LC,#,#,#,VERSION,APEOHO06} .
Nevertheless, when I multiply both variables (TAXA_CALC and VP_M_LOCAL), the result is always 0.
I'm using CURRENCY and CURKEY_LC at the FOREACH to get values for the operands, but when I get values for one of them, the other currency is always empty and vice-versa (I realized that while executing with trace), so I think that when the Fox runs the product there is a mismatch between both variables (looks like a problem in the foreach), and at each step at least one of them has zero value.
Anyone has been through that?
Thanks in advance! |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight  _.____.__ |
