Skip to Content
0
Former Member
Mar 05, 2009 at 06:15 AM

best way to query

24 Views

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