topic Re: Get data from spool in Application Development and Automation Discussions

Get data from spool

Former Member — Mon, 31 Aug 2009 07:12:07 GMT

Hi everybody,

I just asking to find a solution for my project.

I want to use some data in R/3 report, which is running in background.

Is it possible we get data directly from spool (TX: SP01) and use it program?

Regards,

Steph

Re: Get data from spool

venkat_o — Mon, 31 Aug 2009 07:15:54 GMT

Hi Steph, <li>Yes It is possible to use in your program. Use below function module to read spool


     CALL FUNCTION 'CONVERT_ABAPSPOOLJOB_2_PDF'
       EXPORTING
         src_spoolid              = g_spool_no
         no_dialog                = ' '
       IMPORTING
         pdf_bytecount            = l_no_of_bytes
         pdf_spoolid              = l_pdf_spoolid
         btc_jobname              = l_jobname
         btc_jobcount             = l_jobcount
       TABLES
         pdf                      = i_pdf

Thanks Venkat.O

Re: Get data from spool

former_member404244 — Mon, 31 Aug 2009 07:21:10 GMT

Hi,

First get the spool number from TSP01 table and then use the FM 'CONVERT_ABAPSPOOLJOB_2_PDF'.

Regards,

Nagaraj

Re: Get data from spool

Former Member — Mon, 31 Aug 2009 08:26:12 GMT

yes this is possible, you can take spool number from table TSP01 and read the spool data as follows:

SUBMIT rspolst2 EXPORTING LIST TO MEMORY AND RETURN

WITH rqident = Spool Number

WITH first = '1'

CALL FUNCTION 'LIST_FROM_MEMORY'

TABLES

listobject = mem_tab (LIKE TABLE OF abaplist)

IF NOT mem_tab[] IS INITIAL.

CALL FUNCTION 'LIST_TO_ASCI'

EXPORTING

List_index = -1

TABLES

listasci = g_t_text (table type c length 5000)

listobject = mem_tab

ENDIF.

by this way your spool data will come into table g_t_text .

Re: Get data from spool

Former Member — Tue, 01 Sep 2009 02:31:31 GMT

Sorry Nagaraj and Venkat,

Is this FM use to convert spool result into PDF file?

Regards,

Steph

Re: Get data from spool

Former Member — Tue, 01 Sep 2009 02:36:25 GMT

Thanks Sheelesh, it's work, eventhough I must separated the data one by one

it very plain text, but still separated by delimiter so that's ok...

Regards,

Steph