SAP SELECT EXCEPT MIN ABEXA



Get Example source ABAP code based on a different SAP table
  



SELECT, Difference with Aggregate Expression
This example demonstrates how a difference is created across a table using an aggregate expression.

ABAP_SOURCE_CODE
DEMO CL_DEMO_SELECT_EXCEPT_MIN

ABAP_DESCRIPTION
EXCEPT is used to create the difference of the result sets of two SELECT statements for the same DDIC database table. The first SELECT statement reads all flights for a carrier and the second SELECT statement aggregates the flights by connection, adding the minimum number of occupied seats. The entire result contains only the non-aggregated rows as they are only available in the first result set.