{"id":270,"date":"2024-08-01T16:40:08","date_gmt":"2024-08-01T16:40:08","guid":{"rendered":"https:\/\/sapabap.dwimansolution.com\/?p=270"},"modified":"2024-08-01T16:40:09","modified_gmt":"2024-08-01T16:40:09","slug":"sap-abap-download-alv-to-excel-with-total-and-subtotal","status":"publish","type":"post","link":"https:\/\/sapabap.dwimansolution.com\/index.php\/2024\/08\/01\/sap-abap-download-alv-to-excel-with-total-and-subtotal\/","title":{"rendered":"SAP ABAP &#8211; Download ALV to Excel with Total and Subtotal"},"content":{"rendered":"\n<p>Bismillah..<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DATA: t_data TYPE TABLE OF sflight.\r\n\r\nSTART-OF-SELECTION.\r\n\r\n  DATA: lo_alv TYPE REF TO cl_salv_table.\r\n  DATA: lt_solix    TYPE TABLE OF solix,\r\n        lv_filename TYPE string.\r\n  DATA:\r\n    lo_columns TYPE REF TO cl_salv_columns_table,\r\n    lo_column  TYPE REF TO cl_salv_column.\r\n\r\n  SELECT *\r\n    FROM sflight\r\n    INTO TABLE t_data.\r\n\r\n\r\n  cl_salv_table=>factory(\r\n    IMPORTING\r\n      r_salv_table   = lo_alv    \" Basis Class Simple ALV Tables\r\n    CHANGING\r\n      t_table        = t_data\r\n  ).\r\n\r\n  DATA(lo_sorts) = lo_alv->get_sorts( ).\r\n  DATA(lo_sort) = lo_sorts->add_sort( columnname = 'PLANETYPE' subtotal = abap_true ).\r\n\r\n\r\n  DATA(lo_aggrs) = lo_alv->get_aggregations( ).\r\n  DATA(lo_aggr) = lo_aggrs->add_aggregation( 'PAYMENTSUM' ).\r\n\r\n  DATA(lv_xstring) =   lo_alv->to_xml( if_salv_bs_xml=>c_type_xlsx ).\r\n\r\n  CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'\r\n    EXPORTING\r\n      buffer     = lv_xstring\r\n    TABLES\r\n      binary_tab = lt_solix.\r\n\r\n  lv_filename = 'C:\\test_excel\\file.xlsx'.\r\n\r\n  CALL FUNCTION 'GUI_DOWNLOAD'\r\n    EXPORTING\r\n      filename                = lv_filename\r\n      filetype                = 'BIN'\r\n    TABLES\r\n      data_tab                = lt_solix\r\n    EXCEPTIONS\r\n      file_write_error        = 1\r\n      no_batch                = 2\r\n      gui_refuse_filetransfer = 3\r\n      invalid_type            = 4\r\n      no_authority            = 5\r\n      unknown_error           = 6\r\n      header_not_allowed      = 7\r\n      separator_not_allowed   = 8\r\n      filesize_not_allowed    = 9\r\n      header_too_long         = 10\r\n      dp_error_create         = 11\r\n      dp_error_send           = 12\r\n      dp_error_write          = 13\r\n      unknown_dp_error        = 14\r\n      access_denied           = 15\r\n      dp_out_of_memory        = 16\r\n      disk_full               = 17\r\n      dp_timeout              = 18\r\n      file_not_found          = 19\r\n      dataprovider_exception  = 20\r\n      control_flush_error     = 21\r\n      OTHERS                  = 22.\r\n\r\n  IF sy-subrc &lt;> 0.\r\n    \" Handle the error accordingly\r\n    WRITE: 'Error downloading file.'.\r\n  ELSE.\r\n    WRITE: 'File downloaded successfully.'.\r\n  ENDIF.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Bismillah..<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/270"}],"collection":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/comments?post=270"}],"version-history":[{"count":1,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":271,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/posts\/270\/revisions\/271"}],"wp:attachment":[{"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/media?parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/categories?post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sapabap.dwimansolution.com\/index.php\/wp-json\/wp\/v2\/tags?post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}