Query CDS view with table as input

[Khushdeep]

Hi Expert,

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.

Regards,

Khushdeep

[former_member194416]

Hi Khushdeep,

I am using CDS's for quite some time, I can not really imagine such case that you mentioned. In my opinion instead of using a internal table as input you may try to put the logic which creates the internal table in your CDS using joins etc or If you will call the view via ABAP you can use  below alternative in ABAP Select ( Open SQL ) to have for all entries logic.

"Select * from cds_view for all entries in internal table"

Regards,

Gungor