Tag Archive for 'BASIS'

SAP* Password Reset

Published
by
rs
on July 12, 2008
in BASIS, SAP and Technical
. 1 Comment

When you forgot the password of SAP* user on a certain client on SAP, you could always reset it by deleting its record on your database.

DELETE FROM <db name>.USR02
WHERE BNAME=’SAP*’ AND MANDT=’<client no.>’

On the script above, <db name> is the database name of your system which is usually the same with system id and <client no.> is of course the specific client you want a password reset of SAP* user. Let say my system id is “flq” and i want to reset the password of SAP* on client 100, my script would be like this:

DELETE FROM flq.USR02
WHERE BNAME=’SAP*’ AND MANDT=’100′

Once you successfully run this script on your database, you could now log on to your system on a specific client by using SAP* and password = pass.

Note: SAP* user is activated when parameter login/no_automatic_user_sapstar is set to 0(zero).

SAP client copy

Published
by
rs
on July 6, 2008
in BASIS, SAP and Technical
. 3 Comments

We always use client copy during the initial installation of the R/3 system. We create new clients by copying client 000 which is always available when you install the R/3 system. Other than that, we also use client copy to create test clients, deve clients, playground clients, training clients, production clients, etc. You could initially create new clients through tcode SCC4 and copy a client through tcode SCCL.

When copying a client, you could always select a components you want to be copied with the use of Copy Profiles. I googled for a list of copy profiles and help.sap.com always comes in handy. Here’s a list of common copy profiles for client copy.

SAP_USER - Users, user roles and authorization profiles are copied. The client is not reset.
SAP_UONL - User without authorization profile and role
SAP_PROF - Only authorization profile and roles
SAP_CUST - Client-specific customizing including authorization profile is copied. The application data is deleted, the user data is retained.
SAP_CUSV - SAP_CUST with variants
SAP_UCUS - SAP_CUST with user master data
SAP_UCSV - SAP_UCUS with variants
SAP_ALL - All client data and local data is copied.
SAP_APPL - SAP_ALL without user master data
SAP_AAPX - SAP_ALL without authorization profile and roles

Also remember that copying clients requires a large amount of system resources so always ensure that enough resources and database storage space are available.