Ansicht
Dokumentation

ABENNEWS-756-ABAP_SQL - NEWS-756-ABAP SQL

Addresses (Business Address Services)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

in Release 7.56

New CDS System Entities to Generate Series

The following new CDS system table functions are available:

• ... SERIES_GENERATE_DATE( step = ... from_value = ... to_value = ... ) ...

• ... SERIES_GENERATE_INTEGER( step = ... from_value = ... to_value = ... ) ...

• ... SERIES_GENERATE_TIME( step = ... from_value = ... to_value = ... ) ...

• ... SERIES_GENERATE_TIMESTAMP( step = ... from_value = ... to_value = ... ) ...
  
  
  
  

New String Function

now supports the new string function INITCAP.

New Date and Time Functions

The following new generic date and time functions are available:

SQL Function	Date	Time	Time Stamp
IS_VALID	x	x	x
EXTRACT_YEAR	x	-	x
EXTRACT_MONTH	x	-	x
EXTRACT_DAY	x	-	x
EXTRACT_HOUR	-	x	x
EXTRACT_MINUTE	-	x	x
EXTRACT_SECOND	-	x	x
DAYNAME	x	-	x
MONTHNAME	x	-	x
WEEKDAY	x	-	x
DAYS_BETWEEN	x	-	x
ADD_DAYS	x	-	x
ADD_MONTHS	x	-	x

New Casts

The following new casts are available:

Source type	Numeric target type	Character-like target type	Date/time field as target type
CHAR, SSTRING, DATS, TIMS	INT1, INT2, INT4, INT8, DEC, CURR, QUAN, DECFLOAT16, DECFLOAT34, FLTP	-	-
FLTP	INT1, INT2, INT4, INT8, DEC, CURR, QUAN, DECFLOAT16, DECFLOAT34	CHAR, SSTRING	-
DF16_DEC, DF34_DEC	FLTP	-	-
DATN	-	-	DATS
TIMN	-	-	TIMS

New Set Operators

now supports the new set operators INTERSECT and EXCEPT.

Strict Mode of the Syntax Check

If one the new features listed above is used in an statement, the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.

General Material Data   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 8258 Date: 20240426 Time: 052411     sap01-206 ( 94 ms )