maintainence view

[Former Member]

tell me something about maintenance view

[Former Member]

It's used to maintain entires in a table view, i.e. multiple tables can be updated through one screen.

[Former Member]

hi,

Data that is distributed on more than one table often forms a logical unit, called an application object.

You should be able to display, change and create the data of such an application object together. Users

usually are not interested in the technical implementation of the application object, such as the

distribution of the data on several tables.

You can maintain complex application objects in a simple way using a maintenance view. The data is

automatically distributed on the underlying database tables.

All the tables used in a maintenance view must be linked with a foreign key. This means that the join

conditions are always derived from the foreign key in the maintenance view. You cannot enter the join

conditions directly as in a database view.

A maintenance interface with which the data of the view can be displayed, changed and created must be

generated from the definition of a maintenance view in the ABAP Dictionary.

When the maintenance interface is created, function modules that distribute the data maintained with the

view on the underlying tables are automatically generated.

The maintenance interface is generated with the Transaction Generate Table View (Transaction SE54)

or from the view maintenance screen with Environment -> Tab.maint.generator.

Maintenance views implement an outer join.

Hope this helps, Do reward.

[Former Member]

Message: Hai.

check this.

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.

Go thru this link plzz

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

- 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&;

1.Go to se11

2. select view radiobutton and give a name

3. Create

4. select type of view you want to create. Such as database view.

5. give short description

6. give a table name such as mara

7. press the pushbutton relationship. here you will find all the tables which are allowed to create view with mara.

8. select one or mane tables.

8 copy

9.save , check and activate.

[Former Member]

When you run the Maintenance view, it will not allow you to change the primary keys fields they will be grayed out, other than that all the non primary key fields will be input enabled,

There you can directly change the values and save. they will reflect in the respective database tables.

I hope this give you fair idea about the maintenance view.

Let me know if you need detailed steps for the same