
Learn how to create Hana Cloud database instances in SAP BTP using the new workflow, including configuring Hana Cloud tools, assigning role collections, and provisioning an instance.
Start the SAP Business Application Studio, create and manage dev spaces for SAP CAPM development, then initialize a fresh CAP project and set up SQLite for local development.
Explain cloud application programming model development using the EPM data model, detailing master and transaction tables, key relationships, and csv-driven links, with localization and UUID usage.
Start your BAS development by logging into the BTP cockpit, enabling SQLite for initial CAPM work, and mapping dev and test spaces to a Hana cloud database for later deployment.
Format and load CSVs for SAP BTP, CAPM, BAS by naming files as namespace.context-name-dash-table-name, remove node keys, and align fields. Deploy to SQLite via Business Application Studio and resolve references.
Compile the data model by running cds compile data model.cds --to sql in the db folder to reveal field names, node keys, and prepare for deployment.
Create a v2 odata endpoint from a v4 service using a node.js server.js proxy. Update package.json and run the proxy to expose a v2 endpoint alongside the v4 service.
Learn to use the @path annotation in service.cds to preserve mixed-case names when configuring OData v4 to v2 services, and print exact names with brackets and single quotes.
Create cds views across data model contexts and expose them via an odata service, deploy to v2 and v4, and verify data for po details and po items.
•Using Business application studio
•Various commands in BAS
•Creating a Cloud Application Programming Project
•Creation of simple services
•Calling external api using Axios
•Learning various npm packages and using it in CAP Projects
•Using Sqlite database for deployment
•SAP BTP account, space mapping
•Datamodel – Example EPM Model (Enterprise Procurement Model)
•Creating several entities and learning about their associations
•Inserting data using csv files
•Learning association
•Multilanguage support, french, german and english
•Creating labels using i18n files
•Implementing custom validations for email id and phone number
•Exposing tables via Odata V4 and using $select, $top, $expand etc keywords.
•Locally testing, creating http file in BAS and perform CRUD operation
•Testing multilevel expand Odata
•Using CDS watch
•Learning services in detail
•Restricting services using annotations
•Learning db and srv folders in detail to create datamodel and exposing entities via Odata
•Using different annotations to
•Odata V4 to V2 conversion
•learning UUID concepts and using it to create auto generated keys
•Learning Aspects - SAP Standard Aspects and Creating Custom Aspects
•CDS Views
•Exposing CDS views via Odata
•CDS Query Language (CQL) – CQL CRUD operation
•Using Javascript to query database for CREATE, READ, UPDATE and DELETE operations
•Generic Handlers - Creating custom handlers to implement business logics
•Implementing Actions and Functions
•And many more…
NOTE: All resources, codes, ppt are available at Section 7, Lecture 38 and can be downloaded.