SAPLIB

After the XLS file resides on your local system or an accessible file share, you need to import this file into Microsoft Access (the following steps assume Access has been installed on your system; given that Access is not included with all versions of Microsoft Office, this might not be the case by default):

1. Launch Microsoft Access on your system.
2. From this initial window, select the Blank Database option, and then click OK. You are prompted to create a name and to select a location for your database. In this example, I selected the C:\My Documents directory and named the database MySAP.mdb
3. Click the Create button; you then see the main Microsoft Access window
4. To bring the SAP data into Microsoft Access, use the Microsoft Access menu path File, Get External Data, Import. You are then prompted with a window similar to the one shown in Figure 22.10. This is where you have to input the location and filename of the output file you saved earlier. By default, the Files of Type box lists Microsoft Access (*.mdb). You have to change this to Microsoft Excel (*.xls). (more…)

Popularity: 18% [?]

As you have seen, exporting SAP data to Microsoft Excel and Word is useful when it comes to performing further offline manipulation of your data, for creating reports and graphs, or for drafting form letters. Exporting data to a Microsoft Access database is quite useful, too, when it comes to general reporting.

The initial steps to export data into Microsoft Access are the same as the steps to download a file into Microsoft Excelthe idea is to get the data into the Excel XLS format. Verify this is the case before proceeding. (more…)

Popularity: 15% [?]

SAP R/3 has a great interface for creating form letters using Microsoft Word. This tool has endless possibilities for your company. For an example, let’s assume you need to output SAP Human Resources employee data into Microsoft Word so that you can create a form letter to all employees.

1. Select a query to execute.
2. From the selection screen, use the Display As Table option and then execute your report.
3. When the output appears, rather than saving this file to Microsoft Excel, select the Word Processing button at the top of your Query Output. Doing so opens the Word Processor Settings dialog box. Press Enter to continue.
4. The dialog box that is displayed presents you with a number of options. You can designate whether you want to create a new Word document, use a current Word document (one that is currently “open” on your system), or use an existing Word document (one that is saved on your computer). Click the green check mark to begin the merge between SAP and Microsoft Word. Upon execution, SAP opens Microsoft Word.
5. An important thing to note is that your Microsoft Word application now contains a new mail merge toolbar that gives you the capability to insert your SAP fields into your Microsoft Word form letter. In Microsoft Word, press the Enter key to begin at a new line, and then select the Insert Merge Field button on the toolbar. In the drop-down list (or the Insert Merge Field pop-up window, in the case of Microsoft Office 2003), you see all the SAP fields contained in your original SAP Query.
6. As appropriate for your needs, select one of your SAP fields. It appears in brackets in your Microsoft Word document. Press Enter and insert another SAP field. Type some text into your Microsoft Word document, and then insert another SAP field (more…)

Popularity: 12% [?]

Microsoft Excel provides a user-friendly format and helpful tools to assist you in the process of analyzing and presenting data. To get your SAP data into Microsoft Excel, you can employ several methods. The most basic method involves the System List function, which enables you to save lists displayed on your SAP screen.

You can also use the SAP Query tool to export data to Microsoft Excel, as follows:
1. Execute an SAP Query, as discussed in Hour 20, “Reporting Tools in SAP (SAP Query, InfoSet Query, Ad Hoc Query, and QuickViewer).”
2. The options listed on the selection screen enable you to designate the type of output you want for your report. For a basic transfer to a Microsoft Excel spreadsheet, select the Display As Table radio button. (more…)

Popularity: 12% [?]

There are many ways to share data between SAP and Microsoft. As I briefly mentioned in previous hours, executing %pc in the transaction dialog box is an excellent and expedient way of moving data from SAP lists into other formats. Transactions that display their data via OCX controlsin various panels, each with its own data sources, constructs, and so onare generally not good candidates for %pc. That is, OCX-based output typically does not lend itself to being downloaded into a PC format such as XLS, RTF, and so on. But transactions that are displayed in list formatmost of them, to some degreeare excellent candidates for this method of downloading SAP data into Microsoft Officebased formats.

To save SAP list-based output to a file on your desktop or the network, enter the characters %pc in the transaction dialog box and then press Enter. A print window pops up , defaulting to saving the screen’s contents in an unconverted file format. Choose the format most appropriate for your immediate needs, press Enter, browse to the desired directory path, type the name of the output file you want to create, and then press Save to save the list data to the filename you specified.

Popularity: 5% [?]