Banner 468 x 60px

Sunday, December 30, 2012

Auto Login to SAP GUI

Requirement :

User will be given a short cut on his desktop for his frequent access transaction codes from his favorite tcode list  and he do not need to enter user name and password every time.

Solution:

Create a desktop icon for his tcode.  

Login into sap with user id and right click on transaction and select create shortcut on desktop


Icon on desktop will be created.



After logging out from sap click on the icon. It will open the PO create screen but it will prompt you for password.




To enable autologin follow below procedure 


Right click on icon and edit menu.



By default Password field is disabled. To enable this make following changes in windows registry. 

Navigate to HKEY_CURRENT_USER  > Software > SAP > SAPShrotcut > Security > Create new string value EnablePassword and the value shoud be 1.




This will enable password field in above screen. Enter the password and save the entries. Once You click on desktop icon it will open transaction window without prompting for password.



Read more...

Thursday, November 8, 2012

Friday, November 2, 2012

SAP Authorization Objects Tables

0 comments

Table Name Description
TOBJ Authorization Objects
TACTActivities which can be Protected (Standard activities authorization fields in the system)
TACTZ Valid activities for each authorization object
TDDAT Maintenance Areas for Tables
TSTCSAP Transaction Codes
TPGPABAP/4 Authorization Groups
USOBTRelation transaction > authorization object
USOBX Check table for table USOBT
USOBT_C Relation Transaction   > Auth. Object (Customer)
USOBX_C Check Table for Table USOBT_C


User Tables

Table Description
USR01User master record (runtime data)
USR02 Logon data
USR03 User address data
USR04User master authorizations
USR05 User Master Parameter ID
USR06 Additional Data per User
USR07Object/values of last authorization check that failed
USR08 Table for user menu entries
USR09 Entries for user menus (work areas)
USR10User master authorization profiles
USR11 User Master Texts for Profiles (USR10)
USR12 User master authorization values
USR13Short Texts for Authorizations
USR14 Surchargeable Language Versions per User
USR30Additional Information for User Menu
USH02 Change history for logon data
USH04 Change history for authorizations
USH10Change history for authorization profiles
USH12 Change history for authorization values
UST04 User masters
UST10CUser master: Composite profiles
UST10S User master: Single profiles
UST12 User master: Authorizations


Read more...

Monday, October 29, 2012

Unlocking SAP users like(SAP* & DDIC) in DB2

0 comments


1.Login to db2 using db2<SID> user.

2.db2 connect to SID user sapSID using <password>

Here SID = XYZ Password = 1234
e.g db2 connect to XYZ user sapxyz using 1234

3.db2 select bname,uflag from sapxyz.usr02 where mandt='700' and bname='SAP*'

BNAME                                UFLAG
------------------------------------ ------
SAP*                                  128

  1 record(s) selected.

4.db2 update usr02 set uflag=0 where mandt='700' and bname='SAP*'
  DB20000I  The SQL command completed successfully.

db2 commit

DB20000I  The SQL command completed successfully.

Read more...

Wednesday, September 26, 2012

SAP backup log extensions

0 comments

aab        BRARCHIVE        BRARCHIVE abort
afd        BRBACKUP        Whole offline database backup to local disk
aff        BRBACKUP        Whole offline database backup using BACKINT at file level
afp        BRBACKUP        Whole offline database backup to remote tape
afr        BRBACKUP        Whole offline database backup using RMAN
afs        BRBACKUP        Whole offline database backup to remote disk
aft        BRBACKUP        Whole offline database backup to local tape
afv        BRBACKUP        Whole offline database backup using BACKINT at volume level
alf        BRRECOVER        Restore and apply archivelog files
aly        BRCONNECT        Collect optimizer statistics
and        BRBACKUP        Whole online database backup to local disk
anf        BRBACKUP        Whole online database backup using BACKINT at file level
anp        BRBACKUP        Whole online database backup to remote tape
anr        BRBACKUP        Whole online database backup using RMAN
ans        BRBACKUP        Whole online database backup to remote disk
ant        BRBACKUP        Whole online database backup to local tape
anv        BRBACKUP        Whole online database backup using BACKINT at volume level
bab        BRBACKUP        BRBACKUP abort
cds        BRARCHIVE        Second backup and deletion + first backup of archivelogs
chk        BRCONNECT        Database check
cln        BRCONNECT        Clean up DBA logs
cma        BRARCHIVE        Determination of archivelog compression rates
cmb        BRBACKUP        Determination of database compression rates
cpd        BRARCHIVE        Second backup and deletion of archivelogs
cps        BRARCHIVE        Second backup + first backup of archivelogs
cpy        BRARCHIVE        Second backup of archivelogs
crv        BRRECOVER        Complete database recovery
dba        BRSPACE        Alter database
dbc        BRSPACE        Recreate database
dbp        BRSPACE        Alter database parameter
dbr        BRSPACE        Start up database
dbs        BRSPACE        Shut down database
dbv        BRBACKUP        Database verification using DBVERIFY or RMAN validate
dbw        BRSPACE        Show database information
dcp        BRARCHIVE        Deletion of archivelogs backed up twice
ddb        BRBACKUP        Deletion of disk backup
dfa        BRSPACE        Alter data file
dfm        BRSPACE        Move data file
dpt        BRRECOVER        Database point-in-time recovery
drs        BRRECOVER        Whole database reset
drv        BRRECOVER        Disaster recovery
dst        BRCONNECT        Delete optimizer stat
aab        BRARCHIVE        BRARCHIVE abort
afd        BRBACKUP        Whole offline database backup to local disk
aff        BRBACKUP        Whole offline database backup using BACKINT at file level
afp        BRBACKUP        Whole offline database backup to remote tape
afr        BRBACKUP        Whole offline database backup using RMAN
afs        BRBACKUP        Whole offline database backup to remote disk
aft        BRBACKUP        Whole offline database backup to local tape
afv        BRBACKUP        Whole offline database backup using BACKINT at volume level
alf        BRRECOVER        Restore and apply archivelog files
aly        BRCONNECT        Collect optimizer statistics
and        BRBACKUP        Whole online database backup to local disk
anf        BRBACKUP        Whole online database backup using BACKINT at file level
anp        BRBACKUP        Whole online database backup to remote tape
anr        BRBACKUP        Whole online database backup using RMAN
ans        BRBACKUP        Whole online database backup to remote disk
ant        BRBACKUP        Whole online database backup to local tape
anv        BRBACKUP        Whole online database backup using BACKINT at volume level
bab        BRBACKUP        BRBACKUP abort
cds        BRARCHIVE        Second backup and deletion + first backup of archivelogs
chk        BRCONNECT        Database check
cln        BRCONNECT        Clean up DBA logs
cma        BRARCHIVE        Determination of archivelog compression rates
cmb        BRBACKUP        Determination of database compression rates
cpd        BRARCHIVE        Second backup and deletion of archivelogs
cps        BRARCHIVE        Second backup + first backup of archivelogs
cpy        BRARCHIVE        Second backup of archivelogs
crv        BRRECOVER        Complete database recovery
dba        BRSPACE        Alter database
dbc        BRSPACE        Recreate database
dbp        BRSPACE        Alter database parameter
dbr        BRSPACE        Start up database
dbs        BRSPACE        Shut down database
dbv        BRBACKUP        Database verification using DBVERIFY or RMAN validate
dbw        BRSPACE        Show database information
dcp        BRARCHIVE        Deletion of archivelogs backed up twice
ddb        BRBACKUP        Deletion of disk backup
dfa        BRSPACE        Alter data file
dfm        BRSPACE        Move data file
dpt        BRRECOVER        Database point-in-time recovery
drs        BRRECOVER        Whole database reset
drv        BRRECOVER        Disaster recovery
dst        BRCONNECT        Delete optimizer stat
Read more...