Author Justin Valley outlines the necessary steps to export reports in SAP ERP
- [Instructor] While you can do some filtering…right inside SAP, it's often more practical…to work with your report results…in other software, usually Excel.…Let's look at exporting reports to Excel.…To demonstrate, we're in the output…for the materials movement history report.…Now that we're in the report, we click More, List, Export.…From here we can choose Word Processing,…Spreadsheet or text file.…We want to export a spreadsheet.…This brings up a screen to choose a format.…
I'll choose the default Excel Open Office XML Format…and click Continue.…This brings up the Save As screen.…I'll save this as Materials Spreadsheet and click Save.…This brings up an SAP GUI Security screen.…It's asking whether the system is okay…to create a file on our computer.…It is, so we'll click Allow.…This brings up another sAP GUI Security screen.…SAP is trying to open Excel, so we do want to allow this.…
Excel now automatically opens and all of our data…from the report can now be manipulated in Excel.…
- Benefits and limitations of SAP ERP
- Exploring the different SAP modules
- SAP security roles
- Menu tree and transaction code navigation
- Searching for data and using wildcards
- SAP basic reporting
- Editing SAP report layouts
- Printing and exporting reports
Skill Level Beginner
SharePoint: Site Customizationwith Bill Kulterman55m 54s Intermediate
SharePoint Workflow Automation: Nintexwith Tiffany Songvilay1h 15m Intermediate
Business Collaboration in the Modern Workplacewith Phil Gold1h 33m Intermediate
Understanding SAP ERP1m 5s
1. Overview of SAP
2. Exploring SAP Modules
3. SAP End-User Base Navigation
4. SAP Basic Reporting
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.