There are scenarios where the user will upload a file in the Application Server which needs to be consumed to manipulate that data (such as updating in a table or sending it as a mail). In that case, we can use the DATASET to read the file in the Application Server.
The user uploads an Excel File in the Application Server. That Excel file is picked from the list of files in the Application server and stored in an internal table and then the data is uploaded to a custom table in SAP.
Step 1: Know the directory in which the file is stored.
DATA : lv_dir TYPE eps2filnam.
lv_dir = '/VTS/DEV/'.
Step 2: Get the list of files in that Directory path using the Function Module EPS2_GET_DIRECTORY_LISTING
Step 3: Find the file in that list using its name or date(or any indicator to identify the file given by the user)
DATA : p_file_n TYPE localfile .
READ TABLE it_files INTO DATA(wa_files) INDEX 1. "reading recent file
IF sy-subrc = 0.
p_file_n = wa_files-name.
Step 4: Use OPEN DATASET keyword to open the file. Use READ DATASET to read each record in the file. CLOSE DATASET to close the file. Store each line item in an internal table.
DATA: BEGIN OF it_tab OCCURS 0,
rec(1000) TYPE c,
END OF it_tab.
DATA: wa_tab(1000) TYPE c.
OPEN DATASET p_file_n FOR INPUT IN TEXT MODE ENCODING NON-UNICODE.
IF sy-subrc = 0.
READ DATASET p_file_n INTO wa_tab.
IF sy-subrc <> 0.
it_tab-rec = wa_tab.
CLOSE DATASET p_file_n.
Step 5: Now the excel data is stored in an internal table which can be uploaded into any table of the same structure.
MODIFY ztest FROM it_Tab.
I hope this blog post helped you to get an idea on how to read an excel from the Application Server and store it in an internal table which can further be used to update a table. Apart from Excel, PDF, as well as an Image, can also be read from the Application Server. It can be stored in an XSTRING format.