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