topic Help needed with pivot table in Application Development and Automation Discussions

Help needed with pivot table

Former Member — Wed, 28 Feb 2007 01:38:08 GMT

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.

Re: Help needed with pivot table

Former Member — Wed, 28 Feb 2007 01:44:01 GMT

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

Re: Help needed with pivot table

Former Member — Wed, 28 Feb 2007 04:16:59 GMT

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.

Re: Help needed with pivot table

Former Member — Thu, 01 Mar 2007 02:53:24 GMT

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?