Defining Drilldown Reports (SAP Library - Flexible General Ledger (FI-GL))

Defining Drilldown Reports

Use

You can define the following reports using the drilldown technique.

Financial statement reports
Account balances

Prerequisites

In Flexible General Ledger Customizing, you define reports and forms. To do this, in the Flexible General Ledger Implementation Guide select the application area Information System and complete each activity.

Procedure

The procedure for creating reports and forms corresponds to the procedure in the previous general ledger. Here, the differences between the previous general ledger and the Flexible General Ledger are described. The exact procedure can be found in the R/3 Library under Financial Accounting in the General Ledger documentation. Read the "Information System" documentation in this section.

Financial statement reports (one axis with key figures)

The following rules apply to forms:

Select "One axis with key figure" as the form type.

In the "Handling the currency" screen, select indicator "Currency per element, with currency translation". Only one currency is possible for a financial statement report.

If you want define the characteristics for all columns, choose Edit ® General selections ® Display/change. Here you enter the general selection criteria such as ledger and business area. You can assign fixed values to these characteristics.

If you want to define the characteristics of the individual columns, note that you always have to select "Balance sheet value" as the key figure. This value is then entered in the column.

After you have determined the key figure, you can select the characteristics you want such as fiscal year and company code.

Afterwards, enter the values for your characteristics. You can enter either fixed values or variables for your characteristics. Select Variable on/off to enter variables. The entry field is then changed accordingly. Unlike with the present general ledger, there are no predefined global variables. Rather, you have to define local variables at this point. A local variable has to begin with a "$" sign.

The following rules apply to creating reports:

When determining the breakdown characteristics with Goto ® Characteristics, you have to select either "Financial statement item" or "Financial statement item/account". Additionally, you can select the relevant general ledger dimensions (such as functional area, cost center, and profit center).

Choose Edit ® Hierarchy selection to select the "Financial statement version" indicator.

Note the following when carrying out this report:

When including a report in the report tree, select application class FBRG.
To carry out the report, choose Account ® More reports in the Flexible General Ledger.

B. Balance sheet key figure reports (2 axes)

The following rules apply to forms:

Select "Two axes (matrix)" as the form type.

In the "Handling the currency" screen, select the "Currency per element, with currency translation" indicator. You can only use one currency for a financial statement report.

If you want define the characteristics for all columns, choose Edit ® General selections ® Display/change. You have to select "Financial statement version" as a general selection. All other selection criteria are optional, such as ledger, business area. You can assign fixed values to these characteristics.

If you want to define the characteristics of the individual columns, note that you always have to select "Financial statement item" as the key figure for the first column. On the next screen, position your cursor on the hierarchy nodes button and select the desired financial statement item using the F4 key. You can extend these reports by including the financial statement items desired in the individual rows.

You can also have values calculated for the individual lines of the key column. To do this, you have to select the "Formula" element type. You can, for example, have totals from the financial statement items be calculated for defined rows.

If you want to define the characteristics of the other columns, note that you always have to select "Balance sheet value" as the key figure. This value is then entered in the column.

After you have determined the key figure, you can select the characteristics you want such as fiscal year and company code.

The following rules apply to creating reports:

When determining the breakdown characteristics, you can select the characteristics desired by choosing Goto ® Characteristics. You can also select the relevant general ledger dimensions (such as functional area, cost center, and profit center).

No hierarchies are selected for this report.

The following rules apply to creating reports:

When including a report in the report tree, select application class FBRG.
To carry out the report, choose Account ® More reports in the Flexible General Ledger.

C: Account balances

The following rules apply to forms:

You can select each type of form.

In the "Handling the currency" screen, select indicator "Any currency, no currency translation". All currencies can be used for account balances.

If you want define the characteristics for all columns, choose Edit ® General selections ® Display/change. You can select the selection characteristics needed, such as ledger, version, and profit center, and you can enter fixed values for them.

If you defined the individual columns, you can select any key figure for each row; for example, the total of the debit posting for one row, total of the credit postings for the second row, and balance for the third row.

After you have determined the key figure, you can select the characteristics you want, such as fiscal year and company code.

The following rules apply to creating reports:

When determining the breakdown characteristics, you can select the characteristics desired by choosing Goto ® Characteristics. You can also select the relevant general ledger dimensions (such as functional area, cost center, and profit center).

No hierarchies are selected for this report.

The following rules apply to creating reports:

When including a report in the report tree, select application class FBRG.
To carry out the report, choose Account ® More reports from the Flexible General Ledger menu.