Duke University
 

Step By Step Instructions

Step by Step instructions for using SAP R/3 are available below. A list of the major topics covered in the Step by Step instructions is below.

All of the Step by Step instructions are PDF documents. If you do not have PDF reader already installed on your computer, please consult with your department's computer support staff.

 

 


Introduction to R/3
Duke Basics Guide
  1. Logging Into R/3
  2. The SAP R/3 Window
  3. Navigating R/3 Using the User Menu
  4. Transaction Codes
    • How Can I Find the Transaction Code for a Particular Transaction?
    • How Do I Use a Transaction Code?

  5. Command Codes
  6. Multiple Sessions
  7. Messages
    • Changing Messages to Display in Dialog Boxes
    • What are the Message Types

  8. Setting User Profile
    • How Do I Enter My User Information?
    • How Do I Set My User Defaults (Printer & Date format)?
    • How Do I Set Parameter Defaults (Field Default Values)?
    • How Do I Find a Parameter ID (PID) for a Field?

  9. Displaying Technical Names
  10. The Favorites Folder
  11. Logging Off of R/3
  12. Fields and Matchcode Searches
    • How Do I Enter Multiple Selections for a Field?
    • How Do I Perform a Matchcode Search?
    • Guidelines for Using Asterisks in Searches

  13. Tips and Tricks
    • How Do I Hide the Windows Taskbar?
    • How Do I Create a Shortcut on My Desktop for a Frequently Used Transaction?
    • How Do I Use the Shortcut from My Desktop?
    • How Do I Maximize/Minimize the R/3 Window?
    • How Do I Stop a Transaction (the “Hour Glass”) If Needed?

  14. Supplement for Mac OS Users
    • How Will R/3 Look and Perform On a MAC?
    • How Do I Log Into R/3 on a MAC?
    • How Do I Print a Hardcopy (Screen) on a MAC?

| Top |

| Top |

Accounts Payable
Accounts Payable Invoice Exception Workflows
View the Whole Document (1.7MB)
 Last Revised: April 2007
  • Purchase Order Value Exceed Limits Price Block
  • Value Exceeds Limit Workflow
  • Quantity Block Workflow
  • Item Not on Purchase Order Workflow
  • Appendices for Workflows

| Top |

Budgeting (BPS)
Budget Developement
View the Whole Document (2.9MB)
 Last Revised: November 2009

| Top |

Budget Modifications
View the Whole Document (298KB)
 Last Revised: August 2007

| Top |

Budget Projections
View the Whole Document (655KB)
 Last Revised: October 2007

| Top |

Cognos Report with Comments
View the Whole Document (185KB)
 Last Revised: March 2007

| Top |

Business Warehouse
Introduction to Business Warehouse Guide for Duke University (Company Code 0010)
View the Whole Document (635KB)
 Last Revised: November 2005
  1. About SAP Business Warehouse (BW) at Duke
  2. Logging Into SAP BW
  3. The BEx Toolbar Functions
  4. BW Terms and Definitions
  5. Using an Existing Query – Fund Trial Balance
  6. Saving a Formatted Query into a Workbook in the Favorites Folder
  7. Opening a Workbook and Accessing a Saved Query at a Later Date
  8. Other Navigation Tools for Queries
    • To navigate between BW and BEx using Alt + Tab Keys
    • To undo an action performed or go back to prior results
    • To prevent column sizes from adjusting to the default width
    • To eliminate the technical description of the Duke Cost Object
    • To swap the view from Duke Cost Object to Commitment Item (G/L Account)
    • To enhance the Commitment Item view by removing the hierarchy in the first column
    • To drill-down and further analyze a specific Commitment Item (G/L Account)
    • To expand the hierarchy and see all levels and cost objects
    • To display balances by period
  9. List of Commonly Used Queries

| Top |

ECRT
Basic Guide for Effort Coordinators
View the Whole Document (3.5MB)
 Last Revised: January 2009
  1. Introduction to ECRT
    • To access ECRT via Duke@WORK
    • Allow Pop-up Windows from the Duke@WORK Website (via Internet Explorer)
    • To exit ECRT and Logout

  2. Certification Overview
    • To certify effort on the Base Effort Card
    • To certify effort on the Supplemental Pay Card
    • To legally attest to the certification on the Certification Attestation Effort page

  3. Processing the Effort Card
    • To access the Effort Card via Manage Effort Tasks
    • To review and process the Base Effort
    • To review and process the Supplemental Effort
    • To view a processed (complete) Supplemental Pay Card
    • To re-open the Effort Card for Recertification

  4. Processing Salary Cost Transfers via iForms
    • To access iForms via Duke@WORK
    • To find the Certifier for the Salary Cost Transfer
    • To process the iForm for the Salary Cost Transfer

  5. Managing Secondary Effort Coordinators
    • To access the Org. Code (BFR Code) via the Org Code Dashboard
    • To restrict the Secondary Effort Coordinator’s access to specific Certifiers
    • To grant a Secondary Effort Coordinator the ability to process Effort Cards for specific Certifiers

  6. Managing Effort Certification
    • To determine if Faculty or Monthly Staff qualify as a Certifier
    • To understand about Quarterly Notices and Email Notifications for Certifiers
    • To monitor the Certification Status in ECRT
    • To review the Certifiers for an Org. Code
    • To review the CC/WBSE(s) within this Org. Code
    • To place a Certifier on hold
    • To assign a Proxy to a Certifier
    • To transfer a Certifier Effort Card(s) to another Org. Code’s Primary Effort Coordinator for Processing

  7. Reviewing the ECRT Reports
    • To access the ECRT reports via the Base Effort Card
    • To access the ECRT reports via View Reports in the ECRT Home Page
    • To review the Certification Payroll Report
    • To review the Certifier Payroll Summary Report
    • To review the Certification Status Report
    • To review the Cost Share Report
    • To review the Org. Code CC / WBSE Report
    • To review the List of All Users Report
    • To review the Payroll Adjustment Reconciliation Report
    • To review the Potential Certification Conflict Report
    • To review the Sponsored Projects Employee Summary (SPES) Report
    • To review the Sponsored Project Activity Report

  8. Reviewing the Email Notifications
    • Emails Generated During the Period of Performance
    • Emails Generated about Proxy Certifier
    • Emails Generated During Certification Period
    • Emails Generated After the Certification Period Has Ended

| Top |

Total Professional Effort (TPE) Guide for Effort Coordinators
View the Whole Document (724KB)
 Last Revised: June 2009
  1. Introduction to ECRT
    • To access ECRT via Duke@WORK
    • To allow Pop-up Windows from the Duke@WORK Website (via Internet Explorer)
    • To exit ECRT and Logout

  2. Reviewing and Approving Total Professional Effort (TPE)
    • Overview of Total Professional Effort in ECRT
    • To review the TPE from the Faculty’s Effort Card
    • To create or confirm the TPE for absent Faculty
    • To review and approve the TPE for Faculty

  3. Reviewing the Total Professional Effort (TPE) Report
    • To access the TPE Report

| Top |

Effort Supporting DUHS (ES-DUHS) Guide for Effort Coordinators
View the Whole Document (1.4MB)
 Last Revised: October 2009
  1. Introduction to ECRT
    • To access ECRT via Duke@WORK
    • To allow Pop-up Windows from the DUKE@Work Website (via Internet Explorer)
    • To exit ECRT and Logout

  2. Overview of Effort Supporting Duke University Health System (ES-DUHS)
    • General Introduction of ES-DUHS in ECRT
    • Overview of the ES-DUHS Process in ECRT
      • Quarterly Certification
      • Logic Checks
      • Annual Effort Certification
    • Steps done by Faculty for the ES-DUHS quarterly certification

  3. Processing the ES-DUHS Card
    • To pre-fill the ES-DUHS effort card for your Faculty
    • To process the ES-DUHS quarterly confirmation
    • To process the ES-DUHS annual confirmation

  4. Reviewing ECRT Reports for ES-DUHS
    • To access the ECRT reports via IQ Tool in the ECRT Home Page
    • To review the Medicare Hours Validation Quarterly Report
    • To review the Medicare Hours Validation Yearly Report
    • To review the Medicare Incomplete Data Report

| Top |

Financials
Journal Entry Guide
View the Whole Document (2.8MB)
 Last Revised: February 2009
 See Related Course Description
  1. Transaction Code Quick Reference
  2. Overview Of The Journal Entry Process
  3. Set User Preferences Via Editing Options
  4. Initiate And Complete A Journal Entry Document Via Park Document (Document Types SA or ZB)
  5. Initiate And Complete A Non-Salary Cost Transfer Journal Entry (Document Type ZJ)
  6. Initiate And Complete An Accrual Or Deferral Via Park Document (Document Type ZB)
  7. Monitor The Status Of Completed Journal Entries Via The Initiator’s SAP Outbox
  8. Display A Parked Document (Individual Or Via List)
  9. Change A Parked Document
  10. Attach A File (Word, Excel) Via Change Parked Document
  11. Display Changes To A Parked Document
  12. Process A Rejected Journal Entry Via The Initiator’s SAP Inbox
  13. Send A Copy Of A Journal Entry To Other Users
  14. Delete A Parked Document
  15. Create An Account Assignment Model
  16. Use An Account Assignment Model To Initiate A Journal Entry
  17. Change Or Delete An Account Assignment Model
  18. Initiate A Journal Entry From The Excel JV Upload
  19. Approve Or Reject A Completed Document Via The Approver’s SAP Inbox
  20. Forward A Completed Document To Another Approver
  21. Create, Change, And View Attachments Via The SAP Inbox
  22. Display A Posted Journal Entry Document
  23. Change A Posted Journal Entry
  24. Display Changes To A Posted Journal Entry
  25. Reports To Track Journal Entries In The JV Workflow Process

| Top |

Reconciliation and Documents Guide
  1. Reconciliation of Financial Transactions
    • Importance of Financial Transaction Reconciliations
    • Performing a Reconciliation
    • Documentation
    • Compensation Expenses (Payroll)
    • Grants & Contracts Distinctions
    • Responsibilities and Record Retention

  2. R/3 Documents
    • R/3 Document Type List (FI)
    • Other R/3 Documents (CO, PS)
    • The Most Common Document Types In More Detail

  3. Displaying Documents via Report Drill Down
    • Before drilling down on an item from a line item report
    • To drill-down on a report line item
    • The stages of drill-down on a report

  4. Displaying an R/3 (FI) Document – FB03
    • To print a copy of a document (from Document Overview – Display screen)
    • To view or print the extra text (note) for applicable documents

  5. Journal Entry (Type SA, ZJ, ZB, AB or ZZ)
    • Key pieces of information
    • To view details about a particular journal entry line item
    • To view the extra text (audit documentation) if applicable
    • To see header information about the entire accounting document
    • To display any attached files (Word, Excel, etc.)
    • To display an overview of the Workflow approvals from a posted document

  6. Vendor Invoice - Does NOT Reference PO (KN and YD)
    • Key pieces of information
    • To see if the document is the original or a supporting document
    • To view header information for the entire document
    • To see if a check or direct deposit was issued
    • To view the scanned invoice attachment

  7. Invoice - References PO (RN, RE, KG, YM, ZN, ZS, ZC and ZU)
    • Key pieces of information
    • To see if the document is the original or a supporting document
    • To see if a check or direct deposit was issued and view the payment information
    • To view the scanned invoice attachment
    • To view the referencing Purchase order for an Invoice line item

  8. Accounts Payable Check Request/Tution Grant (ZT and ZQ)
    • Key pieces of information
    • To see if a check was issued and display the payment information

  9. Research for Invoices/Check Payment
    • To see if a check or direct deposit was issued and view the payment information
    • To view the scanned invoice attachment
    • Supplement for MAC users on AP Invoice images and various web browsers
    • To see if an invoice has been paid using the Purchase Order number
    • To see if an invoice has been paid using the vendor’s invoice number

  10. Travel Accounting: Employees & Students on Payroll (YT)
    • Key pieces of information
    • To see if a check was issued and display the payment information
    • To view header information for the entire document from any screen

  11. Other Travel Payments (YU)
    • Key pieces of information
    • To see if a check was issued and display the payment information
    • To view header information for the entire document

  12. Experimental Subject Payments (ZK)
    • Key pieces of information
    • To see if a check was issued and display the payment information
    • To view header information for the entire document

  13. Purchase Order
    • To display a Purchase Order (document number is known)
    • To display a list of Purchase Orders (document number not known)
    • To display a Purchase Order from an Invoice document referencing a PO
    • To display a Purchase Order from a Commitment on a report
    • Key pieces of information for each line item
    • To find who (in Procurement Services) created the Purchase Order
    • To see the Purchase Order history (Goods Receipt or Invoice documents)
    • To see the accounts charged, delivery location, and goods recipient
    • To see the vendor address/phone information
    • To view the referencing Purchase Requisition, if applicable

  14. Purchase Requisition
    • To display a Purchase Requisition (document number is known)
    • To display a list of Purchase Requisitions (document number not known)
    • To display a Purchase Requisition from a referencing Purchase Order
    • To display a Purchase Requisition from a Commitment on a report
    • Key pieces of information
    • To view the details of a line item, like the price per item
    • To see if this line item is subject to release
    • To find who (in a department) created the Purchase Requisition
    • To see the accounts charged, delivery location, and goods recipient

  15. Material Document (WA and WE)
    • Key pieces of information
    • To view the detailed expenses by Cost Center

  16. Internal Orders (Work Orders)
    • Internal Order Actual/Plan/Variance Report

| Top |

HR/Payroll
Biweekly Overtime Report (ZH409)
View the Whole Document (36KB)
 Last Revised: February 2007

| Top |

Salary Setting (ZH230)
View the Whole Document (252KB)
 Last Revised: May 2008

| Top |

MyResearch
Grants Management Guide for MyResearch Reports
View the Whole Document (820KB)
 Last Revised: August 2009
  1. Accessing the MyResearch Reports

  2. Financial Summary Report
    • To drill-down to the supporting reports

  3. Summary Awards Statement
    • To drill-down to the supporting reports
    • To use the Project Master Data (Excel) Drill-down

  4. Summary Fund Balance Statement
    • To drill-down to the supporting reports

  5. Transaction Statement

  6. Project Summary Report
    • To drill-down to the supporting reports in the Active Projects section
    • To use the Award Information Drill-down
    • To use the Proposal Information Drill-down

  7. Personnel Report

  8. Sponsor Required Final Financial Report Status

  9. PI Current Effort Distribution Report

  10. Employees Paid on This Cost Object (ONLY Available as Drill-down Report)
    • To access the Employees Paid on This Cost Object report from report drill-downs

  11. Other Report Functions
    • To perform advanced functions in general
    • To drill-down from a report and view supporting reports or data via the Goto function
    • To change the analysis presented via the Swap with… function
    • To export a report
    • To print a report

| Top |

Grants Management Guide for ARRA Reporting Tools
View the Whole Document (348KB)
 Last Revised: August 2009
  1. Accessing the ARRA Reporting Tools

  2. Using the ARRA Report Tool
    • To execute the report
    • To review and understand the report results
    • To enter the Award Description and Project Description
    • To enter the Project Status
    • To approve and promote all Fund Codes to the next level of reivew
    • To return and demote all Fund Codes to a lower level of reivew

  3. Using the ARRA Calculated FTEs Report
    • To execute the report
    • To review and understand the report results

| Top |

Purchasing

| Top |

| Top |

Reporting

| Top |

Hospital and Health System R/3 Reporting Guide
View the Whole Document (1.1MB)
 Last Revised: May 2005
  1. Report Selection Criteria: Key Terms
    • Display a Cost Center Group
    • Display a Cost Element Group

  2. R/3 Cost Object Reporting
    • Profit Center: Plan Actual Comparison Curr./Cumm. (Budget Variance)
    • Cost Centers: One Line Summary Mo/YTD
    • Cost Centers: Current / Cumulative Comparison
    • Cost Centers: Actual/Plan/Commitments

  3. R/3 Line Item Reporting
    • Cost Centers: Display Actual Line Items
    • Material Issues (Cost Centers: Display Actual Line Items)
    • Cost Centers: Commitment line items

  4. R/3 Organizational Reports
    • Accounting View of Payroll Activity (ZH223)
    • Payroll Activity Detail (ZH262)

  5. Printing A Report

  6. Exporting a Report to Excel

| Top |

| Top |

| Top |

University Reporting-Sponsored Projects
View the Whole Document (760KB)
 Last Revised: January 2009
 See Related Course Description

| Top |

Advanced Reporting Functions
View the Whole Document (645KB)
 Last Revised: January 2006
 See Related Course Description
  1. Buttons to Functions Quick Reference
  2. Further Selection Criteria (Dynamic Selections)
    • General Steps
    • Select By Org. Unit / BFR Code for University Project Reports
    • Select By Period for Line Item Reports

  3. Multiple Selections of Cost Objects
  4. Selection Screen Variants
    • Save Variant
    • Get Variant
    • Change / Overwrite Variant
    • Delete Variant

  5. Process/Execute a Report in Background
    • Process Report in Background without Automatically Printing
    • Check Status of Background Job and View Report Output
    • Process Report in Background to Automatically Print at a Later Date

  6. Sort
    • Sort Order
    • Cancel

  7. Navigation of Cost Objects within a Cost Element Report
  8. Filter
    • Set Filter
    • Delete Filter

  9. Subtotal (Line Item Reports Only)
    • Subtotal Set
    • Subtotal Reset

  10. Column Settings (Line Item Reports Only)
    • Optimize Width
    • Column Width
    • Freeze/Unfreeze

  11. Layout (Line Item Reports Only)
    • Choose a Layout
    • Change a Layout
    • Save a Layout
    • Whom to Contact to Delete a Layout

  12. Other Reporting Tools Available
    • Display User Information and Status via USER ID (ZTCD)
    • Find and Find Next

| Top |

 

 

 

 

 
Duke University  >>  Financial Services  >> SAP Information
Financial Services Home | Sitemap | About This Site