SAP中如何用SCAT批量导入数据

How to Create SCAT program for any mass upload purpose?

SCAT is similar to LSMW/BDC to upload/updated data in SAP from legacy system.

The differences between SCAT and LSMW :-

LSMW and SCAT has different functionalities and different advantages, but common thing is they are used for data upload.

SCAT is mainly used as a testing tool for follow-on transactions i.e. Purchase Requisition, Purchase order, Goods Receipt etc.

Whereas LSMW is used for Master data (Materials, Customer, Vendor, BOM, Info record etc) and some of the transactions data (Purchase order, purchase requisition)

There are many standard objects are available in LSMW so most of the consultants use LSMW, but again depends on the requirement.

Writing a CAT script to create user:-

1 Recording a test case 

1.1 To record a test case, call Transaction SCAT and enter test case Zuser_creat. 
- Do not choose Enter. 
- Choose Test Case ? Record Transaction. Enter Transaction SU01, and choose Record/Enter. 
- The system runs Transaction SU01. 
- Enter the user name TESTZ and choose Create. 
- Enter the user’s title first name ZEBRA and the last name TEST. 
- Select the Logon data tab, enter init as the initial password, and repeat the password, profile select sap_all then choose Save. 
- Go back a screen and in the dialog box displayed, select End recording. 
- A message is displayed stating that the recording has ended. 
- Enter the test case title User maintenance. 
- In the field Component, enter BC-SEC-USR. 
- Save the test case. 
- In the field package class, enter $TMP. 
- Choose Save to save the attributes. 
- To save the test case functions, go back. 

2 Entering parameters for a test case 

2.1 To define parameters for a test case, call Transaction SCAT. 
- Enter the test case name Zuser_creat. 
- Select Functions and choose Change. 
- Double-click on TCD. 
- Then double-click on program SAPLSUU5 screen 0050. (first appearance of this program) 
- The first screen of Transaction SU01 is displayed. (If you backed out, enter the procedure name again and double-click on TCD.) 
- Double-click on the user name field. In the field Param. name, enter an "&", and choose Copy/Enter. 
- Choose Next screen and double-click the last name. In the field Param. name, enter an "&" and choose Copy/Enter. 
- Go back until the Save folder appears, and choose Save. 

3 Creating and using an external variant for the test case 

3.1 To export the default parameters into a frontend file, in the test case, select Goto?  Variants ?  Export Default. 
Note: The default file name is .txt. Do not change the default values. 

3.2 Open the file, with excel and edit and add another couple of user, and save the text file

3.3 To execute the test case using the external variant from file, from the initial CATT screen, enter the test case name and choose Execute. 
In the field Variants, select External from file and choose Choose. Select the file created above, and choose Open. Under Processing mode, select Errors, and choose Execute. 
Note: When you use this method, the file must be imported each time the test case is executed (file remains only on PC).