Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

tvarv selection

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi kiran,

1. U can use like this

(the to_date will be dynamic, ie.

61 days from today)

2. Just copy paste

3.

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.

7 REPLIES 7

FredericGirod
Active Contributor
0 Kudos

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

0 Kudos

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...

0 Kudos

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

Former Member
0 Kudos

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.

4.

20000101 = fixed ?

sy-datum = current date (no problem)

61 = fixed ?

regards,

amit m.

Former Member
0 Kudos

Hi kiran,

1. U can use like this

(the to_date will be dynamic, ie.

61 days from today)

2. Just copy paste

3.

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.

0 Kudos

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..

0 Kudos

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