SAPLIB

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% [?]

Integration between SAP and Microsoft products hinges upon the use of OLE, a common and standard technology for transferring and sharing information among applications. With OLE, you can take data out of your SAP system and place it into another system, all the while maintaining the format and integrity of the data. For example, you can view data residing in any number of SAP database tables as a series of columns and rows in Microsoft Excelan easy way to view and manipulate data otherwise trapped in the SAP database.

The SAP Assistant is the OLE interface used for calling SAP functions and transactions from other non-SAP applications. The SAP Assistant exposes both ActiveX controls and OLE object classes, for logging in to SAP, managing data and tables, calling functions and transactions, and more. SAP systems are therefore designed today so that you can share data with any OLE-compatible application. Sample OLE-compatible applications include (more…)

Popularity: 5% [?]

To insert a single row into an internal table, use the insert statement.

Syntax for the insert Statement

The following is the syntax for the insert statement.

insert [wa into] it [index n]

where:

• wa is a work area with the same structure as a row of internal table it.
• n is a numeric literal, variable, or constant.

The following points apply:

• If wa is specified, the contents of wa are inserted into it. wa must have the same structure as it.
• If wa is not specified, the contents of the header line are inserted into it. If it does not have a header line, wa must be specified.
• If index is specified, the new row is inserted before row n. Row n then becomes row n+1.
• The insert statement can be used inside or outside of loop at it. If it is outside, the index addition must be specified. If it is inside, index is optional. If it is not specified, the current row is assumed. (more…)

Popularity: 6% [?]