topic Re: driver program for SAP CONNECT in Application Development and Automation Discussions

driver program for SAP CONNECT

Former Member — Mon, 16 Oct 2006 08:59:44 GMT

hi guys,

I am sending a output request from spool to be sent via mail and that is through SAP CONNECT. can anyone tell me wat is the driver program behind it?

i tried to debug it but cudnt find.

i want the program that send the request from spool to SAP CONNECT.

please help me if u can..

gaurav

Re: driver program for SAP CONNECT

Former Member — Mon, 16 Oct 2006 09:19:40 GMT

Hi,

R u looking for RSCONN01 ??

Cheers ....

Re: driver program for SAP CONNECT

Former Member — Mon, 16 Oct 2006 09:57:47 GMT

good

try this

RSCONN01

SAPconnect: Start Email Send Process

thanks

mrutyun^

Re: driver program for SAP CONNECT

Former Member — Mon, 16 Oct 2006 10:08:15 GMT

hi sunanda and mrityunjay..

thanks for ur help..my actuall problem is when i send the ouput from spool to SAP connect, the title takes the value sys-id+spoolnumber. the same title is reflected in e-mail attachment too.

Can you tell me if i can change that over in the program??

thanks in advance..

gaurav

Re: driver program for SAP CONNECT

Former Member — Mon, 16 Oct 2006 12:22:58 GMT

Hi,

It is possibel to pouplate subject. Eg given below.

FORM email_output TABLES pt_out STRUCTURE t_output.

Populate table with details to be entered into .xls file

CLASS cl_abap_char_utilities DEFINITION LOAD.

CONSTANTS:

con_tab TYPE c VALUE cl_abap_char_utilities=>horizontal_tab,

con_cret TYPE c VALUE cl_abap_char_utilities=>cr_lf.

DATA: lw_user TYPE so_recname.

DATA: no TYPE i.

FIELD-SYMBOLS <fs> TYPE ANY.

FIELD-SYMBOLS <fs1> TYPE ANY.

DATA: temp(1000) TYPE c.

DATA: lw_email TYPE so_recname.

DATA: lw_today(10) TYPE c.

DATA: lw_message TYPE char256.

DATA: BEGIN OF tw_out OCCURS 0,

matnr LIKE mara-matnr,

lifnr LIKE lfa1-lifnr ,

END OF tw_out.

loop at t_output.

move t_output-matnr to tw_out-matnr.

move t_output-lifnr to tw_out-lifnr.

append tw_out.

endloop.

Output headings

CONCATENATE

'Article'

con_tab 'Vendor' con_tab INTO temp.

MOVE temp TO gt_attach-tabname3000.

CONCATENATE con_cret gt_attach INTO gt_attach.

APPEND gt_attach.

CLEAR gt_attach.

LOOP AT tw_out .

CLEAR: temp, no.

DO 255 TIMES.

ADD 1 TO no.

ASSIGN COMPONENT no OF STRUCTURE tw_out TO <fs>.

CONCATENATE temp <fs> con_tab INTO temp.

CLEAR <fs>.

ENDDO.

MOVE temp TO gt_attach-tabname3000.

CONCATENATE con_cret gt_attach INTO gt_attach.

APPEND gt_attach.

CLEAR gt_attach.

ENDLOOP.

CONDENSE p_user NO-GAPS.

TRANSLATE p_user TO LOWER CASE.

MOVE p_user TO lw_user.

WRITE sy-datum TO lw_today.

CONCATENATE lw_today '_' 'WRITE SUBJECT HERE'

INTO lw_message.

CALL FUNCTION 'ZMD_EMAIL_XLS_ATTACHMENTS'

EXPORTING

email = lw_user

MESSAGE = lw_message

TABLES

t_attach = gt_attach.

ENDFORM. " email_output

If helpful pl reward.

Cheers

Re: driver program for SAP CONNECT

Former Member — Mon, 16 Oct 2006 12:42:58 GMT

hi sunanda..

i still have one doubt if u can help. i have been debuggin my program since 1 day now. I dont see any FM that send the document to e-mail. do you think it will be in RSCONN01??

and the code u gave me..i m nt sure where shud i try it??

thanks in advance

gaurva