Get Example source ABAP code based on a different SAP table
AB_SQL in ABAP Release 7.56 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 Addition for the String FunctionREPLACE_REGEXPR
The new parameter start can now be used in the function REPLACE_REGEXPR. Additionally, the parameter occurrence can now include expressions.
ABAP_MODIFICATION_NN New String Function SUBSTRING_REGEXPR
AB_SQL now supports the new string function SUBSTRING_REGEXPR which supports regular expressions.
ABAP_MODIFICATION_NN Byte Fields as Null Indicators
ABAP Alternative 2@2@> INDICATORS ... NULL BITFIELD of the INTO clause of a SELECT statement allows a byte field type component to be specified as a null indicator. The single bits of the byte field serve for indicating null values in the result set of the query. For this purpose, condensed indicator structures can be declared with the addition ABAP Addition the TYPES statement.
ABAP_MODIFICATION_NN Position of Null Indicators
If CORRESPONDING FIELDS is used in the INTO clause of a SELECT statement, a null indicator defined by INDICATORS can be positioned anywhere in the target area. Otherwise, it must be the last component.
