Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Fox Formula : no records generated

Hi.

I have a question regarding following fox formula.

The goal is to have a function that creates a new record in my planning cube.

I already created the new variables that I used. There are no errors in this formula.

Can you guys have a look at this formula and give some suggestions? Usefull ones will be rewarded!

**********************************************************************************************

  • FORMULA EXAMPLE:

  • CHANGE THE VALUE OF THE KEYFIGURE ZQUANTITY OF PRODUCT11

  • TO THE VALUE OF ZQUANTITY OF PRODUCT09 TIMES 1.1

  • ASSUMPTION FOR FIELDS TO BE CHANGED: ZPRODUCT

  • ==> OPERAND: {NAME OF KEYFIGURE, ZPRODUCT}

**********************************************************************************************

  • DATA L_FACTOR TYPE F.

  • L_FACTOR = 1.1.

  • { ZQUANTITY, PRODUCT11 } = { ZQUANTITY, PRODUCT09 } * L_FACTOR.

**********************************************************************************************

DATA CK TYPE 0COUNTRY.

DATA FY TYPE 0FISCYEAR.

DATA CC TYPE ZCOSTCENT.

DATA IO TYPE ZCOORDER.

DATA PL TYPE ZPLGROUP.

DATA COG TYPE ZCOOBJGR.

DATA AM TYPE I.

CK = VARV(ZJANCNTRYNEW).

FY = VARV( CYEAR001).

CC = VARV(ZJANCCNEW).

IO = VARV(ZJANCORNEW).

PL = VARV(ZJANPLGRNEW).

COG = VARV(ZJANCOGNEW).

AM = VARV(ZAMOUNTNEW).

IF CC <>'' AND IO <>''.

MESSAGE E000(ZDEMOIP).

EXIT.

ELSE.

{0AMOUNT,CK,FY,COG,IO,CC,PL}=AM.

ENDIF.

Regards,

Bart

Former Member
Not what you were looking for? View more on this topic or Ask a question