on 02-05-2014 4:39 PM
Hello All,
I am required to split a file based on the number of Detail records in the file to ECC through Proxy.
Source file is CSV file and the same has to send as Header and Detail strucutres to ECC. But here I have to send 10 records of Headers in each time.
So I would like to post the data using Message Splitting.
Please guide me on the detaled steps of this Message Splittng.
Thank you all!!
Hi John - Have a look at the below document
http://scn.sap.com/docs/DOC-3493
If you don't need to send header multiple times(in each message) and just want to split the file then you can make use of the recordset per message option.
Message was edited by: Hareesh Gampa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hareesh,
No, I am required to send Header also each time.
communication is through proxy, so can you tell me where can i set the recordset per message?
can you please elaborate me on this.
example : Below set has to go in one time and in another set another data with the seq no starts as 4 should go....
<Header>
<Date>20130206</Date>
<Detail>
<SeqNo>1</SeqNo>
<RefNo>18987</RefNo>
</Detail>
</Header>
<Header>
<Date>20130205</Date>
<Detail>
<SeqNo>2</SeqNo>
<RefNo>58909</RefNo>
</Detail>
</Header>
<Header>
<Date>20130306</Date>
<Detail>
<SeqNo>3</SeqNo>
<RefNo>298712</RefNo>
</Detail>
</Header>
Hi John - You have to use BPM for splitting as message split happens on adapter engine and proxy adapter runs on ABAP stack.
Below blog will help you in designing the BPM.
XI/PI &#8211; 1:n Multi-Mapping using BPM
how can i split based on the Detail records count?
What do you mean by details records count? Do you want to create separate message for each header in the csv?
Message was edited by: Hareesh Gampa
Hi Hareesh,
Requirement that I got is that each Header should have 100 Detail records.
So I would need to send each time one Header with 100 Detail records.
If I recieve a CSV file with 2000 records then I would need to call the proxy for 20 times.
Please let me know how I can achieve this.
Thank you.
Oh.. If you only have details records in the csv file and you are creating the header with constant values then you can make use of "records sets per message option".
I though your csv will have header data too.
So in your file sender channel go to content conversion tab, you should be able to see "maximum record sets per message". configure that as 1000 and rest all direct mapping.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.