08-06-2010 10:42 AM
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.
08-06-2010 11:10 AM
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.
08-06-2010 11:27 AM
Hi Selva,
I already tried, but it didnt worked. The access tab is still grayed out.
08-12-2010 5:48 AM
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.