I have a requirement where I have to pass table as input to CDS View and query it.
similar to ABAP query like this:
select * from table_name for all entries in input_table where column_name1 = input_table-column_name into table result_table.
here in above query, as we provide input_table as an input based on which , the matching rows are queried.
So in CDS View, is there a similar SQL query where I can pass a table as an input.