SAP ABAP - Uploading Large Data From Excel Sheet To Internal Table Using FM ALSM_EXCEL_TO_INTERNAL_TABLE.
To upload data from excel sheet having more than 65,356 records into an internal table. In the sample code below a loop has been made on the function module to read 10000 records from excel sheet at a time. SAMPLE PROGRAM: REPORT zp2p_test_sample1. TABLES:mvke,s001,s004,knvv. TYPES : BEGIN OF t_final, spwoc TYPE spwoc, vkorg TYPE vkorg, vtweg TYPE vtweg, spart TYPE spart, matnr TYPE matnr, kunnr TYPE vbak-kunnr, vbeln TYPE vbeln, posnr TYPE posnr, fkdat(10) TYPE c, fkart TYPE fkart, ummenge TYPE s001-ummenge, umnetwr(15), END OF t_final. DATA: i_final TYPE TABLE OF t_final, wa_final TYPE t_final, wa_xcl_upd TYPE t_final. DATA: i_excel TYPE TABLE OF alsmex_tabline WITH HEADER LINE. DATA: wa_excel TYPE alsmex_tabline. DATA: v_file TYPE rlgrap-filename. DATA: w_total_rows TYPE i, w_row_num TYPE i. DATA: lv_counter_low TYPE i, "Bottom range of the rows to scan lv_counter_hgh TYPE i, "Top range of the rows to...