General Ledger Report with Drilldown
You use the general ledger report to check and display movement of accounts in a specified period. You also have the opportunity to select drilldown fields; this causes the report and all key figures to be drilled down to the selected drilldown field.
Prerequisites
You have the following authorizations:
Company code (for both accounting documents and general ledger accounts)
Business area
Profit center
Features
The default report has the following fields:
Period
Account code and name
Currency key
Business area
Business area description
Profit center
Profit center description
Segment
Segment description
Beginning balance
Accumulated debit
Accumulated credit
Year-to-date debit
Year-to-date credit
Balance
Export Report
The general ledger with drilldown report is display only. However, you can also export your report to Microsoft Excel for further manipulation or printing.
Activities
Choose 
G/L Accountant
Reports
General Ledger: Drilldown Report
.
The following selection criteria are mandatory:
Company code
The default is the currently-selected favorite.
Fiscal year
The default is the current year.
Ledger
The default is 0L (leading ledger).
You can also choose from the following selection criteria:
Period
The default is the current period.
G/L account number
This can be the number of a general ledger account or the number of a general ledger account level in a level hierarchy. Leave blank for a report on all general ledger accounts.
Business area
Profit center group
Profit center
Segment
Hide account without postings
This checkbox indicates whether the accounts that do not have postings and beginning balance in a given period are displayed in the report. This option is selected by default.
Include documents to be verified
This checkbox indicates whether the documents to be verified are displayed and taken into the balance and cumulative amount calculations in the report.
Run report in background
This checkbox indicates whether the report should run in the background. If it is selected, the result of the report is not displayed after executing the search but runs asynchronously in a separate task. The status for reports running in the background can be viewed in the task monitor and the report result can be displayed by choosing
Display Report
in the task monitor. When the volume of the data to be searched is large and executing the search needs to take a long time, consider selecting this checkbox so that the report runs in the background and returns the result asynchronously.Process large volumes of data
This checkbox indicates that the report splits the task of search execution into many subtasks and distributes these between multiple server processes for execution. Use this option when the selection criteria imply many general ledger accounts (not account levels) or many periods. The maximum number of processes used to run the report in this way is set in reports customizing.
The larger the number of the maximum processes, the faster the search runs.
Account currency
You can use this field to select a currency in which the report displays the accounts. The following options are available:
Leave the field blank: this causes all accounts that satisfy the selection criteria to display in the local currency
Specify the local currency: this causes all local currency accounts that satisfy the selection criteria to display in the local currency
Figures for foreign currency transactions on these accounts are converted to the local currency before display.
Specify a foreign currency: this causes all accounts in the specified foreign currency that satisfy the selection criteria to display
Transaction figures for these accounts are displayed in the foreign currency.
For entering the selection criteria, you can also use the F4 help for a list of options. The account number is displayed as a hierarchy to allow for rapid selection; selecting a parent account also selects all the associated subaccounts.
Not all selection criteria are displayed by default. You can use the 
(Insert line
) and 
(Delete line
) controls to add or remove lines of selection criteria.
You can save your selection criteria as a variant for reuse.
Drilldown
Choose Drilldown Settings
.
The drilldown fields are displayed at the left of the report. The available fields are as follows:
Period
General ledger account
Currency key
Business area
Profit center
Segment
Select one of the drilldown fields and choose Execute
. The report is regenerated drilled down vertically to your selected field.
This report is display only – you cannot print the report.