Hi all!
My problem is the following:
We are doing a migration from BPS to IP, and we try to migrate the Profit Planning chapter!
During the migration there are some functions which are in FOX Formula and when i migrate them into IP and try to test them by the RSPLAN Wizard i get this error message:
MultiProvider 'SALES_MUL': Cannot change key figure '0BRT_PR_AVG'
And i get this error message with every Key figure that the FOX Formula want to change!
Here is the FOX Code:
DATA REFYEAR TYPE 0FISCYEAR.
REFYEAR = VARV('0P_FYEAR').
PRICE
{0BRT_PR_AVG,REFYEAR,'0SEM_C10',#,#} =
{0COPAREVEN,REFYEAR,'0SEM_C09',#,010} /
{0COPASLQTY,REFYEAR,'0SEM_C09',#,010}.
REBATES
{0SL_DED_AVG,REFYEAR,'0SEM_C10',#,#} =
{0COPADISCT,REFYEAR,'0SEM_C09',#,010} /
( {0COPAREVEN,REFYEAR,'0SEM_C09',#,010} / 100 ).
DIRECT SALES COSTS
{0SEK_AVG,REFYEAR,'0SEM_C10',#,#} =
{0COPADIRSL,REFYEAR,'0SEM_C09',#,010} /
( {0COPAREVEN,REFYEAR,'0SEM_C09',#,010} / 100 ).
Operand:{Key figure name, 0FISCYEAR, 0INFOPROV, 0VERSION, 0VTYPE}
So the question is how can i set the Key Figure values to be change-able by RSPLAN using a FOX Formula Planning Function?
(I'm not using BEX Query Designer atm, i just want to test the Planning Functions by the Wizard in RSPLAN)
Thx for the answers!
Regards,
Corran