topic Re: data transfer using eCATT in Application Development and Automation Discussions

data transfer using eCATT

Former Member — Sat, 21 Jun 2008 11:24:42 GMT

Hi Experts..,

can any one help me in migrating data to SAP using eCATT,

do v have an y built in scripts to transfer the data using eCATT..?

Reply soon...its urgent..

Thanks & Regards,

Prashanth

Re: data transfer using eCATT

Former Member — Mon, 23 Jun 2008 03:02:14 GMT

http://www.erpgenie.com/ecatt/index.htm

check these link,

eCATT- An Introduction

Creating Test Scripts

eCATT Logs

eCATT Scripts Creation – TCD Mode

/people/sapna.modi/blog/2006/04/10/ecatt-scripts-creation-150-tcd-mode-part-ii

Creation of Test Data Container

eCATT Scripts Creation - SAPGUI Mode

Integrating ECATT & MERCURY QTP Part -1

Using eCatt to Test Web Dynpro ABAP

and

-command reference

http://help.sap.com/saphelp_nw04/helpdata/en/c6/3c333b40389c46e10000000a114084/content.htm

http://prasadbabu.blogspot.com

https://www.sdn.sap.com/sdn/developerareas/was.sdn?page=test_tool_integration_for_sap_e-catt.htm

http://help.sap.com/saphelp_nw04/helpdata/en/1b/e81c3b84e65e7be10000000a11402f/frameset.htm

http://www.erpgenie.com/ecatt/index.htm

ECATT is automated testing tool developed by sap for functional testing.

http://www.sapdevelopment.co.uk/testing/ecatt.htm

Check my weblogs too.

hope this helps.

< Removed by Moderator>

Edited by: Mohan Kumar K on Oct 16, 2008 1:19 PM

Re: data transfer using eCATT

former_member188594 — Mon, 23 Jun 2008 04:45:51 GMT

Hi,

The use of CATT is for bulk uploading of data. Although CATT is primarily a testing tool, it can be used for the mass upload of data. The way CATT works is like a real user actually inputting on the SAP screen. You prepare a set of data that are required to be input into the system and execute what you called a Test Case and CATT will do the boring task of keying for you.

Over-all procedure

The over-all procedure to upload data using CATT is as follows:

u2022 Creation of the CATT test case & recording the sample data input.

u2022 Download of the source file template.

u2022 Modification of the source file.

u2022 Upload of the data from the source file.

Details of each step are provided in the following paragraphs.

Detailed Procedure

Creation of the CATT test case:

Creation of the test case is completed as follows:

u2022 Execute Transaction SCAT

u2022 Name the test case. Test case name must start with u201CZu201D. It is also good practise to include the transaction code in

the test case name (e.g. Z_IE01_UPLOAD for the upload of equipment)

u2022 Click the u201CRecordu201D button.

u2022 Enter the transaction code (e.g. IE01)

u2022 Continue recording the transaction. Ensure data is entered into every field that is to be used during the upload.

u2022 Save the test case.

Download the source file template

Download of source file template is conducted in two stages as follows:

u2022 Creation of import parameters:

u2022 Within transaction SCAT, Double Click on the TCD line in the u201CMaintain Functionsu201D screen.

u2022 Click the Field List button (Field list is displayed).

u2022 For every field that you wish to upload data, double click in the Column New field contents (This creates an

import parameter).

u2022 In the Maintain Import Parameter Pop-Up:

u2022 Delete the default value if not required.

u2022 Press Enter

u2022 The New field contents column now contains the character & followed by the field name (e.g. &EQART). This

is the name of the import parameter.

u2022 Repeat this for every field (in every screen) to be uploaded.

u2022 Back out and save the CATT test case

u2022 Download of source file template:

u2022 Use the path GOTO -> Variants -> Export Default

u2022 Select path and file name (e.g. C:\TEMP\Z_IE01_UPLOAD.TXT)

u2022 Click Transfer

Modify the source file

The downloaded source file template is now populated with the data that is to be uploaded. This is completed as follows:

u2022 Using Excel, open the tab-delimited text file.

u2022 Do not change any of the entries that already exist.

1st row contains the field names.

2nd row contains the field descriptions.

3rd row displays the default values which are set in the test case.

4th row contains a warning that changing the default values in the spreadsheet has no effect on the actual default values.

u2022 The data to be uploaded can be entered in the spreadsheet from row 4 onwards (delete the 4th row warning &

replace with data for upload).

u2022 Save the file as a Text file (Tab delimited).

Upload data from the source file

Uploading the data is completed as follows:

u2022 Execute the CATT test case

u2022 In the Execute screen:

u2022 Set processing mode to Errors or Background (your choice).

u2022 Set variants to External from file.

u2022 Click the Choose button and select the file to be uploaded.

u2022 If uploading to another client, click the Remote execution button and select the RFC connection to the required client.

u2022 If uploading to the current client, click the execute button.

Best Regards,

Sekhar

Edited by: Mohan Kumar K on Oct 16, 2008 1:19 PM

Re: data transfer using eCATT

Former Member — Thu, 16 Oct 2008 11:07:57 GMT

Hello,

eCATT is a functional testing tool and its not used to migrate data into SAP system.

However through eCATT its possible to generate data in the SAP system by recording the transactions to generate data and executing the scripts in the system where you want to generate data.

Hope it answers your question.

Thanks and Best regards,

Ajay