Adding Sample Data

Objectives

After completing this lesson, you will be able to:

  • Add sample data

Add Sample Data

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 task: Add sample data to entities.

Once the structure of your application is finished, you can add sample data to the application. You either can use the visual data editor, or insert data using a CSV file.

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 and watch the simulation instead.

Exercise Options

You can perform this exercise in two ways:

  1. Live Environment / Practice System: you can perform the steps provided below, either in your SAP BTP account or you use the "Practice System Access" provided below.
  2. Simulation: follow the step-by-step instructions within the simulation.
Note

You can try out this exercise in the practice system below. Open the system by clicking on the bottom on the end of this page.

Please note that the practice system access only covers access to the SAP Business Application Studio. When deploying to an SAP BTP runtime or consuming other SAP BTP services, you have to use an SAP BTP Trial Account, Free-Tier, or an Enterprise Account.

Note
We recommend performing the steps in the live environment first.

The following simulation reproduces the full exercise execution:

ExerciseStart Exercise

Task 1: Add Sample Data in Different Ways

Steps

  1. Add a new data entity and create data for the entity A_BusinessPartner.

    1. In the Storyboard, select Open Editor and choose Sample Data from the drop-down menu.

    2. In the Search field, enter Business

    3. From the list of entities, select A_BusinessPartner.

    4. Set Mock Data to off. In the Number of rows field, enter 3. Choose Add.

    5. In row 1, add the following data:

      FieldValue
      BusinessPartner3270
      Customer202
      Supplier1018
      BusinessPartnerCategory7
      BusinessPartnerFullNameNue Tech inc
      Note
      The data is stored automatically.

    6. In row 2, add the following data:

      FieldValue
      BusinessPartner2803
      Customer245
      Supplier1403
      BusinessPartnerCategory6
      BusinessPartnerFullNameExpo Technologies Plc

    7. In row 3, add the following data:

      FieldValue
      BusinessPartner3510
      Customer1710
      Supplier374
      BusinessPartnerCategory7
      BusinessPartnerFullNameInlandskunde DE80

  2. For the entities Mitigations and Risks it is possible to import predefined sample data.

    1. At first download the CSV file with the required data for Mitigations. You find the file here: https://education.hana.ondemand.com/education/pub/mmcp/group/GR_1C5B25FF9CC48BA3/718A8FCC99228C80.csv?download=1.

    2. Rename the downloaded file.

      The name of the csv file must contain the name of the project you created in the exercise Create a New Project and the name of the entity you created for mitigations in the exercise Create and Configure a Data Model. (If you use the naming proposed in this learning journey, you have to rename the csv file to RiskManagement-Mitigations.csv.

    3. Go back to the Storyboard tab of the application.

    4. Find the Data Models tile.

    5. Select the entry Mitigations. Choose Add Sample Data.

    6. Choose the Import button.

    7. Select the downloaded and renamed file.

      Note

      The sample data will automatically be saved for the selected entity.

    8. Download the CSV file with the required data for Risks. You find it here: https://education.hana.ondemand.com/education/pub/mmcp/group/GR_1C5B25FF9CC48BA3/A933D368B6F7B080.csv?download=1

    9. Rename the downloaded file to RiskManagement-Risks.csv.

      The name of the csv file must contain the name of the project you created in the exercise Create a New Project and the name of the entity you created for mitigations in the exercise Create and Configure a Data Model. (If you use the naming proposed in this learning journey, you have to rename the csv file to RiskManagement-Risks.csv.

    10. Repeat the steps 3 to 7 (c to g) with Risks.

Practice System

Log in to track your progress & complete quizzes