| The following sections provide details on maintenance functions that are available for InfoSets. These sections are designed to assist users who are responsible for the maintenance of InfoSets. Users who are being trained on the concepts of InfoSets need not review these maintenance functions. As recommended in Chapter 1, those designated personnel who will be responsible for the InfoSets can read on to see how to perform the different maintenance functions. Returning to an InfoSet to Add Fields After an InfoSet is created, you can return to it at any time to make changes. It is a best business practice to maintain an InfoSet in your development environment so any changes can be tested before the InfoSet is transported to your live production client. (See Chapter 1 for more information.) To add an additional field to your InfoSet, follow these steps: 1. | Log in to the SAP client where your InfoSets are maintained.
| 2. | Navigate to the InfoSet: Initial Screen by using the transaction code /nSQ02.
| 3. | Ensure that you are in the appropriate query area by selecting Environment, Query Areas and then selecting Standard Area.
| 4. | Type in the name of the InfoSet that you want to make changes to, and then click the Change button.
| 5. | Review the fields that are currently present in the field groups (shown on the top right of your screen) in your InfoSet.
| 6. | When you initially created the InfoSet, it is likely that you did not add all fields in the logical database to your field groups. Determine which field group is the appropriate one to add a field to. Place your cursor on that field group, and double-click it to highlight it as the selected field group. Then select fields from the left side of the screen from the corresponding table and add them to the highlighted field group by placing your cursor on a field on the left side of the screen, right-clicking, and selecting the option Add Field to Field Group Remember to ensure that you add fields to the appropriate field group. Your newly added fields now appear in your selected field group.
| 7. | When you have finished adding additional fields, click the Save button on the toolbar. A message appears in the status bar, saying that the InfoSet was saved.
| 8. | Generate the InfoSet by clicking the Generate button on the Application toolbar. A message appears in the status bar, saying that the InfoSet has been generated.
|
Returning to an InfoSet to Delete Fields After an InfoSet is created, you can return to it any time to remove fields. As mentioned earlier, it is a best business practice to maintain your InfoSet in your development environment so any changes can be tested before the InfoSet is transported to your live production client. To delete a field from your InfoSet, follow these steps: 1. | Log in to the SAP client where your InfoSets are maintained.
| 2. | Navigate to the InfoSet: Initial screen by using the transaction code /nSQ02.
| 3. | Ensure that you are in the appropriate query area by following the menu path Environment, Query Areas and selecting Standard Area.
| | | 4. | Type in the InfoSet name and then click the Change button. The Change InfoSet screen appears, displaying a list of all the tables available in your InfoSet. The logical database F1S that is selected contains three test tables, called SPFLI, SBOOK, and SFLIGHT, which correspond to the three field groups listed at the top right.
| 5. | To view the fields in each of the three tables, use the expand subtree button next to each table name. The table selected expands and displays the fields underneath.
| 6. | Review the fields that are currently present in the field groups (shown on the top right of your screen) in your InfoSet.
| 7. | Determine which field group you wish to delete fields from, and place your cursor on it. Double-click the field group to highlight it as the selected field group. Next, place your cursor on a field in the field group on the top-right side of the screen, right-click, and select the option Delete Field from Field Group. The deleted fields no longer appear in your selected field group.
| 8. | When you have finished deleting fields, click the Save button on the toolbar. A message appears in the status bar, saying that InfoSet was saved.
| 9. | Generate the InfoSet by clicking the Generate button on the Application toolbar. A message appears in the status bar, saying that the InfoSet has been generated.
|
Note If you selected to remove fields that are already used in existing queries, you will receive an error message saying "Field used in existing query." A best practice is to first determine whether the field is in use. You do so by placing your cursor on the field, right-clicking, and selecting the Queries for Field option. SAP then displays a list containing any existing queries that use that field. You need to access that query and remove the field from its output before you can save the changes to your InfoSet.
Changing the Name of a Field or Column Header Many users will be looking for a field name that corresponds to a field name on an SAP screen, so it is important to be very careful when renaming fields and column headers. However, there are rare situations in which you may need to do so. You can alter the name of a field and its column heading when it appears in a query-based report by simply following these steps: | | 1. | Select a field by double-clicking it in the top-right side of the screen. The details of that field appear on the bottom-right side of the screen, as shown in Figure 2.8.
Figure 2.8. It is not a best practice to rename fields. 
| 2. | Alter the field name by editing the text in the Long Text field, and edit the column heading of the field as it will appear in reports by editing the text in the second line of the Header field at the bottom right, as highlighted in Figure 2.8.
| 3. | Click the Save button on the toolbar. A message appears in the status bar, saying that the InfoSet was saved.
| 4. | Generate the InfoSet by clicking the Generate button from the Application toolbar. A message appears in the status bar, saying that the InfoSet has been generated.
|
Reverting the Name of a Field or Column Header to Its Original Name If you have altered the name of a field or column heading, you can revert it to the SAP standard delivered text by following these steps: 1. | Select a field by double-clicking it in the top-right side of the screen. The details of that field appear on the bottom-right side of the screen.
| 2. | Click the Get Default button. The field and column names revert to their original names.
| 3. | Click the Save button on the toolbar. A message appears in the status bar, saying that the InfoSet was saved.
| 4. | Generate the InfoSet by clicking the Generate button on the Application toolbar. A message appears in the status bar, saying that the InfoSet has been generated.
|
|
