XML File splitting in PI

[former_member216353]

Hi all,

We have a requirement that the receiving application can accept files only of size 2MB. So this is a limitation from the receiving application

The source system is SAP ECC system and the receiving application is a legacy application.

Technically it is a ABAP Proxy to File scenario. Receiving application can accept files only in XML format.

SAP ABAP Proxy code is written in such a way to read all the records in a SAP table and the full table load is sent as an proxy xml message to PI, PI has to split this  full xml file  in to chunks based on some condition and then transfer it to receiving legacy application.

Can we achieve file splitting in PI for XML files based on no.of records or size.

Please share your inputs/pointers to provide the best solution to this requirement.

regards,

Younus

[iaki_vila]

Hi Mohammed,

A few cents, check this blog

Regards.

[javier_alcubilla]

Yes, it is possible

In the mapping, set the occurrence of the target to  0..unbounded

And in the mapping definition, the root to something like this:

The constant is the counter limit. (for instance 300)

When record 300 is reach, one message is created, so, 1 file with 300 records is created also

If you have 900 records, you will have 3 files

Hope it helps

Regards javi

[Former Member]

Dear Yousus,

below links may be help you.

Split source message into multiple target messages

SAP XI/PI: 1..N Message Split Interface without BPM

Regards,

Rajendra K

[Former Member]

Hi,

Yes this can be done by the amount of records you send through at a time.

So lets there is 10000 records. You might only send 200 at a time and that will keep it under the 2mb limitation.

This is a simple if function on your nodes. Please see the links below that would help you.

Defining Message Splits - SAP NetWeaver Process Integration - SAP Library

Configuring Mapping-Based Message Splits - Integration Directory - SAP Library

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30ea2fdf-f047-2a10-d3a2-955a634bd...

Regards,

Jannus Botha