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