topic Re: Database View Vs Maintanence View in Application Development and Automation Discussions

Database View Vs Maintanence View

Former Member — Mon, 14 Feb 2005 15:23:04 GMT

Friends

Why did SAP design two types of views as above ?(forget projection and help views for the moment).

Is it not possible to control the read only part from Maintanence views when multiple tables are involved as done by Database Views ?

What are the additional benefits by using Maintanence views ?

I would be glad if anyone can explain me the differnces b/w these two types of views.

Apart from the conventional differences, what I need mainly is, "Is it not possible to achieve the functionalities of a database view from a Maintanence view itself ?"

Thanks

Prasad

Re: Database View Vs Maintanence View

Former Member — Mon, 14 Feb 2005 15:27:12 GMT

Incase of Database View there is a chance u would not get the most updated information

Whereas in the case of Maintenance View u would get the most updated Information

Re: Database View Vs Maintanence View

Former Member — Mon, 14 Feb 2005 15:41:39 GMT

Hi Sundara,

(I don't know if you mean differences between SE16 and SM30...)

Well, as far as I can see, I prefer SM30's in order to "give" this maintenance to users, as it would be too dangerous to let them enter tx SE16.

What we do is: we create a Z-transaction which calls SM30 with a couple of parameters, who determine what table we want to change.

Hope it helps. BR,

Alvaro

Re: Database View Vs Maintanence View

Former Member — Mon, 14 Feb 2005 16:25:19 GMT

Hi Sundara,

The set of data that can be selected with a view greatly depends on whether the view implements an

inner join or an outer join.

n With an inner join, you only get those records which have an entry in all the tables included in the

view. With an outer join, on the other hand, those records that do not have a corresponding entry in

some of the tables included in the view are also selected.

n The hit list found with an inner join can therefore be a subset of the hit list found with an outer join.

n Database views implement an inner join. You only get those records which have an entry in all the

tables included in the view.

n Maintenance views implement an outer join.

Maintenance views may not be used as the selection method for search helps. Normally a database

view is used. However, you should note that database views (in the R/3 System) are always created

with an inner join. As a result, only those values having an entry in each of the tables involved are

offered in the input help. Sometimes the values should be determined with an outer join. In this case

you should choose a help view as the selection method

Regards

Immanuel