topic SAP spool request in Application Development and Automation Discussions

SAP spool request

Former Member — Mon, 18 Sep 2006 08:47:20 GMT

I developed one development regarding send mail notification. when ever PO created alert mail will trigger to some users mail id . I should send all the PO item details as attachment. It was working fine but some cases is not working correctly. In table i maintained more than one user different material types. If material type satisfies then mail should trigger other wise no need. when i debugging mode it was working fine but it is not working correctly in direct execute. both user having different material type but both getting same details.

Re: SAP spool request

Former Member — Mon, 18 Sep 2006 08:50:22 GMT

Please check the follwoing code,it may help u

FORM write_to_spool.

DATA : l_f_list_name LIKE pri_params-plist,

l_f_destination LIKE pri_params-pdest,

l_f_spld LIKE usr01-spld,

l_f_layout LIKE pri_params-paart,

l_f_line_count LIKE pri_params-linct,

l_f_line_size LIKE pri_params-linsz,

l_f_out_parameters LIKE pri_params,

l_f_valid.

l_f_line_size = 255.

l_f_line_count = 65.

l_f_layout = 'X_65_255'.

l_f_list_name = sy-repid.

to get defult spool device for the user

SELECT SINGLE spld INTO l_f_spld FROM usr01 WHERE bname = sy-uname.

IF sy-subrc = 0.

MOVE l_f_spld TO l_f_destination.

ENDIF.

CALL FUNCTION 'GET_PRINT_PARAMETERS'

EXPORTING

ARCHIVE_ID = C_CHAR_UNKNOWN
ARCHIVE_INFO = C_CHAR_UNKNOWN
ARCHIVE_MODE = C_CHAR_UNKNOWN
ARCHIVE_TEXT = C_CHAR_UNKNOWN
AR_OBJECT = C_CHAR_UNKNOWN
ARCHIVE_REPORT = C_CHAR_UNKNOWN
AUTHORITY = C_CHAR_UNKNOWN
COPIES = C_NUM3_UNKNOWN
COVER_PAGE = C_CHAR_UNKNOWN
DATA_SET = C_CHAR_UNKNOWN
DEPARTMENT = C_CHAR_UNKNOWN

destination = l_f_destination

EXPIRATION = C_NUM1_UNKNOWN

immediately = 'X'

IN_ARCHIVE_PARAMETERS = ' '
IN_PARAMETERS = ' '

layout = l_f_layout

line_count = l_f_line_count

line_size = l_f_line_size

list_name = l_f_list_name

LIST_TEXT = C_CHAR_UNKNOWN
MODE = ' '
NEW_LIST_ID = C_CHAR_UNKNOWN
NO_DIALOG = C_FALSE
RECEIVER = C_CHAR_UNKNOWN
RELEASE = C_CHAR_UNKNOWN
REPORT = C_CHAR_UNKNOWN
SAP_COVER_PAGE = C_CHAR_UNKNOWN
HOST_COVER_PAGE = C_CHAR_UNKNOWN
PRIORITY = C_NUM1_UNKNOWN
SAP_OBJECT = C_CHAR_UNKNOWN
TYPE = C_CHAR_UNKNOWN
USER = SY-UNAME

IMPORTING

OUT_ARCHIVE_PARAMETERS =

out_parameters = l_f_out_parameters

valid = l_f_valid

EXCEPTIONS

archive_info_not_found = 1

invalid_print_params = 2

invalid_archive_params = 3

OTHERS = 4

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

IF l_f_valid NE space.

NEW-PAGE PRINT ON PARAMETERS l_f_out_parameters.

WRITE : /5 'Material No.',

25 'Message Type',

40 'Message Issued'.

ULINE.

LOOP AT g_t_message_table WHERE type = 'E'.

WRITE : / g_t_message_table-matnr UNDER 'Material No.',

g_t_message_table-type UNDER 'Message Type',

g_t_message_table-message UNDER 'Message Issued'.

ENDLOOP.

NEW-PAGE PRINT OFF.

ENDIF.

ENDFORM. " WRITE_TO_SPOOL

Regards

Re: SAP spool request

Former Member — Mon, 18 Sep 2006 09:21:24 GMT

Hi ,

Mail sending Process will take some time. I don't know how are you sending the mail. What ever may be the method , You need to specity "commit work and wait". once you say send mail it will be in continuous loop for while until it get's network resouces.

please check few examples:

1. Bapi_transaction_commit parameter 'Wait',

2. SO_NEW_DOCUMENT_SEND_API1 parameter 'Commit'..

Thanks,

Jaffer VAli shaik

Re: SAP spool request

Former Member — Mon, 18 Sep 2006 09:45:43 GMT

Hi,

when you debug implicit commit work may trigger

thats why your code was working fine in debug mode

but in foreground use explicit commit work.

use commit work and wait.

Regards

Amole

Re: SAP spool request

Former Member — Thu, 21 Sep 2006 06:58:11 GMT

it is solved by me. problem in spool titleand spool Ids

Re: SAP spool request

Former Member — Fri, 19 Jan 2007 04:28:29 GMT

it is solved by me. problem in spool titleand spool Ids