Hello all,
Im here to ask your kind advice regarding a problem Im facing while trying to configure a Receiver File Adapter scenario. So these are the facts:
1) Data is supossed to flow from JDBC Adapter to File.
2) Scenario is about updating materials from ERP to an SQL central server and then to legacy system. For doing so I have developed an stored procedure that queries data from that central server and sends it to XI (Data is NOT separated by store but is coming all mixed within resultset).
3) As I needed data per store I had to perform some mapping for splitting data into the structure I wanted. (For further details please refer to message JDBC Sender MSSQL Stored Procedure - Multiple Select Statements)
This is my Output structure:
<root>...
<File>
<Header>
<value1>value</value1>
<value2>value</value2>
<value3>value</value3>
</Header>
<Body>
<value4>value</value4>
</Body>
</File>
</root>...
The problem is that, according to this Link: [http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm], that structure will not work for building the file properly.
I checked the forums and then I came across with this Link: [http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7154] [original link is broken] [original link is broken] [original link is broken];, but it does not seem to work for me either as that suggestion talks about Header, Item and Sub Items, and what I really need is the ability to insert some kind of context during the File Content Conversion execution in order to creat multiple files from one single message execution.
I hope someone can help me with this.
Thanks in advance.
Edited by: Anibal Granado on May 12, 2010 12:37 AM