ABAP SQL in ABAP Release 7.56 - ABAP Keyword Documentation

ABAP - Keyword Documentation → ABAP - ABAP Release News → News for ABAP Release 7.5x → News for ABAP Release 7.56 →

ABAP SQL in ABAP Release 7.56

1. New String Function

2. New Date and Time Functions

3. New Casts

4. New Set Operators

5. New Function for Unit Conversion

6. New Expression Null

7. Addition for the String Function REPLACE_REGEXPR

8. New String Function SUBSTRING_REGEXPR

9. Byte Fields as Null Indicators

10. Position of Null Indicators

11. Strict Mode of the Syntax Check

Modification 1

New String Function

ABAP SQL now supports the new string function INITCAP.

Modification 2

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

Modification 3

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

Modification 4

New Set Operators

ABAP SQL now supports the new set operators INTERSECT and EXCEPT.

Modification 5

New Function for Unit Conversion

ABAP SQL now supports the new function UNIT_CONVERSION for unit conversions.

Modification 6

New Expression Null

ABAP SQL now supports the new expression NULL.

Modification 7

Addition for the String Function REPLACE_REGEXPR

The new parameter start can now be used in the function REPLACE_REGEXPR. Additionally, the parameter occurrence can now include expressions.

Modification 8

New String Function SUBSTRING_REGEXPR

ABAP SQL now supports the new string function SUBSTRING_REGEXPR which supports regular expressions.

Modification 9

Byte Fields as Null Indicators

The new addition INDICATORS ... NULL BITFIELD of the INTO clause of a SELECT statement allows a byte field type component to be specified as a null indicator. The single bits of the byte field serve for indicating null values in the result set of the query. For this purpose, condensed indicator structures can be declared with the addition AS BITFIELD of the TYPES statement.

Modification 10

Position of Null Indicators

If CORRESPONDING FIELDS is used in the INTO clause of a SELECT statement, a null indicator defined by INDICATORS can be positioned anywhere in the target area. Otherwise, it must be the last component.

Modification 11

Strict Mode of the Syntax Check

If one the new features listed above or one of the new CDS system table functions SERIES_GENERATE_ is used in an ABAP SQL statement, the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.