Basics Of Sap R/3 Query-Based Reporting The following SAP R/3 query reporting options are delivered with a standard SAP installation: The Query tools in SAP have four technical aspects: Configuring The Sap Query Tools Configuring the SAP Query tools involves four steps: Step 1: Create query groups. Step 2: Assign users to query groups. Step 3: Create InfoSets. Step 4: Assign InfoSets to query groups.
Step 1 Of 4: Create Query Groups To do the one-time configuration required for using the SAP Query tool, follow these steps: 1. | Log in to the area of your SAP client where your query groups will be maintained.
| 2. | Navigate to the User Groups: Initial screen by using the transaction code /nSQ03.
| 3. | Ensure that you are in the appropriate query area by following the menu path Environment, Query Areas and selecting Standard Area.
| 4. | Type the name for your query group in the User Group field (for example,ZTEST). Then click the Create button.
| 5. | When a dialog box appears, asking you to provide a description for your query group, type Test Query Group 1 and then click the green checkmark Save button.
|
Step 2 Of 4: Assign Users To Your Query Groups To assign users to a query group, perform the following steps: 1. | Click the Assign Users and InfoSets button.
| 2. | Type in the SAP user IDs of any users you wish to include in your query group, making sure to include your own user ID.
| 3. | Click the Save button on the toolbar. A message appears in your SAPGUI status bar, saying "User group ZTEST saved."
|
Step 3 of 4: Create InfoSet To create a new InfoSet, you perform the following steps: 1. | Log in to the area of your SAP client where your InfoSets will be 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 a name for your InfoSet (for example, ZTEST). Then click the Create button.
| 5. | On the InfoSet: Title and Database screen, type an InfoSet description in the Name field (for example, Test InfoSet 1).
| 6. | On the InfoSet: Title and Database screen, select the Logical Database radio button, select or input logical database f1s in the field to its right, and then press Enter. A Change InfoSet screen appears, displaying a list of all tables available in the selected logical database for your InfoSet. The logical database selected, f1S, contains three test tables, called SPFLI, SBOOK, and SFLIGHT, which correspond to the three field groups listed at the top right. The field groups are what the end users will actually see when they are creating reports using the SAP Query reporting tool.
| 7. | 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.
| 8. | Assign fields to the field groups (shown on the top right of the screen) within the InfoSet. These field groups will display in the SAP Query tool during reporting. Only the fields that you include in your field groups will be available for field selection in the SAP Query tool that uses this InfoSet as its data source. By default, these field groups will be empty.
| 9. | Place your cursor on the first field group, Flight Schedule, and double-click to highlight that field group as the selected field group. Next, select fields from the left side of the screen from the Flight Schedule table and add them to the Flight Schedule 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.
| | | 10. | When the field you just added to the Flight Schedule field group appears at the top right of the screen, add fields to your selected functional group by following the procedure outlined in step 9. Be sure to add fields to the appropriate field groups.
For example, fields in the Flight Schedule table should be added to the Flight Schedule field group, and fields from the Flight Booking table should be added to the Flight Booking field group.
| 11. | After you have added a series of fields to your field groups, click the Save button on the toolbar. A message appears in the status bar, saying that your InfoSet was saved.
| 12. | Generate the InfoSet by clicking the Generate button (the red beach ball) from the Application toolbar. A message appears in the status bar, saying that the InfoSet was generated.
| 13. | Exit the Change InfoSet screen by clicking the green Back button.
|
Step 4 of 4: Assign Infoset To Query Group To assign an InfoSet to a query group, you follow these steps: 1. | On the InfoSet: Initial screen (which you reach by entering transaction code /nSQ02), make sure your InfoSet name (for example, ZTEST) is present in the InfoSet text box, and click the User Group Assignment button.
| 2. | In the InfoSet: Assign to User Groups screen that appears, highlight your query group (for example, ZTEST) by selecting the gray button to the left of it, and then click the Save button. A message appears in the status bar, saying that the assignment of InfoSet has been saved.
| 3. | Exit the InfoSet: Assign to User Groups screen by clicking the green Back button.
|
Query Configuration Maintenance Functions To return to a data source and make changes to it, you follow these steps: Returning to an InfoSet to Add Fields To add an additional field to your InfoSet, follow these steps: 1. | Log in to the area of your 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 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 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 To delete a field from your InfoSet, follow these steps: 1. | Log in to the area of 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 want 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 the 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.
|
Changing The Name of A Field or Column Header 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.
| | | 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.
| 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.
|
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 standard SAP-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.
|
|
