SAP SQL EXPR OVER ABEXA

Get Example source ABAP code based on a different SAP table

ABAP_SQLWIN - Window Expressions
This example demonstrates simple window expressions .

ABAP_SOURCE_CODE
DEMO CL_DEMO_SELECT_OVER

ABAP_DESCRIPTION
The example demonstrates how different window functions are applied to windows of a result set of a query defined using PARTITION BY. The content of the columns CHAR1 and CHAR2 is used as a window criterion. All rows that have identical content in these columns form a window. The result of a window function for a row is determined from all rows of the window this row is a part of. The final column perc demonstrates how a window function can be used as arguments of an SQL expression and hence produce row-dependent results, in this case the percentage of the value of the column NUM1 as part of the entire window.