topic Re: TVARV table in Application Development and Automation Discussions

TVARV table

Former Member — Tue, 04 Oct 2011 08:23:19 GMT

Hi,

I've a report where there is the field Year.

If I save a variant the next year system will propose 2011 when that variant will be manually selected.

I would like the system will update automatically the value of the year.

I don't know how to do that by TVARV table

Best regards

Re: TVARV table

Former Member — Tue, 04 Oct 2011 09:46:35 GMT

For system will update automatically the value of the year

Use SY-datum+0(4)

regards

Ajit

Re: TVARV table

Former Member — Tue, 04 Oct 2011 09:48:01 GMT

Hi,

where can I use SY-datum+0(4) ?

Regards

Re: TVARV table

Former Member — Tue, 04 Oct 2011 10:50:06 GMT

Hi ,

Could u be more specific is this a standard report or customization.

a) In case of customization we can do the following for ( Transaction Variant )

The variant gets stored in the table VARID and the variant values are checked in tables TVARC , TVARV.

In some programs the variants are assigned to selection selection screen . These tables are used on the basis of

variant maintenance

The are various scenarios in which it could be used

1) In case of execution of report on yearly basis

TABLES: TVARC

DATA: FROMDATE TYPE SY-DATUM.

UPDATE TVARV

SET LOW = SY-DATUM

(.. or use offset sy-datum +0(4) andcan pass the values)

WHERE NAME = 'FROMDATE'.

Please check the link below

b) For standard reports (STANDARD VARIANT) like FBL3N general legder line item display there are specific tcode

TCODE - FS00 -- > GO TO LINE ITEMS TAB --> G/L ACCOUNT LAYOUT.

Thanks,

Rajat Kumar Sharma

Re: TVARV table

Former Member — Tue, 04 Oct 2011 12:06:57 GMT

You can refer below thread

and for dynamic variants with TVARV

http://wiki.sdn.sap.com/wiki/display/ABAP/Creatingdynamicvariantusingtable+TVARV

Thanks,

Pawan

Re: TVARV table

RaymondGiuseppi — Tue, 04 Oct 2011 12:42:21 GMT

Using TVARV (TVARVC)

First create a periodic (daily) job (or ask basis to) that executes standard report RVSETDAT, this report will update some values in TVARV (and TVARVC on more recent versions) (*)

Then in your variant use variable RV_ACTUAL_YEAR (Read [Using Variables for Date Calculations|http://help.sap.com/saphelp_nw04s/helpdata/en/c0/98039be58611d194cc00a0c94260a5/frameset.htm] in [Variable Values in Variants|http://help.sap.com/saphelp_nw04s/helpdata/en/c0/980398e58611d194cc00a0c94260a5/frameset.htm])

Re: TVARV table

Former Member — Tue, 04 Oct 2011 12:43:21 GMT

Hi,

it's a custom report, I can see the following after saving the variant:

http://imageshack.us/photo/my-images/5/immagineku.png/

http://imageshack.us/photo/my-images/821/immaginelfc.png/

Re: TVARV table

Former Member — Tue, 04 Oct 2011 14:16:26 GMT

Hi,

I solved using the date instead of the year thanks for your help