We have recently moved to BW on Hana system and we have a requirement to upload file (CSV or Excel) into transparent table.
Before HANA we would create a File upload ABAP program and provide its Tcode to user, so that they will use tcode to upload file data into transparent Table.
As we are in Hana, we would like to upload data into a HANA table (Column Store) by the user (without help of Developer) .
What is the proper Hana approach for the above scenario? should we write AMDP for the file upload or please suggest other possible solutions to achieve the same.
Thanks in advance.