Skip to Content
0
Former Member
Mar 24, 2009 at 09:54 AM

Logic required for select query

32 Views

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