Get Example source ABAP code based on a different SAP table
ABAP_CDS in ABAP Release 7.62 ITOC BEGIN_SECTION SAP_INTERNAL_HINT The operator IS [NOT] NULL> can be used in ON>- and HAVING>-conditions. It is not known since when. END_SECTION SAP_INTERNAL_HINT
ABAP_MODIFICATION_NN Session Variables>
When a CDS view> is accessed using AB_SQL , three session variables ($session.user>>, $session.client>>, and $session.system_language>>) can be accessed here. In these variables, the values of the system fields sy-uname>, sy-mandt > and sy-langu> are available.
ABAP_MODIFICATION_NN CDS Views with Input Parameters>
In ABAP_RELEASE 7.62 and higher, the input parameters> of CDS views are supported by all database platforms and can be used in AB_SQL . It is no longer necessary to query property VIEWS_WITH_PARAMETERS> using method USE_FEATURES> of class CL_ABAP_DBFEATURES>>. Querying this property results in a warning check from the syntax check.
ABAP_MODIFICATION_NN Expressions and Functions>
The following changes have been made:
A CAST> expression> now contain nested cast expressions and case distinctions> as an operand.
The following additional string functions are now supported: CONCAT_WITH_SPACE>>, LEFT>>, INSTR>>, RIGHT>>, and RPAD>>.
Input parameters> from the parameter list parameter_list>> of a CDS view can be passed to many arguments of built-in functions>.
A one character literal with the type NUMC> can now be compared> with a data source of the type LANG>.
ABAP_MODIFICATION_NN Exposing CDS Associations>
Path expressions can now be exposed> with more than one CDS association in the SELECT> list> of a CDS view. The fields of the association source> from the ON > condition of the exposed CDS association, which then also need to be specified, must be defined using an appropriately specified path.