Kontakt

Ansicht
Dokumentation

ABENNEWS-760-ABAP_SQL - NEWS-760-ABAP SQL

ABENNEWS-760-ABAP_SQL - NEWS-760-ABAP SQL

General Material Data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

in Release 7.60





Unions

From Release 7.60, the language element UNION creates the union of the result sets of two SELECT statements.



SQL Expressions

From Release 7.60, SQL expressions can be specified in the following operand positions (except in the SELECT list):

  • Left side of any WHERE condition
  • Left side of a HAVING condition

If an SQL expression can be specified, any individual literals, host variables, and host expressions can also be specified.



Host Expressions

From Release 7.60, host expressions with the syntax @( expr ) can be specified in many operand positions in which host variables are possible. For expr, all ABAP expressions can calls are possible that can be specified in general expression positions.

Operand positions for host expressions in Release 7.60:

  • Arguments of SQL expressions and hence all operand positions in which these are possible.
  • Right sides of WHERE, ON, or HAVING conditions, except for LIKE and IN.

Columns Specified After BETWEEN

From Release 7.60, numeric columns can be specified on the right side in an interval condition using BETWEEN, providing the name of the database table or view is prefixed using ~.



Access to CDS Entities

Until Release 7.60, a CDS entity could only be used together with database tables and DDIC views in a SELECT statement if addressed using its CDS-managed DDIC view. This restriction now no longer applies. From Release 7.60, CDS views can be addressed using the name of their CDS entity, even if linked with database tables or DDIC views using joins or subqueries. Accessing a CDS view by specifying the CDS-managed DDIC view is obsolete.



CDS Path Expressions

From Release 7.60, path expressions closed with an element can be specified for columns specified in SELECT statements that access CDS views with CDS associations exposed for outside use.



Strict Mode in the Syntax Check

If one the new features listed here 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.






Fill RESBD Structure from EBP Component Structure   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 4940 Date: 20240427 Time: 070827     sap01-206 ( 56 ms )