using catt scripts
DESCRIPTION
Using CATT Scripts. Creating Multiple R/3 Userids. Bill Willis SAP America – Irvine, CA. The need for using CATT Scripts. Many times the R/3 Security Administrator is asked to add a large number of userids at one time, especially just before a Go-Live on a new R/3 Implementation - PowerPoint PPT PresentationTRANSCRIPT
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 1
Bill WillisSAP America – Irvine, CA
Creating Multiple R/3 Userids
Using CATT Scripts
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 2
The need for using CATT Scripts
Many times the R/3 Security Administrator is asked to add a large number of userids at one time, especially just before a Go-Live on a new R/3 Implementation
In most cases all the necessary userids have been given to the Security Administrator in a large spreadsheet
It would take many man hours (sometimes days) to manually key-in or cut-and-paste the userids to accomplish this task
Using the following procedure, this task could be accomplished in less than 30 minutes!
The following example is very simplistic as we are demonstrating how to create the userid with a first and last name in the address screen, along with a password. It is possible to expand the recorded CATT Script variants to include assigned profiles and activity groups, full address information, cost center and accounting information, as well as, user parameters to suit customer requirements.
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 3
Create your CATT Script
Run transaction SCAT
1. Enter the name of your Test case (must begin with Z)
2. Click on the TCD button
12
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 4
Setup for Recording your CATT Script
1. Enter transaction SU01 – Do not press <Enter>
2. Right-Click in dialog box next to transaction code
3. Select ‘End for Commit Work’ – Do not press <Enter>
4. Click on ‘Record’ icon (yellow arrow)
1
2
4
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 5
Recording Keystrokes and Mouse clicks
In the next steps it is importing not to press the <Enter> key as this keystroke as well as any mistakes you make in the recording phase will be recorded into your test case CATT Script.
If you make a mistake, simple click on the Save icon in the SU01 screen and the Stop Recording icon as shown on page 8 to terminate the recording of the keystrokes. This is why we selected the ‘End for Commit’ option on the previous slide. This tells the CATT Script recorder to end recording when a commit work (clicking the Save icon) has been processed.
To restart the recording simple do not save your test case and click on the green back-arrow until you get to the SCAT initial screen as depicted on page 3. You must then follow the instructions on page 3 to restart the recording.
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 6
Recording your CATT Script
1. Enter the userid as shown – Do not press <Enter>
2. Click on the ‘Create’ icon
1
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 7
Recording your CATT Script
1. Enter Last name – Do not press <Enter>
2. Enter First name – Do not press <Enter>
3. Click on ‘Logon data’ tab
1
2
3
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 8
Recording your CATT Script
1. Enter the password ‘initpass’ – Do not press <Enter>
2. Re-enter the password ‘initpass’ – Do not press <Enter>
3. Click on ‘Save’ icon
4. Click ‘Stop Recording’
1
2
3
4
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 9
Saving your CATT Script
Enter Development class as shown
Click on ‘Local object’
1
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 10
What is next?
Now that we have recorded the transaction steps, we must modify the recorded CATT Script variants so that input can be taken from an external variant file.
We will be modifying the variable part of our input and replace what we typed in with the ampersand character ‘&’
This will signal the CATT Script to accept input from an external variant file – in our case a desktop file modified with Excel.
The external variant file created for us is a delimited text file
After making our modifications, we must save it as a delimited text file so that CATT Script can process the input
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 11
Maintaining your CATT Script variants
1. Click the button next to your test case to fill the name into the Test case dialog box
2. Click on the ‘Change’ icon
1
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 12
Maintaining your CATT Script variants
Double click on the TCD Function field
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 13
Maintaining your CATT Script variants
Click on ‘Field list’ button
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 14
Maintaining your CATT Script variants
1. Change the User name field from ‘sample’ to ‘&’
2. Click on Next screen icon
1
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 15
Maintaining your CATT Script variants
1. Change Last name ‘sample’ to ‘&’
2. Change First name ‘user’ to ‘&’
3. Click Next screen icon
1
2
3
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 16
Maintaining your CATT Script variants
1. No need to change the ‘initpass’ password.
2. Click green back-arrow until the Save icon (floppy disk) is available
All users created with
this script will received
the same initial
password of ‘initpass’
1
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 17
Exporting your external variant file
1. After clicking on the green back-arrow, click on the Save icon
2. Next, select menu path: Goto Variants Export Defaults
21
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 18
Exporting your external variant file
1. Enter local filename to be saved – must be of type ‘TXT’
2. Click on Transfer
1
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 19
Modifying the external variant file
Start Microsoft Excel, select menu File Open
1. Select file type ‘.txt’
2. Click on the file you saved from the previous slide
3. Click in Open icon
13
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 20
Modifying the external variant file
Being that you are reading into Excel a delimited text file simply click on the Finish icon to format the text file for Excel
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 21
Modifying the external variant file
1. Enter the userids into column C, Last names in column D, and the First names in column E of the userids you wish to create as shown
2. There is no limit to the number of userids you can create
3. Click on the Save icon
1
3
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 22
Modifying the external variant file
1. Click on the Save icon
2. Click on Yes
3. Click on Yes
1
2
3
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 23
Running your CATT Script
Go to the transaction SCAT initial screen
1. Click on the button next to your test case if the name does not appear in the ‘Test case’ dialog box
2. Click on the Execute icon
1
2
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 24
Running your CATT Script
1. In the Processing mode box, select the ‘Errors’ radio button
2. In the Variants box, select the ‘External from file’ radio button
3. Click on the Choose button
1
2 3
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 25
Running your CATT Script
1. Select the text file you just modified with Excel
2. Click on the Execute icon
12
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 26
Running your CATT Script
1. When the CATT Script execution has completed, the resultant log file will be displayed
2. Click on the imbedded HTML link inserted below to display the log file of the CATT Script we just created and executed
Microsoft HTML
Document 5.0
1
2
To view this link you must exit the PowerPoint Slide Show mode and double-click on this link
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 27
What’s next?
Now that we successfully run our CATT Script, we should check to see if the userids have been created as expected.
There are many ways to view userids, but the easiest method is to use transaction SUIM, the Security Information System transaction.
In our test case, we created all of our new users with userids beginning with ZUSER.
What might be easy for reviewing newly created userids is to create a user group NEWUSER and assign the userids to this group when recording you script. This is accomplished in the ‘Logon data’ tab of transaction SU01. When you have entered the user’s password, you can then enter the user group NEWUSER.
Transaction SUIM can select user accounts by a specific login group.
To remove the user group NEWUSER from a number of userids in a mass fashion, you can now use transaction SU10 to accomplish this.
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 28
Verify userids have been created
Run transaction SUIM
Make selections as shown
12
34
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 29
Verify userids have been created
Our new userids have been created!
SAP America 2000 Creating R/3 Users with CATT Scripts (Bill Willis) / 30
Further reference information
See your SAP On-Line Help under the section Basis / Development / Testing
Search SAPnet messages for CATT or SCAT
Search the SIG under Development or Security for CATT