ALV with ida access

Dear all,

New bie to hana abap.

If i switch to ALV with IDA access.I get that i can use simple one table data query with selection parameter through passing parameter in methods of ALV.

But when now from this data ,i have to retrieve further data using for all entries from some different table ,then what is the right approach from performance perspecitve ?

If suppose i use cds view,even there could be a situation that anytime further i may have to use another for all entries of same itab.