Triggering mail via T-code CJ20N

Hi ,

Our requirement is to send a mail to the client when the user changes Reservation Relevance/Generation of Purchase Requisition status to u201CImmediatelyu201D.

We have coded our logic in BADI ME_REQ_POSTED (method = IF_EX_ME_REQ_POSTED~POSTED ) used the standard FM u201CSO_NEW_DOCUMENT_SEND_API1u201D.

But the problem is whenever the user saves the changes in CJ20N the FM SO_NEW_DOCUMENT_SEND_API1 internally calls commit transaction & we get the dump u201CSAPSQL_ARRAY_INSERT_DUPRECu201D. We have tried sending mails via OOPS method as well but it still gives the same dump.

Can anybody suggest any other EXIT / BADI name where we can write the code for sending the email without causing dump or any other way to handle the current issue ?