Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Can SAP be automated to output to excel in the background every 15 minutes

Posted on 2006-04-05
Medium Priority
Last Modified: 2013-12-08
I run IW37n transcation (part of the PM module) numerous times through out the day and export to excel. It is a slow process. I want to know whether i can run this action in the background using code or some addin software, say business warehouse.


Question by:vipa2000

Assisted Solution

nasriram earned 500 total points
ID: 16410457
It can certainly be automated as a batch job running ABAP code, but I guess that's not what you have in mind?

As a user, you have limited options:
1.  Use some Windows automation tool such as AutoIt http://www.autoitscript.com/autoit3/

2.  Configure the report to present the data in Excel (certain SAP transactions which output data as an ALV grid are also capable of activating "Excel in-place")

3.  Automate through an Excel macro which invokes the SAPGUI (SAPGUI scripting must be enabled on the production machine)

4.  Set up transmission to BW where a report can be set up as a batch job.

By far the last option is the most practical, as long as your systems guys set up the data connectors to update the BW system periodically.

Accepted Solution

olgavillamizar earned 500 total points
ID: 16428546
Maybe you can create a java application that take the data and store in a database or txt file and read this from excel.
You can use a driver SapConnector to connect to SAP from JAVA.

Author Comment

ID: 16499950
I split the points as i thought you both gave valid and good answers for me to explore. thank you, regads vipa

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question