Skip to Content

SAP BW system can be connected with multiple source systems. Among those source systems SAP ECC is central nerve for BW data source.  Most of BW systems are linked with at least one ECC system. How about linking more than one ECC system with single BW system?

First question – is it possible? Yes it is very much possible.

Second question – what is the best data modeling strategy to follow which minimize complexity in design as well as eliminate data redundancy?

System.png

Here I am summarizing a few best data modeling strategy while linking multiple ECC system with one BW system

A. Master Data

To minimize repetition of master data info objects utilize  single (standard or customized) master data info objects. Compound master data info object with source system (0SOURCE_SYSTEM). Due to compounding record from each system will be unique along with combination from source system.

If you are wondering, why Compounding is required? It is required because if same value arrives from both systems then it will through duplication error or even if duplicate handling is enabled at DTP level, it will overwrite existing value with new one. In such case we will have value from one system only.

For Example, if we are getting 0Materail having material number M001 with different attributes from Source system ECC1 and ECC2.

0Material details are as below

0Material Attributes

Source System ECC1

Source System ECC2

Material No

M001

M001

Material type

Semi-Finished

Finished

Merchandise Category

Casual

Formal

Color

Red

Blue

Weight

10

5

In such case if 0Material is not compounded with source system, we will have only one M001 that gets uploaded recently i.e. either from Source system ECC1 or ECC2. To retain M001 from both systems, compounding with source system is required.

 

B. Transaction Data

In case of transaction data any such specific mapping is not required. Best practice is to keep data in separate DSO/info cube from each system.

To create consolidated report utilize multiprovider with DSO/Info cube from both systems.

At query level as per need restrict source system in restricted key figures.

C. Process chain

Since Master data info objects are same, so we need to upload data from each system in sequence to avoid lock situation.

Transaction data have no impact because source system and target providers are different.

D. A few more frequently asked questions

– Delta Handling

No impacts on delta load and delta pointer since source systems are different.

– Data Load Performance

Data load performance will not have much impact if process chain to upload data from each system organized efficiently to avoid dead locks.

– Reporting

We can create reports as per need either from single system or consolidated one inclusive of each system. It will be more flexible. To optimize performance restrict info provider wherever possible.

– Data Volume

It is based on transaction data in each system.

Please note above list is not exhaustive. It can be adopted as per requirement and specification.

Hope it will help.

Thanks.

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Sangita, Very nice article. I do have a question, however. The source system is a 2 character long field. Can we modify that field length or is it better to create a  new field.

    Thanks,
    Samir

    (0) 
    1. Former Member Post author

      Thanks Samir for your appreciation. If source system is having a field with 2 character length and in BW corresponding info object is having length 1, then better to increase the length of BW object. It will not impact, even if data is already loaded for that object. However it is not advisable to decrease the length. In such case better to create a separate info object.

      Thanks.

      Regards,

      Sangita

      (0) 
  2. Former Member

    Thanks for the document.

    I got one question: Can A single BW System connect to Multiple Clients of a Single Source System [ECC]

    regards

    Raj

    (0) 
    1. Former Member Post author

      Hello Rajeev,

      Yes, it is possible to connect Multiple clients of a single ECC system with a single BW system. You can contact Basis team for more details about connection settings (SM59 etc.).

      Thanks.

      Sangita

      (0) 
      1. Former Member

        Hi Sangita,

        Will there not be any issue of duplication if we have Source systems of different Clients(100, 110) of ECC into BW(100)?

        We are in the same situation to have 2 different clients of ECC connect to BW.
        From Basis perspective, it is a possibility, but from BW standpoint, what precautions/steps do we need to take to avoid any discrepancy.

        Thanks and Regards,

        Satish Dhanalakoti

        (0) 
        1. José Luis Leitão

          Hi Satish,

          Each ECC Client will be created as its own source system in BW, and each one should have a different logical name, i.e.:

          – ECCCLNT100

          – ECCCLNT110

          From this point forward apply the same logic Sangita presents in her Blog post to avoid any issues.

          Note that each source system should have its own 2 digit code for infoobject 0SOURSYSTEM, you set the code assignment in RSA1 > Source Systems > Menu: Tools > Assignment of Source System to Source System ID.

          Regards,

          Jose Luis Leitao

          (0) 
  3. Former Member

    Hello Everyone,

     

    What about the data sources and respective transfer rules or transformations?

    Is there a program which can replicate these between new ECC and existing BW systems? (Similar to existing ECC and BW).

    Or, should everything be redesigned?

     

    Thanks & Regards

    Bhargav

    (0) 

Leave a Reply