topic Re: Fetching Data from Spool directly in Application Development and Automation Discussions

Fetching Data from Spool directly

Former Member — Wed, 14 Nov 2007 09:04:25 GMT

Hello Experts,

I need to do the following:-

There are certain list of transactions that gives ALV List as output and reading data directly from that list is not possible.

So we need to run transactions like IW58 in background and generate a spool job. Then we need to pick the spool via spool number and read the data in it.

How do we pick data from our spool and process that through XI and update the data base.

Regards

Saras Jain

Re: Fetching Data from Spool directly

andreas_mann3 — Wed, 14 Nov 2007 09:16:24 GMT

try fm RSPO_RETURN_ABAP_SPOOLJOB

Re: Fetching Data from Spool directly

former_member404244 — Wed, 14 Nov 2007 09:29:35 GMT

Hi,

U can get the spool number from table TSP01..

Check the below sample code.

DATA:

lv_rq2name LIKE tsp01-rq2name.

CONCATENATE sy-repid+0(8)

sy-uname+0(3)

INTO lv_rq2name SEPARATED BY '_'.

Get the spool number.

SELECT * FROM tsp01 WHERE rq2name = lv_rq2name

ORDER BY rqcretime DESCENDING.

v_rqident = tsp01-rqident.

EXIT.

ENDSELECT.

IF sy-subrc NE 0.

CLEAR v_rqident.

ENDIF.

Reward if helpful.

Regards,

Nagaraj