eCATT-Extrernal file Upload

[Former Member]

Hi All

I have some queries on eCATT.It is regarding to run the test script for external data where the data is in Excel or in Text form.

Your solution will be very helpful for me.

I have created one test script using FK01(Vendor creation).

The Fields i had given as input are:1.Create Vendor :Initial Screen :

Company Code

Account Group

2.Create Vendor :Address

Name

Search term

City

Country

3.Create Vendor :Accounting information :

Recon.Account

Cash mgmnt.gruop.

With these fields i have created the Test Script called Z_FK01_TEST.

And parameterized these filed in the same script as

Company code: I_CCODE

Account Group:I_ACCGRP like that i parameterize all the above fields and visibility as 'I'.

Kindly provide me the solution how can i run this script for the file and required ABAP code and the fields which are to be parameterized and their visibility and the external file format.

Also provide me if there is any other way to do along with above.

Thanks in advance.

Siva

[Former Member]

Hi

check these link,

eCATT- An Introduction

/people/sumeet.kaul/blog/2005/07/26/ecatt-an-introduction

Creating Test Scripts

/people/sumeet.kaul/blog/2005/08/10/ecatt-creating-test-scripts

eCATT Logs

/people/sapna.modi/blog/2006/04/18/ecatt-logs-part-vi

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

/people/sumeet.kaul/blog/2005/08/24/ecatt-creation-of-test-data-container

eCATT Scripts Creation - SAPGUI Mode

/people/sapna.modi/blog/2006/04/10/ecatt-scripts-creation--sapgui-mode-part-iii

Integrating ECATT & MERCURY QTP Part -1

/people/community.user/blog/2007/01/02/integrating-ecatt-mercury-qtp-part-1

Using eCatt to Test Web Dynpro ABAP

/people/thomas.jung/blog/2006/03/21/using-ecatt-to-test-web-dynpro-abap

and

-command reference

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

/people/sapna.modi/blog/2006/04/10/ecatt--an-introduction-part-i

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

hope this helps.

Reward points for useful Answers

Regards

Anji

[Former Member]

Hi,

I think you are Step 2 of below blog,

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

Ok please find the code below,

DO (COUNT).

ABAP.

DATA : V_READINDX TYPE I,

FILE TYPE STRING,

INDX TYPE I VALUE 0.

DATA : BEGIN OF I_MARA OCCURS 0,

• Prepare this internal table-----*

END OF I_MARA.

DATA : WA LIKE I_MARA.

FILE = FILE_V-PATH.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = FILE

HAS_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = I_MARA.

V_READINDX = INT_LOC.

READ TABLE I_MARA INDEX V_READINDX INTO WA.

• assigning work area values to the screen field values you created so far

*example I_CCODE = WA-I_CCODE. " Company Code

ENDABAP.

• Replace this line with your TCD statement TCD ( MM01 , MM01_1 )-----

INT_LOC = INT_LOC + 1.

ENDDO.

If its not clear post your code. I will send you the code.

Please follow the comments (lines with *).

I am sure ur done.

Reward if it helps.

-Manjula P

Message was edited by:

Manjula Pasala

[Former Member]

Hi Manjula,

Your program is perfect, surely it will work out. But my questions is - Is there any other way to pull the data one time instead of pulling each and everytime.

I tried to get the data in one shot and keeping in the internal table but when cursor is going out of abap-endabap block all the internal tables are initialzing.

what will be the alternative for this.

regards

jaya