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 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>
ABAP_MODIFICATION_NN 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>
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.