topic Re: Regarding View in Application Development and Automation Discussions

Regarding View

Former Member — Sat, 17 Feb 2007 09:59:28 GMT

Hello Guys..

I want To know Something About View in SAP.

View are create only to use in Search help ?.is it ....

1. Defination.

2. Different Use's.

3. When to Use Seach help with View and when Not.

Thank

Swati...

Re: Regarding View

Former Member — Sat, 17 Feb 2007 10:14:05 GMT

View :

Created to Provide Restricted access to user on a specific table .

Many Types :

Data Base View :

Combined by joining more than 1 tables .

Projection View

To project selected field from One table .

Re: Regarding View

p291102 — Sat, 17 Feb 2007 10:14:35 GMT

To extend of the comments above, Views are not a concept specific to SAP. Database views are part of the Relational Database model created by Dr. E.F Codd in the early 1970s.

Views can be created for the sole purpose of reducing the resultant columns (as mentioned above).

However, they are more appropriately used to join multiple tables based on certain criteria. This "joining" inside of the view reduces the amount of SQL that an application developer needs to write get create reports, etc.

In theory (at least), it should also reduce the number of "bugs" that an application developer might create by not understanding the data table structures, inefficient SQL, poor coding structure, etc.

Re: Regarding View

Former Member — Sat, 17 Feb 2007 10:15:34 GMT

View :

Created to Provide Restricted access to user on a specific table .

Many Types :

Data Base View :

Combined by joining more than 1 tables .

Projection View

To project selected field from One table .

Re: Regarding View

Former Member — Sat, 17 Feb 2007 14:19:58 GMT

View is nothing but a table....it is created to join 2 or more tables so that data can be stored from all gthe tables while saving....Data retrieval will be fast when using a VIEW...

To see a view, goto SE11 & specify the view name in the tables name & goto display mode...Here u can check all the properties of the view and also will be able to see which all tables have been used to create the view...

There are 4 types of views Maintainenance view, database view..project view..etc..

View doesn't physically contain data. It points to the data in table/s using a set of joins and conditions.

Re: Regarding View

Former Member — Sat, 17 Feb 2007 15:53:19 GMT

Hi swati,

The concept of View is so simple and very useful. I will try to give a brief idea of it. there are 4 types of views. 1. Data base View

2. Maintainence View

3. Projection View

and 4. Help View.

But in new versions Help view is not there. So overall we consider 3 types of views.

A view is basically a ligical way of viewing the required fields of a database table. i.e., if I have a database table with say 40 fields of which i want to use only 15 fields or so in my program and if i have to get the field details repeatedly from the table, I have to write the select statement as SELECT FLD1 FLD2 FLD3....... FLD15 FROM ........ and i should also define the structure of the internal table mentioning all the 15 fields which is a cumber some process and tidious process. Instead I can define a view with the 15 fields of the table in the data dictionary and then in my program i can define the internal table with structure as that view very simply and also i can now write the select statement as SELECT * FROM ...... and process same as above in the program which is easy. This way of defining a view with only one table is called as PROJECTION VIEW. Another importent thing about this view is that we can also enter data into the database table using a projection view. i.e., if we are loading some data in the view it means we are storing the data in the db table from which the view is defined.

Coming the the remaining two types of views, if we need to access data of fields in two or more tables which are related with each other ( with foreign key relation. I hope u know about that) then we use the remaining two types of views. In database view we have to define the relation between the tables whereas in maintainence view it generates the relation by itself. Here one thing is that we only get data from the data base tables through these two types of views. WE CANNOT LOAD DATA INTO DATABASE TABLES USING DBVIEW AND MAINTAINENCE VIEW. And I hope how easy it is to write a select statement to fetch data from a single database table instead of two or more. One of the main advantage of these two types of views is this. The view has put all the required fields from different tables into a single table (VIEW) using the relation between the tables.

Search helps is a bit different concept. As search helps can also be defined independently, there is'nt any use of Help view and so we generally dont use it in new versions.

This is all a brief overview of the advantages of view. I hope by now u got something from this lengthy description.

regards,

rajsekhar.k

Now coming to

Re: Regarding View

Former Member — Mon, 26 Feb 2007 06:12:51 GMT