topic Re: getting spool request using the jobname and program as input in Application Development and Automation Discussions

getting spool request using the jobname and program as input

Former Member — Sat, 28 Apr 2012 14:17:53 GMT

Hi all

am new to abap please help me to resolve this issue

am developing the report to fetch the spool request no and convert the spool request to pdf format and send as a mail which are available in the set

i want to know how to get the spool request from job name and program as input in report please help in this issue

Re: getting spool request using the jobname and program as input

jitendra_it — Sat, 28 Apr 2012 20:20:07 GMT

Hi Ashoke,

See the point 3 in below link.

http://wiki.sdn.sap.com/wiki/display/ABAP/PDF+Downlaod+By+Creating+Spool+Request

Many Thanks,

Jitendra soni

Re: getting spool request using the jobname and program as input

Former Member — Sun, 29 Apr 2012 04:15:17 GMT

Hi jitendra

Thanks for giving the above link . am able to convert the spool request to PDF and able to download it to the local PC can u help me how to send the particular PDF to mails which are maintained in the sets(gs01)

please help regarding this one ..................

thanks and regards

Ashok

Re: getting spool request using the jobname and program as input

jitendra_it — Sun, 29 Apr 2012 07:04:18 GMT

Hi Ashoke,

Refer the standard program BCS_EXAMPLE_8 for converting the spool into PDF and sending it to any

email address.

Many Thanks,

Jitendra

Re: getting spool request using the jobname and program as input

Former Member — Mon, 30 Apr 2012 11:28:28 GMT

Hi Jitendra soni,

I am able to execute the program but could not able to receive the mail can you let me know where I need to check whether the mail is sent out from SAP?

Thanks,

Ashok

Re: getting spool request using the jobname and program as input

jitendra_it — Mon, 30 Apr 2012 11:33:12 GMT

You can check in SOST transaction.. Take help from your basis guy for error analysis.

Many Thanks,

Jitendra

Re: getting spool request using the jobname and program as input

RaymondGiuseppi — Mon, 30 Apr 2012 11:40:42 GMT

Direct from database

- From job name and program name, you can find the job step in table TBTCP fields JOBNAME,

PROGNAME

- For old version, you get the spool id in table TBTCP field LISTIDENT (only one)

- For recent version, you get the spool id in table TBTC_SPOOLID (every one)

Using FM

Call BP_JOB_SELECT and then BP_JOB_READ

Regards,

Raymond

Re: getting spool request using the jobname and program as input

Former Member — Tue, 01 May 2012 06:09:55 GMT

Hi Jitendra,

Now am able to get the test mail as a attachment by running the above program and the transaction respectively.

can u help me how to create a set using the table ADR6 and the field should be SMTP_ADDR.

i had tried to create using the above mentioned table and field am getting the meesage like

"you cannot create the set because the field is >24 character long ".

(SMTP_ADDR character type is string and its length is 241)

please give me the suggestion for this.

Thanks ,

ASHOK

Re: getting spool request using the jobname and program as input

jitendra_it — Tue, 01 May 2012 10:43:54 GMT

ashok kumar wrote:

"you cannot create the set because the field is  >24 character long ". 
(SMTP_ADDR character type is  string and its length is 241)

It is clear from above message that one can not create a set with field lenght greater than 24 chars.

If you want to maintain email ids then u can go for z table else u can diretly fetch from ADR6 table.

Many Thanks,

Jitendra Soni

Re: getting spool request using the jobname and program as input

Former Member — Wed, 02 May 2012 07:47:35 GMT

Hi jitendar,

weather it is possible to create a set for maintaining the mail id based on the company code or by based on the user ids

Re: getting spool request using the jobname and program as input

Former Member — Wed, 02 May 2012 07:48:53 GMT

Hi Jitendra

if yes let me now how to create the set using these thing .

Thanks and regards

Ashok Kumar.

Re: getting spool request using the jobname and program as input

jitendra_it — Wed, 02 May 2012 08:31:48 GMT

Hi Ashok,

I dont have much idea about SETs. I have worked only on Basic SETs, which does not support above requirement.

Many Thanks,

Jitendra

Re: getting spool request using the jobname and program as input

Former Member — Wed, 02 May 2012 08:36:15 GMT

Hi Jitendra ,

thank for ur discussion it help me to solve my issue .

Thanks

Ashok

Re: getting spool request using the jobname and program as input

Former Member — Mon, 21 May 2012 17:52:40 GMT

Hi Jitendra ,

Am able to send the PDF to the required mails

but my problem is that am not able to send the mail s with attachments and with body i.e am able to send the mail either with body or attachment with PDF attachment but i need to send the mail with attachment as well as with body can u help me regarding this .

hope for the best.

Thanks

Ashok

Re: getting spool request using the jobname and program as input

jitendra_it — Mon, 21 May 2012 18:25:29 GMT

Hi Ashok,

If u r using classes for mail sending(like in BCS_EXAMPLE_8 ) then use text1 for body of email.

text1 = 'Body of Email'.

document = cl_document_bcs=>create_document(

i_type = 'RAW'

i_text = text1

i_length = '21'

i_subject = 'Subject of Email' ).

Many Thanks,

Jitendra

Re: getting spool request using the jobname and program as input

VijayCR — Sat, 26 May 2012 05:17:00 GMT

Hello Ashok,

We can get it from TBTCP-List ID by giving the JOb name also you can fetch the Job Names based on the Process .

Suppose Your doing it for Payment Advice.

1) F110-(RUnon)-* So u can get it from the TBTCP.

Thanks ,

Vijay.