TVARVC/TVARV

[Former Member]

Hi all,

Is there a specifice purpose of using TVARVC/TVARV tables.

Regards,

Neo.

[andreas_mann3]

hi,

you need them for your variants (e.g. to adjust date automatically in your variant of an job)

http://help.sap.com/saphelp_470/helpdata/en/c0/980398e58611d194cc00a0c94260a5/frameset.htm

A.

[anversha_s]

hi,

variants are stored in table VARID

variant values are checkd in the tables TVARVC, TVARV .

rgds

anver

Message was edited by: Anversha s

[Former Member]

Neo,

As of i know,

we will be having variant names and maintained it's values(type as parameter or select-optioin) in TVARV.

In some transactions these variants are assigned to the selection screen fields.

so when ever we go to that selection screen values that are maintainted in TVAVR comes directly to that selection fields.

-Anu.

[Former Member]

Hi,

These tables used for varient maintenance . If you need to execute any report which needs to run say hourley and it will pick up the latest information then with the help these tables you can execute u r report.

eg.

SELECT SINGLE low

FROM tvarv

INTO ws_fromdate

WHERE name = c_fromdt.

SELECT SINGLE low

FROM tvarv

INTO ws_fromtime

WHERE name = c_fromtm.

Perform some_action based on ws_fromdate and ws_fromtime.

When processing will be over then update tvarv by the details of last run so that next time when the report will execute it will take date and latest time from the table and will search records based on the date and time.

eg.

UPDATE tvarv

SET low = sy-datum

WHERE name = 'FROMDATE'.

IF sy-subrc <> 0.

error message.

ENDIF.

UPDATE tvarv

SET low = sy-uzeit

WHERE name = 'FROMTIME'.

IF sy-subrc <> 0.

Error message

ENDIF.

If it makes sense , pl assign points.

Cheers.