Consolidation Of data in XI

[Former Member]

Hi,

I am transferring data from Non SAP system into SAP through XI. But I want to do consolidation of data in XI before transferring data to SAP system. Suppose I have 4 purchase entries from same vendor of same material for a week in non SAP system. Instead of transferring 4 different entries to SAP system. can I consolidate those 4 entries in XI into one & then tranfer to SAP?

If this is possible then how to do it?

Please guide.

Pradip Nikam

[aashish_sinha]

Hi,

As suggested by Vijay, and if i understand it correctly,

you want to merge multiple source file to one and the you want to post it somewhere in SAP system.

For this requirement you need to use BPM.

http://help.sap.com/saphelp_nw2004s/helpdata/en/21/6faf35c2d74295a3cb97f6f3ccf43c/frameset.htm

regards

Aashish Sinha

[Shabarish_Nair]

>

> Hi,
> 
> I am transferring data from Non SAP system into SAP through XI. But I want to do consolidation of data in XI before transferring data to SAP system. Suppose I have 4 purchase entries from same vendor of same material for a week in non SAP system. Instead of transferring 4 different entries to SAP system. can I consolidate those 4 entries in XI into one & then tranfer to SAP? 
> 
> If this is possible then how to do it? 
> 
> Please guide.
> 
> 
> 
> Pradip Nikam

1. If your source system is sending all the entries in a single message you can easily do this via the mapping in XI

2. Suppose your source system is sending these 4 message separately and then you want to consolidate, then you will have to involve BPM.

You will need to collect these messages and then have a N:1 mapping that does the consolidation

Ref:

http://help.sap.com/saphelp_nw04/helpdata/en/08/16163ff8519a06e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/0e/56373f7853494fe10000000a114084/content.htm

[Former Member]

Hi ,

You achieve this using BPM.

take this blog as reference.

/people/pooja.pandey/blog/2005/07/27/idocs-multiple-types-collection-in-bpm

This blog gives procedure to collect idocs, you can use same BPM for collecting messages from NON SAP system

Regards,

Reyaz

[Former Member]

Hi,

You can do this in mapping level using simple udf function.

Regards,

Prakasu.M

[Former Member]

Need to chk with BPM ,I am not 100 percent sure but I think can be done using BPM

Rajesh

[Former Member]

do you mean the Non SAP sys sends data weekly once

assume 100 records sent and if you find same combination u had mentioned then you want to send that as one entry to SAP

If so you can do this in mapping