2008 Feb 26 11:48 AM
hi,
how to upload the data in ECATT using external varient.
reply ASAP.
thanks in advance.
hi,
how to upload the data in ECATT using external varient.
reply ASAP.
thanks in advance.
2008 Feb 26 11:51 AM
Check
[help.sap.com/bp_retailv1500/Retail_Korea/Documentation/Retail_Quick_Guide_EN_KO.doc]
SAP users use CATT frequently to upload master data or to make changes to master data records. SAP Consultants and Abapers tend to used 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.
2008 Feb 27 4:31 AM
hi sir,
thnks for ur reply..........but i want to know how to upload data through external varient in ECATT not in CATT.
if u have any information regarding the same plz send it me.
thnks in advance................
2008 Feb 27 5:38 AM
Hi,
We followed a rather tricky way in getting this done.
Create a Test Data with a number of parameters....
Say your screen might look like this:
Parameter Description Value .... ABAP Type Length
V4 ACC06 C 128
V5 BCC07 C 128
Now in Variants Tab : Select Internal Variants option :
Varaiant Description V4 V5
ECATTDEFAULT ACC06 ertt
VAR1 TEST ACC07 45445
VAR2 TEST ACC08 1232
In Edit->Variants->Download Give a Text file name
Now, your text file will have the data in a defined format.
Carefully modify the data in the Text file and make sure it's tab delimited,
and takes the same format, for each row!!
Edit your test Data again....
This time in the Variants tab, select External Variants / Path
And give the path of your edited Text data File.
Now run your Test Configuartion -> Ie Test Script along with Test Data
There are options to give XML file as Test data... We have still not found a work around for that....!!
Hope this helps in some way!!!
Cheers,
Remi