SAP HANA Cloud and CAP to Build Full-Stack Applications Using VSCode

In this session we will develop a multi-target application using SAP Cloud Application Programming Model and SAP HANA Cloud. We will start from scratch and create a service layer and SAP Fiori UI that also includes SAP HANA native artifacts, such as calculation views. We will perform nearly all steps in VSCode but also see tips on how to use Git to move your project easily between VSCode and the SAP Business Application Studio.

This content is based upon the SAP Developer Tutorial Mission:

The content is updated to highlight improvements made possible by CAP 6.0. In particular we will use the cds bind functionality to support hybrid testing. This means running and debugging the application locally but securely connecting to remove HANA and UAA instances running on SAP BTP.

Reference Information
- CDS bind example that works in Powershell (suggested by Cemre Dogan): cds bind --exec -- {npm start --prefix approuter}

=============================================================================

CHAPTER TITLES
0:00 Intro
0:52 Dev Environment Setup
3:15 Verify HANA Cloud is Running
5:24 Create CAP Project
8:51 Explore the generated artifacts
11:32 Sync to Git
13:56 Create Database Artifacts Using Core Data Services (CDS) for SAP HANA Cloud
16:12 Deploy to HANA Cloud
20:48 Check the Database Explorer
24:04 Run Service Layer
25:20 Create a User Interface with CAP
27:20 Create a Fiori freestyle web interface
30:56 Add User Authentication
39:57 Create and grant roles
44:08 Test with Security
46:36 Create Calculation View
50:44 Create calculation view proxy entity
57:41 Create Stored Procedure
59:56 Implement Exit for Stored Procedure
1:02:10 Closing

[ashutoshtube]

very in depth and in understandable language by TJ sir. Its very nice tutorial to begin with CAPM full stack development.

[DD-coder]

Amazing tutorial. However in order to be e2e it will be great to see how we can deploy this app to CF. There is a great number of tutorials explaining 1.The hybrid mode ( aka. having the hdi container and its tables deployed) and 2. how to deploy a CAP services, but they never complete with a Fiori app deployment.

[anniep]

Table details is not appearing in hana cloud HDI containers. Please help me for that.

[Guha]

Hello Team, I have a query. When I deploy all the setup to SAP BTP, the Odata is not returning any output. I dont have any app router added to my project.

[chantelesmith]

I can't seem to get generator-fiori to install on VS code any ideas why?

[fmarifmahamud]

Thanks for preparing this video. its really helpful.

The issue is, i have followed the full process without any issue but after executing the command "hana-cli dbx" browser open but I can not see the container which i have created using hana-cli.
I clicked on + button to ad but there is no container.

Could you please help?

Also i am getting Certification Expired error when executing "hana-cli createModule"

Thank you.

[somnathbhattacharya]

Can achieve same using managed approuter

[nidhisehgal]

I have followed this tutorial and deployed the application on cloud foundry environment. The UI is not visible when I click on Application Routes in the standalone app router application. Any help would be appreciated.

[ChetanBhatt-qg]

what is HANA server you write in vscode

[mateocano]

I have followed the Add User Authentication to Your Application part and my response on the windows is: "Bad gateway"...Someone can help me?
If I use user-api/attributes it returns the correct data and scope...