How to Create View on Different Tables and Load Data through Generic Datasource based on that View

This article describes first how to create a view on two or more tables. Then how to load data through generic datasource based on that view. Here I have used BI tables and datasource created on BI server. But the same procedure we can follow if we need to load data from R/3.