topic Re: how to create a database view in Application Development and Automation Discussions

how to create a database view

Former Member — Thu, 27 Mar 2008 10:46:52 GMT

dear all,

how to create database view with example.

Re: how to create a database view

Former Member — Thu, 27 Mar 2008 10:54:16 GMT

goto SE11

select View option and put name starting with 'Z'

n create the view u want.

try it u can do it.

don't forget to reward.

S@meer

Re: how to create a database view

Former Member — Thu, 27 Mar 2008 10:54:38 GMT

Hi,

in SE11 u can create view that is below database table

there u need to give required joining condition

reward if helpful

Edited by: Ashish Paliwal on Mar 27, 2008 4:25 PM

Re: how to create a database view

Former Member — Thu, 27 Mar 2008 10:56:23 GMT

Hi jyothi,

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

chek this link.

regards

shibu

Re: how to create a database view

Former Member — Thu, 27 Mar 2008 12:40:44 GMT

Hi,

Database View: You can create this view on transparent table. It supports all the three operations like Selection, Projection & Join.

Creating View

• From initial screen of data dictionary, enter the name of object i.e. view.

• Select view radio button and click on the push button.

• Dialog box is displayed for types of views.

• Select the view type.

• On the next screen, you have to pass following parameters.

• Short text

• In the table box you need to enter the table names, which are to be related.

• In join table box you need to join the two tables.

• Click on the TABFIELD. System displays the dialog box for all the table fields and user can select the fields from this screen. These fields are displayed in the view fields box.

• Save and Activate: When the view is activated, view is automatically created in the underlying database system. As long as the table exists in the database, the view also exists (Unless you delete it).

Regards,

Bhaskar

Re: how to create a database view

Former Member — Thu, 27 Mar 2008 12:49:31 GMT

Hi,

1. Go to se11

2. click the view radio button and give the new object name

3. Then you will be prompted to select one among 4 more views

4. Select database view then enter.

5.Give short description

6. Click the Table/Join conditions tab then give the table names which are going to be joined.

note: we can have only inner join with the database view.

7. Give the table names as mara,marc,makt under tables

8. Then in the adjacent area that is in Join conditions just give

mara-matnr = marc-matnr

marc-matnr = makt-matnr

9. Then click the tab View flds, give the field names whichever you want to fetch from the tables as just like the ineer join in the select query as like follows.

matnr -> mara -> matnr

werks -> marc -> werks

maktx -> makt -> maktx

10. Then save and activate.

For further reference use the link,

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

Regards,

Sankar.

Re: how to create a database view

Former Member — Thu, 27 Mar 2008 12:52:07 GMT

Goto se11 transaction.....in taht there is a tab VIEW select taht...then u wil get a pop up in taht u acan select DATABASE VIEW....click continue..in the next screen u can give the table names and click on relationship tab so the relation wil be maintained......

in the VIEW FEILDS tab u can give the feilds which u want to use in the view.....

save and actiavate...