extraction from different datasources
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.
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.