Skip to Content
0
Jan 24, 2014 at 02:35 PM

Exporting to Excel from Personas

152 Views

My Personas launchpad gives easy access to CO line item reports (actuals/commitments for cost centre/internal order/project). Sadly, but not unexpectedly, my users have asked for the ability to export the reports to Excel. I had removed that button, indeed the whole toolbar, from the Personas flavours for those reports. The "export to excel" button - this one - works fine, but the process is quite cumbersome, presumably due to the browser sandboxing of the Silverlight plug-in. And since some of the process is in the browser and not in SAPgui, it can't be scripted. Here's how it looks:

I can't even script the first step in the process - choosing a file format and hitting the "tick" - because the browser pop-ups seem to upset the Personas scripting engine. As soon as I add an action to click the tick, I start getting "timeout" messages.

Is the above process as good as I'm going to be able to get, or is there a way I haven't found yet to simplify it? The transaction here is KSB1, if anybody wants to try 😊