Ansicht
Dokumentation

ABENSQL_FUNCTION_UPPER_ABEXA - SQL FUNCTION UPPER ABEXA

ABENSQL_FUNCTION_UPPER_ABEXA - SQL FUNCTION UPPER ABEXA

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

- SQL Function UPPER

This example demonstrates the SQL function UPPER in and ABAP CDS.

Source Code

Execute

Description

A SELECT statement accesses the following CDS DDIC-based view and view entity, which use the SQL function UPPER:

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 . The results are the same. The search effected by the examples is not case-sensitive.






RFUMSV00 - Advance Return for Tax on Sales/Purchases   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 1078 Date: 20240510 Time: 234935     sap01-206 ( 29 ms )