Skip to Content
author's profile photo Former Member
Former Member

SQ01 Automatic extraction

Hello !

I would like to extract tables from the transaction SQ01 automatically and periodically (period of 1 hour).

Currently, I have to enter the SQ01 transaction and extract the table I want, then I export it to Excel and display it on a screen from a derived PPT file. It takes some time, so I can only do it one time a day.

Now I would like to make the extraction and the Excel exportation automatic and periodic, so the displayed data is concrete.

I've seen that I have to use the SM36 or SE38 transaction to make a loop with an ABAP program execution. In this ABAP program I would have to instruct the extraction of the table I want, but I don't know at all how could I write it.

There are softwares who can do that instead of programming by myself, but it's quite expensive.

Have some of you already tried the ABAP way ? How could I do that ?

Thanks a lot in advance, looking forward to your answers.

Regards.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 06, 2012 at 09:31 AM

    Sounds like you need to hire a programmer.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.