views

[Former Member]

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.

[Former Member]

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

[Former Member]

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.htmhttp://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

Regards,

Sudhir Kothavale.

[Former Member]

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

[Former Member]

Hi Enoch,

                     Kindly view the below link you will get and idea .

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

Regards,

Anand raj.S

[Former Member]

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.