topic Date Issues while creating a Variant. in Application Development and Automation Discussions

Date Issues while creating a Variant.

Former Member — Fri, 25 Feb 2011 06:22:56 GMT

HI,

I have a report with a date field, which is hard coded where from date = 1st day of month and todate = system date -1,

How do i create a variant with the date field set as above.

I need to create a variant, so that i can schedule the report daily.

Rgds

Norman

Re: Date Issues while creating a Variant.

Sandeep_Panghal — Fri, 25 Feb 2011 06:31:58 GMT

You can use FM "RS_CREATE_VARIANT" inside the report and then use this variant for execution.

Other FM to check out for RS_VARIANT_EXISTS .

Re: Date Issues while creating a Variant.

prasoon_sahay — Fri, 25 Feb 2011 07:14:38 GMT

Please search in SDN before posting your issues.

You need to create dynamic variant

Try below link for its detail:

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

Regards,

Prasoon Sahay

Re: Date Issues while creating a Variant.

Former Member — Fri, 25 Feb 2011 07:55:06 GMT

While saving the variant.....

1. Select selection variable as D for TO date

2. Select Current date - XXX days as give it as -1 so it will show as currentday- 1 days....

1. Select selection variable as D for FROM date

2. Select First day of current month.....

You can set these values in ALV options bar displayed in variant maintenance....

Don't go for TVARVC or manually changing the variant through code...it's the easiest option available...

Re: Date Issues while creating a Variant.

vinod_vemuru2 — Fri, 25 Feb 2011 08:02:16 GMT

Hi,

You can achieve this by creating a namic variant. Checkout below blog on how to create.

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17257] [original link is broken] [original link is broken] [original link is broken];

Thanks,

Vinod.