SAP PI 7.4 IDoc to Flat File - Group Flat File Output
I've an issue with my IDoc to Flat File scenario. I would appreciate any advice you could give on this.
I have mapped IDoc SHPORD|DELVRY06 to produce a fixed length flat file output. The IDoc's are collected in SAP and sent out to PI. We are appending all the IDocs sent out to one flat file.
For every IDoc line segment E1EDL24 we need one line in the flat file output. This works fine. (E1EDL24 ->removeContexts>Record)
The problem I have is grouping the lines in the flat file. Currently the output comes out like:-
But the requirement is to have the output group (rolled up) by <Transaction><Key><Material> <Quantity> as follows:-
Do i need to perform another mapping step ? Or is there I way I can achieve this within the existing mapping ? I've searched around but for some reason can't seem to find this scenario. Any help would be greatly appreciated.
Thanks for your time.