This page includes step-by-step guidance on SAP report functions that in general behave consistently across all SAP transactions. 

  • Common Report Functions Quick Reference
    • A reference to report functions that are accessible via button.
  • Multiple Selections of Cost Objects
    • An SAP function used to enter more than one value for a selection field in a report, including individual values, ranges, etc.
  • Further Selection Criteria (Dynamic Selections)
    • An SAP function which allows a user to choose extra fields to supplement the standard fields shown on the initial screen of a report. Those extra fields allow the user to input additional selection criteria and narrow the scope of the report.
  • Selection Screen Variants
    • An SAP function which allows a user to save the information/criteria that is input or selected on the initial selection screen for a specific report. The variant can then be used over and over again to get the saved criteria for that report versus having to key or enter the criteria again each time the report is executed.
  • Process/Execute a Report in Background
    • In order for SAP to process information more efficiently without hindering performance, reports with large amounts of data should be processed in the background as a job that is scheduled versus a real-time report. The processing in the background feature can also be scheduled to execute a report and/or print on a certain date and time, such as over the weekend after a fiscal month closing.
  • Sort
    • Once in a report, the Sort function allows a user to select one or more column(s) and sort the report by the column(s) selected. This functionality is not available on all reports.
  • Filter
    • Once a report is generated, the Filter function allows a user to narrow the line items displayed by setting filter criteria. For example, the filter is useful on the Amount column to narrow the report to see only amounts greater than a certain dollar amount.
  • Subtotal
    • Once in a report, the Subtotal function allows a report to be both sorted and subtotaled by the data in the column or columns selected. This function is available for some reports, such as One Line Summary reports and Line Item reports.
  • Column Settings
    • Most One Line Summary reports and Line Item reports provide the ability to adjust the column settings for the report. The options for adjusting columns include automatically optimizing all the column widths to the longest character amount per column, as well as the ability to freeze and unfreeze columns.
  • Layouts
    • A Layout, such as the standard default of /DUKE used for Line Item reports, determines how a report looks, i.e., displays on the screen. More specifically, a Layout determines the formatting, such as which columns are displayed, in what order the columns are displayed, and how the report is sorted and/or subtotaled.
  • Report Exports
    • Export the ALV Tree Control View of SAP Reports
    • Export the ALV Grid Control View of SAP Reports
      • The following reports have both the ALV Tree Control View and the ALV Grid Control View: 
        • Z71PROJ - Project WBSE ITD with Plan
        • Z71PROJ_FD - Project WBSE ITD by GL Acct Group with Plan
        • Z72CC - Cost Center by GL Account with Stat Rev
        • Z73PC - Profit Center Plan vs Actual by GL Account
        • Z74FUND - Fund by GL Account Plan vs Actual
    • Export SAP One Line Summaries and Line Items
      • Export instructions for the following reports:
        • ZF107 - All Funds - One Line Summary
        • ZH109AR - Sponsored Programs Accounts Receivable One Line Summary
        • ZF600 - WBSE Master Data & One Line Summary
        • Z72CC_1Line - Cost Center with Stat Rev
        • ZH74Fund_1Line - Fund Plan vs. Actual
        • KSB1 - Display Actual Cost Line Items for Cost Centers
        • CJI3 - Display Project Actual Cost Line Items
  • Display User Information and Status via USER ID - SAP Transaction ZTCD
    • The Duke customized transaction code ZTCD allows a user to enter a UserID (Duke Net ID) and view pertinent information about the user in the SAP system.
  • Find and Find Next
    • The Find and Find Next functions are useful tools available in line item reports, as well as other types of list displays, field match code searches (drop-down beside fields used to search for values), and the drill-down into original documents from line item reports.
  • View Who Receives Supporting Documentation for SAP Reports - SAP Transaction ZF102V
    • This transaction code allows you to view the name and box number of the individual receiving documentation that supports transactions for a specified cost object report. This pertains to any paper documentation and many documents are now electronic.