Skip to Content
author's profile photo Former Member
Former Member

Database View Vs Maintanence View

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 14, 2005 at 03:27 PM

    hi

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 14, 2005 at 03:41 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 14, 2005 at 04:25 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.