SAP NEWS-754-ABAP SQL Get Example source ABAP code based on a different SAP tableSAP Help
AB_SQL in ABAP Release 7.54 ITOC
ABAP_MODIFICATION_NN Extensions of the INTO Clause The
INTO clause has been extended as follows: The new addition NEW can be used to implicitly create anonymous data objects as target areas. The addition NEW now also makes inline declarations possible when using dynamic tokens and after the statement FETCH . The new addition INDICATORS can be used to specify a null indicator. ABAP_MODIFICATION_NN Definition of Associations common table expression are published using the addition WITH ASSOCIATIONS, new CTE associations can be defined by specifying JOIN TO ONE$|MANY . These CTE associations can be used in the subsequent queries of the current WITH statement, either in path expressions or as hierarchy associations in the hierarchy generator HIERARCHY. ABAP_MODIFICATION_NN New Aggregate Function STRING_AGG STRING_AGG can be used to chain character-like results of the rows of the results set of a query or of the current group as a string. ABAP_MODIFICATION_NN Addition DISTINCT Optional in Aggregate Function COUNT COUNT( sql_exp ) can now be used without the addition DISTINCT. In this case, it counts all rows in which the value of the argument is not the null value. ABAP_MODIFICATION_NN Window Expressions OVER can now be used in the SELECT list of a query. Window expressions define windows as a subset of the results set and apply window functions to them. ABAP_MODIFICATION_NN Temporal SQL Hierarchies hierarchy generator HIERARCHY can now use the new addition PERIOD FROM TO VALID FROM TO to create temporal hierarchies in which the hierarchy nodes are limited by time intervals. ABAP_MODIFICATION_NN Hierarchy Navigators hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE can be used to calculate aggregate functions for descendant nodes. ABAP_MODIFICATION_NN Aggregate Expressions in SQL Expressions aggregate expressions can be specified as operands of SQL expressions. ABAP_MODIFICATION_NN Extension of the CAST Matrix CAST expression has been expanded. In particular, the new data types of the ABAP Dictionary are taken into account. ABAP_MODIFICATION_NN Client Handling USING $[ALL$] CLIENTS $[IN$] in queries USING $[ALL$] CLIENTS $[IN$] in write statements client handling from the current default client to multiple clients. CLIENT SPECIFIED obsolete in queries and obsolete in the write statements UPDATE SET and DELETE FROM. ABAP_MODIFICATION_NN Syntax Check for Literals and Host Constants host variables in read positions need to be lossless is checked for untyped literals and host constants in the strict syntax check modes from ABAP_STRICT_762 ABAP_RELEASE ABAP_762 / and ABAP_STRICT_763 ABAP_RELEASE ABAP_763 / and hence can produce syntax errors. From ABAP_RELEASE 7.54, a syntax check warning is produced when this rule is broken outside of the strict mode too. ABAP_MODIFICATION_NN SQL Conditions SQL conditions were revised as follows: Unlike in all other relational expressions in AB_SQL , the relational expression IS $[NOT$] NULL can now be used to check LOBs and geodata types. A new variant of the operator IN can be used to compare multiple operands with a list of value tuples. ABAP_MODIFICATION_NN New Window Functions window functions in window expressions: LEAD and LAG. ABAP_MODIFICATION_NN New Built-In Functions UUID ABAP_MODIFICATION_NN Strict Mode in the Syntax Check
