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

Posted on 2006-04-05
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
    LVL 1

    Assisted Solution

    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

    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.
    LVL 1

    Accepted Solution

    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

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

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now