Select Query for *

How to select all material starting with TL from Master. Make use of * in select query.



Here is the program for it.

report zusing_star.
constant c_mat type mara-matnr value 'TL%'.

types : begin of st_mara,
 matnr type mara-matnr,
end of st_mara.

data it_mara type table of st_mara.

select matnr from mara
into table it_mara
where matnr like c_mat.

it_matnr contains all material tarting with TL.