cancel
Showing results for 
Search instead for 
Did you mean: 

date from number oof days

Former Member
0 Kudos

Hi all

Please guide me how to proceed with this reqirement.

  1. Days are required in Selection screen and this will work as following,

If user enters 31 Days in selection screen, then 31 day will be deducted from current date. (System date – 31) e.g. If current date is 20/08/2007

thanks

sreelatha

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

you will need a user exit to perform the subtraction. create a formula variable on a hidden column that is ready for input. create a second variable on the data field you want to restrict upon and make that a user exit variable.

in the user exit, i_step = 2, read the value entered in by the user as the formula value and subtract that from sy-datum. the resulting value will be for the 2nd variable on the date field.

that will work,

-john

Former Member
0 Kudos

Hi john

thanks for your quick reply.

it is not clear to me that no.of days variable need to be built on which characteristic.

i don't have such field in cube.

sreelatha

Former Member
0 Kudos

it doesnt need to be built on a characteristic, which is why im suggesting it be created as a formula variable.

Former Member
0 Kudos

hi john

please explainin detail

thanks

Former Member
0 Kudos

hi

for that user entry variable default value should be 30.

and it should not allow values more than 90.

please give me step by step approach.

sreelatha