Skip to Content
0
Former Member
Sep 07, 2007 at 01:34 PM

Help in select query

17 Views

Hi all,

I have an internal table itab with material.

lets say my itab has

a

b

Then i have to get the data from another ztable say zabc

if not itab[] is initial.

select matnr max ( zid ) from zabc into table itab1 for all enteries in itab where matnr = itab-matnr.

  • syntax error

endif.

i have data in zabc as

fld1 matnr zid

1 a 1

2 a 1

3 b 2

4 b 2

5 b 2

in itab1 i need

like

2 a

5 b

any combination but i need only row that mateches material no

Let mne know the logic the my select query seems to be incorrect

Thanks

Suchitra