Help needed with pivot table

[Former Member]

Hi experts,

I would like to know is it possible to export your internal table to pivot table -> do some changes to the data in the table -> save -> and pass it back to another internal table? Thanks in advance.

[Former Member]

Using FM 'SAP_CONVERT_TO_XLS_FORMAT' which converts Data in Internal table to an Excel Sheet.You can specify the path of your Excel file in parameter i_filename of Function module 'SAP_CONVERT_TO_XLS_FORMAT'.

Then carry out the changes which you want. Using GUI_UPLOAD, you can upload the values from file to new ITAB.

hope this will help.

Thanks,

Ashwani

[Former Member]

Hi, thanks for the reply but can I do it in such a way that I do not need to save the Excel in my harddisk and upload it later into SAP again? What I really need is to get the excel to popup, able to change it directly, and close it and get the data back to SAP directly. Not sure whether can be done or not.

[Former Member]

Hi Ashwani,

I would like to know whether is it possible to skip the step of saving the Excel file to harddisk?

What I really need is user click a button on the report -> Excel popup with data -> perform changes to data -> close Excel -> updated data refresh in the SAP report.

Can it be done?