variable with low value as first day of year and high as key date

[Former Member]

hi all,

i need to create a variable with key date for which the low value should be 1st day of the year,

means if i enter a key date (5/9/06) the values to appear should be from 1/1/06 to 5/9/06.

If i want the manipulation based on key date like key date + 90 etc. is it possible?

i have written a customer exit as

case i_vnam.

when 'keydate'

clear : e_t_range,

l_t_range.

DATA DAT(8)TYPE D.

LOOP AT i_t_var_range INTO loc_t_var_range.

IF loc_t_var_range-vnam = 'keydate'.

loc_found = 'X'.

EXIT.

ENDIF.

ENDLOOP.

DAT = loc_t_var_range-vnam .

if loc_found = 'X'.

l_s_range-sign = 'I'.

l_s_range-opt = 'BT'.

CONCATENATE sy-datum(4) '01' '01' INTO l_s_range-low.

l_s_range-high = DAT.

APPEND l_s_range TO e_t_range.

ENDIF.

WILL THIS CODE WORK.

I FEEL THERE IS PROBLEM WITH L_T_RANGE- HIGH.

IS THERE A DICREPENCY IN THE CODE?

IS THE CALLING SEQUENCE OF THE VARIABLE CORRECT?

PLZ LET ME KNOW.

THANK U ALL

[Former Member]

hi thank u for ur reply.

my mail id is mahesh_shu@yahoo.co.in.

iam awarding u points.

i forgot to mention I_Step = 2. in my post.

plz send me the doc.

[Former Member]

Hi,

my mail bounced back. send vaild mail id.

try this.

1) create one customer exit variable say zcuvar

2) create a USER entry variable Keydate 0date.

3) in CMOD, in I_STEP = 1 of zcuvar, make it default value ad 01/01/2006 as you have done.

4) in use as range in Selection restrict.

zcuvar;0date.

hope i m clear.

regards,

San!

[Former Member]

Hi Sandeep,

Does this mean one has to create 0Date as a user Entry Variable of type Interval and then restrict the lower range to the customer exit variable?

Can you provide some more details please.

Thanks.

[former_member189638]

0Date variable will be ready for input and will just accept the date entered by the user. This date will be then used by the customer exit variable to populate the Low and High Range.This will be achieved by writing a code in CMOD. The Key figure will be then restricted by this customer exit variable.

[Former Member]

Hi mahesh,

this code won' work.

As you have defined KeyDAte Variable say V1 which is will take single value (when you run your query).

Secondly there i no I_STEP define.

send me you mail id. i will mail a doc.

regards,

San!