Open items by customer group

Use TCODE: S_ALR_87012172 - Customer Balances in Local Currency
Description

The balances from the following transactions can be issued with the customer balance list:
Standard G/L transactionsSpecial G/L transactions (per special G/L indicator)The following figures (for a particular month only) are displayed in local currency:

Balance at period start ( balance carried forward and balance of the periods before the reporting periods)Debit total for the reporting periodCredit total for the reporting periodDebit or credit balances for the whole periodThe following data is issued at the end of the list for each local currency:

Totals per company codeFinal total across all company codesOutput and Sort SequenceYou can choose from two sort sequences for the accounts.

Sort sequence "1" uses the reconciliation account as the sort criteria whereas sort sequence "2" uses the account number.

With both of these sort sequences you can choose between a standard version and a corporate group version. In the standard version, the accounts are listed per company code. In the corporate group version the company codes are listed per account.

You can use the "Summarization level" parameter to specify whether the data is to be issued in detailed or summarized form.

The following overview shows the relation between
The account sort sequencesThe standard or corporate group versions

The summarization levelsAccount

sort sequence 1 - standard version - Data sorted by:
Company codeReconciliation accountAccount numberSummarization levels:
0 = No summarization (total per open item account)

1 = Summarization of the open item accounts (total per reconciliation account)

2 = Summarization of the reconciliation accounts (total per company code)

3 = End totals sheet only (totals across all company codes)Account

sort sequence 1 - corporate group versionData sorted by:
Reconciliation accountAccount numberCompany code currency keyCompany codeSummarization levels:
0 = No summarization (total per company code)

1 = Summarization of company codes (total per currency key)

2 = Summarization of open item accounts (total per reconciliation account)

3 = End totals sheet only (totals across all company codes)Account

sort sequence 2 - standard versionData sorted by:
Company codeAccount numberSummarization levels
0 = No summarization (total per open item account)

1 = Summarization of open item accounts (total per company code)

2 = End totals sheet only (totals across all company codes)Account

sort sequence 2 - corporate group versionData sorted by:
Account numberCurrency keyCompany codeSummarization levels
0 = No summarization (total per company code)

1 = Summarization of the company codes (total per currency key)

2 = End totals sheet only (totals across all company codes)

Recording data on microficheYou can request information for recording on microfiche. The fixed part of the microfiche information is documented under the parameter for it. The variable part, i.e. the report-specific part, has the following structure:
In the standard version:
Company code 4 charactersReconciliation account 10 characters (only with sort sequence 1)Account number 10 charactersIn the corporate group version:
Reconciliation account 10 characters (only with sort sequence 1)Account number 10 charactersCurrency key 5 charactersCompany code 4 characters