SAP ABAP Data Element OUT_FORM1 (Output Format (Addition))
Hierarchy
SAP_FIN (Software Component) SAP_FIN
   FI-SL-IS (Application Component) Information System
     GRWT (Package) Report Painter / Report Writer
Basic Data
Data Element OUT_FORM1
Short Description Output Format (Addition)  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type OUT_FORM1    
Data Type CHAR   Character String 
Length 1    
Decimal Places 0    
Output Length 1    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 Format (A) 
Medium 20 Output format (A) 
Long 40 Output Format (Addition) 
Heading Format 
Documentation

Definition

This field controls the format in which the reports in the report group are to be ouput to the output medium.

Where

'0'
List format - Output as on the screen

'1'
Table format - Formatting characters such as underline, column separators and thousands point are left out

This format cannot be output to the screen (output medium '0'), it is used to exchange data with external programs. For example to import a report to a spreadsheet program.

'2'
Excel format - The report is exported to the presentation server in a special Excel format (output medium '2'). To display this a special Excel filter must be installed on the presentation server.

'3'
HTML format - The report is exported in HTML format to the application server (output medium '1') or the presentation server (output medium '2'). The file can subsequently be displayed using an Internet Browser.

Note

You should use output format '2' to export to Microsoft Excel. Note that this format assumes a special Excel filter has been installed on the presentation server.

If the report is to be imported to a different spreadsheet program, the output formats '0' and '1' are basically suitable. You must, however, note the following:

  • Output format '0': The complete report is exported as a text file. In order to import the cells into a spreadsheet program correctly, you must enter the current column separators at the time of the import (this is, for exaqmple, supported by Microsoft Excel).
  • Output format '1': The report is exported as a table. Headers and footers are not exported. Exception: If the standard headings have been suppressed using column text type '9', the column headings generated from the header are exported. The title, last and comment pages are not exported in file format 'WK1' (see below).

    For output format '1' to output medium '2' (presentation server) you can specify various file formats:

    • ASC ASCII (text format)
    • BIN binary format
    • WK1 spreadsheet format
    • DAT data table ASCII with column tabulator

      The file format 'DAT' is the most suitable for exporting a report to a spreadsheet program.

History
Last changed by/on SAP  20010607 
SAP Release Created in