Get Example source ABAP code based on a different SAP table
SELECT, Intersection with Aggregate Expression This example demonstrates how an intersection is created across a table using an aggregate expression.
ABAP_SOURCE_CODE DEMO CL_DEMO_SELECT_INTRSCT_MAX
ABAP_DESCRIPTION INTERSECT is used to create the intersection of the result sets of two SELECT statements for the same DDIC database table. The first SELECT statement reads all flights and the second SELECT statement aggregates the flights by connection, determining the maximum number of occupied seats. The entire result contains the aggregated rows checked against the associated rows of the first result set. Only the connections with the highest seats occupation are shown.
