topic Re: Database View in Application Development and Automation Discussions

Database View

Former Member — Fri, 21 May 2010 16:49:44 GMT

Hi,

As far as i know we cannot maintain database, help or projection view, then why we have the field 'Data Browser/Table View Maint.' in these view. I have tried with database view. i set the value of the flag as 'Database maintenance allowed' but i am not able to maintain it in the transaction SE54 or SM30.

Also please tell me exactly what these transaction (SE54 and SM30) do and what is the difference between both these transactions.

thanks,

tanmaya

Re: Database View

Former Member — Fri, 21 May 2010 17:04:22 GMT

Hi,

In SE55 you can create the screen that will be used by SM30 to edit/display data.

So, in SE55 you create (only one time) the screen, and in SE11 you inform your table do edit/display in daily work.

Best regards,

Leandro Mengue

Re: Database View

Former Member — Fri, 21 May 2010 17:20:20 GMT

Hi,

In SM30 do you receive message "Table/View xxxx not in the Dictionary" or "The maintenance dialog for xxxx is incomplete or not defined "? O you can´t "maintain" / "edit" the data?

Best regards,

Leandro Mengue

Re: Database View

Former Member — Fri, 21 May 2010 19:42:08 GMT

If it is marked for maintenance in the dictionary definition in SE11, and if you have the authorization, you'll be able to maintain entries in SE16, even if there is no maintenance view.

Re: Database View

Former Member — Sat, 22 May 2010 07:28:45 GMT

hi,

after self studying what i get is we cannot maintain database views in SE54 and SM30. however, we can maintain and create new entries in se16 provided only one table is used in the database view and table maintenance flag have ' maintenance allowed ' value. hope this info will help others....correct me if i am wrong and if you have any other idea about the databse view.

thanks

tanmaya

Re: Database View

Sandra_Rossi — Sat, 22 May 2010 17:05:55 GMT

In SAP NetWeaver 7.0, there is the warning text You can only read database views with more than one table displayed in SE11 Maintenance status tab, just above the "display/maintenance allowed" flag, don't you have it?

Re: Database View

Former Member — Sat, 22 May 2010 17:18:58 GMT

hi sandra,

i know that. but even if you have only one database table attched to the view. you can not cretae maintenance dialog from SE54 or SM30. you can just create entries from se16.

Re: Database View

Sandra_Rossi — Sat, 22 May 2010 19:02:33 GMT

ah okay. When you try to create the table maintenance dialog, SAP sends error message "Only use views of type "Maintenance view"" (Message no. SV309)

You may convert the view type from database to maintenance, using a menu of SE11. If you don't want to alter the original view, copy it and convert the duplicate.

Re: Database View

Former Member — Mon, 24 May 2010 06:00:31 GMT

Yes,

thats what i am saying. if we can't maintain the field then why that attribute 'Data Browser/Table View Maint' is. i studied it and got to know that only significance of that attribute is we can maintain fields in SE16.

thanks

tanmaya

Re: Database View

Sandra_Rossi — Mon, 24 May 2010 10:32:39 GMT

Tanmaya, I think that you can close the post then

Re: Database View

Former Member — Mon, 24 May 2010 10:47:28 GMT

thanks