Excel Upload By RAP Without Extending on SAP BTP/Business Application Studio Platform?

[AR77]

I want to Upload Data by Excel using RAP Applications, without Extending this Service on SAP BTP Platform Bcoz in my case we dont have any BTP Subscription.

I Already go through with this Blog and it is working fine but here we need to extend the service on BTP Platform. 

https://community.sap.com/t5/technology-blogs-by-members/excel-upload-using-rap-part-1/ba-p/13545399

So please suggest how we can acheive the same using RAP Application Only.

[SerhiiMartynkov]

Dear AR77,

I've come across your inquiry and believe I have a solution that might help you. The guide you require provides comprehensive steps to address your concern effectively. To briefly summarize, it outlines the latest SAP BTP ABAP 2208 release introduces support for handling Large Objects (LOBs) within RAP applications, allowing users to upload various file formats like PDF, XLSX, and binary files without extending the application. Large objects are modeled with fields such as Attachment, Mimetype, and Filename, with the Attachment field containing the LOB itself in RAWSTRING format. CDS annotations like @Semantics.largeObject and @Semantics.mimeType are utilized to define and handle these fields within the application, enabling seamless media handling without the need for extension.

For detailed instructions and further insights, I recommend referring to the complete guide available at https://community.sap.com/t5/technology-blogs-by-sap/streams-in-rap-uploading-pdf-excel-and-other-fi... . This resource will guide you through the process in a clear and concise manner, ensuring successful implementation.

Should you have any further questions or require assistance, feel free to reach out. I'm here to help!

Best regards,
Serhii.

[SachinArtani]

Hi, doesn't the user mean that he wants to upload the data through Excel to the database table and not uploading the excel as an attachment (BLOB) to a field in the database table?

[SerhiiMartynkov]

Hi AR77,

Since update 2208 you can handle Large objects as Excel files in regular RAP applications without extensions.
I think this detailed guide will help you achieve your goal.

Kind regards, Serhii.

[SachinArtani]

Check this out - 
Upload Excel using SAP RAP Only - SAP Community

[MioYasutake]

@AR77 

Is your RAP application custom-developed? If so, to run it as a Fiori application, you'll need to develop the application in BAS (or VS Code) and deploy it to the backend. During that process, you can also incorporate the Excel Upload functionality you mentioned.