Kontakt

Ansicht
Dokumentation

ABENCDS_SET_OPERATORS - CDS SET OPERATORS

ABENCDS_SET_OPERATORS - CDS SET OPERATORS

BAL_S_LOG - Application Log: Log header data   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

- 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@@




General Data in Customer Master   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 1259 Date: 20240511 Time: 181218     sap01-206 ( 25 ms )