3 steps to upload data from an Excel file using CATT :- Create Import variant for the fields you need
- To change the MRP Group for a list of Material
- Configure the recorded entry fields to read from the imported text file data
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 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. Map the data with the Office software like Microsoft Excel and save it as a tab delimited file. It is easier to manage the data in Excel rather than directly as a text file. 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.
Related Items:
|
