What is CDS Views ? Syntax to create parameter based views? syntax to create Association. How to publish CDS views

Question

Accepted Answer

CDS Views are virtual database views in SAP HANA. They can be parameter-based and have associations. They are published using annotations.

CDS Views are virtual database views in SAP HANA
Syntax to create parameter-based views: @AbapCatalog.sqlViewName: 'view_name' @AccessControl.authorizationCheck: #NOT_REQUIRED define view view_name(parameter_name) as select from table_name where field_name = :parameter_name
Syntax to create Association: define view view_name as select from entity1 as e1 association to entity2 as e2 on e1.field_name = e2.field_name
To publish CDS views, use annotations like @OData.publish: true

Top Accenture SAP ABAP Hana Developer interview questions & answers