How to handle 2 SAP sources into one BW target

[former_member230374]

Hello All,

I have 2 SAP sources ECC1 and ECC2, need to do reporting in BW as target.

For all the Master data objects like 0Comp_code, gl_account etc, I am getting data from both the sources (as of now the data is not duplicated meaning as different GL Accounts, company codes etc.

Created copy of standard Info providers to get data from different sources for handling transaction data.

ECC1 --> 0IC_ABC

ECC2 --> Z0IC_ABC

Master data from both the systems goes into dame info objects.

ECC1 --> 0GL_ACCOUNT

ECC2 --> 0GL_ACCOUNT

Is this the right way. I only fear if the chart of accounts in both the systems are duplicated, how the system handles the master data. Will there be inconsistnecies ?

Please advise.

Thanks

Krishna

[Former Member · Accepted solution]

Hi Krishna,

For transaction data, you may need to use separate data targets in order to avoid the aggregration of key figures. Further, you can use the multiprovider, if single report is needed on both the targets.

For master data, using the same infoobject to load from different source systems should work good as the key figures are not involved here.

Also, we have the 0SOURCESYSTEM field which can be used as a key to differentiate the records from both the systems.

Hope this helps.

Regards,

Nikhil

[Former Member]

hi,

As you mentioned that this is master data, with separate combinations of source systems, duplicate data should not be  a problem. You can always handle duplicate data master data with the DTP checkmark further in the flow.

Also, if you do find inconsistencies, then you can use 0SOURCESYSTEM field (like Nikhil suggested) and differentiate the records coming from different systems.

You can go ahead and load your master data. However, I do think that testing beforehand would help.

Hope this helps!

Thanks,
Sheen

[Former Member]

Hi, the way you mentioned is correct, your loading data from different sources to single master data object.most probably duplicate records wont come; because your using different datasources, transformation and DTPs . if u get duplicate records from source select handle duplicate records at DTP level.