07-25-2008 7:26 PM
Hi All,
Is it possible to upload data into SAP from EXCEL file having 5 to 6 tabs containing data. All tabs data should go to different Internal tables or same internal tables.
Any help will be appreciated.
Regards
07-25-2008 7:43 PM
07-25-2008 7:30 PM
Hi,
Use the fm:
ALSM_EXCEL_TO_INTERNAL_TABLE
eg:
types: l_yprice_object_id type yprice_object_id.
DATA: itab TYPE STANDARD TABLE OF alsmex_tabline WITH HEADER LINE,
filename type rlgrap-filename.
* Set the path and filename to the file in filenet
filename = 'C:\My Documents\..........'.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = filename
i_begin_col = 5
i_begin_row = 2
i_end_col = 5
i_end_row = 10000
TABLES
intern = itab.
Regards,
Subramanian
Edited by: Subramanian PL on Jul 25, 2008 11:32 AM
07-25-2008 7:36 PM
Hi Subramanian,
Will this upload the data from the single excel sheet which is having Multiple spread sheets in it.
Can you please clarify my query.
Regards,
Venkatesh
07-25-2008 7:43 PM
07-25-2008 7:52 PM