Given the following Core Data Service view entity data definition:
@AccessControl.authorizationCheck: #NOT_REQUIRED
DEFINE VIEW ENTITY demo_cds_param_view_entity
WITH PARAMETERS
p_date : abap.dats
AS SELECT FROM sflight
{
key carrid,
key connid,
key fldate,
price,
seatsmax,
seatsocc
}
WHERE fldate >= $parameters.p_date;
Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the parameter on line #4?
Note: There are 2 correct answers to this question.
Show Answer
Hide Answer
Correct Answer:
A, B
Parameters in CDS view entities (WITH PARAMETERS) must always be supplied when querying. In ABAP SQL, the syntax rules are:
A . Correct
Supplying a literal date ('20230101') directly is valid because the parameter p_date is of type abap.dats.
B . Correct
Supplying a value via an ABAP expression using @( ... ) is syntactically correct. Here, cl_abap_context_info=>get_system_date( ) returns the current system date in ABAP Cloud-compliant way, and is wrapped with @() for expression embedding. This is the best practice in ABAP Cloud development.
C . Incorrect
Backticks (`...`) are used in ABAP for string templates, not for literals in this context. A date literal must be in quotes '...'.
D . Incorrect
:$session.system_date is not valid in ABAP SQL. Session variables like $session.* are supported in HANA SQL, but in ABAP CDS view consumption via ABAP SQL, this is not allowed.
Therefore, only A and B are correct.
Reference:
ABAP CDS Development User Guide -- section on CDS View Entity Parameters and ABAP SQL parameter passing rules; ABAP Cloud development guidelines on cl_abap_context_info=>get_system_date.
