Skip to Content
0
Former Member
Aug 01, 2008 at 01:05 AM

Select statement-Problem while case sensitve

27 Views

HI All,

I am trying to select the Material number(MATNR) from MARA based on the old material number(BISMT).

SELECT MATNR FROM MARA INTO ITAB_MARA

FOR ALL ENTRIES IN ITAB

WHERE BISMT = ITAB-BISMT.

The field MARA-BISMT contains data in upper case and my Internal table contains as lower case.So the select statement is not populating the corresponding records.

Please let me know is it possible to give a check in the select statement.

Or is there any way to change the BISMT column data in ITAB to upper case in one shot rather than going for TRANSLATE in a loop.

Thanks,

Savitha