{"id":2753,"date":"2024-06-21T08:19:46","date_gmt":"2024-06-21T06:19:46","guid":{"rendered":"https:\/\/www.clavis.biz\/sap-consulting\/core-data-services-cds\/"},"modified":"2025-07-08T11:15:56","modified_gmt":"2025-07-08T09:15:56","slug":"core-data-services-cds-2","status":"publish","type":"page","link":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/","title":{"rendered":"Core Data Services (CDS)"},"content":{"rendered":"\n<div class=\"wp-block-cover alignfull\" style=\"min-height:320px;aspect-ratio:unset;\"><span aria-hidden=\"true\" class=\"wp-block-cover__background has-nv-site-bg-background-color has-background-dim-100 has-background-dim\"><\/span><div class=\"wp-block-cover__inner-container is-layout-flow wp-block-cover-is-layout-flow\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading has-text-align-left has-neve-text-color-color has-text-color\">Core Data Services and CDS Views<\/h2>\n\n\n\n<h3 class=\"wp-block-heading has-neve-text-color-color has-text-color has-link-color wp-elements-6e3952778fb3b0ca17531012a67c9624\">New paradigm requires new infrastructure<\/h3>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-9e0b3784850735ca2c5a5df840a75b99\">With the introduction of S\/4HANA and the SAP HANA platform, a paradigm shift in the development of SAP applications is taking place: all data-intensive work is being shifted to the database in order to achieve the best possible performance. When modeling with CDS, the data models are defined on the database and not on the application server. CDS views are converted as database views, so that all data accesses, calculations are performed at database level.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-f7b76bf16360237c167d87a83eb5d914\">Core Data Services extend SQL and use their own Data Definition Language (DDL). They can be provided with additional annotations or associations. Using DDL enables CDS views to define database tables, database views and data types.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-7c5ca4a762c2051f093e4c65034aa8c4\">In the time before SAP HANA, the SAP stack used the architecture of the application server with the tools ABAP Dictionary and Data Modeler to create the data model.<\/p>\n\n\n\n<p class=\"has-neve-text-color-color has-text-color has-link-color wp-elements-c1cb44ec85c81e6ad6b0c01eb0181c40\">With CDS Views, you can differentiate between ABAP CDS Views and HANA CDS Views depending on the version \/ SAP stack. In principle the CDS views under ABAP and HANA follow a uniform concept with identical purpose for data modelling, but due to the possible use of non-HANA databases in a SAP ECC system, ABAP CDS views use OpenSQL, whereas HANA CDS views use native SQL.<\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n<div class=\"wp-block-cover alignfull\" style=\"min-height:300px;aspect-ratio:unset;\"><span aria-hidden=\"true\" class=\"wp-block-cover__background has-nv-dark-bg-background-color has-background-dim-100 has-background-dim\"><\/span><div class=\"wp-block-cover__inner-container is-layout-flow wp-block-cover-is-layout-flow\">\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"wp-block-image is-style-rounded\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"285\" height=\"285\" src=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/cl_orange_Informationen.png\" alt=\"\" class=\"wp-image-765\" style=\"width:80px;height:80px\" srcset=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/cl_orange_Informationen.png 285w, https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/cl_orange_Informationen-150x150.png 150w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/figure>\n<\/div>\n\n\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-text-align-center has-nv-text-dark-bg-color has-text-color\">Do you have any questions?<br\/>Get in touch with us.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-default\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.clavis.biz\/en\/contact\/\">CONTACT<\/a><\/div>\n<\/div>\n\n\n\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":1006,"parent":2750,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"default","neve_meta_container":"","neve_meta_enable_content_width":"on","neve_meta_content_width":100,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"off","neve_meta_reading_time":"","_ti_tpc_template_sync":false,"_ti_tpc_template_id":"","footnotes":""},"class_list":["post-2753","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Core Data Services (CDS)<\/title>\n<meta name=\"description\" content=\"Data modeling with Core Data Services (CDS) for SAP S\/4HANA: Flexible, efficient and database-independent\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Core Data Services (CDS)\" \/>\n<meta property=\"og:description\" content=\"Data modeling with Core Data Services (CDS) for SAP S\/4HANA: Flexible, efficient and database-independent\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/\" \/>\n<meta property=\"og:site_name\" content=\"clavis berater soziet\u00e4t\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-08T09:15:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1126\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/\",\"url\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/\",\"name\":\"Core Data Services (CDS)\",\"isPartOf\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg\",\"datePublished\":\"2024-06-21T06:19:46+00:00\",\"dateModified\":\"2025-07-08T09:15:56+00:00\",\"description\":\"Data modeling with Core Data Services (CDS) for SAP S\/4HANA: Flexible, efficient and database-independent\",\"breadcrumb\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#primaryimage\",\"url\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg\",\"contentUrl\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg\",\"width\":1920,\"height\":1126,\"caption\":\"Core Data Services_Image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Start\",\"item\":\"https:\/\/www.clavis.biz\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP Technologies\",\"item\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"S\/4 HANA programming model\",\"item\":\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Core Data Services (CDS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.clavis.biz\/en\/#website\",\"url\":\"https:\/\/www.clavis.biz\/en\/\",\"name\":\"clavis berater soziet\u00e4t\",\"description\":\"Beratung f\u00fcr SAP, mobile Anwendungen und Web-Entwicklung\",\"publisher\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.clavis.biz\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.clavis.biz\/en\/#organization\",\"name\":\"clavis berater soziet\u00e4t\",\"url\":\"https:\/\/www.clavis.biz\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png\",\"contentUrl\":\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png\",\"width\":441,\"height\":200,\"caption\":\"clavis berater soziet\u00e4t\"},\"image\":{\"@id\":\"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Core Data Services (CDS)","description":"Data modeling with Core Data Services (CDS) for SAP S\/4HANA: Flexible, efficient and database-independent","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/","og_locale":"en_US","og_type":"article","og_title":"Core Data Services (CDS)","og_description":"Data modeling with Core Data Services (CDS) for SAP S\/4HANA: Flexible, efficient and database-independent","og_url":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/","og_site_name":"clavis berater soziet\u00e4t","article_modified_time":"2025-07-08T09:15:56+00:00","og_image":[{"width":1920,"height":1126,"url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/","url":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/","name":"Core Data Services (CDS)","isPartOf":{"@id":"https:\/\/www.clavis.biz\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#primaryimage"},"image":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg","datePublished":"2024-06-21T06:19:46+00:00","dateModified":"2025-07-08T09:15:56+00:00","description":"Data modeling with Core Data Services (CDS) for SAP S\/4HANA: Flexible, efficient and database-independent","breadcrumb":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#primaryimage","url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg","contentUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/06\/Hintergrund-HANA-pixabay-moon-1527501_1920.jpg","width":1920,"height":1126,"caption":"Core Data Services_Image"},{"@type":"BreadcrumbList","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/core-data-services-cds-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Start","item":"https:\/\/www.clavis.biz\/en\/"},{"@type":"ListItem","position":2,"name":"SAP Technologies","item":"https:\/\/www.clavis.biz\/en\/sap-technologies\/"},{"@type":"ListItem","position":3,"name":"S\/4 HANA programming model","item":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/"},{"@type":"ListItem","position":4,"name":"Core Data Services (CDS)"}]},{"@type":"WebSite","@id":"https:\/\/www.clavis.biz\/en\/#website","url":"https:\/\/www.clavis.biz\/en\/","name":"clavis berater soziet\u00e4t","description":"Beratung f\u00fcr SAP, mobile Anwendungen und Web-Entwicklung","publisher":{"@id":"https:\/\/www.clavis.biz\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.clavis.biz\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.clavis.biz\/en\/#organization","name":"clavis berater soziet\u00e4t","url":"https:\/\/www.clavis.biz\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png","contentUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2024\/05\/clavis-Logo_M.png","width":441,"height":200,"caption":"clavis berater soziet\u00e4t"},"image":{"@id":"https:\/\/www.clavis.biz\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/comments?post=2753"}],"version-history":[{"count":4,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2753\/revisions"}],"predecessor-version":[{"id":4932,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2753\/revisions\/4932"}],"up":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2750"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/media\/1006"}],"wp:attachment":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/media?parent=2753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}