Build a Simple CRUD Application with SAP Build on SAP BTP Cockpit

[SmrutiRekhaPradhan]

Introduction
In today’s application landscape, CRUD (Create, Read, Update, Delete) functionalities serve as the backbone of most business solutions. SAP Build Apps, available via SAP BTP Cockpit, allows developers and business users alike to rapidly design and deploy full-stack applications using a no-code/low-code approach. This blog guides you through the steps to develop a basic CRUD app and manage it within SAP BTP Cockpit.

Prerequisites
Before proceeding, make sure you have the following in place:
An active SAP BTP account (Free Tier or Enterprise)
SAP Build Apps service enabled in your subaccount
Access to SAP BTP Cockpit
Familiarity with basic data structures (Entities and Fields)

Step 1: Prepare Environment in SAP BTP Cockpit
Log in to the SAP BTP Cockpit.
Create a new subaccount and select your preferred region.
Navigate to the Service Marketplace and enable SAP Build Apps.
Assign the necessary roles such as SAP Build Apps Admin and Developer.
(Optional) Set up destinations if you plan to connect external services or backends.

Step 2: Start Your Application in SAP Build Apps
Open SAP Build Apps from the BTP Cockpit.
Click on Create New App.
Provide a name (e.g., “Task Manager”) and choose a layout.
Create a Data Resource, either using local storage or a connected data source.
Add a Data Entity (e.g., "Tasks") with fields like id, title, description, and status.

Step 3: Create the UI for CRUD Features
Create:
Add a form with input fields for each task attribute.
Use a "Create" button with logic to insert new records into the "Tasks" entity.
Read:
Design a container with a Repeat with binding to list all tasks.
Map data fields to their respective UI components.
Update:
Design a Detail View for editing selected task data.
Pre-populate form fields and connect an "Update" button with update logic.
Delete:
Add a Delete button or icon beside each task item.
Connect it to Delete Record logic and include a confirmation dialog.

Step 4: (Optional) Integrate with External Backend
If connecting to CAPM or external APIs, define a Destination in the SAP BTP Cockpit.
Set up proper authentication and headers.
Use REST API Direct Integration in SAP Build Apps to map backend services to CRUD actions.

Step 5: Preview and Test Your Application
Use the Preview App option within SAP Build Apps.
Test all features — create, view, edit, and delete tasks.
Utilize alerts and console logging for debugging and validation.

Step 6: Deploy and Monitor Using SAP BTP Cockpit
Publish your application for web or mobile use.
Return to the BTP Cockpit to:
Monitor usage and logs
Manage authorizations and roles
Verify destination and connectivity settings

Conclusion
Congratulations! You’ve successfully created a working CRUD application using SAP Build Apps within SAP BTP Cockpit. This streamlined process enhances productivity, minimizes development time, and provides seamless SAP ecosystem integration.