Defining a Report (SAP Library - Consolidation (FI-LC))

Defining a Report

Choose Info system ® Reports to define or modify reports. Several sample reports are preset in the PC data entry program. You can use them as a template when creating new reports.

Creating a new report

When creating a new report, enter an ID, a name, and identifiers for the line and column layout. The ID’s may not exceed 8 characters. The ID’s must begin with a Z for all reports created by users other than ADMIN . You can use line and column layouts that already exist.

Defining common parameters

Describe the report on the next screen:

You can (re-)define the name, the title and the line and column layout ID’s.

You can insert the following variables in the title:

Variable

Print Example

&VERSION

001

&VERSION-T

ACTUAL

&GJAHR (= fiscal year)

1996

&GJAHR+1

1997

&GJAHR-1

1995

&PERIOD

10

&PERIOD+1

11

&PERIOD-1

09

Choose one of the formats portrait or landscape.

Define the number of columns and sub-lines using the Possible entries function. Click to confirm your entry - the field’s color will change from white back to black.

Choose the arrangement of the FS items and companies in the lines and columns in the model matrix on the screen:

Option 1: The items are listed (vertically) in the line layout; the company, time and/or version are listed (horizontally) in the column layout.
Option 2: The company is listed (vertically) in the line layout; the items, time and/or version are listed (horizontally) in the column layout.

By choosing the selection options you can determine which company/subgroup or item is to apply to a specific column.

Defining a line layout

You can either create an entirely new line layout, or you can copy and modify an existing line layout as your template. Specify the following parameters for your line layout:

Sequence number

The sequence number determines the order of your lines. You can also control paragraphing and paging by the way you assign the two leading digits:

New Paragraph:
is achieved by incrementing the second digit (from the left) in the sequence number.
New Page:
is achieved by incrementing the first digit (from the left) in the sequence number.

Sequence no.

Output

00010

line 10 / paragraph 1 / page 1

00011

line 11 / paragraph 1 / page 1

01012

line 12 / paragraph 2 / page 1

11013

line 13 / paragraph 2 / page 2

Sign

All values can be displayed on the report as positive numbers by entering a minus sign at the items that normally have a negative value. The value will appear positive in the output.

Shading

Highlight any lines you want to emphasize with color.

Column suppression

Use the entries described below to hide a range of columns on a line-by-line basis:

H and <column number> (e.g., H04 ):

columns remain hidden starting at this line

V and <column number> (e.g., V04 ):

columns become visible again starting at this line

Suppression begins at the line specified down to the line containing the revocation.

FS item and transaction type

Enter the item and the transaction type, if applicable, on each line. Refer to the FS chart of accounts information provided in the PC data entry program under Master data.

Determine for each item and transaction type whether the text is to be displayed.

Defining a column layout

You can either create an entirely new column layout, or you can copy and modify an existing column layout as your template. Specify each individual column, distinguishing between column 0 and the remaining columns. Column 0 is reserved for the line identifiers. Column parameters do not apply to this column.

Column

The number of columns defined in the common parameters are displayed for further specification. Use the scroll bar, located along the bottom of the window, for paging among the columns.

Column heading

You can define three heading lines. You can also use the same variables that were available for the report title.

Column format

Define the font size and width, the column’s distance from the left margin, and the column width.

Sub-lines

You can use sub-lines to distinguish columns among several criteria. For instance, you can depict data for multiple years or versions on sub-lines.

Column parameters

Version

Shifting of year and period

You can access another year’s values via the first parameter. Likewise, you can access another period’s values with the second parameter. These variables let you avoid having to redefine reports for different years or periods.

Subgroup/company or FS item (depending on which matrix is chosen)

Transaction types

Sign

Analogous to the line definition.

Formula

You can use a formula for referencing values from other lines or columns:

Referencing lines: X and <line number> – operands available: + - * /

Referencing columns: Y and <column number> – same operands

Y1-Y2
X4+X8

Base line

When specifying a base line, the column’s values are put into relation to that in the base line, thereby producing a percentage ratio.

Variable	Print Example
&VERSION	001
&VERSION-T	ACTUAL
&GJAHR (= fiscal year)	1996
&GJAHR+1	1997
&GJAHR-1	1995
&PERIOD	10
&PERIOD+1	11
&PERIOD-1	09

Sequence no.	Output
00010	line 10 / paragraph 1 / page 1
00011	line 11 / paragraph 1 / page 1
01012	line 12 / paragraph 2 / page 1
11013	line 13 / paragraph 2 / page 2