Fetching Data from Spool directly

[Former Member]

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

[andreas_mann3]

try fm RSPO_RETURN_ABAP_SPOOLJOB

A.

[former_member404244]

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