Skip to Content
0
Jul 02, 2020 at 06:15 AM

CDS view with parameters

431 Views

Hello,

I have created a CDS view with parameters:

define view ZI_CustomerHierarchy with parameters 
p_kunnr: kunnr, p_vkorg: vkorg, p_vtweg: vtweg, p_spart: spart, p_datbi: datbi_kh, p_datab: datab_kh 
as select from knvh as hier0 ........

Now I want to call the CSD view with parameters in another CDS view where the parameters will be equal to fields of the second CDS view:

define view ZI_REV_Detail as select from KNA1 inner join ZI_CustomerHierarchy( p_kunnr = kna1.kunnr ......).

It seems that it is not possible. Is thete anby workaround?

I was thinking to use CDS table function instead.

thank you for yuor advices

Christophe