Convert report to excel and send it to business workplace

Thu Apr 7 02:01:41 EDT 2011

Hi Paul,

Thanks for the quick response!

We are using ALV function modules in the report for better outcome. Does it not come under flat listing?

BR,
Hari

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Paul.Bakker at osr.treasury.qld.gov.au
Sent: Thursday, April 07, 2011 11:16 AM
To: SAP Workflow Users' Group
Subject: Re: Convert report to excel and send it to business workplace

Hari,

What is the report you are trying to run? You will get the CNTL_ERROR
message if the report uses some kind of UI object (like a table control).

See if there's a way to make the report issue a flat listing.

cheers
Paul

From:   <hari.bommaraju at accenture.com>
To:     <sap-wug at mit.edu>
Date:   07/04/2011 03:36 PM
Subject:        Convert report to excel and send it to business workplace
Sent by:        sap-wug-bounces at mit.edu

Dear WUG,

Need your advice!

We have a requirement where every Monday morning at 6 AM - a report needs
to be run (with predefined variant) and the output need to be converted
into an excel and sent directly to business workplace.

My idea was to use a background job to trigger a workflow every Monday
morning at 6 AM and that the workflow in turn would take care of converting
and sending the report in excel format to the user's business workplace.

As part of workflow design - I have used the workflow wizard: Include
"Execute Report/Job".

1) Selected the operation mode as Dialog
2) I have provided the report name and the variant name.
3) The system displayed all the mandatory parameters that can be seen on
the selection screen (My assumption was that - I might not need these
parameters as I have defined a variant already).
4) I then use the option "Execute report and generate list".
5) I then provide the title of the list and chose the option "Send to
recipients".
6) Then I chose recipient type as "Organizational Object" and expression "
&WF_INITIATOR&".
7) I provided the task abbreviation and name.
8) The wizard created a step in the workflow.

When I tested this workflow, I found that this task never got completed
(remained in "In Process").

When I checked the TRFC - I found the status text as "Exception condition
"CNTL_ERROR" raised."

I got the following information from ST22.

"CL_GUI_CUSTOM_CONTAINER=======CP" "CNTL_ERROR"

"RAISE_EXCEPTION" C
"CL_GUI_CUSTOM_CONTAINER=======CP" or "CL_GUI_CUSTOM_CONTAINER=======CM001"
"CONSTRUCTOR"

I searched for valid SAP Note but found none suitable.

Is my approach wrong? Please suggest a better way to achieve the desired
functionality.

Br,
Hari

This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify the sender immediately and delete the
original. Any other use of the email by you is prohibited.
_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug

*********************************************************************************************
Only an individual or entity who is intended to be a recipient of this e-mail may access or use the information contained in this e-mail or any of its attachments.  Opinions contained in this e-mail or any of its attachments do not necessarily reflect the opinions of Queensland Treasury.

The contents of this e-mail and any attachments are confidential and may be legally privileged and the subject of copyright.  If you have received this e-mail in error, please notify Queensland Treasury immediately and erase all copies of the e-mail and the attachments.  Queensland Treasury uses virus scanning software.  However, it is not liable for viruses present in this e-mail or in any attachment.
***************************************************************************************************

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information.  If you have received it in error, please notify the sender immediately and delete the original.  Any other use of the email by you is prohibited.