SAP SELECT INTER CDS PARA ABEXA

Get Example source ABAP code based on a different SAP table
  SAP Help

SELECT, Intersection of CDS View Entity with Input Parameters
This example demonstrates an intersection of a CDS view with input parameters.

ABAP_SOURCE_CODE
DEMO CL_DEMO_CDS_PARAMETERS_INTRSCT

ABAP_DESCRIPTION
This example uses a common table expression and two SELECT statements joined using INTERSECT to access the following CDS view entity.
DDLS DEMO_CDS_PARAMETERS
This fills the input parameter p_unit with different values.