Ansicht
Dokumentation

ABENNEWS-783-ABAP_SQL - NEWS-783-ABAP SQL

ABENNEWS-783-ABAP_SQL - NEWS-783-ABAP SQL

BAL_S_LOG - Application Log: Log header data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.
SAP E-Book

in Release 7.83





New String Function

now supports the new string function INITCAP.



New Date and Time Functions

The following new generic date and time functions are available:

SQL Function Date Time Time Stamp
IS_VALID x x x
EXTRACT_YEAR x - x
EXTRACT_MONTH x - x
EXTRACT_DAY x - x
EXTRACT_HOUR - x x
EXTRACT_MINUTE - x x
EXTRACT_SECOND - x x
DAYNAME x - x
MONTHNAME x - x
WEEKDAY x - x
DAYS_BETWEEN x - x
ADD_DAYS x - x
ADD_MONTHS x - x

New Casts

The following new casts are available:

Source type Numeric target type Character-like target type Date/time field as target type
CHAR, SSTRING, DATS, TIMS INT1, INT2, INT4, INT8, DEC, CURR, QUAN, DECFLOAT16, DECFLOAT34, FLTP - -
FLTP INT1, INT2, INT4, INT8, DEC, CURR, QUAN, DECFLOAT16, DECFLOAT34 CHAR, SSTRING -
DF16_DEC, DF34_DEC FLTP - -
DATN - - DATS
TIMN - - TIMS

New Set Operators

now supports the new set operators INTERSECT and EXCEPT.



Strict Mode of 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.






TXBHW - Original Tax Base Amount in Local Currency   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 7534 Date: 20240419 Time: 001622     sap01-206 ( 38 ms )