Upload Excel Data to ABAP Table | ABAP Projects | SAP

In this video, we will learn how to Upload Excel Data to ABAP Table

To perform ABAP excel upload using ABAP report, we need to call a FM ‘TEXT_CONVERT_XLS_TO_SAP’. This FM converts the excel data to ABAP data. Now we can store the same in our internal table and later in our database table. The only mandatory requirement is that the table fields should match the header of excel in a synchronous way, else wrong data will be saved.

Many times we need to upload an excel data from our local storage on PC and insert those data into our ABAP tables. This can be easily achieved using ABAP Function Module ‘TEXT_CONVERT_XLS_TO_SAP’. In the given program we convert our excel data into ABAP data and insert those data in our ztable.

#sap #abap #excel #table

[sherifelkoumy]

Hi, I get error message, that type truxs_t_text_data ist unknown. I am developing on bw4, Do have any idea how to fix that?

[gokulbhoi]

i have to read excel file containing data of two different tables. How do i upload the file data into two different DDIC tables?