Creation of view on top of two tables or creation of two datasources and loading to DSO
I have two customized tables and created two datasources on top of it(for time being). Here i am having doubt to connect these data sources to DSO.
First Datasource contains: (bold fields are keyfields)
Limit eff. from
Second data source contains: ((bold fields are keyfields))
Connection between the two tables: Company and Transaction concatinated (DSO2) and linked to CodeAssignment obj (DSO1).
Here my question is can we create a view on top of these two tables?
If we are loading seperately two tables (by createing two data sources) into DSO how can i select key fields and data fields at DSO level and how i need to load??
Please let me know your views.