How to Email POWL Reports / Apply Web Dynpro ALV Table Layout Settings

[Former Member]

Hi all,

we want to be able to automatically extract POWL reports and email them to users in a batch job.

We can refresh a POWL report using FM POWL_QUERY_REFRESH, and access the raw report data using method CL_POWL_QUERY_ACCESSOR=>GET_CACHED_RESULTS.

However this merely gives us a table of raw data. No view layout (ie. Web Dynpro ALV table layout) settings have been applied, so there is no hiding or arranging of columns, row sorting, calculations or filters.

Ideally we would like to be able to specify a query and view layout. The batch job would then refresh and extract the data, and format the data according to the view layout before sending it on as an attachment in an email.

Does anyone know how to determine and apply Web Dynpro ALV table layout settings to format table data outside of the Web Dynpro environment ?

Thanks & regards,

Grogan

[Former Member]

Hi Grogan,

Did you find out how this works..i also have the same issue.

Thanks

Jdsouza