As a newbie in SAP, I always spend my time looking for a freee ebooks or pdf on SAP. Sure there are so many sites, webpages, blogs that offer information on SAP but not all of them are helpful. If I have any questions on SAP, I go directly at SAP Help to search for the answer. If I did not find what I’m looking for then I go to SDN (SAP Developers Network) to look for the answer, If I still didn’t find what I’m looking for, then I’ll post my problem on under the category that most fits my question.
I also recommend dbebooks as a great source of free SAP ebooks and pdf articles. And also, SAP Material is a great source of information on SAP that helps me in many ways.
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).
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.
sdn blogger
sap blogger
Recent Comments