Important Reports in SAP FI

SAP FI ships a large set of standard reports in its Information System, reached through S_ALR transaction codes or the SAP Easy Access menu. The reports below cover the accounts receivable and accounts payable ledgers as well as the general ledger, and each one runs the same way: enter the transaction code, set the selection parameters on the next screen, and execute with F8.

Report	Transaction code	Ledger	What it shows
G/L Chart of Accounts List	S_ALR_87012326	G/L	All G/L accounts defined in a chart of accounts
G/L Account List	S_ALR_87012328	G/L	G/L account master records, filtered by company code or chart of accounts
G/L Account Balances	S_ALR_87012277	G/L	Period and cumulative balances of G/L accounts
G/L Account Totals and Balances	S_ALR_87012301	G/L	Debit, credit, and balance totals per G/L account
AR Customer Master Data List	S_ALR_87012179	AR	Customer master records held in accounts receivable
AR Customer Balances	S_ALR_87012172	AR	Outstanding customer balances in local currency
AR Customer Line Items	S_ALR_87012197	AR	Individual customer line items, open and cleared
AR Customer Open Items	S_ALR_87012174	AR	Open, unpaid customer items as of a key date
AR Customer Payment History	S_ALR_87012177	AR	Customer payment behavior over time
AP Vendor Master Data List	S_ALR_87012086	AP	Vendor master records held in accounts payable
AP Vendor Balances	S_ALR_87012082	AP	Outstanding vendor balances
AP Vendor Line Items	S_ALR_87012103	AP	Individual vendor line items
AP Vendor Open Item Analysis	S_ALR_87012083	AP	Open, unpaid vendor items grouped by due date

G/L Chart of Accounts List

Step 1) Enter transaction code S_ALR_87012326 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the Chart of Accounts key whose accounts you want to list.

Step 3) Press Execute (F8). The G/L Chart of Accounts List is generated for the chart of accounts key entered.

G/L Account List

Step 1) Enter transaction code S_ALR_87012328 in the SAP command field, as shown below.

Step 2) On the next screen, Enter selection parameters such as Company Code, Chart of Accounts, or G/L Account to filter the list. These parameters are optional.

Step 3) Press Execute (F8). The G/L Account List is generated according to the filter. If no filter is entered, the complete list for all company codes and charts of accounts is produced.

G/L Account Balances

Step 1) Enter transaction code S_ALR_87012277 in the SAP command field, as shown below.

Step 2) On the next screen, Enter selection parameters such as Company Code or G/L Account to filter the report.

Step 3) Press Execute (F8). The G/L Account Balances list is generated based on the parameters entered.

G/L Account Totals and Balances

Step 1) Enter transaction code S_ALR_87012301 in the SAP command field, as shown below.

Step 2) On the next screen, Enter selection criteria such as Company Code, Chart of Accounts, or G/L Account to filter the report.

Step 3) Press Execute (F8). The G/L Account Totals and Balances report is generated based on the parameters selected.

AR Customer Master Data List

Step 1) Enter transaction code S_ALR_87012179 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AR Customer Master Data List is generated based on the parameters selected.

AR Customer Balances

Step 1) Enter transaction code S_ALR_87012172 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AR Customer Balances report is generated based on the parameters selected.

AR Customer Line Items

Step 1) Enter transaction code S_ALR_87012197 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AR Customer Line Items report is generated based on the parameters selected.

AR Customer Open Items

Step 1) Enter transaction code S_ALR_87012174 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AR Customer Open Items report is generated based on the parameters selected.

AR Customer Payment History

Step 1) Enter transaction code S_ALR_87012177 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AR Customer Payment History report is generated based on the parameters selected.

AP Vendor Master Data List

Step 1) Enter transaction code S_ALR_87012086 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AP Vendor Master Data List report is generated based on the parameters selected.

AP Vendor Balances

Step 1) Enter transaction code S_ALR_87012082 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AP Vendor Balances report is generated based on the parameters selected.

AP Vendor Line Items

Step 1) Enter transaction code S_ALR_87012103 in the SAP command field, as shown below.

Step 2) On the next screen, Enter selection criteria such as Company Code or Vendor Account to filter the report.

Step 3) Press Execute (F8). The AP Vendor Line Items report is generated based on the parameters selected.

AP Vendor Open Item Analysis

Step 1) Enter transaction code S_ALR_87012083 in the SAP command field, as shown below.

Step 2) On the next screen, Enter the selection criteria to filter the report.

Step 3) Press Execute (F8). The AP Vendor Open Item Analysis report is generated based on the parameters selected.

FAQs