topic Re: how to upload the data using CATT? in Application Development and Automation Discussions

how to upload the data using CATT?

Former Member — Thu, 20 Sep 2007 10:40:49 GMT

Please reply as soon as possible

Re: how to upload the data using CATT?

Former Member — Thu, 20 Sep 2007 10:42:17 GMT

for perfect ex- tep by step.refer...

check this online document.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCATTOL/BCCATTOL.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCCATTOL/CACATTOL.pdf

Usually from what I have seen CATT is not used for regular transactions in the productive environment. I have only seen LSMW used for the transfer of data from non-SAP systems to SAP systems. It guides you thru your data migration tasks.

http://help.sap.com/saphelp_nw04/helpdata/en/d7/e21017408e11d1896b0000e8322d00/content.htm

- SAP advise not to use CATT in productive systems.

http://www.planetsap.com/basis1.htm

- Start of CATT processes allowed: This option determines whether you want to allow the CATT (Computer Aided Test Tool) process in the client or not. Computer Aided Test Tool (CATT) is tool provided by SAP to test different functionality of the SAP system. To run the CATT tool you can execute transaction SCAT. CATT process changes the database extensively and requires lot of system resources. So we recommend not to chose this option if you are in the production environment.

There has also been some comments on LSMW on this forum:

https://www.sdn.sap.com/sdn/collaboration.sdn?contenttype=url&content=https%3A//forums.sdn.sap.com/thread.jspa%3FthreadID%3D37272%26tstart%3D135

- The Legacy System Migration Workbench (LSMW) is a tool recommended by SAP that you can use to transfer data once only or periodically from legacy systems into an R/3 System.

My 2 cent would be why not develop a solution using Batch Input, BAPI etc?

Check these links

http://help.sap.com/saphelp_nw04/helpdata/en/48/c521a8f6ec11d2bdde080009b4534c/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/ae/410b37233f7c6fe10000009b38f936/frameset.htm

http://www.thespot4sap.com/Articles/CATT.asp

http://www.sap-img.com/sap-catt.htm

******************************************

Check this link..There is a step by step procedure of how to create CATT and then upload data from a file..

http://www.sap-img.com/sap-catt.htm

*****************************************

If you want to use CATT, first you need to activate the CATT tool in your Client, for this one

1)In transaction code SCC4 - click the change button

2)Double click on the client number

3)In the Restriction section, tick Allows CATT processes to be started.

Upload data using CATT

1. Create Import variant for the fields you need

Transaction SCAT

Goto Parameters

Create Import Variant

Goto Variant -> Edit

Goto Variant -> Fast entry or F9

Duplicate 01

2. To change the MRP Group for a list of Material

Assuming that I want to change the MRP Group for a list of Material.

My text files should look something like this:

[Variant ID] [Variant Text] &ZDISGR &ZMATNR

--> Parameter texts MRP group Material

--> Default Values M1 A001

Changes to the default values displayed above not effective

#01 M1 A001

#02 '' A002

#03 M1 A003

Note : '' denotes a blank in the field. e.g. Material A002 MRP group will be replaced by a blank.

3. Configure the recorded entry fields to read from the imported text file data

In the CATT : Maintain functions test case Screen

Double click on the Object Name

Double click on the screen number with your desired fields

Park the cursor on the fields

Click Edit -> Details

Fill in the Parameters Name and Field Contents

Finish Save it.

Assign your text file data.

In the CATT : Execute test case Screen

Click External from file and choose your text file

CATT will now read from your text file and update whatever data you have specified.

*************************************

1) Start tcode SCAT

2) Give the test case name and create

3) Give title, component then save and come back

4) Select the test case and go to change mode

5) Start record and provide the tcode to be recorded

1st button is for normal record (button with arrow key)

2nd button is for remote (to record in remote server of our landscape)

Give all the mandatory fields in the transaction without errors and without using f4 and f1 just like recording

After entering entire data click save button

Then click end recording

Then double click on the test case TCD

Then double click on the first report (SAPMF02D)

It will open the recorded transaction code

Import all the fields which we are going to provide in flatfile

There should not be any default values in the fields after importing

Click on next screen button

Same way import for all screens

Finally it should come to the below screen

Then go back and click save then go to GOTO -> VARIANTS -> EXPORT DEFAULT

Then give the path to be transferred in our local sys and transfer as excel file (save with .xls type)

Then open the excel file

Select 1st 2 columns right click and delete

It should contain only the field headings and description as shown in the below excel snapshot

Leave one empty line and enter our records from 4th row onwards

Enter all the records and save the excel file

Then execute our test case

Then select the type of mode (foreground/background) and variants from external file

Select our excel file and then execute (click remote execution if it’s a remote server)

Finally check the data is uploaded or not

*********************************************

Regards

vasu

Re: how to upload the data using CATT?

Former Member — Thu, 20 Sep 2007 10:46:01 GMT

SAP users use CATT frequently to upload master data or to make changes to master data records. SAP Consultants and Abapers tend to use it for creating test data. The transactions run without user interaction. You can check system messages and test database changes. All tests are logged. The CATT records your keystrokes while performing the actual transaction. You then identify the fields that you wish to change in that view. Then export this data to a spreadsheet to populate with the data required. This is uploaded and executed saving you keying in the data manually.

To perform CATT, it has to be enabled in your production environment (your systems administrator should be able to do this - SCC4). You will also need access to your development system to create the CATT script.

The process of uploading data with a CATT:

Activate CATT in your client

In transaction code SCC4 - click the change button

Double click on the client number

In the Restriction section, tick Allows CATT processes to be started.

Upload data using CATT

1. Create Import variant for the fields you need

Transaction SCAT

Goto Parameters

Create Import Variant

Goto Variant -> Edit

Goto Variant -> Fast entry or F9

Duplicate 01

2. To change the MRP Group for a list of Material

Assuming that I want to change the MRP Group for a list of Material.

My text files should look something like this:

[Variant ID] [Variant Text] &ZDISGR &ZMATNR

--> Parameter texts MRP group Material

--> Default Values M1 A001

Changes to the default values displayed above not effective

#01 M1 A001

#02 '' A002

#03 M1 A003

Note : '' denotes a blank in the field. e.g. Material A002 MRP group will be replaced by a blank.

3. Configure the recorded entry fields to read from the imported text file data

In the CATT : Maintain functions test case Screen

Double click on the Object Name

Double click on the screen number with your desired fields

Park the cursor on the fields

Click Edit -> Details

Fill in the Parameters Name and Field Contents

Finish Save it.

Assign your text file data.

In the CATT : Execute test case Screen

Click External from file and choose your text file

CATT will now read from your text file and update whatever data you have specified.

u can go through this link

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=catt&cat=sdn_all

Reward if useful

Regards

anji

Re: how to upload the data using CATT?

Former Member — Thu, 20 Sep 2007 10:46:49 GMT

Hi Sulaja,

1)Creation of the CATT test case

2) recording the sample data input.

3)Download of the source file template.

4)Modification of the source file.

5) Upload of the data from the source file.

If any questions please respond.

If answer is usefull, rewardpoints please.