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?