Skip to Content
Technical Articles
Author's profile photo shivam shukla
shivam shukla
July 16, 2023 2 minute read

Lets Deep dive into CAPM and HANA Cloud –> HANACap

Hello everyone!

 

I hope you’re coding and having a great time!!!

Currently, I am engaged in working on various BTP (Business Technology Platform) services, and designing and development constitute my everyday tasks. As expected, we encounter some challenges along the way, which is quite normal 🙂 Therefore, I’ve decided to document these challenges along with their corresponding solutions in my GitHub repository. This compilation is expected to grow into a substantial list over time, but for now, I have already included two challenges and their respective solutions.

 

Pre-requisite:

  • Get your BTP Trial Account setup before you jump into Coding 🙂 + VSCode or BAS

 

Here you go GitHub Repo – https://github.com/shivamshukla12/SAP-CAP/tree/main 

 

  • Write your first CAP Application –  Its a simple one Hello World

  • Create one entity in your CAP App and Insert  / Retrieve some Hard coded Values

  • Add some CSV Data in your CAP Application

  • Run and retrieve your CSV Data

  • Connect your CAP Application to BTP Space

  • Provision Services for your CAP Application

  • Enable HANA Cloud Instance and Add HDI Containers

  • Build and Deploy your CAP Application on CF ( Cloud Foundry )

  • Run and Debug your CAP Application

 

Tutorial Highlights:

 

Say%20Hello%20to%20SAP%20CAP

Say Hello to SAP CAP

Supplier%20Entity%20for%20Projection

Supplier Entity for Projection

 

Supplier%20JS%20File%20For%20logic%20and%20data%20export

Supplier JS File For logic and data export

GET Request :

Using CDS in CAP –  you can simply write select statement and Wrap it in NodeJS and run the query to get data back from the database

POST Request :

Using CDS in CAP – you can make POST Calls directly on Entity exposed which will Create New entry in Database

Delete Request :

Using CDS in CAP – You can use custom handler function to delete records from the database – A Custom logic or i would say simply wrap your delete statement in Nodejs and run it on CDS.

Highlights

CRUD%20Operations%20in%20CAP%20Entity

CRUD Operations in CAP Entity

Coming up Next…

  •  How SQL is giving the real value to your cloud Application Programming -- SQL is the magic
  •  Working with multiple entities and Association
  •  Projection , Aggregate functions and Joins
  •  Function Import in CAP

 

Keep Learning and Keep Sharing 🙂

 

PS: I will Keep posting Updates in my this blog and Updating  the repo for promised exercises

 

Thanks Shivam

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.