on 01-07-2016 2:47 PM
Hi Experts!
Happy New Year!
My requirement is when ever the file leaves from PI I have to send emails to particular users.
Inputs: Based on the country code we need to send email to recipient. Mail should contain body ( as
BofA Transmission OUTBOUND-Informational Message: Wed Dec 30 19:00:25 PST 2015
Preparing to send attached ePayables File to Bank of America.) and attachment.
Country Code and attachment will be coming to PI through proxy from ECC.
Please suggest me how to do this. As per my knowledge we can go with UDF. Please send me the code for this requirement.
Appreciate your quick reply.
Awaiting for your Kind Response.
Thanks,
Gayathri.
>>Country Code and attachment will be coming to PI through proxy from ECC.
If the attachment is coming from Proxy, i don't think you need to do something using UDF.
All you need to do is enable "keep attachments" in the receiver email channel.
Assign the recipient email ID based on the country code logic during the mapping and same goes with Body.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>> I am getting attachment as xml file and I have to send it through mail as .xls.
i don't think this would be a good design to convert xml into Excel in PI mapping.
It shouldn't be very difficult to send the attachment as excel using ABAP proxies.
>>>2. Can you tell me the logic of mapping and how can I add body in the email (it contains date and time format too)
Go through below blog.
you can provide date & time logic to Content field.
Yes Hareesh. I checked with them. the thing is we have to sent payment file as xml. but when it comes to email notification it should be in .xls.
And one more thing we have encryption also in middle ( forgot to add this).
We need to send the mail with (mentioned above ) body text and attachment (as .xls) to particular recipients based on country code.
Thanks.
Hello Gayathri,
can you refer the below links
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Raghu,
As of now we don't have any mapping for sending mail.
Can you confirm me whether I can add this in existing mapping (sending file with dynamic file name and path).
In my requirement ABAP proxy will add 2 more fields Country code and mail address.
Now I have to send mail by using these 2 values.
Thanks.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.