SAP CDS SET OPERATORS



Get Example source ABAP code based on a different SAP table
  



ABAP_CDS_DDL - CDS View Entity, Set Operators
Set operators merge the result sets of multiple queries into a single result set. In CDS view entities, the following set operators are available:
EXCEPT returns all distinct rows of the first result set that are not part of the following result sets.
INTERSECT returns all distinct rows that are part of all result sets.
UNION merges the result sets of all queries.
The following image illustrates how each set operator merges several result sets:
IMAGE ABDOC_SET_operators.jpg 700 195