cancel
Showing results for 
Search instead for 
Did you mean: 

How to load master data in to BI from R3

Former Member
0 Kudos

Hello Buddies

I have few small questions regarding extraction of master data from r3 to BW,Requesting you to please help me

1.)Suppose if i have 6 infoobjects say (materials,products,Regions,country,division,) I want to load master data for these infoobjects from r3(no flat file)

       For this Is it required to create 6 data sources in BW sides to get the master data?

2.)I have seen some of the discussions in this forum regarding extraction of master of data from r3 they are saying that extraction from r3 like in r3  RSA5 --     

      >select datasource->maintaing extract structure-->in BW side as usual procedure like replicate datasource, etc....(But i taught it this procedure is for transaction data not for master   correct me if i am wrong)

3.)I need some standard master  data data source names for SD module for master data if any

Please help me out

Regards

Venkat

Accepted Solutions (1)

Accepted Solutions (1)

former_member186082
Active Contributor
0 Kudos

Hi Venkat,

We have data sources for each master data object. In R3 system, call RSA5 and search with *OBJECT* (OBJECT = CUSTOMER, MATERIAL, BPARTNER, etc, which you need)

All the data sources will be obtained. Now the procedure is the same as you said - activating them, replicating in BW and start loading.

Here are few

0CUSTOMER_ATTR

0MATERIAL_ATTR

0BPARTNER_ATTR

Regards

Chandu

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear Venkat,

          According your scenario, you need to load Master data ( 0MATERIAL, 0PRODUCT, 0REGION , 0COUNTRY,0DEVISION ).from R/3 to BI.

         1) First, go to R/3 Dev system, go to RSA5, and search 0Material ( Attribute,Text,hierar ).

Select those objects, and activate in RSA5 ,using New Request.  Like that do for 0PRODCUT,0REGION etc.

         2) Move the R/3 Dev request to Qty and Production system.  Once done that, RSA1 -> Source system -> Replicate Meta data.  Now data source is replicate in BI side.

         3) Once replicate, go to RSA1 -> Modeling -> Infosource -> find 0MATERIAL infosource.  Trigger info package for Attribute,Text,Hierarchy.

         4) Once done this check " 0MATERIAL " right click -> Maintain Master data.  You can see all Master data's for 0MATERIAL.

         5) Same, you have to follow the rest of objects ( 0PRODUCT,0REGION etc)

Regards,

Baskaran.

former_member210724
Contributor
0 Kudos

Hi,

Yes, you need to maitain 6 different DS(Attributes DSEg: 0MATERIAL_ATTR and Text DS Eg: 0MATERIAL_TEXT) for 6 different infoobjects.If the Infoobject is standard then you will find the DS in RSA5 bydefault.

Activating the DS in RSA5 ........................replicating that in BW.....are applicable for master data DS also.

For Standard DS in SD module,  Rsa5-------->Expand SAP R/3-------->expand SD -------->expand sales master data there it displays.

Anand.

Former Member
0 Kudos

Hi Venkat,

For many info objects we have data sources for R/3 side.

Example:0MATERIAL_ATTR,OMATERIAL_TEXT,

Go to RSA5 and find your data source and install data source.

After installation we can see your data source in RSA6.

Go to BI replicate the data source by using tcode RSDS and map the info objects.

Thanks

Vijay

0 Kudos

Hi Vijaya,

Read your response to a sdn question. I need some help too. My questions are:

1. Who creates these data sources in SD?

2. I have a sales product which has its own customised work bench in SD. I am having problem finding fields and tables for it.

Any ideas how to find. Thanks

Regards

Zafar

Former Member
0 Kudos

Hi Venkat,

Please find the answers to your questions as mentioned below:

1.)Suppose if i have 6 infoobjects say (materials,products,Regions,country,division,) I want to load master data for these infoobjects from r3(no flat file)

       For this Is it required to create 6 data sources in BW sides to get the master data?

Ans). Material is the object which it contains attributes products,regions,country and division objects.

As per requirement you  need to load the Material data from R/3 to BI system. then only mentioned objects get updated with the data.

2.)I have seen some of the discussions in this forum regarding extraction of master of data from r3 they are saying that extraction from r3 like in r3  RSA5 --     

      >select datasource->maintaing extract structure-->in BW side as usual procedure like replicate datasource, etc....(But i taught it this procedure is for transaction data not for master   correct me if i am wrong)

Ans). Yes , You need to activate the datasource in RSA5and replicate the respective datasource from R/3 to BI side.

3.)I need some standard master  data data source names for SD module for master data if any

Ans) You can find the SD related Datasources in RSA5 under respective application.

Regards