topic Re: variable of date calculation in Application Development and Automation Discussions

variable of date calculation

ratana_pouy — Fri, 28 Apr 2017 06:42:55 GMT

Hi,

i am trying to create a new variant to select date range:

From: current date -1

To : End of month

I don't see variable in the list to meet above requirement.

Would you please advise, on how shall I create a new variable?

best regards,

Rtn

Re: variable of date calculation

Former Member — Fri, 28 Apr 2017 10:42:58 GMT

Hi Ratana,

SAP variant do not support current your requirement. If you you are using the customize report, you can do sample code abap below.


REPORT  zzzztest.
SELECT-OPTIONS: s_day  FOR sy-datum.



DATA : lv_lastday_month  TYPE sy-datum.



INITIALIZATION.

  CALL FUNCTION 'RP_LAST_DAY_OF_MONTHS'

    EXPORTING

      day_in            = sy-datum

    IMPORTING

      last_day_of_month = lv_lastday_month.

  s_day-sign = 'I'.

  s_day-option = 'EQ'.

  s_day-low = sy-datum - 1.

  s_day-high = lv_lastday_month. " last day of month

  APPEND s_day.

Re: variable of date calculation

Jelena_Perfiljeva — Tue, 02 May 2017 20:18:23 GMT

It should be "BT" instead of "EQ". "EQ" will give you exactly two days, not the period in between.

Re: variable of date calculation

Jelena_Perfiljeva — Tue, 02 May 2017 20:24:55 GMT

How are the variables defined in the program? PARAMETERS or SELECT-OPTIONS?

If it's PARAMETERS (i.e. two variables - from and to) then you can use in the variant dynamic variables "current date - 1" and "Last day of current month".

If it's SELECT-OPTIONS then your dynamic variable options are limited to just one. In this case either you could fill in values in the program, as shown by John (in this case you won't use variant to determine those values, so be careful when saving a variant for other values) or you'll have to create a custom variable. (option T in the variant). The latter has been discussed numerous times on SCN. Google -> TVARVC site:sap.com.

Kindly make sure to search and read documentation before posting in SCN.

P.S. "month" in SAP could also be fiscal, not calendar month. Make sure to clarify that.

Re: variable of date calculation

ratana_pouy — Wed, 03 May 2017 09:58:21 GMT

Hi,

It's PARAMETERS: Two variables-From and To, how to use in the variant dynamic variable "Current date-1" and "Last day of current month"? I don't see in SAP.

Thanks,
Ratana

Re: variable of date calculation

Jelena_Perfiljeva — Wed, 03 May 2017 19:48:49 GMT

Where exactly are you looking "in SAP"? It's in the variant, under selection variable -> dynamic date calculation, at least in ECC 6.0.