Creating a Data Model

Business Scenario

Your company is planning to develop a set of cloud-based applications based on the SAP Cloud Application Programming Model (CAP), and these applications will be deployed to SAP Business Technology Platform (BTP) as extension applications for the SAP core back-end systems.

In this exercise, you will perform the following tasks:

Create a data model.
Add properties to the data model.
Create an association.

Now, you can start the development of your application. At first, you will model your application, and define the database table and the relationship between the entities.

Note

Note that some of the services that this learning journey links to can incur costs.

If you are concerned about charges, you can opt to skip the corresponding exercises.

Task 1: Create Data Models

Steps

Create the required two Data Models, "Risks" and "Mitigations", to hold the data in this application.
1. Open the SAP Business Application Studio.
2. Select Project Overview from the menu on the left to open the Storyboard.
3. Select the Storyboard entry from the Project Overview by opening Project Actions.
4. Under the Storyboard, look for the Data Models tile and select the + button.
5. Make sure the correct Namespace is selected and click Create.
Configure the Risks entity.
Use the following properties:
Property Name Property Type Max Length
title string 100
prio string 5
descr string 100
impact integer
criticality integer
1. The new entity is shown in the schema.cds tab.
2. Change the name in the header of the entity to Risks.
3. Choose the Show Details icon to be able to add properties.
  A new menu opens on the right side of the screen.
4. Choose the + icon in the properties table. Enter the properties from the preceding table.
Create the entity named Mitigations.
Use the following properties:
Property Name Property Type Max Length
createdAt string 100
createdBy string 100
description string 100
owner string 100
timeline string 100
1. Go back to the schema.cds tab. Choose the Add Entity button in the menu on the top to add another entity.
2. Drop the new entity somewhere on the screen.
3. Choose the entity’s header, and enter the Entity name as Mitigations.
4. Choose the + icon in the Properties menu to add the properties from the preceding table.
  If the menu is not visible, choose the entity’s header and choose the Show Details icon.
  Now, you can see two properties in the schema.cds.
Describe the interconnection between those entities by defining a relationship between risks and mitigations.
Use the following data:
Field Value
Type Association
Direction Bidirectional (default)
Key Property No (default)
Multiplicity To-many
Name risks
Backlink Property miti
1. Find the entry of Mitigations, and choose the header of the table.
2. Choose the Add Relationship icon in the menu on the right.
3. Connect the line to the Risks entity by selecting the Risks entity and configure the relationship in the pop-up screen.
4. Enter the data from the preceding table and choose Create.
5. Choose Save.