Hello All,
I have a scenario.
I read a DB table MARA, i will get few records .
now i have to query a Z* table, based on the mara entries, what i got earlier.
but in Z* table contains the material, with two extra characters than mara-matnr.
for eg: if mara-matnr = 12345
Z*-matnr can be 1234500 or/and 12345AB like this.......
I know i can loop through mara entries and select Z* for each of mara entry using like statement.
is there any other better way.
I cant use 'for all entries' with 'like' it is giving a sytax error saying this combination cant be used.
Thanks in advance.
Best Regards
Amrender Reddy B