Downloading Terminology from SAPterm
Use
You can download lists of terms to a local file based on various criteria. Some reasons for doing so include:
-
You want to give a list of new terms to your product manager or your team for review.
-
A colleague needs a list of terms from a given component for reference while on travel.
-
You want to run a spellchecker in another program through the index entries in your area.
Procedure
Downloading Entries from the Results List
Any user with display authorization can download term and index entries from the results list.
This example shows how to download a list of all main term entries from a given component that have not yet been translated into a target language. You can, of course, select or deselect other delimiters as you require.
-
Call transaction STERM.
-
Choose
. -
Check the source and target languages. Leave the Term field empty or enter an asterisk (*).
-
Enter the correct component in the Application Component field.
You can use Multiple Selection to enter more than one component or groups of components.
-
Under Select Terminology Entries only and deselect Index entries.
-
Under Entry Category, select Main entries only and deselect the other categories.
-
Choose
. -
When the results list appears, choose the right mouse button and choose Display non-translated entries only.
The results list will now display only those entries that have not been translated into the target language. To return to the original hit list, choose the right mouse button and choose Display all entries.
-
Download the resulting list by choosing .
-
Select Spreadsheet and choose Enter.
The Save DAT to a Local File dialog box appears.
-
You can accept the default directory in the Filename field, or you can change it according to your wishes. Do not specify a file format in the Files of type: field.
-
Choose Transfer
-
Start Microsoft Excel and choose In the dialog window, in the Files of Type: field, select All Files (*.*). Then find the relevant folder in order to see the downloaded file.
Excel will start the Text Import Wizard which you use to format the data by rows and columns.
You can change the worksheet formatting (such as adjusting the column widths), sort the entries in the resulting worksheet (alphabetically, by component, and so on) and include any additional columns (for instance, a column for feedback or for notes).
-
To keep the formatting and information in the resulting file, save in Excel spreadsheet format (.xls)

