topic Re: Dynamic Date Calculation in Application Development and Automation Discussions

Dynamic Date Calculation

Former Member — Thu, 04 Sep 2014 17:48:38 GMT

Hello,

I am trying to run a program twice a month, on the 1st and on the 15th.

I am setting up two separate variants.

The first variant needs to collect information from the 16th of the previous month up until the time runs at 23:59

The second variant needs to collect data from the 1st to 23:59 on the 15th of the current month.

I tried looking for a parameter that allows these conditions, but it seems to only be linked to working days.

Re: Dynamic Date Calculation

ronaldo_aparecido — Thu, 04 Sep 2014 20:54:15 GMT

Hi Brett.

Did you use select options?

Could you show the code?

Re: Dynamic Date Calculation

Former Member — Fri, 05 Sep 2014 01:30:22 GMT

Hi Brett,

Please use dynamic date calculation in variant, then you just a single variant will work. You just need to select the appropriate option out of available options.

Thanks!

Let me know if this solves your requirement.

Thanks & Regards,

Anil Kumar Sahni

Re: Dynamic Date Calculation

Former Member — Tue, 09 Sep 2014 18:56:36 GMT

I have tried the options in dynamic date calculation. I just do not know how to select the correct option to pull from the 15th of the previous month.

I only see an option to pull from the nth "working" day of the previous month. The amount of working days will be different in every month.

Re: Dynamic Date Calculation

former_member206257 — Tue, 09 Sep 2014 19:26:55 GMT

you can use tcode STVARV to Create a dynamic variant for it in the Selection Options tab.

or something like given below code . schedule program for 1st of every month . it will update tvarvc table .

REPORT zupdate_tvarv.

TABLES : tvarvc.

DATA : it_tvarvc TYPE STANDARD TABLE OF tvarvc WITH HEADER LINE ,

wa_tvarvc TYPE tvarv .

DATA: end_date TYPE /sapapo/cdps_date_to,

start_date TYPE /sapapo/cdps_date_to,

start_date1 TYPE /sapapo/cdps_date_to,

t_date TYPE /sapapo/cdps_eval_date_from ,

end_month TYPE sy-datum,

month TYPE i .

SELECTION-SCREEN BEGIN OF BLOCK b1.

PARAMETERS : p_datum TYPE sy-datum DEFAULT sy-datum.

SELECTION-SCREEN END OF BLOCK b1.

PERFORM curr_month_start.

MODIFY tvarvc FROM TABLE it_tvarvc.

COMMIT WORK .

*&---------------------------------------------------------------------*

*& Form CURR_MONTH_START

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

FORM curr_month_start.

CONCATENATE p_datum+4(2) p_datum(4) INTO t_date .

PERFORM get_period USING t_date CHANGING end_date start_date .

it_tvarvc-name = 'CURR_MONTH_START' .

it_tvarvc-type = 'P'.

it_tvarvc-low = start_date .

APPEND it_tvarvc ." to it_TVARVc.

CLEAR : t_date ,end_date, start_date ,it_tvarvc.

ENDFORM.

Re: Dynamic Date Calculation

former_member206257 — Wed, 10 Sep 2014 20:44:03 GMT

hi ,

is this problem solved?