cancel
Showing results for 
Search instead for 
Did you mean: 

Message Splitting in Proxy for Inbound Interface

0 Kudos

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!!

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184720
Active Contributor
0 Kudos

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

0 Kudos

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>

former_member184720
Active Contributor
0 Kudos

so can you tell me where can i set the recordset per message?


This is not useful as you need header in all the messages.


For splitting inbound proxy - Can you confirm your PI version? If you are 7.3 and above you can go with message split at mapping level i believe.

0 Kudos

We are using PI7.0.

Also please let me know how can i split based on the Detail records count

former_member184720
Active Contributor
0 Kudos

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 &amp;#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

0 Kudos

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.

former_member184720
Active Contributor
0 Kudos

so does your CSV will always have one header or can have multiple headers too?

0 Kudos

No Hareesh, Its only with Detail records.

But in target structure it should be Header with Detail data.

former_member184720
Active Contributor
0 Kudos

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.

0 Kudos

We are recieveing the CSV file through Mail, Also the same file is being used by some other interfaces.But for this particular interface, we would need to send as Header with 100 details.

former_member184720
Active Contributor
0 Kudos

This blog -

former_member184720
Active Contributor
0 Kudos

receiving through mail .. you mean mail adapter or email?

0 Kudos

Mail adapter as CSV attachement.We are only processing the attachment.

Please let me know how can I split here.

former_member184720
Active Contributor
0 Kudos

I would prefer a two step approach here..

1-> Place the attachment on NFS server(mail - file)

2-> Process it using file sender(records set per message option)(file- proxy)