Beginner to Advanced SAP BTP, CAPM, BAS Course [Part-1]

Learn to set up a SAP BTP account, create a global and trial sub account, configure dev spaces, deploy apps, and explore Hana Cloud and SAP Business Application Studio.

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.

Set up sqlite and sql tools, create a sqlite connection, and build a service with a function that returns a string using cds and javascript files, export and run.

Learn to call an external API from a cap project using axios, set up npm packages, and model the data in the India.db namespace with fields userId, title, and body.

Create an external api server by defining a cds service for the external data table in the india dot db namespace and expose it via an external api service.

Master calling an external API in a cap project using cds run and cds watch, fix typing errors, install axios, and implement a service with an external API data model.

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.

Create and deploy a data model using data model.cds, defining master and transaction contexts and tables like business partner, product, and po items with associations, then test in SQLite.

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.

Compile the data model from the cds file in the db folder, create an address entity with a business partner association, and load the csv to deploy to sqlite.

Expose master and transaction context tables via OData v4 by creating a CDS service and data model, surfacing business partner, address, product, and orders as endpoints.

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.

Explore testing OData services with OData v4 and v2 endpoints, deploying to an in-memory SQLite database, and using $top, $select, and $expand to navigate multi-level associations for UI data queries.

Test OData locally with BAS by issuing get, post, put, patch, and delete requests on business partner and address data, and learn put versus patch.

Explore the multilanguage feature in CAPM using the localized keyword to auto-create a product texts table and translate product descriptions across English, German, and French.

Auto generate UUIDs in a worker table, replacing manual IDs with universally unique identifiers and exposing them via OData for reliable mobile UI keys.

Learn how SAP provided aspects in CAPM, via SAP CDS common, enable reusable and localized data by importing aspects such as language, currency, and time zone.

Use the managed aspect to automatically create four fields created at, created by, modified at, and modified by across records, leveraging the aspect library for reusability and faster development.

Create and apply custom aspects in SAP CDS to validate gender, phone number, and email with regex, integrate via data model cds file, and verify through OData post requests.

Create a reusable custom aspect for amount fields in SAP BTP, CAPM, BAS course, adding currency code, gross amount, net amount, and tax amount to purchase order and po items.

Create labels for the business partner fields using an i18n folder with English and German properties, mapping BP_key, BP_role, and company_name, then deploy and verify in the Fiori preview.

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.

Continue building cds views by correcting context placement and creating an aggregated product sum view from master product and transaction po items, exposing product id, description, and gross amount sum.

Examine defining service capabilities by testing OData endpoints with get and post requests, distinguishing between views and entities, and applying read-only annotations to enforce data restrictions.

Annotate the entity with capabilities to control insertable, updatable, and deletable operations. Explore read-only versus restricted scenarios and validate behavior with post, put, patch, and delete requests.

Explore the CDS query language (CQL) by reviewing SQL basics and learn how to query a database in a CAP project using JavaScript with select, insert, update, and delete.

Learn to query data in JavaScript using SQL-like syntax to read from the worker table, filter by first name, and return results via an OData v4 endpoint.

Learn how to create a service to insert records using JavaScript and SQL-like commands, including handling payloads, post requests, and transaction-based insert operations.

Demonstrates updating worker records in a JavaScript environment by using update and set statements, applying a where id condition, and testing with a PUT request to verify changes.

Implement delete operation in a cap project by deleting a worker record via an async request using an ID passed in the URL, then verify removal.

Explore how the cloud application programming framework uses actions and functions to implement custom business logic, data validation, and event-driven workflows, with examples of write vs read operations and hooks.

Create an action to increment a worker's salary by 20,000 using a cds service, reading the salary and updating the salary amount within a transaction that supports rollback and commit.

Expose worker table from the master context with a CDS service, and implement an increment salary action using the annotation at rate impl. Test with POST to increment by 20,000.

Implement a function in a cap project using JavaScript and cds files. Fetch the highest salary from the worker table and expose it as a get operation via a service.

Conclude part one of the SAP CAPM course by reviewing data models, services, cds, views, i18n, validation, and testing in sqlite, and preview part two's cloud deployment and security.