SAP Standard Reports FICO

1 .Structured Account Balances (Balance Sheet & P&L Account in FS Version Format) S_ALR_870122792. GL Account Balances (Totals & Balances ) S_ALR_870123013. GL Line Items S_ALR_870122824. Statements for GL Accounts, Customers & Vendors S_ALR_870123325. Document Journal S_ALR_870122876. Compact Document Journal S_ALR_870122897. Line Item Journal S_ALR_87012291 8. Display of Changed Documents S_ALR_870122939. Invoice Numbers assigned Twice S_ALR_8701234110. Gaps in Document Number Assignments S_ALR_8701234211. Posting Totals Document Type wise S_ALR_8701234412. Recurring Entry Documents S_ALR_8701234613. Chart of Accounts S_AL:R_8701232614. GL Account List S_AL:R_8701232815. Display Changes to GL Accounts S_ALR_8701230816. Financial Statement Version FSE2 CASH & BANK REPORTS

1. Check Information List FCH62. Check Register FCHN3. Check Number Ranges S_P99_41000102

TAX REPORTS & REGISTERS

1. List of Internally generated Excise Invoices J1I72. Capital Goods Transfer of Credit J2I83. List of GRs without Excise Invoice J1IGR4. List of SubContract Challans J1IFR5. CENVAT Register J2I9

ACCOUNTS RECEIVABLE

1. Bill Holdings (Bill of Exchange Receivable List with ALV facility)S-ALR_870099872. Customer Balances in Local Currency S_ALR_870121723. Customer Line Items S_ALR_870121974. Due Dates Analysis for Open Items S_ALR_870121685. List of Customer Open Items S_ALR_870121736. Customer Evaluation with Open Item Sorted List S_ALR_870121767. Customer Payment History S_ALR_870121778. Customer Open Item Analysis (Overdue Items Balance) S_ALR_870121789. List of Customer Cleared Line Items S_ALR_8701219810.List of Down Payments open at key date S_ALR_8701219911. Debit & Credit Notes Register u2013 Monthly S_ALR_8701228712. Customer wise Sales S_ALR_87012186

1. Vendor Balances S_ALR_870120822. Vendor Debit/Credit Memo Register S_ALR_87012287

This tutorial will give you an overview of important reports which are used frequently in SAP FI. Following

is list of important reports

1.  GL Chart Of Accounts List

2.  GL Account List

3.  GL Account Balances

4.  GL Account Totals And Balances

5.  AR Customer Master Data List

6.  AR Customer Balances

7.  AR Customer Line Items

8.  AR Customer Open Item Analysis Drilldown Report

9.  AR Customer Payment History

10.  AP Vendor Master Data List

11.  AP Vendor Balances

12.  AP Vendor Line Items

13.  AP Vendor Open Item Analysis

We will now discuss them one by one.

GL Chart Of Accounts ListEnter Transaction Code S_ALR_87012326 in the SAP Command Field

In the next screen , Enter Chart of Account Key

Press F8 (Execute)

The GL Chart of Accounts List is Generated for COA key mentioned in the last screen

 GL Account ListEnter Transaction Code S_ALR_87012328  in SAP Command Field

 

In the next screen, Enter Selection Parameters like Company Code / Chart of Accounts / GL Account for

Filtering. Entering these parameters is optional

 

Press F8 (Execute)

The GL Account List is generated as per the filtering selections from the previous screen .

Otherwise complete list is generated for all company code and chart of accounts

 

 

 GL Account BalancesEnter Transaction Code S_ALR _87012277  in the SAP Command Field

In the next screen, Enter Selection Parameters for Filtering the Report such as Company code / GL

Account

 

Press F8 (Execute)

In the next screen, GL Account Balance List is generated as per the parameters entered in the previous

screen

 

GL Account  Totals and BalancesEnter Transaction code S_ALR_ 87012301 in the Sap Command Field

In the next screen , Enter Selection Criteria like Company Code/ COA / Gl Accounts for the filtering the

Report

 

 

In the next screen , GL Account Total and Balance report is generated as per the parameters

selected in the previous screen

 

 AR Customer Master Data List 

Enter Transaction S_ALR_87012179  in SAP Command Field

 

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AR Customer Master Data List is  generated as per the parameters

selected in the previous screen

 

 AR Customer BalancesEnter Transaction Code S_ALR_87012172 in the SAP Command Field

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AR Customer Balance Report  is  generated as per the parameters selected in the

previous screen

 

 

AR Customer Line Items 

Enter Transaction Code S_ALR_87012197 in the SAP Command Field

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AR Customer Line Item Report  is  generated as per the parameters selected in the

previous screen

AR Customer Open Items 

Enter Transaction Code S_ALR_87012174  in the SAP Command Field

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AR Customer Open Item Report  is  generated as per the parameters selected in the

previous screen

 

AR Customer Payment HistoryEnter Transaction Code S_ALR_87012177 in SAP Command Field

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AR Customer Payment History Report  is  generated as per the parameters selected

in the previous screen

 

AP Vendor Master Data ListEnter Transaction Code S_ALR_87012086  in SAP Command Field

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AP Vendor Master Data List Report  is  generated as per the parameters selected in

the previous screen

AP Vendor BalancesEnter Transaction Code S_ALR_87012082 in SAP Command Field

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AP Vendor Balances Report  is  generated as per the parameters selected in the

previous screen

AP Vendor Line Items

Enter Transaction Code S_ALR_87012103 in SAP Command Field

In the next screen , Enter Selection Criteria like Company code / Vendor Accounts for the filtering the

Report

 

In the next screen , AP Vendor Line Items  List Report  is  generated as per the parameters selected in

the previous screen

AP Vendor Open Item AnalysisEnter Transaction Code S_ALR_87012083  in SAP Command Field

In the next screen , Enter Selection Criteria for the filtering the Report

 

In the next screen , AP Vendor Open Item Analysis Report  is  generated as per the parameters selected

in the previous screen

Read more at http://www.saptraininghub.com/important-reports-sap-fi/#i26tl4K2hCW5rcMe.99

GENERAL LEDGER

Information Systems

1.  Structured Account Balances (Balance Sheet & P&L Account  in FS Version Format)

                                                         S_ALR_870122792.  GL Account Balances (Totals & Balances )             S_ALR_870123013.  GL Line Items                                        S_ALR_870122824.  Statements for GL Accounts, Customers & Vendors      S_ALR_870123325.  Document Journal                                     S_ALR_870122876.  Compact Document Journal                             S_ALR_870122897.  Line Item Journal                                    S_ALR_870122918.  Display of Changed Documents                         S_ALR_870122939.  Invoice Numbers assigned Twice                       S_ALR_8701234110. Gaps in Document Number Assignments                  S_ALR_8701234211. Posting Totals Document Type wise                    S_ALR_8701234412. Recurring Entry Documents                            S_ALR_87012346

Master Data

13. Chart of Accounts                                    S_AL:R_8701232614. GL Account List                                      S_AL:R_8701232815. Display Changes to GL Accounts                       S_ALR_8701230816. Financial Statement Version                          FSE2

CASH & BANK REPORTS

1. Check Information List                                FCH62. Check Register                                        FCHN3. Check Number Ranges                                   S_P99_41000102

TAX REPORTS & REGISTERS

1. List of Internally generated Excise Invoices          J1I7

2. Capital Goods Transfer of Credit                      J2I83. List of GRs without Excise Invoice                    J1IGR

4. List of SubContract Challans                          J1IFR

5. CENVAT Register                                       J2I9(Monthly Return under Rule 57AE of the Central excise Rules fromwhich Monthly Return under Rule 7 of the CENVAT Credit Rules 2001)

6. Registers : RG 23A/C Part I &II , RG1, PLA            J1I5,J2I5,J2I6ACCOUNTS RECEIVABLE

Information Systems

1. Bill Holdings (Bill of Exchange Receivable List  with ALV facility)                                                         S-ALR_870099872. Customer Balances in Local Currency                   S_ALR_870121723. Customer Line Items                                   S_ALR_87012197

4. Due Dates Analysis for Open Items                     S_ALR_870121685. List of Customer Open Items                           S_ALR_870121736. Customer Evaluation with Open Item Sorted List        S_ALR_870121767. Customer Payment History                              S_ALR_870121778. Customer Open Item Analysis (Overdue Items Balance)   S_ALR_870121789. List of Customer Cleared Line Items                   S_ALR_8701219810.List of Down Payments open at key date                S_ALR_8701219911. Debit & Credit Notes Register – Monthly              S_ALR_8701228712. Customer wise Sales                                  S_ALR_87012186

ACCOUNTS PAYABLE

(Note : Similar Reports available for A/R are available for A/P also)

1. Vendor Balances                                       S_ALR_870120822. Vendor Debit/Credit Memo Register                     S_ALR_87012287

Is there a Report displaying Master data, that is a list of vendors showing name, address, payment method, etc ( everything about vendor).   Is their any report like that and what's the table name to display all vendor master data too.

Go to this menu: Financial Accounting -> Accounts Payable -> Information System -> Reports for AP accounting -> Master Data.

How to get Report of Withholding Tax along with Vendor Name.  What is the T-Code or Path for this report?

You can get the withholding tax report for vendor by using these t.codes: S_P00_07000134 - Generic Withholding Tax Reporting  S_PL0_09000447 - Withholding tax report for the vendor

Which reports we can use for the receivables to be checked on daily basis?

Go to SAP Easy Access main menu. Go To Accounting -> FI Acc -> customer(receivables) -> information system -> reports .  Here you can get all the standard reports for receivables.

Important FI Transactin Codes  Some Important Tcodes for FI GL AR AP Asset

Get help for your SAP FI/CO problems SAP FICO Forum - Do you have a SAP FI/CO Question?

SAP Books SAP FICO Books - Certification, Interview Questions and Configuration

SAP FICO Tips 

SAP FI/CO Tips and Financial Accounting/Controlling Discussion Forum