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

How to upload data using CATT ?

Former Member — Fri, 06 Oct 2006 04:26:25 GMT

These are the steps to be followed to Upload data through CATT: Creation of the CATT test case & recording the sample data input. Download of the source file template. Modification of the source file. Upload of the data from the source file.

I KNOW ONLY THIS ABOUT CATT but i wanna complete in details with an example. its better if anyone can further explain in detail with example

Re: How to upload data using CATT ?

Former Member — Fri, 06 Oct 2006 04:27:18 GMT

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

Please 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

Re: How to upload data using CATT ?

Former Member — Fri, 06 Oct 2006 04:27:46 GMT

Hi,

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

Thanks,

Naren

Re: How to upload data using CATT ?

Former Member — Fri, 06 Oct 2006 05:06:02 GMT

Hi,

Please follow the links

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

http://www.sap-basis-abap.com/sapab027.htm

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

Please reward for the same.

Re: How to upload data using CATT ?

Former Member — Fri, 06 Oct 2006 05:12:39 GMT

Hi,

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.

Regards

Sudheer

Re: How to upload data using CATT ?

shishupalreddy — Fri, 06 Oct 2006 11:27:30 GMT

hi,

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

END

gIVE ME YOUR MAILid so tha i can fwd the atachment to you

Regards,