SAP NEWS-783-ABAP SQL



Get Example source ABAP code based on a different SAP table
  



AB_SQL in ABAP Release 7.83
ITOC

ABAP_MODIFICATION_NN New String Function

AB_SQL now supports the new string function INITCAP.

ABAP_MODIFICATION_NN New Date and Time Functions

The following new generic date and time functions are available: SQL FunctionDateTimeTime Stamp
IS_VALIDxx x
EXTRACT_YEARx -x
EXTRACT_MONTHx -x
EXTRACT_DAYx -x
EXTRACT_HOUR- xx
EXTRACT_MINUTE- xx
EXTRACT_SECOND- xx
DAYNAMEx -x
MONTHNAMEx -x
WEEKDAYx -x
DAYS_BETWEENx -x
ADD_DAYSx -x
ADD_MONTHSx -x

ABAP_MODIFICATION_NN New Casts

The following new casts are available: Source typeNumeric target typeCharacter-like target typeDate/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

ABAP_MODIFICATION_NN New Set Operators

AB_SQL now supports the new set operators INTERSECT and EXCEPT.

ABAP_MODIFICATION_NN New Function for Unit Conversion

AB_SQL now supports the new function UNIT_CONVERSION for unit conversions.

ABAP_MODIFICATION_NN New Expression Null

AB_SQL now supports the new expression NULL .

ABAP_MODIFICATION_NN Strict Mode of the Syntax Check

If one the new features listed above is used in an AB-SQL statement, the syntax check is performed in a ABAP_STRICT_783 strict mode / , which handles the statement more strictly than the regular syntax check.