topic Re: Data retrieval from OADD in Application Development and Automation Discussions

Data retrieval from OADD

Former Member — Wed, 18 Jan 2012 19:36:10 GMT

Hi,

We are archiving spools using the standard SAP funtionality. We use OADD to display the data. Is there any way to extract the data - some thing like a FM that helps to download the spool data?

Any pointers to this will be very helpful.

Thank you.

Re: Data retrieval from OADD

Former Member — Wed, 18 Jan 2012 19:50:09 GMT

you can use the function module "RSPO_RETURN_ABAP_SPOOLJOB", by providing the input RQIDENT field, the field RQIDENT value scan be derived from the table TBTCP by providing the job name, you can get the field value LISTIDENT which is equal to the RQIDENT in the table TSP01.

Re: Data retrieval from OADD

Former Member — Wed, 18 Jan 2012 21:55:23 GMT

Hi,

I'm aware of the FM mentioned by you which is used to retrieve data from the spool. In this case, the spool is archived and cannot be accessed using this FM.

Thanks.

Re: Data retrieval from OADD

Former Member — Thu, 02 Feb 2012 21:49:50 GMT

Hi,

Is there any way to access archived data in SAP other than using transaction OADD?

Any pointers will be helpful.

Thank you.

Re: Data retrieval from OADD

kesavadas_thekkillath — Fri, 03 Feb 2012 06:26:02 GMT

Why do you need a fm, the program OADISPPR uses a simple logic by fetching data from tables toadl, toasp & toasr. If your willing to program it then you could write a submit statement to this program and retrieve data in this manner [Gain Programmatic Access to Data of SAPGUI ALV Reports|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24944] [original link is broken] [original link is broken] [original link is broken];

Re: Data retrieval from OADD

Former Member — Fri, 03 Feb 2012 16:28:12 GMT

Keshav,

We have a requirement to download all the pages of archived spool data in a single instance. OADD does not help to download this but allows only single page download. When the pages are more, it becomes a hectic task to download this data and put to use. Let me try with the data you have mentioned but if there is any other way to download mutiple pages, pls. let me know.

Thanks.