i have a internal table with 4 columns. 3 columns having varrious material numbers. i want to check every material with mara table. its available or not?
I need to write a single select queary? how to do this?
My internal table looks like
matnr idnrk s_idnrk normt
test10 10UPC3050 F14839030 test.
i wrotes like below
select matnr from mara into table
i_mara2 for all entries in
i_sub_file
where matnr = i_sub_file-matnr and
matnr = i_sub_file-idnrk and
matnr = i_sub_file-s_idnrk.
Its not working, How to manage this? Anyone help this.
Mohaha