Application Development 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: 

How to change the Access for Database views

Former Member
0 Kudos

Hello Experts,

My requirement is to copy the records of a standard database view BDCPV (which is a combination of BDCP & BDCPS) to a custom view and then compare the records with a new table BDCP2.

I copied the BDCPV view to a table and used the custom view in the program. While executing the program, I'm getting an error message like "The database view <View Name> is write protected, so it cannot be changed".

I'm unable to change the Access under Maintenance Status Tab from Read only to "Read and Change". Could anyone help me how to resolve this issue".

Also please share teh sample code if you have any for the above requirement. We are using it in a SP upgrade to one of the systems.

Regards,

Rajesh.

3 REPLIES 3

Former Member
0 Kudos

Hi,

In your view (goto se11 & give the view name & change), just change your access as 'read & change' in the 'Maint. & Staus' tab.

Once it is done, hope your issue will be solved.

Regards,

Selva K.

0 Kudos

Hi Selva,

I already tried, but it didnt worked. The access tab is still grayed out.

Former Member
0 Kudos

Hi,

Change the status in the given way.

Choose Extras ® Maintenance status. A dialog box appears, in which you can select the maintenance status for the view. If more than one table is involved in the view, the maintenance status read only cannot be altered.

Regards,

Srinivas.