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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

SAP C_ABAPD_2507 Exam - Topic 2 Question 11 Discussion

Actual exam question for SAP's C_ABAPD_2507 exam
Question #: 11
Topic #: 2
[All C_ABAPD_2507 Questions]

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?

Show Suggested Answer Hide Answer
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.


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

Limited Time Offer

25%

Off

Get Premium C_ABAPD_2507 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Michael
3 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.
upvoted 0 times
...
Casie
3 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.
upvoted 0 times
...
Portia
3 months ago
I think the ON condition should relate the two sources directly, so maybe it's A? But I'm not completely sure.
upvoted 0 times
...
Ludivina
3 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.
upvoted 0 times
...
Vanna
4 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.
upvoted 0 times
...
Emogene
4 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.
upvoted 0 times
...
Susy
4 months ago
A) is the correct answer.
upvoted 0 times
...
Elena
4 months ago
Wait, why would we use $projection? Seems off.
upvoted 0 times
...
Luisa
5 months ago
I think it's A. It directly matches the fields.
upvoted 0 times
...
Marge
5 months ago
Hmm, this looks tricky. I'm not sure which one is the right answer. I'll have to think it through carefully.
upvoted 0 times
...
Jospeh
5 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.
upvoted 0 times
Nieves
4 months ago
I believe the correct ON condition is A. It matches the carrier_id fields directly.
upvoted 0 times
...
...

Save Cancel