Saturday 29 June 2013

Administration: System Copy vs System Refresh

What is System Copy: To build a SAP system similar to Production data
1) Homogeneous system copy: source and target system using the same operating system and database system  (using database backup/restore)
2) Heterogeneous system copy/migration: source and target system using different operating system or database system (using SAP specific tools*). Additional info:

What is System Refresh: Refresh existing system data with production data (target system is online)
1) Database Specific method (database backup/restore)
2) SAP specific method*

*SAP specific tools/method: R3load (for ABAP) and Jload (for JAVA)

       Create new DEV/QAS systems            Update existing QAS system with latest data

Thursday 27 June 2013

Administration: How to delete a client

As Basis administrator, there are time to remove a unwanted client from the system. Sample below shown how to perform the client deletion


1) Login to the target client to be delete

2) Execute TCODE: SCC5, click the "background" button and enter the preferable number of process.

3) Verify the option selected and click the "Continue" button

4) Monitor the progress using TCODE: SCC3 (can be monitor from other clients as well)

5) Sample of the delete progress

6) Another sample screen of the delete progress

7) Using SQL command to ensure no users are available for the deleted client

8) Some logs of the client delete progress

9) The "Successful" status 

10) Log will be shown once the progress complete

11) The client no longer appear in the SCC4

Wednesday 26 June 2013

Administration: Client copy within same instance

As Basis administrator, performing local client copy would recommended to be execute by the user with "SAP_ALL" authorization. The example below would be assuming the administrator with the access of the ORACLE database as well.

Prerequisite before performing client copy to avoid data in-consistencies:

1) Lock all the users by using TCODE: SM04 (By single user) / SU10 (Mass users) or AL08

2) Suspended all background process with TCODE: SE38, enter "BTCTRNS1" and click the "execute button"

3) Ensure hard disk space is sufficient Ex: using TCODE: DB02 

Steps to perform local client copy:

1) Ensure the new client to be create is not in the system either using TCODE: SCC4 or from Oracle database.
    - Execute: sqlplus "/ as sysdba"
    - Enter: select mandt, count(*) from sapsr3.usr04 group by mandt; to show all client in the instance

2) Enter: select mandt, count(*) from sapsr3.usr04 group by mandt having mandt=702; ("No row selected" which mean is clear to proceed the client copy)

3) Create the client in the target instance, execute TCODE: SCC4 to create a new client in the list

4) New client created and ready to perform client copy

5) The new client will not be able to be access showing "name or password is incorrect"

6) Login with "sap*" on the target client to begin the client copy

7) Execute TCODE: SCCL and select all the relevant details. Ex: profile to be create.

8) When prompt for the number of process, select the default or add more.

9) Select "Schedule in Background Job" button instead "Start Immediately" which require the GUI to be sign-on when processing.

10) Select the "Immediately" option and click "Schedule Job" button

11) Click "Continue" button

12) The background job started

13) Execute TCODE: SCC3 to monitor the client copy progress (this can be monitor from others clients in the same instance as well)

14) Sample details of the progress on the client copy

15) Another sample details of the progress on the client copy

16) Third sample screen of the progress

17) Once complete, the log summary will shown.

18) Details of the progress

19) With the SQL command, clearly shown users where created for the new client

20) The "success" status

21) Login the new client with existing user ID.

22) The system status if the new client

23) Verifying on the user configurations

24) The details of the clients in SCC4

25) Finally, don't forget to run the program "BTCTRNS2" to release all the background job on the source client.

Tuesday 25 June 2013

Administration: What is a client and method to create a new client

What is client: 
In SAP world, a client is attach with an instance (SID). It provides isolation of data and one client cannot see the data of the other client. Depends on the hardware infrastructure of the system, theoretically we can create a number of clients from 000 to 999.

What does a client contains:
1) Application Data: Is the data that are stored in the database tables
2) Customizing Data: Is the data created by users when they customize their systems
3) User Master Record: Is the set of data which is commonly used across the entire organization and all business processes, normally Basis administrator are responsible for maintaining the user master record and assigning authorizations for it.

Common method to create a client

Method 1: within the same instance
1) Local client copy, TCODE: SCCL
Explanation: Copy client within the same instance (SID)

Method 2: Between different instances

1) Remote client copy, TCODE: SCC9
Explanation: Remote client copy is through RFC and it will not create a transport request

2) Client Import / Export. TCODE: SCC8
Explanation: Client Export is via transport, when performing a client export the system will create more than 1 transport request depends on the profile selected. Client Export will create cofile and data file in source system /usr/sap/trans data and cofile directory. Copy the transport requests to the target system Data file and Cofile. These transport will required to import into the target client using tp addtobuffer and tp import command, after the import would need to run transaction TCODE: SCC7 in target system which will perform the post import activities for the client import. 

Sunday 23 June 2013

User Management with CUA: Create New User and Locked User

With CUA, user management on multiple SAP systems and clients can be perform from a single source easily without the need to manage user account individually in each of the systems and clients itself.

Create new user:

1) Login to the CUA client, execute TCODE: SU01, enter the new user ID to be create and Click the "New" button

2) On the "Address" tab, enter the relevant information (title, last name, function, department, telephone, extension, e-mail)

3) On the "Logon data" tab, click the “magic” button to create random password and select the “valid from” as create date and “valid through” as unlimited date

4) On the "Systems" tab, select or enter the systems/clients to be access by the user and click “Save” button

5) The steps below can be perform either with CUA or within the individual clients. Sample below will shown the user settings be done in particular clients. Login with the User ID just created in CUA on particular clients. (Steps below assume the new user settings are to be copy from another existing user)

6) Execute "SU01" with the newly created user and in the “Default” tab, set the details same as the source user

7) On "Logon" tab, reset the password or click the “magic” button to create random password for particular client. (this will overwrite the password set from CUA)

8) Execute a new "SU01" session and display the user settings to be copy into the new user. Ex: parameters details.

9) Select “Parameters” and copy all the parameters to be paste into the new user

10) Paste the parameter details into the new user "Parameter" tab

11) In the“Roles” tab copy all the roles from source user into the new user as well and click "Save" button

12) Here you go the sample of creating a new user by using the CUA and continue of the new user configuration with the individual client itself.

Locked / suspend unwanted user:

1) Login to the CUA client.

2) Execute TCODE: SU01

3) Enter the user to be terminate and select the "Systems" tab and highlighted the client that need to be locked

4) Select "Logon data" tab,  change the valid date to yesterday date to expired the account and click the "Save" button

5) Click the "lock" button to locked down the account as well

6) Click the “Global” locked button to lock all the SAP clients

7) Wait for the message to be prompt.

8) Verify the user in different systems and clients whether all of it been locked