regarding data source

[Former Member]

HI Experts,

Can u tell me how to Create a datasource using the table view and how to create table view.

[ravikanth_indurthi · Accepted solution]

Hi Hema,

You can create data source using tables/views by generic extraction process.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d3219af2-0c01-0010-71ac-dbb4356c...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b062adbb...

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/bi/generic%2bextraction

Hope this helps.

Thanks = Points in SDN

Rgs,

I.R.K

[Former Member]

Hi

follow the steps for creating a View and u can get the steps in sap.help

1) Go to SE11. Choose 'views' option and click create.

2)Choose DB View

3)Save it in a Development class

3)In the Table column, enter the Table name on which you want to create view.

4)In the 'View Fileds' tab, enter the Table name and field nams in the respective columns and then save the view.

5)Check it and then generate the View.

Here's how to create a datasource from View:

1) Go to transaction RSO2 and create a datasource.

2) Specify the Application component, description and table/view

3) Test your datasource in RSA3.

[Former Member]

hi,

goto se11 in source system,

choose database view give name-> create.

choose the tables and the join condition of primay keys ->activate the table ->also specify the fields to used.

goto RSO2 -> choose the type of data source and give the name -> create -> give the application component name -> view name -> and specify the delta method and save the data source.

replicate the datasource in BW side ->assign infosource and other stuffs and start ur loads.

Ramesh