What does it do? In a ABAP_CDS_V1_VIEW , these functions execute operations with arguments of the built-in data types DATN and DATS. The functions have positional parameters to which actual parameters need to be assigned when called. There are currently no optional parameters. Suitable fields of a data source, literals, parameters, path expressions, built-in functions, 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.
Latest notes: The session variable $session.system_date is used in a CDS view to provide direct access to the current system date. In addition, special annotation @Environment.systemField makes it possible to pass the value of the ABAP system field sy-datum to input parameters. NON_V5_HINTS ABAP_HINT_END
ABAP_VARIANT_1 ... DATN_DAYS_BETWEEN(date1,date2)
What does it do? 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 . 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.
Latest 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. NON_V5_HINTS ABAP_HINT_END
ABAP_VARIANT_2 ... DATN_ADD_DAYS(date,days)
What does it do? 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 it must contain a valid date in the format YYYYMMDD.
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 . In other cases, the number of days is subtracted. If the calculation produces an invalid date, an error occurs.
Latest notes:
Literals are not possible for parameter date.
The days missing from the Gregorian calendar (from 5.10.1582 to 15.10.1582) are handled as usual in ABAP. NON_V5_HINTS ABAP_HINT_END
ABAP_VARIANT_3 ... DATN_ADD_MONTHS(date,months)
What does it do? 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.
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. 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 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.
Latest notes:
Literals are not possible for parameter date.
The days missing from the Gregorian calendar (from 5.10.1582 to 15.10.1582) are handled as usual in ABAP. NON_V5_HINTS ABAP_HINT_END
ABAP_VARIANT_4 ... DATS_IS_VALID(date)
What does it do? 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. 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.
Latest notes: The value 00010101 is a valid date but the value 00000000 is not. NON_V5_HINTS ABAP_HINT_END
ABAP_VARIANT_5 ... DATS_DAYS_BETWEEN(date1,date2)
What does it do? 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. Any invalid dates specified are initialized or set to the value 00010101 before the calculation. The result has the data type INT4. If date2 is greater than date1, the result is positive. In the reverse case, it is negative.
Latest notes: Before the difference is calculated, the specified dates are converted to integers, like in ABAP, and the corresponding rules apply. NON_V5_HINTS ABAP_HINT_END
What does it do? 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. Any invalid date specified is initialized or set to the value 00010101 before the calculation.
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.
Latest notes: 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. NON_V5_HINTS ABAP_HINT_END
What does it do? 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. Any invalid date specified is initialized or set to the value 00010101 before the calculation.
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.
ABAP_EXAMPLE_VX5 The following CDS view applies date functions in the SELECT list to columns of the DDIC database table DEMO_EXPRESSIONS. The class CL_DEMO_CDS_DATE_FUNCTIONS uses SELECT to access the view. The columns DATN1, DATN2, DATS1 and DATS2 in the database table and the actual parameters for the input parameters of the view can be given any values. In the case of DATS_ADD_DAYS and DATS_ADD_MONTHS , invalid values or values that produce invalid results are handled as specified in the view. DDLS DEMO_CDS_DATE_FUNCTIONS ABAP_EXAMPLE_END
