December 28, 2012

Modify the CUA tables to modify settings on a satellite system

#USRFLDSEL is the table with the SCUM settings of the satellite systems of a CUA landscape.

#Setting the UFLAG column to L will turn the desired "LOG_FIELD" field to locally editable, if the UFLAG is setted to G then it will be globally editable. This is very useful when you have to adjust just one thing for a particular user on an ABAP system and don't want to modify the CUA settings. For example, the TMSADM user.

update tst.USRFLDSEL set UFLAG='G' where LOG_FIELD='PASSWORD' and CLIENT='000'