Skip to Content
0
Dec 05, 2014 at 07:29 AM

Select query for the table using user input and internal table

347 Views

I have internal table it_characteristics which is type table of structure characteristics which contains some values name_char which are various characteristics of materials and I have fetch the data from the ausp table based on objek (material number which is entered in selection screen ) and all character values from the internal table it_characteristics .

What would be my select query ?

SELECT objek
atinn
atzhl
mafid
klart
adzhl
atwrt
FROM ausp
INTO TABLE it_ausp
WHERE objek EQ s_object(this is material number)

And now I want feach attn. comparing the name_chares values from the internal table it_characteristics

Means atinn must match with the name_char vales





Attachments

pastedImage_1.png (10.0 kB)
pastedImage_0.png (126.9 kB)