https://community.sap.com/t5/application-development-and-automation-discussions/what-is-the-difference-between-cds-view-database-view-at-the-execution/m-p/12196301#M1981300 <P><SPAN class="mention-scrubbed">zsai_varma</SPAN></P><P>There are many other reasons why we choose CDS over Database views:</P><P>1) Database View only support Inner Joins where as CDS supports Inner Join, Outer Join, Union.</P><P>2) You can easily generate the ODATA services which will be further used for UI5 and FIORI elements.</P><P>3) Implicit Authorizations Checks are supported in CDS.</P><P>4) CDS functions on CODE push Down principle which gives them an edge.</P><P>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.</P><P>Regards!</P> Fri, 17 Apr 2020 07:45:02 GMT former_member1716 2020-04-17T07:45:02Z https://community.sap.com/t5/application-development-and-automation-discussions/what-is-the-difference-between-cds-view-database-view-at-the-execution/m-p/12196300#M1981299 <P>CDS Views got extra features like aggregate functions, union, view on view .,etc.</P> <P>I got it, but at execution level, lets say I have joined 3 tables , no aggregate functions, no complex code.</P> <P>What is the difference between creating cds view / se11 database view for above requirement?</P> Fri, 17 Apr 2020 06:26:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-the-difference-between-cds-view-database-view-at-the-execution/m-p/12196300#M1981299 former_member665806 2020-04-17T06:26:48Z https://community.sap.com/t5/application-development-and-automation-discussions/what-is-the-difference-between-cds-view-database-view-at-the-execution/m-p/12196301#M1981300 <P><SPAN class="mention-scrubbed">zsai_varma</SPAN></P><P>There are many other reasons why we choose CDS over Database views:</P><P>1) Database View only support Inner Joins where as CDS supports Inner Join, Outer Join, Union.</P><P>2) You can easily generate the ODATA services which will be further used for UI5 and FIORI elements.</P><P>3) Implicit Authorizations Checks are supported in CDS.</P><P>4) CDS functions on CODE push Down principle which gives them an edge.</P><P>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.</P><P>Regards!</P> Fri, 17 Apr 2020 07:45:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-the-difference-between-cds-view-database-view-at-the-execution/m-p/12196301#M1981300 former_member1716 2020-04-17T07:45:02Z