SAP NEWS-772-ABAP SQL



Get Example source ABAP code based on a different SAP table
  



AB_SQL in ABAP Release 7.72
ITOC

ABAP_MODIFICATION_NN Date/Time Functions

AB_SQL now supports the following new time zone functions:
ABAP_SYSTEM_TIMEZONE
ABAP_USER_TIMEZONE
When used, these functions apply the ABAP_STRICT_772 strict mode from ABAP_RELEASE ABAP_772 / .

ABAP_MODIFICATION_NN Relational Expression IS INITIAL

The relational expression IS $[NOT$] INITIAL can now be used in a condition sql_cond to compare operands with their type-dependent initial value.
When used, this expression requires the ABAP_STRICT_772 strict mode from ABAP_RELEASE ABAP_772 / .

ABAP_MODIFICATION_NN Exposing CDS Associations of Common Table Expressions

When CDS views are accessed within a common table expression, the addition WITH ASSOCIATIONS of the statement WITH can now be used to expose CDS associations of these views for use in path expressions of the current WITH statement. The addition REDIRECTED TO can also be used to replace the association target of the exposed CDS association with a previous CTE or the current CTE.
When used, this addition requires the ABAP_STRICT_772 strict mode from ABAP_RELEASE ABAP_772 / .

ABAP_MODIFICATION_NN Numeric Literals in the SELECT List

Until now, only those numeric literals whose value matched the value range of the type INT4 could be specified as elementary SQL expressions in the SELECT list of a query. Now numeric literals of up to 31 digits can be specified, which are interpreted as numbers of the type DEC if the value range of INT4 is exceeded.

ABAP_MODIFICATION_NN Enhanced Cast Matrix

A cast expression can now be used to convert the data types INT1, INT2, INT4, and INT8 to DEC.