Show TOC

 Creating Forms for Financial Statement Analysis

You can create a form in Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting or General Ledger Accounting (new) Next navigation step Information System Next navigation step Drilldown Reports (G/L Accounts) Next navigation step Form Next navigation step Define Form End of the navigation path .

The following describes how to create a form for financial statement analysis. In this example, a form is created for an actual/actual year comparison .

Basic data

Enter the basic data for your form:

  1. Select form type financial statement analysis and enter a name for the form.

    Caution Caution

    The SAP standard reports for financial statement analysis have the naming convention 0SAPBLNCE-01 to 0SAPBLNCE-XX . For your form, use a technical name that does not lie within this name range.

    End of the caution.

  2. As a structure, choose one axis with key figure.

  3. You can use a SAP standard form as a template. To do so, choose Copy from and select the desired SAP standard form.

  4. Choose Create.

    The Report Painter screen appears. Create form.

    Note Note

    In the standard system, the row display appears. To switch to the column display, choose Start of the navigation path Goto Next navigation step Column display. End of the navigation path

    End of the note.
General selections

Define your general selections, that is, define the characteristics that are valid for all columns in your form.

  1. Choose . The Element definition screen appears. General selections

  2. Selected the characteristics you want to use from the characteristics available. Select the characteristic you want to use and insert it in the list of selected characteristics via the button.

  3. Enter a value or range for the selected characteristics.

    Example Example

    If you define an actual/actual year comparison form, the values should be actual values for all characteristics. You thus select from the available characteristics Plan/actual key figure and enter 0 in the From field for actual data.

    End of the example.

  4. To return to the display of your form, choose Confirm .

Characteristic definition

Make the character definitions , that is, define the characteristics for the individual columns :

Note Note

The key figure column defines the characteristic with which your valuations are structured. In the G/L Account Information System, the hierarchical order of the account numbers is typically the account number or the financial statement version. You define the characteristic key figure when defining the report , that is, you do not have to define this characteristic in the form.

End of the note.

  1. For the individual columns, select the column header with the name Element x with a double-click and then select the element type Key figure with characteristics . The Element definition screen appears.

  2. Select the desired key figure . With the key figure you define what type of values you want to display for a specific column.

  3. From the available characteristics, choose the ones you need for the column. Select the characteristics you want to use and insert them in the list of selected characteristics via the button.

  4. For the selected characteristics, select fixed values or variables .

    • If you want to assign fixed values , enter the value or range in the From field.

    • If you want to enter a variable , select the column. You obtain a list with the predefined global variables for the selected characteristic.

  5. If you have already defined columns, you can make calculations between these columns.

    To do so, choose the column in which you want to make the calculations and choose the element type Formula . The formula editor, in which your predefined columns are defined as identifiers, appears. In the formula editor, you can use the basic mathematical calculations (+,-,*,/).

    Example Example

    For an actual/actual year comparison, you could, for example, make the following characteristic definitions for the individual columns:

    End of the example.

    First column: Financial statement values for a specific year

    Second column: Corresponding values for the previous year

    Third column: Difference between the first and second column

    Element type

    Key figure with characteristics

    Key figure with characteristics

    Formula

    Key figure

    Financial statement value

    Financial statement value

    Enter the formula using the formula editor: X001 - X002

    Selected characteristic

    Fiscal year as predefined global variable: &1FY

    Previous fiscal year as a variable: &1FY-1

  6. You can copy the characteristic definition of a column and insert the definition in another column. To do so, select the column to be copied using , position the cursor on the column to which it is to be copied, and choose .

  7. To return to the display of your form, choose Confirm .

Text definition

Entering the texts for your columns:

  1. Position the cursor on the desired column and choose . The screen for text editing appears.

  2. You can enter a short, medium, and long text for the column name.

    Note Note

    If you want to enter a two-line name, you enter a semi-colon at the point where you want the second line to begin.

    End of the note.

  3. If you use variables in the characteristic definition, you can also enter variables for the column names. The text for the column header is thus determined when the report is run.

    Note Note

    For an actual/actual year comparison, you can enter the following texts for the first column:

    End of the note.

    Text type

    Example

    Short text

    FY;&1FY

    Mid-length text

    Fisc. Yr; &1FY

    Long text

    Fiscal Year;&1FY

Save the form.

Result

You have created a form.

Based on this form, you can now create a report for financial statement analysis.