Given the following Core Data Service View Entity Data Definition:
@AccessControl.authorizationCheck: #NOT_REQUIRED
DEFINE VIEW ENTITY demo_flight_info_union AS
SELECT FROM scustom {
KEY id,
KEY 'Customer' AS partner,
name,
city,
country
}
UNION
SELECT FROM stravelag {
KEY agencynum AS id,
'Agency' AS partner,
name,
city,
country
}
When you attempt to activate the definition, what will be the response?
Show Answer
Hide Answer
Correct Answer:
D
In CDS UNION, field names and positions must match exactly across all SELECT statements.
In this case, the first SELECT uses id, while the second uses agencynum AS id, which is fine. However, the literal 'Customer' AS partner and 'Agency' AS partner create inconsistencies.
SAP CDS guidelines specify that for a UNION, field names must be identical and aligned in order; mismatches cause an activation error.
Study Guide Reference: ABAP CDS Development User Guide -- Union Compatibility Rules.
