Kontakt

Ansicht
Dokumentation

ABENCDS_DATE_FUNCTIONS_V2 - CDS DATE FUNCTIONS V2

ABENCDS_DATE_FUNCTIONS_V2 - CDS DATE FUNCTIONS V2

TXBHW - Original Tax Base Amount in Local Currency   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

- CDS View Entity, Date Functions

... DATN_DAYS_BETWEEN(date1,date2)
  $| DATN_ADD_DAYS(date,days)
  $| DATN_ADD_MONTHS(date,months)
  $| DATS_IS_VALID(date)
  $| DATS_DAYS_BETWEEN(date1,date2)
  $| DATS_ADD_DAYS(date,days,on_error)
  $| DATS_ADD_MONTHS(date,months,on_error) ...

Variants:

1. ... DATN_DAYS_BETWEEN(date1,date2)

2. ... DATN_ADD_DAYS(date,days)

3. ... DATN_ADD_MONTHS(date,months)

4. ... DATS_IS_VALID(date)

5. ... DATS_DAYS_BETWEEN(date1,date2)

6. ... DATS_ADD_DAYS(date,days,on_error)

7. ... DATS_ADD_MONTHS(date,months,on_error)

Effect

In a CDS view entity, these functions execute operations with arguments of the built-in data types DATN and DATS. The functions have positional parameters to which actual parameters must be assigned when called. There are currently no optional parameters. Suitable fields of a data source, literals, session variables, parameters, path expressions, built-in functions, reuse expressions using $projection, or expressions can all be specified as actual parameters. Only literals can be passed to the parameter on_error. If an actual parameter contains the null value, every function except DATS_IS_VALID returns a null value.

Notes

  • The session variables $session.user_date and $session.system_date return the data type DATS. They can be specified as actual parameters in all functions that expect data type DATS as input. They can be converted to data type DATN with the conversion function DATS_TO_DATN.

Variant 1

... DATN_DAYS_BETWEEN(date1,date2)


Effect

The function DATN_DAYS_BETWEEN calculates the difference between two specified dates, date1 and date2, in days. The actual parameters must have the built-in data type DATN and must contain a valid date in the format YYYYMMDD. They can be specified as literals, as fields of a data source, parameters, or as path expressions. To use a session variable, it must be converted to data type DATN using the conversion function DATS_TO_DATN. The result has the data type INT4. If date2 is greater than date1, the result is positive. In the reverse case, the result is negative. If the result is outside of the range of valid dates, an error occurs.

Notes

  • Empty literals are not possible.
  • If an actual parameter is assigned the literal input '00000000', it is set to the initial value and the value '00010101' is used for the calculation.
  • The days missing from the Gregorian calendar (from 5.10.1582 to 15.10.1582) are handled as usual in ABAP.

Variant 2

... DATN_ADD_DAYS(date,days)


Effect

The function DATN_ADD_DAYS adds days days to a specified date date.

  • The actual parameter date must have the built-in data type DATN and is must contain a valid date in the format YYYYMMDD. It can be specified as typed literal, field of a data source, parameter, or as path expression. To use a session variable, it must be converted to data type DATN using the conversion function DATS_TO_DATN.
  • The actual parameter days must have the built-in data type INT4.

The result has the data type DATN. If days is positive, the number of days is added to date. Otherwise, the number of days is subtracted. If the calculation produces an invalid date, an error occurs.

Notes

  • The days missing from the Gregorian calendar (from 5.10.1582 to 15.10.1582) are handled as usual in ABAP.

Variant 3

... DATN_ADD_MONTHS(date,months)


Effect

The function DATN_ADD_MONTHS adds months months to a specified date date.

  • The actual parameter date must have the built-in data type DATN and it must contain a valid date in the format YYYYMMDD. It can be specified as typed literal, field of a data source, parameter, or as path expression. To use a session variable, it must be converted to data type DATN using the conversion function DATS_TO_DATN.
  • The actual parameter months must have the built-in data type INT4.

The result has the data type DATN. If months is positive, the number of months is added to date. Otherwise, the number of months is subtracted.

An attempt is made to create a date with the same day in an earlier or later month. If the target month has fewer days than the source month, the last day of the target month is returned. If the calculation produces an invalid date, an error occurs.

Notes

  • The days missing from the Gregorian calendar (from 5.10.1582 to 15.10.1582) are handled as usual in ABAP.

Variant 4

... DATS_IS_VALID(date)


Effect

The function DATS_IS_VALID determines whether date contains a valid date in the format YYYYMMDD. The actual parameter must have the built-in data type DATS. It can be specified as literal, as field of a data source, parameter, or as path expression. The result has the data type INT4. A valid date produces the value 1 and all other input values (including the null value) produce the value 0.

Note

The value '00010101' is a valid date but the value '00000000' is not.

Variant 5

... DATS_DAYS_BETWEEN(date1,date2)


Effect

The function DATS_DAYS_BETWEEN calculates the difference between two specified dates, date1 and date2, in days. The actual parameters must have the built-in data type DATS and should contain a valid date in the format YYYYMMDD. They can be specified as literals, as fields of a data source, parameters, session variables, or as path expressions. The result has the data type INT4. If date2 is greater than date1, the result is positive. In the reverse case, it is negative.

Note

Before the difference is calculated, the specified dates are converted to integers, like in ABAP, and the corresponding rules apply.

Variant 6

... DATS_ADD_DAYS(date,days,on_error)


Effect

The function DATS_ADD_DAYS adds days days to a specified date date.

  • The actual parameter date must have the built-in data type DATS and should contain a valid date in the format YYYYMMDD.
  • The actual parameter days must have the built-in data type INT4.
  • The actual parameter on_error must have the built-in data type CHAR with the length 10 and must have one of the following values:
  • 'FAIL' (an error raises an exception)

  • 'NULL' (an error returns the null value)

  • 'INITIAL' (an error returns the initial value)

  • 'UNCHANGED' (an error returns the unmodified value of date)

The values are case-sensitive. Any incorrectly specified values raise an exception.

The result has the data type DATS. If days is positive, the number of days is added to date. In other cases, the number of days is subtracted. If the calculation produces an invalid date, the error is handled as specified in on_error.

Note

For the calculation, the specified date is converted to an integer, like in ABAP, and the result is converted to a date again while applying the corresponding rules.

Variant 7

... DATS_ADD_MONTHS(date,months,on_error)


Effect

The function DATS_ADD_MONTHS adds months months to a specified date date.

  • The actual parameter date must have the built-in data type DATS and should contain a valid date in the format YYYYMMDD.
  • The actual parameter months must have the built-in data type INT4.
  • The same applies to the actual parameter on_error as to DATS_ADD_DAYS.

The result has the data type DATS. If months is positive, the number of months is added to date. In other cases, the number of months is subtracted.

An attempt is made to create a date with the same day in an earlier or later month. If the maximum day possible in a month is exceeded, the greatest possible day is used. If the calculation produces an otherwise invalid date, the error is handled as specified in on_error.

Example

The following CDS view entity applies date functions in the SELECT list to columns of the DDIC database table DEMO_EXPRESSIONS. The program DEMO_CDS_DATE_FUNC_VE uses SELECT to access the view. You can assign values to the columns DATN1, DATN2, DATS1 and DATS2 and to the actual parameters for the input parameters. In the case of DATS_ADD_DAYS and DATS_ADD_MONTHS, invalid values or values that produce invalid results are handled as specified by the parameter on_error.






PERFORM Short Reference   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 21287 Date: 20240418 Time: 072034     sap01-206 ( 203 ms )