Useful Procedures on SAP R/3

Below you will find some tips and tricks which are for commonly used procedures in SAP and that will save your time. Mainly the topics are;

• User File Capture of SAP Print Spool Output
• Determining Where a Field is Used
• System Access to Logical Databases
• Listing Standard SAP Reports Listing Reports by Group
• Listing the Reports Tree
• Make a Text File of an ABAP Program
• Exporting a Report Writer Report

User File Capture of SAP Print Spool Output

1. Run an SAP program that creates a report and spool the report output
2. Examine the spool retained files
3. Save the spool file to local storage
4. The “Print Preview for Local Printer” screen displays
5. Select the “System / List / Save / Local File” menu item
6. Select “unconverted” in the “Save List in File…” dialog
7. Enter a file name in the “Transfer List to a Local File” dialog, i.e., “C:\SAPworkdir\PA0001.txt”
8. Click the Transfer button

Determining Where a Field is Used

1. Locate the field definition via the Data Dictionary (T/C SE16, SE11 or SE84)
2. Click on the Where-used list icon
3. Select the type of structure in the Where-Used List Data Database Tables dialog (i.e., DB tables)
4. Click the Execute button
5. The list of tables/structures using the field is displayed

System Access to Logical Databases

1. Log on to the SAPGUI
2. Follow the menu path; or use T/C SE36:
   Tools – ABAP Workbench – Development – Programming Environment – Logical Databases
   to open the “Logical Database Builder” screen (T/C SE36)
3. At the Logical Database Selection screen, enter a logical database such as “PNP”
4. Select the “Structure” or “Database program” subobjects and click Display. In this instance, select “Structure”.
5. In the “Display Logical Database PNP” screen, select a data line (Node type = Table) such as “PERNR”
6. Click the Display structure button. Review this screen.
7. Now follow the menu path: Utilities – Runtime object – Display. Review this screen.
8. Return to previous screen. Reselect the data line PERNR and choose the Source Code button and review this screen.

Listing Standard SAP Reports Listing Reports by Group

1. Log on to the SAPGUI
2. Enter T/C SA38 — or follow the menu paths below
3. From the main SAPGUI page (T/C S000), follow the menu path:
   System – Services – Reporting
4. The “ABAP: Execute Program” screen appears (T/C SA38)
5. Follow the menu path:
   Utilities – Find Program. The “ABAP Program Directory” screen appears
6. Enter “RP*” in the left Program entry box (enter an extra character plus the wildcard, such as “RPL*” for List Reports)
7. Click the Execute icon
8. The “ABAP Program Directory” screen appears
9. To save the list, follow the menu path: System – List – Save – Local file
10. Select an output format (such as “Spreadsheet”); click the Continue icon
11. Enter the local file name and Save the file
12. You can also view any available documentation and/or execute the report
13. Select “RPLCMP01″ (Display Pay Grade Structure)
14. Check its documentation and then execute the report
15. Return to the “ABAP Program Directory” screen and enter “GP4QL*” and Execute
16. Select the first line and click on the F7 key
17. Review the list of includes for this program

Listing the Reports Tree

1. Log on to the SAPGUI
2. Enter T/C SARP to search for specific report trees
3. Return to the main SAPGUI screen (T/C S000)
4. Enter T/C HR00
5. The Level 0 hierarchy of HR reports are displayed
6. Navigate the tree by clicking on the outline graphics
7. Double click a report name to run the report

Make a Text File of an ABAP Program

1. Log on to the SAPGUI
2. Enter the T/C SE38
3. The “ABAP Editor: Initial Screen” displays
4. Enter the ABAP program name in the Program line
5. Click the Display button
6. Instructions continued below…

Copy the ABAP Program Source File to a Local Text File(Continued from previous tip)

1. With the ABAP program source code in view within the ABAP Editor, follow the menu path:
   Utilities – More utilities – Upload/Download – Download…
2. A standard Windows “Save As” pop-up window appears
3. Enter a local text file name (i.e., “C:\SAPworkdir\RPARlW00.txt“)
4. Click the Save button

Exporting a Report Writer Report

1. Log on to the SAPGUI
2. Enter T/C GR37
3. Enter the appropriate Library, i.e., 1VK
4. Enter the appropriate Report name, i.e., 0F-PER
5. Under the Further details section, select “Export to presentation server”
6. In the Export file line, enter a local text file name (i.e., “C:\SAPworkdir\0F-PER.txt“) or use the drop-down arrow and select an location and file name
7. Click on the Execute button