Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Maintanance view.

Former Member
0 Likes
1,063

Hi all,

What is the advantage of creating maintainance view?

The data is entered with the view and then distributed to the underlying tables by the system.(How the data is entered into this view?)

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,024

Hi,

another advantage comparing to enter data in SE16N is that you can fill in data which is based on database views, meaning to fill in data relevant for more than one table.

E.g. creating maintenance views for value tables incl. language dependent text tables. That is done automaticly.

Another plus is, that you can control data access via authorization groups. You can also create transaction variants of SM30 to create your own tcodes for displaying/editing the content.

BR,

Sebastian

Hi all,

What is the advantage of creating maintainance view?

The data is entered with the view and then distributed to the underlying tables by the system.(How the data is entered into this view?)

6 REPLIES 6
Read only

Former Member
0 Likes
1,024

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.

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.

Read only

Former Member
0 Likes
1,024

Its is an effective way of maintaining data in tables. While you can create new records, you can simultaneously modify existing records. You donot have to worry about adding corresponding data records to different tables, rather the data is itself distributed in underlying tables.

Regards

P Bansal

Read only

Former Member
0 Likes
1,025

Hi,

another advantage comparing to enter data in SE16N is that you can fill in data which is based on database views, meaning to fill in data relevant for more than one table.

E.g. creating maintenance views for value tables incl. language dependent text tables. That is done automaticly.

Another plus is, that you can control data access via authorization groups. You can also create transaction variants of SM30 to create your own tcodes for displaying/editing the content.

BR,

Sebastian

Read only

Former Member
0 Likes
1,024

a maintainance view is used with transaction SM30.

most users dont knwo much about the technical side of SAP, and you cant let them maintain tables with the SE16N and "&sap_edit", therefopr maintainance views are created.

Maintainance views also can drill down a very complex structure of one or more tables to a simple view where you can maintain things quite user friendly and dont have to know anything about foreign key relations and such.

Read only

Former Member
0 Likes
1,024

Hi,

Maintanance view permit you to maintain the data distributed on several tables for one application object at one time. data is automatically distributed in the underlying database tables. All the tables in a maintenance view must be linked with foreign keys, that is the join conditions for maintenance views are always derived from the foreign key. We cannot directly enter the join conditions as for database views.

Please go through the below link for how the data is entered inthis view.

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

Thanks.

Read only

Former Member
0 Likes
1,024

solved