{"id":2626,"date":"2024-06-18T12:07:05","date_gmt":"2024-06-18T10:07:05","guid":{"rendered":"https:\/\/www.clavis.biz\/sap-consulting\/sap-tm-transportation-management\/"},"modified":"2025-12-23T10:46:37","modified_gmt":"2025-12-23T09:46:37","slug":"cap-data-model","status":"publish","type":"page","link":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/","title":{"rendered":"CAP Data model"},"content":{"rendered":"\n
<\/span>
\n
\n

Basics of the Cloud Application Programming Model<\/h2>\n\n\n\n

The SAP Cloud Application Programming Model (CAP) is a framework for the rapid development of cloud-based business applications. It offers a structured architecture, clear conventions and powerful tools for efficiently modeling, implementing and providing backend services. At the heart of the modeling is the declarative data model with CDS (Core Data Services), which together with services and entities forms the basis of a CAP application. <\/p>\n<\/div><\/div>\n<\/div><\/div>\n\n

<\/span>
\n
<\/div>\n\n\n\n
\n

Structure of the data model in CAP<\/h3>\n\n\n\n

A CAP project usually consists of several central components:<\/p>\n\n\n\n

\n
\n

Data Models (CDS-Model)<\/h4>\n<\/div>\n\n\n\n
\n
\n<\/div>\n<\/div>\n\n\n\n
\n
<\/div>\n\n\n\n
\n

The data structure is described in .cds files. Entities (e.g. Books, Authors) are defined here, including fields, types, relationships (associations) and validations.Example: A Books entity with fields such as title, author, price, pages.<\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n

\n
\n
\n

Service-Definition (OData V4)<\/h4>\n<\/div>\n\n\n\n
\n
\n<\/div>\n<\/div>\n\n\n\n
\n
<\/div>\n\n\n\n
\n

To make data from the entities available, services are defined, usually in the srv folder. These automatically generate OData v4 APIs with CRUD functionality (Create, Read, Update, Delete). <\/p>\n<\/div>\n<\/div>\n\n\n\n

\n
\n
\n

Associations<\/h4>\n<\/div>\n\n\n\n
\n
\n<\/div>\n<\/div>\n\n\n\n
\n
<\/div>\n\n\n\n
\n

Entities can be linked to each other – e.g. a book to an author. CAP automatically generates foreign keys such as author_ID.Relationships can be \u201cto one\u201d or \u201cto many\u201d.<\/p>\n\n\n\n

.<\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n

<\/span>
\n
\n
<\/div>\n\n\n\n

Test & Interaction<\/h3>\n\n\n\n

CAP provides an integrated server for local development. The APIs can be tested using simple HTTP requests (e.g. with an .http file or tools such as Postman). CAP offers clear naming conventions for URLs and supports parameters such as $expand to deliver linked data (e.g. author of a book). <\/p>\n<\/div><\/div>\n<\/div><\/div>\n\n

<\/span>
\n
\n
<\/div>\n\n\n\n

Deployment & Runtime<\/h3>\n\n\n\n

A locally developed CAP project can be deployed in the SAP Business Technology Platform (BTP) – initially locally with SQLite, later productively with SAP HANA, for example.<\/p>\n<\/div><\/div>\n\n\n\n

HANA integration<\/summary>\n

The project is prepared for SAP HANA via cds add hana. The database structure is then created automatically during deployment. <\/p>\n<\/details>\n\n\n\n

Authentication with XSUAA<\/summary>\n

The integration of xsuaa enables role-based access control and secure authentication in the BTP environment.<\/p>\n<\/details>\n\n\n\n

MTA (Multi-Target Application) SUAA<\/summary>\n

An MTA project is created for the deployment, which bundles all modules (e.g. service, DB, Auth). After the build, an .mtar archive is created that can be deployed to the BTP.<\/p>\n<\/details>\n\n\n\n

HDI-Container<\/summary>\n

The HANA database runs in a so-called HDI container – an isolated environment in which tables and views of the CAP project are managed.<\/p>\n<\/details>\n\n\n\n

<\/div>\n<\/div><\/div>\n\n
<\/span>
\n
<\/div>\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n
<\/div>\n\n\n\n

Do you have any questions?Get in touch with us.<\/p>\n\n\n\n

\n
CONTACT<\/a><\/div>\n<\/div>\n\n\n\n
<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":4852,"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-2626","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\nTransportation Management<\/title>\n<meta name=\"description\" content=\"Optimize your transportation process from planning and execution to monitoring and billing with SAP SAP TM (Transportation Management)\" \/>\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\/cap-data-model\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transportation Management\" \/>\n<meta property=\"og:description\" content=\"Optimize your transportation process from planning and execution to monitoring and billing with SAP SAP TM (Transportation Management)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/\" \/>\n<meta property=\"og:site_name\" content=\"clavis berater soziet\u00e4t\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-23T09:46:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.clavis.biz\/wp-content\/uploads\/2025\/07\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1124\" \/>\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=\"2 minutes\" \/>\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\\\/cap-data-model\\\/\",\"url\":\"https:\\\/\\\/www.clavis.biz\\\/en\\\/sap-technologies\\\/s-4-hana-programming-model\\\/cap-data-model\\\/\",\"name\":\"Transportation Management\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.clavis.biz\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.clavis.biz\\\/en\\\/sap-technologies\\\/s-4-hana-programming-model\\\/cap-data-model\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.clavis.biz\\\/en\\\/sap-technologies\\\/s-4-hana-programming-model\\\/cap-data-model\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.clavis.biz\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg\",\"datePublished\":\"2024-06-18T10:07:05+00:00\",\"dateModified\":\"2025-12-23T09:46:37+00:00\",\"description\":\"Optimize your transportation process from planning and execution to monitoring and billing with SAP SAP TM (Transportation Management)\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.clavis.biz\\\/en\\\/sap-technologies\\\/s-4-hana-programming-model\\\/cap-data-model\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.clavis.biz\\\/en\\\/sap-technologies\\\/s-4-hana-programming-model\\\/cap-data-model\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.clavis.biz\\\/en\\\/sap-technologies\\\/s-4-hana-programming-model\\\/cap-data-model\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.clavis.biz\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg\",\"contentUrl\":\"https:\\\/\\\/www.clavis.biz\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg\",\"width\":1920,\"height\":1124,\"caption\":\"Symbolbild CAP Datenmodell\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.clavis.biz\\\/en\\\/sap-technologies\\\/s-4-hana-programming-model\\\/cap-data-model\\\/#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\":\"CAP Data model\"}]},{\"@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":"Transportation Management","description":"Optimize your transportation process from planning and execution to monitoring and billing with SAP SAP TM (Transportation Management)","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\/cap-data-model\/","og_locale":"en_US","og_type":"article","og_title":"Transportation Management","og_description":"Optimize your transportation process from planning and execution to monitoring and billing with SAP SAP TM (Transportation Management)","og_url":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/","og_site_name":"clavis berater soziet\u00e4t","article_modified_time":"2025-12-23T09:46:37+00:00","og_image":[{"width":1920,"height":1124,"url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2025\/07\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/","url":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/","name":"Transportation Management","isPartOf":{"@id":"https:\/\/www.clavis.biz\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/#primaryimage"},"image":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/#primaryimage"},"thumbnailUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2025\/07\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg","datePublished":"2024-06-18T10:07:05+00:00","dateModified":"2025-12-23T09:46:37+00:00","description":"Optimize your transportation process from planning and execution to monitoring and billing with SAP SAP TM (Transportation Management)","breadcrumb":{"@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/#primaryimage","url":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2025\/07\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg","contentUrl":"https:\/\/www.clavis.biz\/wp-content\/uploads\/2025\/07\/Hintergrund_CAP_c_Pexels_Pixabay_1920.jpg","width":1920,"height":1124,"caption":"Symbolbild CAP Datenmodell"},{"@type":"BreadcrumbList","@id":"https:\/\/www.clavis.biz\/en\/sap-technologies\/s-4-hana-programming-model\/cap-data-model\/#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":"CAP Data model"}]},{"@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\/2626","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=2626"}],"version-history":[{"count":5,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2626\/revisions"}],"predecessor-version":[{"id":4934,"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/pages\/2626\/revisions\/4934"}],"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\/4852"}],"wp:attachment":[{"href":"https:\/\/www.clavis.biz\/en\/wp-json\/wp\/v2\/media?parent=2626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}