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. First, you will model your application, and define the database table and the relationship between the entities.
NoteNote 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 and watch the simulation instead.
Exercise Options
You can perform this exercise in two ways:
- Live Environment – by using the instructions provided below, you can perform the steps in your SAP BTP account.
- Platform Simulation – follow the step-by-step instructions within the simulation.
NoteThe following simulation reproduces the full exercise execution:
Task 1: Create Data Models
Steps
Create the required two Data Models, "Risks" and "Mitigations", to hold the data in this application.
To create a data model, open SAP Business Application Studio.
To open the Home tab, select Project Explorer from the menu on the left.
From the Project Explorer select the Home entry.
Under the Home tab, look for the tile Data Models.
Choose the + icon to add a new entity.
Configure the Entity Risks.
Use the following properties:
Property Name Property Type Max Length title string 100 prio string 5 descr string 100 impact integer criticality integer As Entity Name enter Risks.
Choose the + icon in the table, and enter the properties from the table above.
Choose Create.
Create the entity named Mitigations.
Use the following properties:
Property Name Property Type Max Length description string 100 owner string 100 timeline string 100 Back in the Data Model Editor, choose the Add Entity button in the menu on the top to add another entity.
To edit the entity, choose the entity’s header, and choose the Edit Entity icon.
Enter the Entity name Mitigations, and choose the + icon in the table to add the properties from the table above:
Enter the Entity name Mitigations.
Choose the + icon in the table, and add the properties from the table above
Choose Update to finish.
Now you can see two properties in the Data Model Editor. In a next step, you will describe the interconnection between those entities by defining a relationship, so that each risk has a mitigation associated to it.
Find the entry of Risks, and choose the header of the table.
Choose the Add Relationship icon in the menu on the right. Connect the line to the Mitigations entity by selecting the Mitigations entity, and configure the relationship in the pop-up.
In the pop-up screen, enter all the required details:
Field Value Relationship Association Relationship Type To-one Property name miti Enter the data from the table above.
Choose Create.
Repeat the step for Mitigations.
Find the entry of Mitigations, and choose the header of the table.
Choose the Add a relationship icon in the menu on the right.
Connect the line to the Risks entity by selecting the Risks entity, and configure the relationship in the pop-up.
In the pop-up screen, select all the required details:
Field Value Backlink Property miti Property Name risks Relationship type To-many Relationship Association Add the required details.
Choose Create.
Include the Aspect global.managed.
Back in the Data Model Editor, choose the header of the Risks entry
Choose the Include Aspects icon in the appeared menu. This allows us to be flexible and extend definitions to new elements, as well as override properties and annotations.
In the pop-up, choose managed from the list, and choose Select.
The managed aspect allows to track changes made in the data.
Repeat the steps for Mitigations.
Choose the header of the Mitigations entry, and choose the Include Aspects icon in the appeared menu.
In the pop-up, choose managed from the list, and choose Select.
