Skip to Content

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

Key figures validation using Fox Formula as part of Planning function

Dear Experts,

I have a requirement as follows to validate the key figures :

Key figures 0CS_TRN_GC and 0CS_TRN_LC;

Char 0FISCYEAR, for which the value entered as '2007'

Requirement:

As part of planned data manual input, it should throw an error message when the first keyfigure value for year 2007 is not equal to second key figure value for the same year.

I wrote below code(derived from sdn help). Please suggest me the correct code as below code is not working and also guide me if the error message next to 'MESSAGE' is correct.

DATA DIFF TYPE F.

DIFF={0CS_TRN_GC, 2007}-{0CS_TRN_LC, 2007}.

IF DIFF<>0.

MESSAGE E001(UPF) REENTER THE VALUES.

ENDIF.

Your help is much appreciated and full points will be rewarded for your cooperation

Regards

Shanthi

Former Member
Former Member replied

Hi,

Ya please also change that statment as below (space

IF DIFF <> 0.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question