R/3 - Xi - MDM integration Scenario.

[rajesh_chavan]

Hi experts,

We are working on R/3 XI MDM integration scenario for Customer master wherein requirement is to consolidate the u201CGeneral datau201D but at the same time we need to retain u201Csales area datau201D for each record as it is.

For example, In sap ECC system we have Master record (Which is duplicate) as mentioned below,

Id Name Sales Area.

1 Neethu SA1

2 Neethu Joy SA2

After merging two duplicate records general data we will have a single record in data manager. Further we want to link Sales Area Data to same consolidated record. Final picture in MDM data manager should look like this,

Id Name Sales Area.

1 Neethu SA1; SA2

Can anyone suggest a solution? How we can u201Cappendu201D Sales area data to Consolidated General master data. How we can deal with u201CDelta Recordsu201D to achieve the same Output..??

Matter is most urgent...Points will be rewarded.

Cheers,

Rajesh Chavan

[Former Member · Accepted solution]

Rajesh,

I think its possible but will look odd in DM,

when you merge two records and you are keeping 1st record in final output. you will first select Neethu, then SD1. Just do one thing on second record just right click on SD2 and select Concatenate. it will concatenate SD1 and SD2 in final output.

and your record will be:

Id Name Sales Area.

1 Neethu SA1 SA2

i am not sure whether we can put any separator between these two. you can check it.

BR,

Alok

[Former Member · Accepted solution]

Hi Rajesh,

Use multivalued qualified table.

In DM; use option append.

you will get your desired result.

abt syndication , I will come back.

Hope this helps,

+ An

[Former Member]

Hi Rajesh,

On merging two duplicate records, generally data merge as a single record in data manager.So i would suggest in this case

You have to change your Repository design and MAP. you can achieve this, Firstly For Sales Area you have to make this lookup field(Multi-Valued) in main table which will lookup to SubTable say SalesA for which Multi-Valued is YES.

Now come to Import Manager, Here during Map as you have

Id Name Sales Area.

1 Neethu SA1

2 Neethu Joy SA2

Map first Source Sales Area Field with Name(DF) when you select SalesA as your Current Destination Table then import Main table records as ususal here in which you also map Sales Area source field with Sales Area which is lookup field(Multi-Valued) in main table

IN Data Manager, During Merge Records when you select Sale Area field as SA1 in Merged Record for Id 1 then Right Click on SA2 for Id 2 here your append Option will get enabled using this you can get desired output as

Id Name Sales Area.

1 Neethu SA1; SA2

Rewards if useful....

Hope it will help you,

Mandeep Saini