How to unlock SAP* user id.

Use the below commands

update sapsr3.usr02 set flag=0 where bname=”ddic” and mandt=’100′;

or

update sapsd1.usr02 set uflag=0 where bname=’SAP*’ and mandt=’120′;

To check the status of SAP* user id
select status from sapr3e.usr02 where bname=’SAP*’ and mandt=’120′

Delete SAP* user id.

delete from sapsr3.usr02 where bname=’SAP*’ and mandt=’120′;