We have a requirement to upload data to custom table via excel using RAP framework.
Till now we are using the ODATA create stream method to achieve this functionality
Post upgrade, we see that we have an option to upload excel using the RAP framework, so I would like to try to use it for uploading data from the attachment to custom table.
Following are the things that I'm worried about:
1. With the strict and ABAP on cloud guidelines we aren't supposed perform DB operations on the database tables, in that case is this approach correct?
2. Also each time we try to upload the data via Excel that Excel file will be saved to the DB in a table, what if huge files are uploaded and it consumes too much space!!
3. This needs to be performed for close to 10 tables, is there any performance impact, if we have huge data?
Thanks & Regards,