topic Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1 in Application Development and Automation Discussions

Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Tue, 17 Mar 2009 14:24:58 GMT

Hi all,

I have requirement to send mails from BADI.For that i used following function modules-SO_NEW_DOCUMENT_SEND_API1

and

SO_NEW_DOCUMENT_ATT_SEND_API1,

Both of these two function module requires to use COMMIT WORK statement.

But if we use COMMIT WORK statement in BADI a run time error is occuring as its not allowed in BADI.

Can anybody provide solution for this or provide another function module.

Thank you.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

former_member156446 — Tue, 17 Mar 2009 14:34:26 GMT

Refer to this link: [E-Mail attachment from remote location|http://www.sapfans.com/forums/viewtopic.php?f=13&t=322733&p=981260]

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Tue, 17 Mar 2009 14:38:13 GMT

HI,

The COMMIT WORK statement is not required while using the FM SO_NEW_DOCUMENT_SEND_API1

and SO_NEW_DOCUMENT_ATT_SEND_API1 to send the email.

Can you be more clear regarding the your problem.

To send the email after excuting the with waing for batch job to triggrer the email sending process..

submit rsconn01 with mode = 'INT'

with output = 'X'

and return.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

SuhaSaha — Tue, 17 Mar 2009 15:18:17 GMT

Hello,

As pointed out by Avinash the param: COMMIT_WORK in the FMs is not mandatory, you can skip it inside your BAdI.

If you have any valid reason as to why you have passed this value to the FM.

BR,

Suhas

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Tue, 17 Mar 2009 15:58:03 GMT

From ECC6.0 onwards,as per my knowledge/experience, its mandatory to use commit_work statement for mail trigger function modules.

thanks.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Tue, 17 Mar 2009 16:03:23 GMT

Hi Sanu,

It is not required to commit_work statement after these FM''s. You need to have RSCONN01 to trigger the mail immediatly..i have written lot of code using these FM in ECC 6.0 but no where i have used the Commit Work statment and still they are working fine,

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

former_member156446 — Tue, 17 Mar 2009 16:06:56 GMT

can submit RSCONN01 program, but never heard of writing commit after send email.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

SuhaSaha — Tue, 17 Mar 2009 16:07:59 GMT

Hello Sanu,

Even i have ECC 6.0 version & i donot think its mandatory. Anyways Avinash has already given an explanation to this.

BR,

Suhas

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Tue, 17 Mar 2009 16:17:13 GMT

for this perpose i used the same function module SO_NEW_DOCUMENT_SEND_API1 but i have not used commit work.so commit work its not necessary.can u give what is the exact error u faced.ok

regards

poluankireddy

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Wed, 18 Mar 2009 03:12:33 GMT

The issue is , in BADI we are not allowed to use SUBMIT statement or CALL TRANSACTION .So i can not use-

SUBMIT rsconn01 WITH mode = 'INT'

WITH output = ''

AND RETURN.

This works in se38/normal program not in BADI.

Edited by: sanu debu on Mar 18, 2009 4:13 AM

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

former_member156446 — Wed, 18 Mar 2009 03:21:41 GMT

its not mandatory to have the program submited.... Ideally every client will have it scheduled on a general interval to 10 minutes job... but commit is not needed... use the FM for email it should be fine.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Wed, 18 Mar 2009 03:36:09 GMT

Hi,

After bringing your final alv data in the final internal table,

go through this link , i also had an same requirement to send data after converting to excel file and

send it as an attachment to mail id outside Sap,

https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/to%252bsend%252b2%252bint%252btables%252bdata%252bas%252btwo%252battachments%252bto%252bmail%252bid%252boutside%252bsap%252bsystem

Hope it helps

Regrds

Mansi

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Wed, 18 Mar 2009 04:09:05 GMT

Without submit and commit work teh function module getting executed but i dont receive any mail

niether it appears in wait mode in SOST transaction.Can you please tell me reason behind the same and how to resolve.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

I355602 — Wed, 18 Mar 2009 04:11:49 GMT

Hi,

Refer:

/people/thomas.jung3/blog/2004/09/09/receiving-e-mail-and-processing-it-with-abap--version-610-and-higher

Hope this helps you.

Regards,

Tarun

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

vsubbakrishna — Wed, 18 Mar 2009 04:27:07 GMT

Hi,

Did you check the below highlighted export parameters in your call from BADI.

CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

STARTING NEW TASK 'ZMAIL'

EXPORTING

DOCUMENT_DATA = MAILDATA

PUT_IN_OUTBOX = 'X'

COMMIT_WORK = 'X'

TABLES

PACKING_LIST = MAILPACK

OBJECT_HEADER = MAILHEAD

CONTENTS_BIN = MAILBIN

CONTENTS_TXT = MAILTXT

RECEIVERS = MAILREC

EXCEPTIONS

TOO_MANY_RECEIVERS = 1

DOCUMENT_NOT_SENT = 2

OPERATION_NO_AUTHORIZATION = 4

OTHERS = 99.

Thanks,

Subba

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Wed, 18 Mar 2009 08:19:32 GMT

COMMIT_WORK = 'X' commented as it leads to runtime error.As i said COMMIT_WORK not allowed in badi.

Thank you.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Wed, 18 Mar 2009 08:47:59 GMT

Hi,

Check the below Link

Regards,

Anki Reddy

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Wed, 18 Mar 2009 09:58:00 GMT

As i said commit work not allowed in BADI.It gives runtime error.Please provide alternative solution.

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

Former Member — Thu, 19 Mar 2009 04:32:56 GMT

Hi,

Use SCOT transaction and start send process with address type "INT". It will put your mail from waiting to completed state.

And still if you are not getting any mail then check your Node under "INT". and also check RFC destination in that node. It might be taking wrong RFC connection.

Sourabh

Re: Issue while mail triggering using function module SO_NEW_DOCUMENT_SEND_API1

UmaArjunan — Thu, 19 Mar 2009 05:21:28 GMT

commit work not allowed in BADI.It gives runtime error

Information on commit work.

becos for commit work. sy-subrc will allways sets to zero.

you can better use commitwork and wait. it sets sy-subrc.

To avoid runtime error / dump you can check the sy-subrc value. if its not equal to zero. just

Roll back work.

Plz look at the piece of code below

commit work and wait.

if sy-subrc eq 0.

exit.

else.

rollback work.

wa_error-msg = "Failed to update the status in the database "

append wa_error to it_error.

exit.

endif.

Also check the badi signature. there you have a internal table to store the error messages.

if commit work fails then add the appropriate error message to the internal table .

Hope this gives you some idea on commit work.

But as everyone says, commit work is not required for that function module . i too agree with that.

if you try to update any database after you successfully send the file . then i think commit work statement is necessary for you.

Thanks,

Uma