on 08-21-2014 9:25 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.