topic Re: views in Application Development and Automation Discussions

views

Former Member — Sun, 10 Mar 2013 06:14:47 GMT

Hi all

I'm now working on views..can anyone pls send me some document regarding views.....!!! my requirment is i need to create a view from 5 tables based on a program in which data is been extracted using select statements.... i don't know based on what i've to create a view.. can anyone help me with this???

Thanks in advance.

Re: views

Former Member — Sun, 10 Mar 2013 06:56:24 GMT

Hi,

If you have the requirement to create a view from 5 database tables then you need to create database view. Please follow the steps in the link.

http://saptechnical.com/Tutorials/ABAP/View/Database.htm

The link shows the database view with 2 tables. You can create your own with 5 tables.

Regards

Purnand

Re: views

Former Member — Sun, 10 Mar 2013 07:57:05 GMT

Hello Enoch,

Note If the database view contains more then one table,you can only read the data.

Make use of proper inner joins. Follow this,

http://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm http://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

Regards,

Sudhir Kothavale.

Re: views

Former Member — Sun, 10 Mar 2013 08:14:20 GMT

for creating view there must have to create relationship between table using JOINS.

for joins please go through below link:-

http://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21ec77446011d189700000e8322d00/content.htm

Re: views

Former Member — Mon, 11 Mar 2013 06:09:55 GMT

Hi Enoch,

Kindly view the below link you will get and idea .

http://saptechnical.com/Tutorials/ABAP/View/Database.htm

Regards,

Anand raj.S

Re: views

Former Member — Mon, 11 Mar 2013 06:52:10 GMT

Hi Enoch,

If you want to view the data from multiple database tables simultaneously then you should create a database view in data dictionary then you can able to do it.

Thanks.

Pavan.