Ansicht
Dokumentation

ABENNEWS-771-ABAP_SQL - NEWS-771-ABAP SQL

ABENNEWS-771-ABAP_SQL - NEWS-771-ABAP SQL

PERFORM Short Reference   PERFORM Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

in Release 7.71





Null Values in the Table Buffer

The table buffer now supports real null values. In table buffering, null values are no longer transformed to type-dependent initial values. When the buffer is accessed, the same results are produced as when the database is accessed directly. The corresponding restrictions now no longer apply. The following are some of the aspects affected:

  • Relational expressions with operands that contain null values. The result of a comparison of this type is now also unknown when the comparison is made in the buffer (except in the expression IS $[NOT$] NULL).
  • Accesses to buffered CDS views. When the buffer is accessed, the same results are now produced as when the database is accessed directly. Null values are often produced by outer joins or in expressions such as case distinction expressions. The restriction specifying that only those CDS views are buffered whose elements do not contain null values no longer applies.



Date/Time Functions

now supports the following new date/time functions:

  • TIMS_IS_VALID

  • TSTMP_IS_VALID

  • TSTMP_CURRENT_UTCTIMESTAMP

  • TSTMP_SECONDS_BETWEEN

  • TSTMP_ADD_SECONDS

  • TSTMP_TO_DATS

  • TSTMP_TO_TIMS

  • TSTMP_TO_DST

  • DATS_TIMS_TO_TSTMP

When used, these functions require the strict mode from Release .



Restrictions Removed

For certain SQL expressions and functions, an read statement no longer bypasses table buffering.



Weaker Check

statements that exploit a database property not supported by all database platforms no longer produce a syntax check warning and produce a syntax warning in the extended program checks instead.



New Check

If the data of the internal table needs to be transported to the database in cases where the internal table is used as a data source of the statement SELECT, a syntax check warning occurs that can be hidden using the pragma ##itab_db_select.



Replacement Service in Program Calls

The method ACTIVATE_REPLACEMENT of the class CL_OSQL_REPLACE has the new parameter FLG_SURVIVE_SUBMIT, which now also allows redirections in called programs.






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

Length: 5093 Date: 20240329 Time: 064642     sap01-206 ( 60 ms )