Skip to Content
author's profile photo Former Member
Former Member

TVARVC table entry

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2008 at 08:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2008 at 10:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2008 at 10:37 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 22, 2008 at 01:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.