how to write a FOX code for a condition, in planning package

[Former Member]

Hi Experts,

I have created a planning package going to t-code bps0  and there i have to filter certain keyfigures using below logic:

Pricing Start Date (0CRM_MKTELM_EUTPC007)>= current day <= Pricing End Date (0CRM_MKTELM_EUTPC009).

I am wondering if I could do that using selection tab of planning package or do I need to write a fox code for same.

If a code needs to be written,please suggest me about the FOX code as I am very much new to FOX as well as BPS.

Thanks,

Dolly

[amine_lamkaissi]

Hi Dolly,

Have a look at the following document, that might be helpful for you:

http://help.sap.com/saphelp_sem320bw/helpdata/en/c4/9057425ca611d4b2e30050dadfb23f/content.htm

I don't think your logic complex to implement, it would be smthg as following:

DATA : KeyFigure TYPE KEYFIGURE_NAME1, KEYFIGURE_NAME2.

Data : Current_day type sy-datum.
FOREACH KeyFigure.
..IF 0CRM_MKTELM_EUTPC007 >=current_day.

    IF  current_day <= Pricing End Date
..  ENDIF.

     ENDIF.
ENDFOR.

Hope it helps you.

Amine