Replicating Data Source to BW from R/3

[Former Member]

Hello, everyone,

I have created a Data Source in R/3 it is maped to a view,

I replicated it to BW, but i can't find it where.

In R/3 RSA5 transaction i can't find that data source too.

Waiting for your suggestions.

Thanks in advance!

Best Regards,

Arunas Stonys

[RenjithKumar · Accepted solution]

Hi ,

<b>R3 side :</b>

The data source must be created in R3 side using

Transaction <b>SBIW</b> .Assign a application component

to it.In your case you are creating your own data src.

<b>BW Side :</b>

RSA1 , select source system , Rt-click your R3 source

system , Replicate datasources . Now you must get that

data source you created in your BW side under the appl

component you gave .

<b>To view data source in appl.comp</b>

RSA1->Source system , select R3 source system , click

data source overview , expand the appl comp given in

R3 during datasource creation .You must be able to see

the data source .

Regards

Renjith Kumar

[Former Member]

Hi ,Renjith,

My mistake was that i was trying to replicate from R3 side, but not from BW.

Thanks for your help.

Best Regards,

Arunas Stonys

[Former Member]

Hy, Renjith,

Yes i am logging seperately.

We have two IDES systems BW and R3.

Regards,

Arunas Stonys

[RenjithKumar]

Hi Arunas ,

You said that you are doing in IDES .

Tell me whether you are using different servers ( I ask this because client name is same for both ). Because in IDES some will logon once and use different client name for R3 and BW .

Are you logging on seperately for R3 and BW ?

Regards

Renjith Kumar

[Former Member]

Hello, Renjith,

BW client = 800 name = BW Produktiv

R/3 client = 800 name = IDES-ALE: Central FI Syst

I have created data source in 800 client in R/3 and RSA6 checked also in 800 client.

Arunas

[RenjithKumar]

Hi Arunas ,

Tell the name of your R3 client , BW client .

In which client you created data source .

In which client you checked RSA6.

Regards

Renjith Kumar

[Former Member]

One more question: how does R/3 system know to which client (e.g. 800 or 810 or 820) in BW, data source should be replicated?

Arunas

[Former Member]

I am testing everything on IDES now. We have R/3 IDES and BW IDES systems on seperate machines.

I work on 800 client in R/3 and in the same client in BW.

In R/3 system i have two Source Systems: one for R/3 and another for BW.

Then i push right mouse button over R/3 source system on R/3 side and trying to choose <b>Customizing for the Extractors</b> i get a message what <i>No destination exists to source system T90CLNT090</i>.

But over BW source system on R/3 side everything works, i am redirecting to SBIW transaction in BW system.

I am new in BW, Is it something wrong with my connections?

Is it enough just one source system on R/3 side?

I am confused.

Maybe you can explane or send some documentations to my email - ekranas@gmail.com

Thanks in advance.

Best Regards

Arunas Stonys

[Former Member]

Yes i see it in RSA6 transaction on R/3 side, but i can't find it on my BW system under R/3 source system

Arunas Stonys

[former_member188975]

Hi Arunas,

How did you try to find? If you searched in the datasource tree under the source system, please choose the topmost node first and then click the search button...Can you find the application component, to which this datasource is assigned, in BW?

[Former Member]

Hi,

You can also check to see, if the mapping has been done on the info source side; you can try to assign the Datasource and see if it appears in the drop down on the BW side.

One more thought, even though it may sound stupid, make sure that the R3 and BW systems are connected and you are looking under the correct BW and R3 systems, ex if BW Dev is connected to R3 dev, then make sure that you are replicating under BW dev and looking for the DS in BW dev. Also you have created the DS on the R3 dev side. Just taking the system names as an example.

Cheers,

Kedar

[Former Member]

Hi Arunas--

Your datasource will appear in RSA6 rather in RSA5.RSA5 is for Business content datasources. Active datasources will appear in RSA6.

yours is a Generic datasource and you have mapped that to an application component while creating. so after replicating the same in BW side, it will appear by double clicking under Sourcesystem. And now u can search for your datasource here.

Regards,

vishwa.

[Former Member]

Hi,

You'll find it under RSA6. On the BW side, goto Source systems and then view all datasources for that system. Try to refresh the tree as well.

Cheers,

Kedar

[former_member188975]

Hi Arunas,

Since you created the datasource, you cannot find it in RSA5 (SAP Delivered datasources). Try to search for it in RSA6. What application component did you create it under? in BW > RSA1 > Source Systems, double click on your Source System to see all the datasources, then search for your's.

Hope this helps...