SAP SM30 upload and download data by excel

长沙铁道学院-康帅傅

已于 2023-08-24 20:52:58 修改

阅读量1.5k

点赞数

分类专栏：函数技巧文章标签： ABAP SAP

于 2022-05-18 20:05:04 首次发布

本文链接：https://blog.youkuaiyun.com/u012232542/article/details/124849818

版权

函数技巧专栏收录该内容

49 篇文章

订阅专栏

本文介绍了SM30模块如何通过标准功能将数据导出到Excel，并提供了ZDOWN（下载Excel）和ZUPLOAD（上传Excel）两种操作案例。详细展示了使用`cl_svim_excel_download`进行文件下载及将Excel数据转换为系统表格的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Download Excel

SM30 provided standard function for export data to excel, Path: Menu->Table View->Export File->Contents；
or you can copy standard function for your own button in PAI as following.

module zuser_command input.
case function.
    when 'ZDOWN'.
      data(lo_excel_download2) = cl_svim_excel_download=>get_instance(
      exporting
        iv_vim_called_by  = vim_called_by_cluster
        iv_object_type    = vim_object_type
        iv_object_name    = conv #( vim_view_name )
        iv_text_table     = abap_true ).
      try.
          call method lo_excel_download2->if_svim_excel_download~download_view_content
            exporting
              it_vim_total  = total[]
              it_vim_header = x_header[]
              it_vim_namtab = x_namtab[].
        catch cx_svim_download_error.
          " Error in excel download
      endtry.
    when others.
  endcase.

endmodule.

upload Excel

Attention: this upload is a direct replace of screen data, require manual save at last.

case function.
    when 'ZUPLOAD'.
*    convert data from excel to <ft_table>.
      extract[] = <ft_table>.
      total[] =  <ft_table> .
      maxlines = tctrl_(table_name)-lines = lines( extract[] ).
      <status>-upd_flag = abap_true.

    when others.
  endcase.