Function documentationJournal Ledger Report by Segment

 

You use the journal ledger report to show movement, and activities of detailed accounts in a specified period for a specified segment. This display-only report is a subset of the complete journal ledger report.

Prerequisites

You have the following authorizations:

  • Company code (for both accounting documents and general ledger accounts)

  • Account type

  • Segment

Features

Display Report

The displayed report contains all historical posts that fit your selection criteria.

Each line of the report describes one document and contains the following default fields:

  • Period

  • Account code and name

  • Segment

  • Segment Description

  • Document number

  • Posting date

  • Description

  • Document currency

  • Direction

  • Debit (document currency)

  • Credit (document currency)

  • Debit (local currency)

  • Credit (local currency)

  • Balance

Choose Settings to show additional fields in the displayed report or to hide fields.

Display as SAP Crystal Reports

Journal Ledger: by Segment SAP Crystal Reports provides an alternative way to display the same information.

Export Report

The journal ledger by segment report is display only. However, you can also export your report to Microsoft Excel for further manipulation or printing.

Activities

Choose Start of the navigation path G/L Accountant Next navigation step Reports Next navigation step Journal Ledger Report: By Segment End of the navigation path

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.

  • Segment

  • Hide accounts 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 (Insert line) and Delete line (Delete line) controls to add or remove lines of selection criteria.

You can save your selection criteria as a variant for reuse.

Drill Down to Posting Document

You can drill down from the journal ledger report to source documents that were used to create the report:

  • Select a line in the journal report and choose Display Document

    The detailed accounting document is displayed in a new window. If you select a line that is not a real posting (such as the beginning balance or the accumulated amount, Display Document is grayed out.

More Information

Journal ledger report

Journal ledger report by profit center

Journal ledger report by business area