SAP ABAP SQL -Upper function

Tue Dec 30, 2025

Using UPPER in SQL

Requirement

I need to fetch MATNR based on CCNGN

🔲 In the above data set we need to fetch MATNR 2 with CCNGN b.2.Ba , b.2.BA , B.2.Ba , b.2.bA ,B.2.aA,B.2.BA orb.2.ba

below is the code for that

DATA(lv_ccngn) = 'B.2.BA'.

TRANSLATE lv_ccngn TO UPPER CASE.

SELECT matnr FROM zac_employee

* WHERE ccngn = @lv_ccngn. ENDSELECT..

WHERE UPPER( ccngn ) = @lv_ccngn

INTO @DATA(lv_matnr).ENDSELECT.

IF sy-subrc EQ 0.

WRITE lv_matnr.

ENDIF.

LearnABAP.IO

10 plus in ABAP | ex Deloitte | 2X certified

Insta - abapcafe Telegram - abapcafe Linkedin - learnabap.io