UPDATE USR02 SET UFLAG = 0 WHERE BNAME = 'SAP.' AND MANDT = xxx To check the account status for DDIC SELECT UFLAG FROM USR02 WHERE BNAME ='DDIC'. Hi all, I was asked to look into a problem in my current clients SAP instance where by users where not showing up in a report for complex selection of user IDs. Basically if they used a check box for 'only unlocked users' they would get a incomplete list. After investigating I found that the values in USR02 UFLAG field where different from. When SAP BC team locks the users to do their job (maintenance, upgrade or whathever), they use a program to add 1 in the Uflag. So when they have to unlock the users they know which ones they locked and which ones were already locked by admin or other reasons. So when they have finished their job, they launch another program to do -1 to Uflag. In db2, update sap.usr02 set uflag=0 where mandt=client and bname=username.
Sync, Edit and Download Oldboy2013 english Subtitle (AC3,BRRip,XviD,TS,BluRay,x264,HD,720p,720,1080p,1080,BDRip,BDR,BDRip,BDR,x264,BRRip,720p,720,AC3,XviD,TS,BluRay. Oldboy movie download with english subtitles. English Subtitles for DivX movie: 'Oldboy 2003' Searh and Download Over 80 Million DVD Quality Movies!!! Subtitles for Oldboy 2003. Oldboy 2003 Click here to download subtitles file for the movie 'Oldboy 2003' Click here to download the movie 'Oldboy 2003' Ads: What? I said I just wanted to speak What the hell? What's with the way you. Sync, Edit and Download Oldboy2003 english Subtitle (TS,BluRay,HD,1080p,1080,REMUX,AC3,x264,720p,720,TS,BluRay,x264,YTS,720p,720,1080p,1080,BRRip,HD,BluRay,HD,Full. Oldboy Full Movie Watch Download Now ️ We will always upload all videos related to movies and TV fi.
When we don’t have any user to login into SAP ABAP level to unlock sap* and ddic user ,Mostly it requires in client 000 as it is supported by SAP BASIS Team . In this case we can unlock sap* or ddic user from OS level / Databse / Sql Level
Unlock DDIC User from OS Level / database /SQL /Oracle level:
Login into Sqlplus:
sqlplus / as sysdba
SQL> select MANDT, BNAME, UFLAG from <schema Name>.USR02 where MANDT=<Client No> and BNAME=’DDIC’;
MAN BNAME UFLAG
— ———— ———-
600 DDIC 64
UFLAG : 64 means ,DDIC user is lock.
BNAME = User Name
MANDT = Client No
SQL> update SAPSR3.USR02 set UFLAG=0 where BNAME=’DDIC’ and MANDT=600;
Here SAPSR3 is schema name and 600 is client no
Unlock Sap* User from OS Level / Database /SQL /Oracle level:
SQL> select MANDT, BNAME, UFLAG from <schema Name>.USR02 where MANDT=<Client No> and BNAME=’SAP*’;
MAN BNAME UFLAG
— ———— ———-
600 DDIC 64
UFLAG : 64 means ,SAP* user is lock.
BNAME = User Name
MANDT = Client No
Sap Uflag 128
SQL> update SAPSR3.USR02 set UFLAG=0 where BNAME=’SAP*’ and MANDT=600;
Uflag Sap
Here SAPSR3 is schema name and 600 is client no.