topic Re: maintenance views in Application Development and Automation Discussions

maintenance views

Former Member — Sun, 19 Oct 2008 05:53:25 GMT

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

Re: maintenance views

Former Member — Sun, 19 Oct 2008 06:01:08 GMT

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

Re: maintenance views

Former Member — Sun, 19 Oct 2008 06:02:51 GMT

Thanks for your reply Vijay.

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

Regards,

Sagar

Re: maintenance views

Former Member — Sun, 19 Oct 2008 06:06:24 GMT

Hi Sagar,

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

Cheers!!

Re: maintenance views

Former Member — Sun, 19 Oct 2008 06:07:08 GMT

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

Re: maintenance views

Former Member — Sun, 19 Oct 2008 06:07:50 GMT

"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

Re: maintenance views

Former Member — Sun, 19 Oct 2008 06:36:18 GMT

Vijay,

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

Regards,

Sagar

Re: maintenance views

Former Member — Sun, 19 Oct 2008 06:42:28 GMT

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

Re: maintenance views

Former Member — Sun, 19 Oct 2008 11:18:18 GMT

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

regards,

Sagar

Re: maintenance views

Former Member — Sun, 19 Oct 2008 11:31:54 GMT

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.