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.