maintenance views

[Former Member]

Hi all,

Having created the DB and projection views i was able to use them in the program as a table and get the data displayed in a report.But, when I use the maintenance view, it says the view is not defined.What are the steps to be taken into account?

I checked SM30 and SM54 but not having a clue as to how to proceed further.

In maintenance status- read change is checked for maintenance iview.

Regards,

Sagar

[former_member188685]

if you are using the maintenance view for selecting data, it is not possible.

[Former Member]

Thanks for your reply Vijay.

In that case what good does maintenance view do. What is the purpose of creating one.

Regards,

Sagar

[former_member188685]

"Maintenace view" itself give you the information what it is for.

it explained clearly here what is the use fo maintenance views. read it once.

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ecdf446011d189700000e8322d00/content.htm

[Former Member]

Vijay,

Sorry for bothering you much, but just want to understand how we would use it.

Regards,

Sagar

[Former Member]

Hi Sagar,

According to vijay i hope you might have got the answer.

Still check the below link you might satisfy completely.

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

Cheers!!

Balu

[Former Member]

Yes that makes sense how to create and all but what is the purpose it serves isnt clear yet.

regards,

Sagar

[Former Member]

Hi Sagar,

The maintenance status of a view controls whether data records can also be changed or inserted in the tables contained in the view.

The maintenance status can be defined as follows:

● Read only: Data can only be read through the view.

● Read, change, delete, insert: Data of the tables contained in the view can be changed, deleted, and inserted through the view.

Only read access is permitted for database views that are defined through several tables. If a database view contains only one single table, data can be inserted in this table through the view (see Inserts Through Database Views).

The following status definitions are also possible for Structure link maintenance views:

● Read and change: Existing view entries can be changed. However, records cannot be deleted or inserted.

● Read and change (time-dependent views): Only entries whose Structure link non-time-dependent part of the key is the same as that of existing entries may be inserted.

Clear.

[Former Member]

Hi Sagar,

Maintenance view is like passing the tables properties like in maintenance view we can create the records, chnage the records.

Cheers!!

[Former Member]

Can you be a little more specific about it.

Also, what are the activities to be carried on in sm30 and sm54.

Edited by: sandeep sagar on Oct 19, 2008 8:07 AM