Getting ECATT script to loop through input file

[Former Member]

Hi,

I need to do a lot of repetitive HCM configuration (transaction SPRO), and I've managed to design an ECATT script (using SAPGUI mode) that works fine for creating the first entry in the input file. The script stops after that. What specifically do I need to do to get the script to keep looping through all the records in the input file?

Thanks in advance!

Vlad

[Former Member]

Dear Vlad,

Did you ever get your Script not looping problem fixed? I am having the same (or similar) problem: My scripts seems to loop thru but the Key value is blank on every iteration other than the first.

Thanks for any info you may have on this!

Julie

[Former Member]

Julie,

I did find some ABAP code to perform the looping. If you post your email I can send you the code. Ultimately I abandoned ECATT altogether and opted for LSMW. LSMW, while not as feature rich as ECATT, is far more intuitive and easy to use, and it has the looping functionality already built in.

Vlad

[Former Member]

Actually, here is the URL to the code I was talking about:

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

- Vlad

[Former Member]

Thank you! for your information, Vlad!

What release were you running in? I am 6.40 (and I thought the looping was available, now) trying to upload entries into a table with SM30. I wonder if LSMW is available for that Transaction? Best Regards, Julie

[Former Member]

Also on 6.4

LSMW works with any transaction.

Vlad

[Former Member]

Vlad, I used the above mentioned ABAP code and got my Script to process all records successfully. So, what we have, then, is a solution that uses only a Script and bypasses the Test Data Container and Test Configuration requirements. Correct?

Have you been to the CA611 training - do they address this type of processing?

I still am wondering if there isn't a way to get the Test configuration and Test Data Container to do this without ABAP code!

Sincerely, Julie

[Former Member]

UPDATE: I got eCATT to loop thru a file and do the recording without ABAP CODE!!!! I eliminated the Test Data container! I now have a Test Script (SM30 recorded with fields parameterized) and created a Test configuration (from within that: Utilities > Test Configuration > Create), Downloaded a "template" file (Edit > Variants > Download), filled that with Excel (Rows 1-3 are reserved, the other rows MUST have A UNIQUE Text name in the 1st column and then the parameter data accordingly - saved as Tab Delimited), back in the Test configuration choose External Variants mode, point to the file, and Execute!

[Former Member]

Dear Julie,

I wanted to let you know that the information you noted was critical in solving the problem I was having runing eCATT with an external file. I needed to add TWO columns: one for variant name, one for description. That was the only way I could my data to align properly with the parameters. I'm disappointed that I was not able to find this documented anywhere, but thankful that you figured it out.

Thanks again!

Rex L. Farris

[Former Member]

Julie -

I am having issues with running eCATT with external file and have read your notes. They are very helpful. Could you provide a sample of what your external file (tab-delimited or Excel) looks like? I only have one parameter value for a vendor number that I need to read in from this file. Does the parameter name need to be in the first row (row# 4) of file?

Thanks,

Steve

[Former Member]

We are using eCATT parametrized script which picks data from an external template file.

The question is what is the ideal place to pick this file from? This will be used by many people with various application servers & clients. Now the issue is where should this file be placed such that it can be used by all users.

Any ideas?

Regards

Rajesh