Develop a CAP Node App Using SAP Business Application Studio

1. From the SAP Business Application Studio hamburger menu, select File > New Project from Template.

2. Select the CAP Project template, and click Start.

   

3. Enter bookshop as the name for the project.

4. Select the SAP HANA Cloud checkbox.

   

5. Click Finish.

   The project is generated and opens in the Storyboard.

   

1. In the Data Models tile, click + to create a data model entity.

   

2. Click Create.

   

   It may take a few moments for the Graphical Modeler to be populated.

3. Change the entity name to Books.

   

4. Click on the entity and then click on the

   

   (Show Details) icon.

   

5. In the Properties pane, click + to add new properties.

   

6. Add the following properties:

   Name	Type
   title	String
   descr	String
   stock	Integer
   price	Decimal

   The Books entity should look like this:

   

7. Click Add Entity.

   

8. Rename the new entity Authors.

9. In the Properties pane, click + to add a new property.

   

10. Add the following property:

    Name	Type
    name	String

11. Click Add Entity.

    

12. Rename the new entity Genres.

13. Click on the Authors entity and then click on the Add Relationship icon.

    

14. Drag the arrow to the Books entity.

    

15. In the Relationship Details dialog, select the To-One radio button for the Cardinality and click OK.

    

16. Click on the Genres entity and then click on the Add Relationship icon.

    

17. Drag the arrow to the Books entity.

    

18. In the Relationship Details dialog, select the Composition radio button for the Type.

19. Select the To-Many radio button for the Cardinality and click OK.

    

1. In the storyboard, go to the Service tile, click + to create a service entity.

2. Click Create.

   

3. Click on the service and select Add Service Entity.

   

4. From the Projection dropdown list, select Bookshop.Books.

5. Click

   

   to save your changes.

   

6. In the storyboard, click on the service and select Add Action/Function.

   

7. Change the name of the action to submitOrder.

   

8. In the Properties pane, add the following:

   Parameter Name	Parameter Type
   amount	Integer
   books_id	Integer

   

1. In the storyboard, go to the Data Models tile, click on Authors, and select Add Data.

   

2. In the Data Editor, enter 3 for the number of rows with mock data and click Add.

   

3. Repeat the procedure to add rows for the Genres and the Books entities.

1. Go to the Explorer.

2. In the srv folder, create a new file called service.js.

3. If asked if you want to allow the use of the ESLint library for validation, click Allow.

   

4. Populate the service.js file with the following:

   JavaScript Copy

       /**
       * Implementation for CatalogService defined in ./cat-service.cds
       */
       const cds = require('@sap/cds')
       module.exports = function (){
         // Register your event handlers in here, e.g....
         this.after ('READ','Books', each => {
           if (each.stock > 111) {
             each.title += ` -- 11% discount!`
           }
         })
       }

5. Save your changes.

   Your application should look similar to the structure shown in the picture below.

   

   You can also see the semantic structure of the application in the Project Overview.

   

You can explicitly deploy your application to a persistent local SQLite database, or you can run your application and it will implicitly use an in-memory database.

This step describes how to run the application with an in-memory database.

You will first add all required dependencies, and then create and run a run configuration.

1. Add and install all required dependencies.

   • From the Terminal menu, select New Terminal.

   • On the bookshop folder, run the following:

     NPM Copy

     npm install

2. From the left side menu, open the Run Configurations view.

   

3. Click + at the top of the view to add a new configuration.

   

4. Select Bookshop - (CAP Node project) as the runnable application from the command palette prompt.

   

   There might be other run configuration options available in the command palette.

5. Press Enter to use the default name for the configuration. A new configuration is added to the run configuration tree.

6. In the Configuration editor, select the Local (project’s default) radio button for the database type.

   

7. Click the green arrow on the right of the configuration name to run the application.

   

   The application opens in the browser.

8. Click on Books to see the metadata and entities for the service.

   

   You can also debug your application to check your code logic. For example, to debug the custom logic for this application, perform the following steps:

9. Place a breakpoint in the function in the service.js file.

10. In the running app, click the Books entity. It should stop at the breakpoint.

![Breakpoint](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/appstudio-cap-app/6-6.png)

11. Click Continue in the debugger until all the books are read and the page is presented.

![Stop the app](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/appstudio-cap-app/6-7.png)

12. Remove the breakpoint.

13. Stop the application by clicking Stop in the Debugger. The number beside the Debug icon represents the number of running processes. Click Stop until there are no processes running.

Prerequisites

• Make sure you have an SAP HANA database available in your space. See Create an SAP HANA Database Instance Using SAP HANA Cloud Central

• You have an SAP HANA service (SAP HANA as a Service or SAP HANA Cloud) available in your space. To create a new instance in your trial account:

  1. Go to your space in the SAP BTP cockpit.
  2. Go to Service Marketplace.
  3. Select SAP HANA Schemas & HDI Containers.
  4. Click Create.
     

     

  5. From the Plan dropdown menu, select hdi-shared as the service plan and provide a name for the new instance.
  6. Click Create.

1. From the Activity pane, open the Run Configurations view.

   

2. Click + at the top of the view to add a new configuration.

   

3. Select Bookshop - (CAP Node) as the runnable application from the command palette prompt.

   

   There might be other run configuration options available in the command palette.

4. Press Enter to use the default name for the configuration. A new configuration is added to the run configuration tree.

5. In the Configuration editor, select the SAP HANA Cloud radio button for the database type.

   

6. Log in to Cloud Foundry.

7. From the SAP Cloud Instance dropdown list, select the relevant instance.

8. Select the Deploy data model to the SAP HANA instance before running checkbox.

   

9. Click the green arrow on the right of the configuration name to run the application.

10. From the terminal on the bookshop folder, run cds add mta. This adds an mta.yaml file to the root of your application.

    Note: If you are working on a trial account, open the mta.yaml file, and in the resources section change the service parameter to hana. Save your changes.

11. Right-click the mta.yaml file and choose Build MTA Project.

    

    A new folder for mta_archives is created containing the new mtar file.

12. Right-click the mtar file and choose Deploy MTA Archive.

    

Once the task is complete, your application should be available in your Cloud Foundry space. To access your application, go to your space in the SAP Cloud Platform cockpit and select Applications from the side menu.