TVARVC table entry

[Former Member]

Hi,

. Can anyone help me understand how to use a TVARVC table entry in a select option/parameter in a SAP standard report variant? I have called them from a program before but can't find any documentation to show how to use them in a variant

Cheers

[Former Member]

Hi,

the table TVARVC contains a flag whether the value is usable as

parameter

or as select-option (P/S).

In the variant maintenance you select "variant attributes". In the block

"field attributes"

the 4th from the top shows as "Selection variable". Follow the line next

to it to find the correct

column with the checkboxes. Mark the check-box that is in line with the

parameter/select-option

you want to work with.

Then click button "Selection variable" (you can select more than one

checkbox right away).

You will notice traffic lights that show you what you can use for the

parameter/select-option.

The first choice is table TVARVC. Select from the drop-down on your

field the TVARVC entry you

want to use.

If available you can also doubleclick on the "dynamic date calculation"

in the column next to your

field. Then you can select there all different kinds of date

calculations (again from drop-down).

Once you have selected what you need, save the variant and you ready to

use the variant. The value

will be set from TVARVC once you start the program and see the selection

screen. Works online and in background of course.

Cheers.......

Edited by: Vijay Chaitanya Raju .P on Feb 22, 2008 9:28 AM

[Former Member]

If you are using ECC 6.0, try the following.

While saving variants,

For a particular field in selection on the Selection Variable Column press F4 and choose "T: Table Variable from TVARVC" option. Now scroll to the right for the same field and press F4 on the "Name of the variable" column and you would get the list of variables available in TVARVC.

Hope this helps.

Thanks,

Balaji

[Former Member]

Hi,

1. Create an entry in TVARV table say v_tvarv with low value as 10 and high as 20.

2. In a report create a variant and assign TVARV variable to the selection screen of the report. The value strored in TVARV will be assigned on to the selection screen i.e, 10 in low and 20 in high of the select options.

REgards,

Santosh

[former_member187457]

HI MS

When ever you have set of values for one field and you want to check in the program that variable exist in those set of values, you can use TVARVC table....

In that table you have to create a field and enter the set of values..in that using sm30.....

let me give you an example....

let us assume that Hub/Site has following values Z01, Z02, Z03, Z04, Z05.

in my logic i have to check that hub/site is present in these set of hub/site or not.....

so i will create a field named as ZSITE in the TVARV.

Run se11..enter table TVARV...

Press 'content' or Cntrl + Shift + F10......

press F8....

Now here press F5...

here enter ZSITE as variable name...

S or P as Selection cat.....

press Save......

now goto SM30 maintan the table....

there select .selection option tab...

then F5....

add the new field ZSITE....here

then in option column select '='.....

in the multiple selection column enter the values Z01, Z02,Z03,Z04,Z05....AND SAVE.....

now u can check in table TVARVC not in TVARV.....

there under name type ZSITE....you will get all the values in LOW column....

now for using them in program you have to fetch the data from table TVARVC where name = ZSITE

and type = 'S' .

thats it.....

using this logic u can create the varient...

thnx

Rohit

Edited by: Rohit Kumar on Feb 22, 2008 6:51 PM