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

views

what is the exact difference between projection view and maintanence view.plz tell in exact and briefly.

points will be rewarded.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 09:18 AM

    hi,

    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.

    Creating Database View:

    http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

    Creating Projection View:

    http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ecc5446011d189700000e8322d00/frameset.htm

    Creating Help View:

    http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ecd2446011d189700000e8322d00/frameset.htm

    Creating maintenance View:

    http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ecdf446011d189700000e8322d00/frameset.htm

    what-are-the-various-views

    http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ec5d446011d189700000e8322d00/content.htm

    Regards

    Reshma

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 09:20 AM

    <b>Projection Views</b>

    Projection views are used to mask out certain fields of 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 only refer to one table. Selection conditions cannot be specified for projection views.

    There is no corresponding object on the database for a projection view. Access to a projection view is mapped by the R/3 System onto the corresponding access to its base table.

    It is also possible to access pooled tables or cluster tables with a projection view.

    In an INSERT with a projection view, the fields which were masked out are supplied with their initial values, thus avoiding NULL values.

    <b>Maintenance Views</b>

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

    A standardized table maintenance transaction is provided for this (SM30), permitting you to maintain the data from the base tables of a view at one time. The data can often also be maintained with customizing transactions.

    Maintenance mechanisms, like screens and processing programs, must be created from the view definition with a special transaction (SE54). This makes it possible to generate comfortable maintenance user interfaces in a simple manner.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 09:20 AM

    hi,

    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. 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.

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

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

    tables included in the view.

    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

    Refer

    database-view-vs-maintanence-view

    Regards,

    Santosh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 09:20 AM
    Data about an application object is often distributed on several tables. By defining a view, you can define an application-dependent view that combines this data. The structure of such a view is defined by specifying the tables and fields used in the view. Fields that are not required can be hidden, thereby minimizing interfaces. A view can be used in ABAP programs for data selection.
    
    
    Details of Views.
    
    1. Maintainance VIew Will allow you to edit / delete or create new entry.
    2. Database view allows you to display content of DATA Base. Are implemented with an equivalent view on the database.
    3.Projection view are used to hide fields of a table (only projection). i.e if you want to display only a few fields of table not all of them.
    4. Help veiw will help you to create search Help.
    
    If you have SAP help with you. you can open file 619.chm from the directory you will get details of the view. 
    
    
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 09:20 AM

    Hi

    excerpt from sap help file:

    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.

    chk this: dictionary

    regards,

    madhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 09:29 AM

    maintenance view :

    its a collection of screens for

    facilitation data entry into the table. A maintenance view is used to maintain data for an object that is technically distributed on several tables.

    projection view :

    Projection views are used to hide fields of a table. This can minimize interfaces; for example when you access the database, you only read and write the field contents actually needed.

    A projection view contains exactly one table. You cannot define selection conditions for projection views.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 09:39 AM

    Hi,

    VIEWS

    There are four separate, types of views:

    Database view

    - Defined just as a table is defined within the database

    - one or more related tables may be used

    - only transparent tables may be used

    Help view

    - Accessed from within transactions

    - accessed only from within SAP Help

    - Open SQL and Native SQL cannot access

    - only 1:1 and 1:C relationships are possible

    Projection view

    - Allows suppression of some fields within transparent table displays

    Maintenance view

    - Enables table maintenance via SM30

    - allows specific customizing transactions

    VIEW

    POINTS:

    · A view is like a table but lacking content – it is a Virtual Table.

    · A view is a definition based upon the relationship between one or several tables using the permitted relational database operations

    · A view reduces the need to create new tables with only the specific data for each application

    · A view reduces redundancy of tables (which are costly to maintain) and is a preferred method for relating specific modules of business applications, which may be logically separated.

    *****reward points if useful.

    all the best

    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.