COMPOUNDING SOURCE SYSTEM ID WITH OUT DELETING MASTER DATA

[Former Member]

Hi,

We have existing data from r/3 system (for eg. D1) in BW. Now we have a requirement to get data from a new r/3 system (for eg D2). So we need to use 0COMP_CODE for two sources. We have COMP CODE C11 with different master data in D1 and D2. So we need to compound sourcesystem id to 0COMP_CODE. If we compound it now we need to delete comp code master data in production which means deleting data from 10 other cubes which are dependent on 0COMP_CODE. We can create a new infoobject ZCOMP_CODE for D2. But is it a good idea to create a new info object as we can't report on D1 and D2 if master data is different?. Is there any other way to reuse 0COMP_CODE for D1 and D2.

[Former Member · Accepted solution]

Instead of modifying your 0COMP_CODE, create a new info object ZCOMP_CODE with source system ID compounded, load D2 master data into it and the load D1 master data using a datamart on 0COMP_CODE with ID hard coded, so now you have a single master data object ZCOMP_CODE to report on. for further impolementations and older master data is still retained.

Hope this works

[Former Member]

Thank you.

Actually we are creating a new info object ZCOMPCODE. But in future if we need to merge data or have a mulitiprovider on D1 and D2 it would be a problem.

[Former Member]

Krishna,

simple and well known solution... You might want to try if appropriate.

Since you dont nwant to modify the COMP_CODE and Datasource D1, for data coming fom D2, add an identifier at the end..

for example, if comp_code 1000 is coming in from D2, make is 1000D2.

so that if 1000 already exsits in D1, then

1000 means D1

1000D2 means D2.

You can modify the text for D1 data to indicate that it comes from D1.

Kind of patchy solution, but may be appropriate given your situation.

Good Luck

Gova

[Former Member]

Gova thanks a lot!!,

This looks good for COMP_CODE as it has less number of records. But I have other Master data to be loaded from new source D2. For eg I have Asset Account number which has some 100K records. Is there any other way ....

Thanks in advance

Krishna

[Former Member]

Krishna,

Is there a reason why you think this method does not work for other object that has 100K records.

Technically, it should work without a problem, if that is your concern.

Good Luck

Gova