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
- Run an SAP program that creates a report and spool the report output
- Examine the spool retained files
- Save the spool file to local storage
- The “Print Preview for Local Printer” screen displays
- Select the “System / List / Save / Local File” menu item
- Select “unconverted” in the “Save List in File…” dialog
- Enter a file name in the “Transfer List to a Local File” dialog, i.e., “C:\SAPworkdir\PA0001.txt”
- Click the Transfer button
Determining Where a Field is Used
- Locate the field definition via the Data Dictionary (T/C SE16, SE11 or SE84)
- Click on the Where-used list icon
- Select the type of structure in the Where-Used List Data Database Tables dialog (i.e., DB tables)
- Click the Execute button
- The list of tables/structures using the field is displayed
System Access to Logical Databases
- Log on to the SAPGUI
- 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) - At the Logical Database Selection screen, enter a logical database such as “PNP”
- Select the “Structure” or “Database program” subobjects and click Display. In this instance, select “Structure”.
- In the “Display Logical Database PNP” screen, select a data line (Node type = Table) such as “PERNR”
- Click the Display structure button. Review this screen.
- Now follow the menu path: Utilities – Runtime object – Display. Review this screen.
- 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
- Log on to the SAPGUI
- Enter T/C SA38 — or follow the menu paths below
- From the main SAPGUI page (T/C S000), follow the menu path:
System – Services – Reporting - The “ABAP: Execute Program” screen appears (T/C SA38)
- Follow the menu path:
Utilities – Find Program. The “ABAP Program Directory” screen appears - Enter “RP*” in the left Program entry box (enter an extra character plus the wildcard, such as “RPL*” for List Reports)
- Click the Execute icon
- The “ABAP Program Directory” screen appears
- To save the list, follow the menu path: System – List – Save – Local file
- Select an output format (such as “Spreadsheet”); click the Continue icon
- Enter the local file name and Save the file
- You can also view any available documentation and/or execute the report
- Select “RPLCMP01″ (Display Pay Grade Structure)
- Check its documentation and then execute the report
- Return to the “ABAP Program Directory” screen and enter “GP4QL*” and Execute
- Select the first line and click on the F7 key
- Review the list of includes for this program
Listing the Reports Tree
- Log on to the SAPGUI
- Enter T/C SARP to search for specific report trees
- Return to the main SAPGUI screen (T/C S000)
- Enter T/C HR00
- The Level 0 hierarchy of HR reports are displayed
- Navigate the tree by clicking on the outline graphics
- Double click a report name to run the report
Make a Text File of an ABAP Program
- Log on to the SAPGUI
- Enter the T/C SE38
- The “ABAP Editor: Initial Screen” displays
- Enter the ABAP program name in the Program line
- Click the Display button
- Instructions continued below…
Copy the ABAP Program Source File to a Local Text File(Continued from previous tip)
- With the ABAP program source code in view within the ABAP Editor, follow the menu path:
Utilities – More utilities – Upload/Download – Download… - A standard Windows “Save As” pop-up window appears
- Enter a local text file name (i.e., “C:\SAPworkdir\RPARlW00.txt“)
- Click the Save button
Exporting a Report Writer Report
- Log on to the SAPGUI
- Enter T/C GR37
- Enter the appropriate Library, i.e., 1VK
- Enter the appropriate Report name, i.e., 0F-PER
- Under the Further details section, select “Export to presentation server”
- 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
- Click on the Execute button
