Extract DSO data from production

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member]

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.

[Rushikesh_Yeole]

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

[Former Member]

Hi Rushikesh,

Regarding point 1, As there are lot of records and lots of fields, the excel download is coming in proper format. Jumbled or misplaced felds

Regarding point 2, Getting error, Data_Buffer_exceeded.

Regards,

Vineet

[Rushikesh_Yeole]

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?