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:
developers.sap.com/mission.ha...
And the CodeJam: github.com/SAP-samples/cap-ha...
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
- The prerequisite steps to install the environment locally is documented here: github.com/SAP-samples/cap-ha...
- All the VSCode Extensions I have installed and will be using today are documented here: github.com/SAP-samples/cap-ha...
- The tool that is adding the colored breadcrumb in the terminal (Oh-My-Posh): ohmyposh.dev/
- And an excellent introduction to Oh-My-Posh: www.hanselman.com/blog/my-ult...
- DJ's script to added status updates int he terminal as well: github.com/qmacro/dotfiles/bl...
- GitHub Desktop Client: desktop.github.com/
- SAP Cloud Application Programming Model Compositions: cap.cloud.sap/docs/guides/dom...
- SAP Cloud Application Programming Model Hybrid Testing: cap.cloud.sap/docs/advanced/h...
- Boosting tutorial UX with dev containers part 1 - challenge and base solution blogs.sap.com/2022/01/27/boos...
- WDI5 github.com/ui5-community/wdi5
- VSCode Development for SAP Cloud Application Programming Model Using Remote - WSL blogs.sap.com/2020/11/10/vsco...
- This project's DevContainer Docker example: github.com/SAP-samples/cap-ha...
- Automated Testing in CAP: cap.cloud.sap/docs/node.js/cd...
- More details about the app router user-api: www.npmjs.com/package/@sap/ap...
- CDS bind example that works in Powershell (suggested by Cemre Dogan): cds bind --exec -- {npm start --prefix approuter}
- Consuming Services in CAP: cap.cloud.sap/docs/guides/usi...
- Example from ‪@SAPTechEdChannel‬ Developer Keynote 2020 with service consumption via REST: github.com/SAP-archive/teched...
- Why developers should care about credential-types for xsuaa? blogs.sap.com/2022/07/05/why-...
- Application Security Descriptor Configuration Syntax help.sap.com/docs/BTP/65de297...
=============================================================================
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

Наука