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

views

what is the diff between maintanence view and projection view ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2007 at 02:10 PM

    hi,

    In projection view we can get the fields from a single table only ,where as in maintenance view we can get the fields from different tables but these tables should have a relationship between them n function group should be created for it...

    n if u want to get fields from different tables without having a relationship then go for data base view........for db view there is no need for any relationship between tables tyo get the data.

    if useful reward with points,

    madhuri.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2007 at 10:14 AM

    Hi

    The followings are different types of views:

    - Database View (SE11)

    Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

    In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

    - Help View ( SE54)

    Help views are used to output additional information when the online help system is called.

    When the F4 button is pressed for a screen field, a check is first made on whether a matchcode is defined for this field. If this is not the case, the help view is displayed in which the check table of the field is the primary table. Thus, for each table no more than one help view can be created, that is, a table can only be primary table in at most one help view.

    - Projection View

    Projection views are used to suppress or mask certain fields in a table (projection), thus minimizing the number of interfaces. This means that only the data that is actually required is exchanged when the database is accessed.

    A projection view can draw upon only one table. Selection conditions cannot be specified for projection views.

    - Maintenance View ( SE54 )

    Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

    Please have a look at below link. It will help you.

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed06446011d189700000e8322d00/frameset.htm

    for more detailed info look on:

    http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm

    &

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/abap+dictionary&

    reward points

    regards,

    Anji

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2007 at 10:15 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2007 at 02:15 PM

    hi mrudula,

    in projection view we can get data from a single table..

    in maintaince view u can get info from may tables which are related .. with relationship key... in this u need to create a table maintaince generator n and u need to assign a unction module to it...

    table maintaince genrator is used to maintain tables

    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.