GitHub

008 open sql.md

This is a simple Open SQL example. Select all fields from DDIC table spfli into inner table gt_spfli. In this case, old Open SQL syntax still works. SELECT * APPENDING CORRESPONDING FIELDS OF TABLE gt ...
GitHub

10_ABAP_SQL_Hierarchies.md

This cheat sheet summarizes the functions ABAP SQL offers together with ABAP CDS for working with hierarchical data that is stored in database tables. Hierarchical data in database tables means that ...
Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
Simon Fraser University

CREATE VIEW Statement

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...