SAP SELECT UNION CDS PARA ABEXA

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

SELECT, Union of CDS View Entity with Input Parameters
This example demonstrates a union of a CDS view with input parameters.

ABAP_SOURCE_CODE
DEMO CL_DEMO_CDS_PARAMETERS_UNIT

ABAP_DESCRIPTION
This example uses two SELECT statements joined using UNION to access the following CDS view entity.
DDLS DEMO_CDS_PARAMETERS
This fills the input parameter p_unit with different values.