Skip to Content
avatar image
Former Member

extraction from different datasources

hi,

my problem is we need some fields from one datasource and some in other and some in another.so how can i extract these fields and can use them .can any body give a solution how to achive this.or can we extract the fields from the tables in r/3 which is better option.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 05, 2006 at 05:14 AM

    Sekhar

    There are 3 options of doing this :

    Option 1:- If fields that you want from different datasources are related to one particular application area say purchasing/sales then you can enhance the base datasource(contains max no of fields you want) with the required fields from other data sources ...write an ABAP user exit to populate these fields .

    Option 2 :- You always have option of creating generic data source based on view/infoset query extraction/function module .

    Option 3 : If the required fields are from one particular application area then extract data from these data sources into respective ODS objects . Then you can manipulate the data into Infocube/ODS on top of these base ODS objects if it suits ur requirement.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2006 at 05:13 AM

    Hi shekar,

    1)collect all the fields which you want to extract and also identify the SAP tables where the fields belongs to.

    2)Create a Table or View

    3)RSO2 > create a generic extractor

    I hope you know the process of generic extraction.

    If your datasources are already loading data to BW, you can create a multiprovider by combining the data targets and you can achieve this.

    Let me know, if you need any more details.

    Hope this helps.

    Praveen

    Message was edited by: V.P.K

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2006 at 05:17 AM

    Hi sekhar

    what is the problem, u can extract from different datasource to one datatarget. u can have update rules for all the data source.

    Hope it helps.......let me know

    Regards

    NR

    Add comment
    10|10000 characters needed characters exceeded