{"id":7418,"date":"2025-08-06T00:31:32","date_gmt":"2025-08-05T19:01:32","guid":{"rendered":"https:\/\/www.sapewmhelp.com\/?question=ddic-view-vs-cds-view"},"modified":"2025-08-06T00:31:32","modified_gmt":"2025-08-05T19:01:32","slug":"ddic-view-vs-cds-view","status":"publish","type":"question","link":"https:\/\/www.sapewmhelp.com\/?question=ddic-view-vs-cds-view","title":{"rendered":"DDIC View vs CDS View"},"content":{"rendered":"<table>\n<thead>\n<tr>\n<th><strong>Aspect<\/strong><\/th>\n<th><strong>DDIC View<\/strong> (ABAP Dictionary View)<\/th>\n<th><strong>CDS View<\/strong> (Core Data Services View)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Definition Tool<\/strong><\/td>\n<td>Created using <strong>SE11<\/strong> (Graphical interface)<\/td>\n<td>Created using <strong>ADT (Eclipse)<\/strong> with SQL-like DDL syntax<\/td>\n<\/tr>\n<tr>\n<td><strong>Technology Base<\/strong><\/td>\n<td>Classic SAP NetWeaver<\/td>\n<td>Modern SAP HANA \/ S\/4HANA<\/td>\n<\/tr>\n<tr>\n<td><strong>Definition Style<\/strong><\/td>\n<td>GUI-based definition (drag-and-drop style)<\/td>\n<td>Text-based, code-centric with annotations<\/td>\n<\/tr>\n<tr>\n<td><strong>Join Support<\/strong><\/td>\n<td>Basic joins (Inner, Outer)<\/td>\n<td>Advanced joins using <strong>associations<\/strong> and <strong>path expressions<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Annotation Support<\/strong><\/td>\n<td>\u00a0Not supported<\/td>\n<td>\u00a0Yes \u2013 for UI, OData, analytical models, etc.<\/td>\n<\/tr>\n<tr>\n<td><strong>Modularity \/ Reusability<\/strong><\/td>\n<td>\u00a0Limited<\/td>\n<td>\u00a0High \u2013 views can be composed and reused in layers<\/td>\n<\/tr>\n<tr>\n<td><strong>Abstraction Layer<\/strong><\/td>\n<td>Minimal abstraction<\/td>\n<td>Full abstraction of business logic &amp; semantics<\/td>\n<\/tr>\n<tr>\n<td><strong>Access Control<\/strong><\/td>\n<td>Traditional authorization checks<\/td>\n<td>Declarative via <strong>DCL (Data Control Language)<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>UI Integration (Fiori)<\/strong><\/td>\n<td>\u00a0Not supported<\/td>\n<td>\u00a0Fully supported with annotations<\/td>\n<\/tr>\n<tr>\n<td><strong>OData Exposure<\/strong><\/td>\n<td>Manual development required<\/td>\n<td>Direct with <code>@OData.publish: true<\/code> annotation<\/td>\n<\/tr>\n<tr>\n<td><strong>Analytical Capability<\/strong><\/td>\n<td>\u00a0Not suitable for analytics<\/td>\n<td>\u00a0Designed for <strong>OLAP<\/strong>, supports analytical queries<\/td>\n<\/tr>\n<tr>\n<td><strong>HANA Optimization<\/strong><\/td>\n<td>Limited pushdown capability<\/td>\n<td>Fully optimized for <strong>HANA pushdown<\/strong> logic<\/td>\n<\/tr>\n<tr>\n<td><strong>Extendibility<\/strong><\/td>\n<td>\u00a0Not extendable<\/td>\n<td>\u00a0Can be extended via <strong>CDS view extensions<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Integration with RAP<\/strong><\/td>\n<td>\u00a0Not supported<\/td>\n<td>\u00a0Core to RAP-based app development<\/td>\n<\/tr>\n<tr>\n<td><strong>Use Case Suitability<\/strong><\/td>\n<td>Good for simple reports &amp; legacy ABAP scenarios<\/td>\n<td>Ideal for <strong>modern SAP applications<\/strong>, analytics, and services<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","question-category":[173],"question_tags":[178,209,312,313,177],"class_list":["post-7418","question","type-question","status-publish","hentry","question-category-cdsviews","question_tags-abap","question_tags-cds-view","question_tags-ddic-view","question_tags-hana-db","question_tags-sap"],"_links":{"self":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question\/7418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question"}],"about":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7418"}],"wp:attachment":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7418"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion-category&post=7418"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion_tags&post=7418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}