SAP NEWS-752-ABAP SQL Get Example source ABAP code based on a different SAP tableSAP Help
AB_SQL in ABAP Release 7.52 ITOC
ABAP_MODIFICATION_NN Internal Tables as Data Sources An internal table can be specified as a
data source data source of a query. This statement cannot be executed on all database systems, if the data from the internal table needs to be passed to the database. ABAP_MODIFICATION_NN Relational Expressions conditions in expressions: Size comparisons can now be made between character-like data types and are no longer restricted to numeric data types. The operator BETWEEN is also no longer restricted to numeric data types and SQL expressions can now be specified on the right side. The operator LIKE is now also supported. ABAP_MODIFICATION_NN Conversion Functions BINTOHEX and HEXTOBIN make it possible to convert byte strings to character strings (and the other way round) in SQL expressions, which is not possible with a CAST expression. ABAP_MODIFICATION_NN Path Expressions path expressions: Path expressions can now be split over several source code rows at the blanks in the syntax for parameter passes and filter conditions and also before slashes (/). Associations can now be used whose target data sources are CDS table functions. Parameters can now be passed after the associations of a path expression. This makes it possible to specify paths whose associations have CDS entities with input parameters as data sources. In path expressions, it is now possible to specify the cardinality and type of the join expression as attributes . Filter conditions for associations can now be specified in path expressions. ABAP_MODIFICATION_NN Access Control WITH PRIVILEGED ACCESS switches CDS access control off. ABAP_MODIFICATION_NN ORDER BY and UP TO, OFFSET in Subquery subquery, it is now possible to use an ORDER BY clause and the additions UP TO, OFFSET can be used after the clause. It is not possible to execute a subquery with an ORDER BY clause on all database systems ABAP_MODIFICATION_NN Cardinality in LEFT OUTER JOIN LEFT OUTER JOIN, an addition ONE TO MANY can now be specified for the cardinality. This is evaluated as a note for optimization by SAP HANA databases. ABAP_MODIFICATION_NN FOR ALL ENTRIES and Strings in the SELECT List strict modes of the syntax check, the addition FOR ALL ENTRIES of statement SELECT could not be specified together with columns of the types STRING and RAWSTRING or LCHR and LRAW in the SELECT list. This restriction has been removed and now the syntax check simply issues a warning. ABAP_MODIFICATION_NN Addition NOT for BETWEEN and LIKE NOT can now specified in front of BETWEEN and LIKE in relation expressions for expressions. ABAP_MODIFICATION_NN Strict Mode in the Syntax Check ABAP_MODIFICATION_NN Client Handling USING CLIENT and CLIENT SPECIFIED now apply when switching and disabling implicit client handling in reads on CDS entities: CDS access control does not work for client-independent access. For this reason, the additions USING CLIENT and CLIENT SPECIFIED can only be used in AB_SQL in reads on CDS entities for which access control is switched off using the annotation AccessControl.authorizationCheck.#NOT_ALLOWED or the addition WITH PRIVILEGED ACCESS in the FROM clause of an AB-SQL query. Path expressions can only be evaluated if automatic client handling is switched on. This cannot be done using CLIENT SPECIFIED in cases where path expressions are used that contain associations whose target data source is client-specific In path expressions in the FROM clause, the source data sources of the associations cannot be client-specific either. ABAP_MODIFICATION_NN Replacement Service for AB_SQL CL_OSQL_REPLACE can be used in unit tests with ABAP Unit to redirect database accesses in AB_SQL to other databases.
