cancel
Showing results for 
Search instead for 
Did you mean: 

IDOC TO MAIL SCENARIO

0 Kudos

HI Experts,

  I have a scenario where i need to trigger idoc Orders05 in to PI and PI transforms idoc to excel format as attached. Once excel is generated we need to attach that excel to mail send send it to concern vendor dynamically. Could any one please help me out the scenario. I am taking excel structure as target structure. Please help me on the same. I am new to PI. Please anyone explain me step by step.

Thanks

Sai

Accepted Solutions (0)

Answers (1)

Answers (1)

Bhargavakrishna
Active Contributor
0 Kudos

Hi Sai,

I think you can do IDOC --> File and File to Mail. There are other ways to do it.. but as per my knowledge i'm suggesting this approach.

To generate excel from PI

http://www.saptechnical.com/Tutorials/XI/Adapter/Index.htm

In receiver communication channel give file name extension as .xls and field separator as tab.

Create the file in PI server itself.

Regards

Bhargava Krishna