Ansicht
Dokumentation

ABENPATH_EXPR_IN_FROM_CLAUSE_ABEXA - PATH EXPR IN FROM CLAUSE ABEXA

Path Expressions, Use in the FROM Clause

This example demonstrates path expressions in the FROM clause in .

Source Code

Execute

Description

The first SELECT statement accesses the CDS view demo_cds_assoc_sairport_tz:

This view exposes its CDS association _spfli in its SELECT list. The CDS association _spfli uses the view demo_cds_assoc_spfli_scarr as an association target:

This view exposes its CDS association _scarr in its SELECT list, making it possible to specify it in path expressions after _spfli. This CDS association uses a DDIC database table as a data source and always closes a path expression.

In the FROM clause, the first SELECT statement uses a path expression with the CDS associations \_spfli and \_scarr after the name of the CDS view. The names of all carriers are read that depart from airports in a specific time zone. The time zone is a parameter of CDS view demo_cds_assoc_sairport_tz, and a value is passed to it. Further restrictions apply to the local currency of the airline in a filter condition for the CDS association _scarr and on the flight time in a filter condition for the CDS association _spfli

The second SELECT statement demonstrates which joins and conditions must be created in to achieve the same result. This is guaranteed by an assertion.