Skip to main content

Breakdowns (reporting)

Updated over 2 months ago

The outline represents the line structure of a self-contained sub-report.

Go to Finance > Reports > Reporting and call up any report.
Expand the "Other settings" business object and click on Edit all outlines.

image-20250120-130836.png

The breakdowns are divided into five types: Balance sheet, P&L, cost center, cost unit or other report (e.g. BWA). If your list is empty, you can first create (1) the standard definitions. These serve as a starting point in which you can then edit or copy them directly.

The account assignment in the standard reports is based on SKR03, so this assignment must be revised; the same applies to cost centers and cost objects.

You can export an existing structure via (2) in order to import it into other companies using the CSV import (3).

The other buttons such as Add, Edit, Remove and Duplicate are self-explanatory. The Change dimension accounts button allows you to replace the cost center reference in value lines (see below) with another reference.

You will receive several cost center reports, e.g. per department, if you first define a standard structure for a cost center. By duplicating and swapping the cost center, you can then quickly obtain a set of similar cost center reports. You can call up all of these sub-reports at the same time as part of your main report.

The components of an outline

By selecting an outline and editing it (or adding a completely empty outline), you can access the overview of the components. The header area contains the name and description as well as a language control (1) according to the G/L account master.

image-20250120-135654.png

Each of the following report rows has a name that can be maintained directly in the table. The line number (2) specifies the sequence in the sub-report.

When setting up a report, ensure that there is sufficient space between the line numbers. The line numbers can only be adjusted individually afterwards and cannot be moved in blocks. 10 - or better 20 - lines is a good distance.

The line type (3) defines the content of the line and can be selected via drop-down,
in the assignment (4) you can see whether values have also been assigned to the line.

image-20250120-142304.png

Possible row types

  • Result line
    Balances several lines of the report

  • P&L value
    Special line for balance sheet type reports, determines the current P&L value from the balance of the P&L accounts. No additional G/L accounts may be stored in such a line.

  • Profit carried forward/loss carried forward
    ​

  • Deficit not covered by equity
    Special line for balance sheet type reports.

  • Percentage line
    A percentage value is output in a percentage line.

    image-20250120-144946.png
  • Calculation line
    The values of two lines of the partial report can be linked using the four basic arithmetic operations or set in a percentage ratio.

    image-20250120-144724.png
  • Heading
    Text line, displays the designation according to the column of the same name.

  • Value line
    The data from the posting journal is determined here on an account, cost center or cost unit basis.
    ​

Did this answer your question?