SAP ABAP IMG Activity DRUCKLAYOUT (Edit Layouts for Printing with MS Word)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CP (Package) R/3 Application development: PP Task Lists
IMG Activity
ID DRUCKLAYOUT Edit Layouts for Printing with MS Word  
Transaction Code S_P99_41000191   (empty) 
Created on 19990520    
Customizing Attributes VORLAGEN   Templates 
Customizing Activity VORLAGEN   OMS Templates 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CFMENUOLPSOLDPS    

In this IMG activity, you define templates (layouts) with which you can print header and operation data via Microsoft Word 97.

Depending on the layout, one or more pages can be printed per header or operation, which you select in the Engineering Workbench. A layout can include the following data:

  • Individual header or operation data, such as description of the work center
  • Tables, operation data, component assignments, production resources/tools or inspection characteristics
  • Graphics

You proceed as follows:

  1. You define a layout in the ERP system.
  2. You define one or more tables.
  3. You set the number of graphics you want to appear in each printout.
  4. You create a Word document.
  5. You create the tables defined in the layout and format them.
  6. You create links to the graphics and individual fields.

Then you can begin printing from the Engineering Workbench. The ERP system sends the data to Microsoft Word and thereby fills the tables, inserts the graphics and then prints the document.

Requirements

Setting up Word 97

To ensure smooth interaction between the ERP system and Microsoft Word 97, set the Options in Word 97, proceeding as follows:

  1. Choose Extras -> Options.

    The Options dialog box appears.

  2. Choose the tab page General, and de-select the indicators Update links automatically and Display macro warning.
  3. Choose the tab page Print and deselect the Update links check box.
  4. Choose OK and exit Word.

Creating graphics in the ERP system

Create the graphics that you want to print in the ERP system. You can use graphics with the graphic formats BMP, GIF and JPG.

  1. First of all check in Customizing for the document management system whether the workstation applications are defined for the appropriate graphic formats. Pay attention to the following in the detail view:
    1. If you want to print bitmaps, you must have the file suffix BMP and MIME type image/x-ms-bmp .
    2. If you want to print GIF files, you must have the file suffix GIF and MIME type image/gif.
    3. If you want to print JPEG files, you must have the file suffix JPG and MIME type image/jpeg.
  2. Create the graphic as a document in the ERP Document management system. In the group Original, enter the work station application that is defined in Customizing and then choose the storage data of the graphic. Finally release the document.
  3. Afterwards create this document as a production resource/tool and assign it to the corresponding operation in the rate routing. For the production resource/tool number enter only a number from a specific number area (e.g. 800-900) in order to differentiate between the graphics and other documents, which you have also created as production resources/tools. You must enter this area later, when you create a layout in the ERP system.

Recommendation

If you want certain printouts, such as operational method sheets, to have the same layout enterprise-wide, you should first of all create a layout as template, in which you can enter general data, such as the company logo or page format settings. You can then copy this template for all other layouts that you want to create.

If you want to print several operations in one step, you can create an additional layout that you use for printing a cover sheet.

Activities

To print header or operation data via Microsoft Word 97 you first create a layout in the ERP system and then a Word document. Proceed as follows:

Creating a Layout in the ERP System

  1. First of all create a new template in the work step Header data template, by
    1. Choosing New entries
    2. entering the name and the description of the template
    3. entering the maximum number of graphics that you want to print per operation
    4. entering the number area of the production resources/tools, in which you have placed the graphics
    5. Save your entries.
  2. In the work step Table assignment define the tables that you would like to print for each operation. Enter the following data:
    1. a key for the table (freely definable)
    2. the ERP table that sends the data to Word.
      3. You can, for example, choose the table OPR (operation data)
    3. the current Table number in the Word document

      You should also enter

    4. whether the system is to automatically adjust the number of lines in the table in the Word document
    5. which row is the First row of data in the Word document table
  3. Save your entries.
  4. In the work step Field assignment, assign the field name of an ERP table to each column of the Word table. On printing, this field provides the data to Microsoft Word.
  5. Save the layout so that you can edit the document in MS Word.

Creating a document in Microsoft Word 97

  1. Select a template and then the function key Template to begin Microsoft Word.
    The system automatically opens an empty document template in Microsoft Word, which contains the macros necessary for printing. Therefore you should always begin Word from Customizing for OMS.
  2. Create the following objects in the Word document: For each table that you have already defined in Customizing, create a table in Word.

    Note that Word numbers the tables in columns from top to bottom and from left to right. You must insert the tables in such a way that the table number corresponds to the number which you have entered in the template in the ERP system.

    If you subsequently insert a table into a Word document, Word renumbers all following documents and you must update the layout in the ERP system.

  3. Insert links (placeholder) in the document for the graphics that you would like to print.
    1. To do so, select the function key Link and then select the desired graphic from the selection list. Whilst doing so, keep Microsoft Word constantly open in the background.
      2. The graphics have the key 'PS_PICTURE' followed by a two figure number.
    2. Choose Copy to clipboard. The system inserts the links onto the clipboard.
    3. Change to Microsoft Word and place the cursor on the place in the document in which you would like to insert the link.
    4. Then choose Edit -> Insert contents.
      5. A dialog box appears.
    5. Choose Links.
    6. Choose OK.
      7. You have inserted the link.
  4. As well as links to graphics, you can also insert links to individual fields of an ERP table. To do so, proceed as for inserting graphics. The selection list contains all fields of the tables of operation data OPR and task list header data TSK. You can insert all fields with a name beginning with OPR- or with TSK-.
  5. After you have inserted all objects and the data has been received from the ERP system you can format the tables and if necessary insert further objects such as your company logo, for example. Word then prints these objects with every operation.
  6. You can save the layout and the document simultaneously in Microsoft Word by choosing Save.

Business Attributes
ASAP Roadmap ID 203   Establish Master Data 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
VC_TLDPS C - View cluster OLDPS  
History
Last changed by/on SAP  19990521 
SAP Release Created in