SAP ABAP - Report Program To Upload Excel Sheet Data Into Internal Table Using FM ALSM_EXCEL_TO_INTERNAL_TABLE.
This function module is used to transfer data from excel sheet to internal table. The only problem with this FM is it transfers all the excel data as char type and hence type conversion is needed to be done. For Example, IDATE is of type DATS - Date field (YYYYMMDD) stored as char(8). In excel sheet the date format was : 01.01.2011. hence data conversion has to take place to save the date in internal table in the format YYYYMMDD. Again PRICE is of type CURR of length 13 & decimals 2. Since the FM retrieves the data from excel in CHAR type, hence type conversion has to be done to convert CHAR type to CURR type . PRICE in excel sheet is saved as 23,864.00 . SAMPLE PROGRAM: REPORT z_zvgaq_update. TYPES: BEGIN OF x_zvgaq, mandt LIKE zvgaq-mandt, werks LIKE zvgaq-werks, matnr LIKE zvgaq-matnr, idate LIKE zvgaq-idate, drate LIKE zvgaq-drate, price LIKE zvgaq-price, udate LIKE zvgaq-udate, END OF x_zvgaq. DATA: it_zvgaq TYPE STANDARD TABLE OF x_zvgaq, wa_zvgaq TYP...