issues in loading data into dso from multiple datasources

23 Views

Dear SAP techies,

I have a problem in loading data from multiple datasources to DSO.

Here it is:

I have my account master data in 1 data source having for example 10 records.It has account number,customer type,adress as its fileds.

I have another data source for account master data containing customer telephone number,email id .This datasource also has 10 records.

I have a 3rd datasource for transaction data against account master data, but it contains transaction data for only 5 account numbers.

When i am loading data from the above mentioned 3 data sources to DSO , the DSO gets loaded with 10 account records, 5 having transaction data and the rest 5 having zero value in the transaction data field.

Kindly suggest a solution to load only the 5 account numbers in dso that have the transaction data..

Thanks,