Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

SAP C_ABAPD_2507 Exam - Topic 2 Question 11 Discussion

Posted by Myong on Nov 23, 2025 at 06:53 PM

You have the following CDS definition (aliases shown):

define view entity Z_ENTITY

as select from Z_SOURCE1 as _Source1

association to Z_SOURCE2 as Source2 on ???

{

key carrier_id as Carrier,

key connection_id as Connection,

cityfrom as DepartureCity,

cityto as ArrivalCity,

Source2

}

(The data sources are joined by the field carrier_id. The corresponding field in Z_SOURCE2 is also carrier_id.)

Which ON condition must you insert?

Suggested Answer: D

In a CDS view entity defined AS SELECT FROM, the association ON condition must use the source aliases defined in the FROM clause.

$projection is used in projection views (AS PROJECTION ON ...), not in a basic select view entity. Therefore, options using $projection (B, C) are invalid here.

Using global names (Z_SOURCE1, Z_SOURCE2) in the ON (A) ignores the declared aliases and is not the recommended/valid form within the view definition.

The correct ON clause uses the aliases _Source1 and Source2 with the matching key fields:

ON _Source1.carrier_id = Source2.carrier_id (D).

This aligns with CDS modeling rules in RAP: use aliases consistently and model associations with precise ON conditions based on keys.

Study Guide Reference: ABAP CDS Development---Associations & ON conditions; RAP Data Modeling.


Get Premium C_ABAPD_2507 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
12 comments · newest first
MI
Michael 10 months ago
I'm a bit confused about the use of $projection in option B. I don't recall seeing that in our examples, so I might skip that one.
CA
Casie 10 months ago
I remember practicing a similar question where we had to match keys between two sources. I think D could be the right choice since it uses the aliases correctly.
PO
Portia 10 months ago
I think the ON condition should relate the two sources directly, so maybe it's A? But I'm not completely sure.
LU
Ludivina 10 months ago
I think I've got it! The ON condition should use the field names from the data sources, not the aliases. So option D is the correct answer.
VA
Vanna 10 months ago
I'm a bit confused here. The question mentions aliases, but the options don't seem to match the aliases used in the definition. I'll have to double-check the syntax.
EM
Emogene 11 months ago
Okay, let's see. The data sources are joined by the field carrier_id, so the ON condition should reference that field. I'm leaning towards option D.
SU
Susy 11 months ago
A) is the correct answer.
EL
Elena 11 months ago
Wait, why would we use $projection? Seems off.
LU
Luisa 11 months ago
I think it's A. It directly matches the fields.
MA
Marge 12 months ago
Hmm, this looks tricky. I'm not sure which one is the right answer. I'll have to think it through carefully.
JO
Jospeh 12 months ago
I think I know how to approach this one. The key is to look at the association definition and the data sources to determine the correct ON condition.
NI
Nieves 11 months ago
↳ replying to Jospeh
I believe the correct ON condition is A. It matches the carrier_id fields directly.
0/2000 characters

Save Cancel