Skip to Content
avatar image
Former Member

How to load master data in to BI from R3

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    May 28, 2012 at 08:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2012 at 08:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2012 at 10:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 29, 2012 at 04:51 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 29, 2012 at 05:48 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded