Kontakt

Ansicht
Dokumentation

ABENNEWS-777-ABAP_SQL - NEWS-777-ABAP SQL

ABENNEWS-777-ABAP_SQL - NEWS-777-ABAP SQL

Addresses (Business Address Services)   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

in Release 7.77





Client Handling

The new additions

make it possible to switch implicit client handling from the current default client to multiple clients.

This makes the addition CLIENT SPECIFIED obsolete in queries and obsolete in the write statements UPDATE SET and DELETE FROM.



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 using @DATA(...) possible when using dynamic tokens and after the statement FETCH.

Extension of the CAST Matrix

The matrix of types that can be converted to each other using a CAST expression was revised. In particular, the new data types in ABAP Dictionary are respected. The new types DECFLOAT16 and DECFLOAT34 can also be specified after the addition AS of the aggregate function AVG.



New Built-In Functions

Now supports the following new built-in functions:

New Window Functions

now supports the following new window functions in window expressions:

SQL Conditions

The SQL conditions were revised as follows:

  • A new variant of the operator IN can be used to compare multiple operands with a list of value tuples.



Hierarchy Navigators

The hierarchy aggregate navigators were revised as follows:

  • New WITH additions in the hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE make it possible to evaluate the aggregate functions specified using MEASURES for further row sets in the hierarchy.
  • The new hierarchy navigator HIERARCHY_ANCESTORS_AGGREGATE makes it possible to calculate aggregate functions for ancestor nodes and also supports the new aggregate function PRODUCT.



Strict Mode in the Syntax Check

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



Syntax Check for Literals and Host Constants

The fact that conversions of host variables in read positions need to be lossless is checked for untyped literals and host constants in the strict syntax check modes from Release and Release and hence can produce syntax errors. From Release 7.77, a syntax check warning is produced when this rule is broken outside of the strict mode too.






TXBHW - Original Tax Base Amount in Local Currency   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 6294 Date: 20240424 Time: 225600     sap01-206 ( 93 ms )