Skip to Content
avatar image
Former Member

maintenance views

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 19, 2008 at 06:06 AM

    Hi Sagar,

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

    Cheers!!

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Oct 19, 2008 at 06:01 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.