How to select all data from a table to a structure using one select statement?

SELECT * from /brlt/subsc INTO dup_table WHERE Type = ls_request_input_data-Type AND Dl1 = ls_request_input_data-Dl1.
ENDSELECT.

The statement above is going in a loop instead of selecting all rows at once in a structure.