SAP60 - 1 - 7 ways how to export from SAP to MS Excel



SAP Tutorial

SAP60

SAP60: Export to Excel

? 7 Ways how to export from SAP to MS Excel

These materials contain confidential and trade secret information and unpublished copyrighted expressions belonging to ITICA s.r.o.. The use of these materials is subject to the terms and conditions defined in the ITICA licence agreement. These materials cannot be distributed anywhere without consent of ITICA in a written form. Please take all reasonable steps to maintain the confidentiality of the materials.

These materials contain confidential and trade secret information and unpublished copyrighted expressions belonging to ITICA s.r.o.. The use of these materials is subject to the terms and conditions defined in the ITICA licence agreement. These materials cannot be distributed anywhere without consent of ITICA in a written form. Please take all reasonable steps to maintain the confidentiality of the materials.

How to export, is it complicated?

No. SAP offers 7 ways how to export data (lists, reports) to MS Excel. Here we offer 7 ways how to execute it:

Export No. #1

For our purpose, lets use transaction MB51: A) Right click by your mouse on the list of entries and select Local File:

These materials contain confidential and trade secret information and unpublished copyrighted expressions belonging to ITICA s.r.o.. The use of these materials is subject to the terms and conditions defined in the ITICA licence agreement. These materials cannot be distributed anywhere without consent of ITICA in a written form. Please take all reasonable steps to maintain the confidentiality of the materials.

B) Then select Spreadsheet:

C) Then write the path to the file stored on your computer:

As you can see, the exported file is in .txt format and therefore we can expect not very-well managed data formating.

These materials contain confidential and trade secret information and unpublished copyrighted expressions belonging to ITICA s.r.o.. The use of these materials is subject to the terms and conditions defined in the ITICA licence agreement. These materials cannot be distributed anywhere without consent of ITICA in a written form. Please take all reasonable steps to maintain the confidentiality of the materials.

This is, how the exported data look in MS Excel:

Export No. #1

These materials contain confidential and trade secret information and unpublished copyrighted expressions belonging to ITICA s.r.o.. The use of these materials is subject to the terms and conditions defined in the ITICA licence agreement. These materials cannot be distributed anywhere without consent of ITICA in a written form. Please take all reasonable steps to maintain the confidentiality of the materials.

Export No. #2

A) Select in the main menu List ? Save ? Local File

B) Again we can select several types of exported data. If you prefer HTML format (everybody can open it), then it can look the following way:

These materials contain confidential and trade secret information and unpublished copyrighted expressions belonging to ITICA s.r.o.. The use of these materials is subject to the terms and conditions defined in the ITICA licence agreement. These materials cannot be distributed anywhere without consent of ITICA in a written form. Please take all reasonable steps to maintain the confidentiality of the materials.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download