2007 Feb 02 12:35 PM
hi ,
can any one send me the procedure how to create view in program.
and how its better than for all entries.
thanks & regards
rajareddy.
2007 Feb 02 12:44 PM
Database and projection Views can be created using se11 and used in the reports where ever u need. Where as the maintenance view can not be used directly.
Projection view can be used to fetch the data from only one table. But we can join more than two(related) tables also using database view.
Joins conditions will be auto generated
How it is different:
View are not the physical storage areas. It wont uses memory. and hence the access of data is faster than the data base tables.
Once the view is created , it can be used same as database table.
Cheers.
2007 Feb 02 12:41 PM
raja,
you have to create a view from se11.
you can use that view, normally how do you do a normal select on table.
instead of linking two tables or three tables and giving a select.
you can directly give a select on view.
suppose : v_view is a view on two tables mara makt.
you can write a select like this.
select <col1> <col2> from v_view into table.
check these links for more info...
for all entries is totally differenct concept, like
if you want to get data from database table with respect to entries in internal table then you will be using this.
regds,
kiran
2007 Feb 02 12:44 PM
Database and projection Views can be created using se11 and used in the reports where ever u need. Where as the maintenance view can not be used directly.
Projection view can be used to fetch the data from only one table. But we can join more than two(related) tables also using database view.
Joins conditions will be auto generated
How it is different:
View are not the physical storage areas. It wont uses memory. and hence the access of data is faster than the data base tables.
Once the view is created , it can be used same as database table.
Cheers.