SAP RAP Application – Data Not Inserting into Custom Tables (First RAP Project)

[patrick_winkler]

Hello SAP Experts,

I am currently working on my first SAP RAP application in SAP S/4HANA Cloud Public Edition, and I need guidance from experienced RAP developers.

Business Requirement

Create an Excel uploader to update Bank Details for Vendor/Customer master data.

What I Have Implemented So Far

I followed the standard RAP development steps:

1. Created Custom Persistent Tables and Draft Tables

2. Created Interface CDS View

3. Created Consumption CDS View

4. Added Metadata Extensions for UI

5. Defined Behavior Definitions for Interface and Consumption Views

6. Implemented Behavior Handler Classes

7. Created Service Definition

8. Created Service Binding

Current Issue

• I am successfully reading Excel data and storing it into an internal table in the behavior implementation class.

• However, when I try to insert this data into my custom item table, no data is getting persisted in the database.

• There are no syntax errors, but the records are not saved.

My Doubt / Confusion

Since this is my first RAP project, I am not sure:

• Whether I am inserting data in the correct RAP lifecycle method

• If I should use MODIFY ENTITIES instead of direct INSERT

• If the issue is related to managed behavior, draft handling, or association (_item) handling

• Or if my behavior definition and class implementation are not aligned

Request for Help

I would really appreciate if someone could:

• Review my approach

• Point out what I might be doing wrong

• Explain the correct way to persist item data in a RAP-managed scenario

• Share best practices for Excel upload + RAP persistence

I will paste all relevant code (CDS, Behavior Definition, and Class Implementation) below for reference.

Thank you very much in advance for your support.

Please paste your Code recommendation if possible.

Environment:
SAP S/4HANA Cloud Public Edition Extensibility 
RAP (Managed with Draft)

Class for implementation.txt

Behaviour Definition Consumption View.txt

Consumption Views.txt

Behaviour Definition Interface View.txt

Interface Views.txt

[patrick_winkler]

Have you checked this? https://community.sap.com/t5/technology-blog-posts-by-members/upload-excel-using-sap-rap-only/ba-p/1...

[HenrikeGroetecke]

Hello,

The comment provided may contain the information you're looking for:
Have you checked this? Upload Excel using SAP RAP Only

Kind regards,

Henrike