I'm not sure of 4.0B but I have a procedure that works in 4.6. You are welcome to try it.
1. Using CATT procedures to upload data into SAP
(from version 4.5 onwards)
Have you ever been frustrated because you need to load big chunks of master or transaction data into SAP and it will take you hours of typing to do so? Have you ever needed to replicate keystrokes for testing? Have you ever needed to load large volumes of data into SAP Configuration? The situation that prompted me to find a solution to the problem is where we needed to load many delivery routes into SAP at I&J, and as you may know, these are stored in Configuration!
From version 4.5, Standard SAP allows you to upload external data into R/3 using a CATT (Computer Aided Test Tool) procedure.
To do this you need to follow a few steps:
1. Create a CATT procedure (Transaction SCAT) for the transaction you want to handle.
2. Assign Parameters to the procedure, for the fields you want to change.
3. Export these parameters to a tab-delimited text file.
4. Edit the text file in Excel to add the records you want to add (or do mass changes to).
5. Run the CATT with the ?External from file? option.
1.1 Create a CATT procedure
To create a CATT procedure, you need to record the SAP transaction. (If this is a config transaction, you may not have a transaction code that can be used, in which case you will have to find the table name and use transaction SM31.)
He first step is to invoke CATT using transaction SCAT. Type in a CATT name for the transaction you will be using (Hint: If you are doing a material create, name the CATT ? Z_MM01_something so you can find it again easily) Click on the button TCD
Type in a transaction code and click on the ?Record? button (the yellow arrow) which will start the recording. IT IS IMPORTANT THAT YOU TYPE IN TO EACH FIELD THAT YOU MAY NEED AS A PARAMETER, otherwise CATT won?t know that you will need it later. Once you have completed the transaction and saved, you will get back to the CATT: Record another Transaction popup. This time click on the ?Stop Recording? button (the red dot).
Assign a SAP Component and save the CATT (as a local object)
1.1 Assigning parameters to the CATT
Go to ?Functions?. Here you will see a screen with the transaction code. Double-click on the transaction code, and you will see the Function Details screen. Click on the ?Field List? button and you will see, for each screen entered, the values in each field you entered.
For each screen, for each field that you WANT TO CHANGE, double-click the data in ?New Field Contents? and you will be prompted for a parameter. Agree with what SAP suggests for each field, and repeat for each screen. You have now assigned parameters to your CATT.
Use the green arrow to go back to the functions menu and save the CATT again, to save your parameters.
At this point I suggest you test your CATT procedure by clicking on the ?execute? button, and running it in foreground mode. You can change the values in the input fields and check that you have selected all the parameters you will need.
1.2 Exporting the Parameters to a text file.
Click on: go to > variants > export. This will export a tab-delimited text file to your PC.
1.3 Editing the text file in Excel
Using MS Excel, you can add records to the text file. When you open the file, Excel will know it?s a text file and will attempt to arrange the data in columns. It usually does this perfectly, so go with the defaults.
You can only add records from row 5 onwards, in the format as suggested by the example line in row 3. Please note that numeric fields are always preceded by a hash (#). Add a row for each record you want to add / change.
Save the spreadsheet back to itself in the same format that it was in ? i.e. text tab delimited.
1.4 Run the CATT
To use this external file, you have to make sure Excel is no longer holding it, then execute the CATT, and click on : External from file.
This will ask for the text file name where your data is stored. I suggest you run this in processing mode ?errors? otherwise you will be clicking forever.