Opened in Excel “As a read-only workbook”
And there is even another option where you can play around with called “Use the XML Source task pane”…
So here the coding for a very small program to read database table T005 and put it in an XML-file:
DATA: lt_t005 TYPE STANDARD TABLE OF t005.TYPES: xmlline(1024) TYPE x.DATA: lt_xml TYPE STANDARD TABLE OF xmlline.SELECT * FROM t005 INTO TABLE lt_t005.CALL TRANSFORMATION id SOURCE data_node = lt_t005 RESULT XML lt_xml.CALL METHOD cl_gui_frontend_services=>gui_download EXPORTING filename = ‘C:\table.xml’ filetype = ‘BIN’ CHANGING data_tab = lt_xml.
And if you then open “table.xml” in Excel “as an XML list” it will show you the T005 really like in SE16: