What is the difference between CDS View & Database View at the execution level?

[former_member665806]

CDS Views got extra features like aggregate functions, union, view on view .,etc.

I got it, but at execution level, lets say I have joined 3 tables , no aggregate functions, no complex code.

What is the difference between creating cds view / se11 database view for above requirement?

[former_member1716]

zsai_varma

There are many other reasons why we choose CDS over Database views:

1) Database View only support Inner Joins where as CDS supports Inner Join, Outer Join, Union.

2) You can easily generate the ODATA services which will be further used for UI5 and FIORI elements.

3) Implicit Authorizations Checks are supported in CDS.

4) CDS functions on CODE push Down principle which gives them an edge.

Starting from latest version 7.4 SP05, Same SQL statements may yield same performance in both Dictionary view and CDS view but due to more flexibility in CDS views are preferred.

Regards!