topic Re: tvarv selection in Application Development and Automation Discussions

tvarv selection

Former Member — Fri, 03 Feb 2006 13:54:04 GMT

Hi all,

i need to select data based on date from 20000101 to sy-datum - 61. it cant be hard coded and is said that i have to use tvarv. i tried to input all the other values using tvarv. but i dont know how to input this dynamic range into variant....can u help me with this please.

thanks,

kiran

Re: tvarv selection

FredericGirod — Fri, 03 Feb 2006 14:02:13 GMT

Hi,

1. Create the entry in TVARV.

2. Create a schedull job to update the value (all the night)

3. Use in variant :

Execute the report -> set value -> press save (F11)

When you set the name of the variant name, select the checkbox "Selection variable" for the parameters you would like to update with the TVARV values.

Press the Selection Variable button

Select the name of the field in TVARV.

Press save ...

Rgd

Frédéric

Re: tvarv selection

Former Member — Fri, 03 Feb 2006 14:09:19 GMT

thanks fred..

do it need such a complex procedure mate..is there any other alternative for that... is there any way that a dynamic range be created in tvarv...

Re: tvarv selection

FredericGirod — Fri, 03 Feb 2006 14:11:37 GMT

I don't understand, you have to create only one time the variant.

After this, all the time the value will be update when you call the program.

maybe you have to modify your parameters with default value searching in the TVARV values.

Rgd

Re: tvarv selection

Former Member — Fri, 03 Feb 2006 14:11:52 GMT

Hi kiran,

1. What is ur exact requirement ?

2. Ur critera for dynamic date !

Is it entered on selection screen ?

3. Or u have to check while getting

from dbtable.

20000101 = fixed ?

sy-datum = current date (no problem)

61 = fixed ?

regards,

amit m.

Re: tvarv selection

Former Member — Fri, 03 Feb 2006 14:15:39 GMT

Hi kiran,

1. U can use like this

(the to_date will be dynamic, ie.

61 days from today)

2. Just copy paste

REPORT abc.

DATA : ekko LIKE TABLE OF ekko WITH HEADER LINE.

DATA : todate TYPE sy-datum.

todate = sy-datum - 61.

SELECT * FROM ekko

INTO TABLE ekko

WHERE aedat >= '20000101'

AND aedat <= todate.

BREAK-POINT.

regards,

amit m.

Re: tvarv selection

Former Member — Fri, 03 Feb 2006 14:22:46 GMT

amit,

20000101 is fixed

then when i run the program it should get data from range

20000101 to sy-datum - 61. I cant hard code the thing u provided me. all should be dealt in tvarv as i am instructed like that.. how am i gonna replicate the same in tvarv.....am i clear..

fred i cant get u ..u said for filling in the variant i have to run a batch job..am i right...just to get the date range have i to det a batch job....makes it compliacted mate..

Re: tvarv selection

christian_wohlfahrt — Fri, 03 Feb 2006 14:26:21 GMT

Hi!

Instead of having one select-option for the date, make two parameters (for start / end).

First parameter can be maintained in job variant as constant (not hard-coded, not dynamic).

Second parameter can be maintained as normal variable 'sy-datum +/- n days' with -61 as dynamic option.

Then no TVARV handling is needed.

Regards,

Christian