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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Force a Database update

Former Member

‎2007 Sep 18 12:55 PM

0 Kudos
263

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.

3 REPLIES 3

Former Member

‎2007 Sep 18 12:58 PM

0 Kudos
165

>> 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

Former Member
In response to Former Member

‎2007 Sep 18 1:06 PM

0 Kudos
165

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

Former Member

‎2007 Sep 18 1:09 PM

0 Kudos
165

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