Condition on Characteristic

[Former Member]

I have this characteristic called Store Open date . My query should satisfy the condition that Store open date is greater than Today . How should i achieve this .

Thanks

[Former Member · Accepted solution]

Ashwin Kumar Gadi

Could you please tell me , how should i create the calculated KF using the characteritstic Store open date . I am not sure how to create a KF using a characteristic.

Thanks

[Ashwin · Accepted solution]

Hi!

just right clik on the keyfigure section and select new calculated keyfigure and on left side box you can see all the key figures and formula variables. there just selct the for,ula varibles , right click anc create new varibale. in the

wizard that appears selct option "replacement path" and next then in the second screen select the charecterstic"store opendate" and then in the next screen seclect replace with key. and then in the next screen select as Date.

then use this variable to calclate the keyfigure just doubleclick it and then save this key figure with a name.

then you can use this key figure in the conditions greatet than variable 0cwd to achieve the evffect you wanted.

with regards

ashwin

[Former Member]

There is another requirement , which asks for store open date < current month + 3

Is that also possible using the same process of calculated KF. Because I tried it.

Thanks

[Former Member]

Here's one of the simplest ways of resolving this without writing customer exit.

1. Install SAP Exit variable Current Calendar Day in Business Content

2. Restrict your characteristic with this varible where the Store Open Date > Current Calendar Day.

Regards, Raj

[Former Member]

Ashwin

That was excellent , I really appreciate it.

Thanks

[Former Member]

Can some one provide me with a sample code , for delimiting my characteristic with 'Sys-Datum'. Also some steps to establish this mapping.

Thanks

[Ashwin]

Hi!

I think the a work around for this is to use a calculated key figure whith replacement path to the character "store open Date" and then restricting this calculated key figure in the systemusing conditions. this will not reqire any programming but may be you face performance issue if the data pool is too big.

hope this helps

with regards

ashwin

[Former Member]

s rao

in cmod:

VAR CUSTOMER EXIT NO IMPUT

WHEN 'YOUR VAR'.

CLEAR L_S_RANGE.

L_S_RANGE-LOW = SY-DATUM.

L_S_RANGE-SIGN = 'I'. INCLUDE E = exclude

L_S_RANGE-OPT = 'EQ'. bt = between

APPEND L_S_RANGE TO E_T_RANGE.

alessandro

[Former Member]

Alessandro,

I'm trying to use the Exclude in the CMOD but it sends an error message, as if the exit doesn't support this option. With the "I" and the "EQ" there is no problem, just with the "E" or the "NE".

Do you know what is the problem or how can I solve it? or another way to exclude a society that does not longer exists from a determinate date?

Thanks!

Ana

[GFV]

Delimit your characteristic with a Customer Exit Variable that must be evaluated as sy-datum (in CMOD).

For more details and examples about BW Customer Exits see in service.sap.com/bw under InfoIndex -> Exits.

Hope it helps

GFV