Skip to Content
avatar image
Former Member

Consolidation Of data in XI

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    May 07, 2009 at 05:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07, 2009 at 06:01 AM

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

    Rajesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07, 2009 at 06:19 AM

    Hi,

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

    Regards,

    Prakasu.M

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 07, 2009 at 06:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 07, 2009 at 07:04 AM

    >

    > 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

    Add comment
    10|10000 characters needed characters exceeded

  • May 07, 2009 at 07:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded