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

Extract DSO data from production

Hi Guys,

I need to extract the DSO data from production to an excel. There exist a RFC connection between the Development system and production. Can someone suggest me if there are any standard Function module or program to extract the data. The DSO got 10Lakh + records,. Manual extraction is time consuming and tedious.

Regards,

Vineet

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2015 at 02:00 PM

    Hi Vineet,

    you can try creating a Open hub directly on top of DSO (or) APD from DSO active table ..download it to your local /application drive.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2015 at 12:39 PM

    HI,

    1. To excel: Best option is to download through active table using SE16 at once.

    2. To dev system: (testing purpose): Use function RFC_READ_TABLE. But it may give problems when there are many key figures have float data type

    Add a comment
    10|10000 characters needed characters exceeded

    • Point 1: Hope you have selected ALV Grid format. If total length exceeds 1023 char, then data will flow to next line. Hide fields which are not required; using layout management.

      In spool also, you will face same problem.

      Or can you create small query on DSO and extract all data by suppressing result rows?

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2015 at 12:53 PM

    Hi Vineet,

    Goto active table of the DSO and from the menu bar select Program -> Execute in Background -> select printer LP01 and schedule immediate.

    Goto T-Code SM37 and check the status of the job. Output will be created a spool.

    Thanks,

    Shakthi Raj Natarajan.

    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.