I have

1. ABAP CDS view 1 - ZCD1 : where I am selecting materials from MARA as per a condition and selecting only material columns . This CDS view have a parameter example - MATNR

2. ABAP CDS view 2 - ZCD2 : which have multiple joins with other tables and at the end I would like to put a where condition as below

where MATNR IN ( Select distinct MATNR from ZCD1 )

I am aware IN and select will not work in ABAP CDS view .

What are the option I have to achieve the above requirement.

Requesting Help

regards