scarr | An end-to-end tool for S3 cloudfront static sites

Here is one possible workaround using dynamic approach:

In release 7.40, or even in ABAP 7.52, cl_demo_output=>display can only display an internal table with a list of elementary components (string, i, c, etc.)

In your case, the internal table t_result is automatically declared with three components, the second one being a structure, which is not an elementary type.

It's a structure because you used ~*. Instead, declare each column explicitly (spfli~carrid, spfli~connid, ...)

NB: the class cl_demo_output should not be used productively. If you need a generic tool, create your own tool, for instance based on the class cl_salv_table.

I guess you need a simple LIMIT and ORDER BY Clause -

EDIT: I see that you two already solved the problem in comments.

As Sandra wrote, you could try using cl_salv_table. It should look like this:

There is no simple ABAP SQL syntax as you propose, but there are the following workarounds.

Since 7.51, you may use Common Table Expressions:

I've got no answer whether it's possible to omit the initial "RESULT" tag in full sXML, but my opinion is NO.

Now, there's the solution with the KISS principle :

Here's a solution that makes use of grobs, since I couldn't think of any hack within ggplot that works without repetition in individual facet plots...

Step 0: Create a complete ggplot. This should include all the geoms, coordinate transformations, themes, etc:

The index logic is pretty ugly, you can easily use the ASSIGNING addition to the APPEND command to get a field symbol to the newly added line. You can then use that field symbol to fill the table entry using the same VALUE construct you are using now.

Or you can do it in one statement: