Skip to Content
0
Former Member
Mar 24, 2009 at 04:17 PM

Change key figure values by planning function

379 Views

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