topic Re: Force a Database update in Application Development and Automation Discussions

Force a Database update

Former Member — Tue, 18 Sep 2007 11:55:46 GMT

Hi everybody !

I want to force an update without having to worry about the possible blocks in case the personal number would be in use. Is there any smart way to do this without using batch input and without having to access SM35 unless there isn't errors ??

Thanks in advance for your help.

Re: Force a Database update

Former Member — Tue, 18 Sep 2007 11:58:33 GMT

>> want to force an update without having to worry about the possible blocks in case the personal number would be in use.

Why do you want to do that? the very purpose of the pernr lock is to preserve data integrity.I wouldn't suggest such an update.

Arya

Re: Force a Database update

Former Member — Tue, 18 Sep 2007 12:06:54 GMT

It is an update of some fields that the user is not going to change because they are disabled. They can only be showed.

Re: Force a Database update

Former Member — Tue, 18 Sep 2007 12:09:54 GMT

Hi Maria,

Try using the UPDATE keyword along with SET keyword in that, where you will be setting the non-primary key fields based on the key fields.

Hope this resolves your query.

Reward All the helpful answers.

Regards

Nagaraj