SAP SQL FUNCTION UPPER ABEXA



Get Example source ABAP code based on a different SAP table
  



ABAP_DDIC - SQL Function UPPER
This example demonstrates the SQL function UPPER in AB_SQL and ABAP CDS.

ABAP_SOURCE_CODE
DEMO CL_DEMO_SQL_UPPER

ABAP_DESCRIPTION
A SELECT statement accesses the following CDS view entity, which uses the SQL function UPPER:
DDLS DEMO_CDS_UPPER_VE
Another SELECT statement uses the SQL function UPPER directly to access the same data source T100.
Since SQL functions cannot yet be used on the left side of LIKE in the DDL of ABAP CDS, the view returns a helper field, which is evaluated in AB_SQL . The results are the same. The search effected by the examples is not case-sensitive.