Useful Reports Tcode in SAP Financial Accounting

OVERALL LEDGER

Data and Information Systems

1. Balanced account balances (P&L account and balance sheet in FS Version Format)      S_ALR_87012279

2.  GL Account Balances (Totals & Balances )          S_ALR_87012301

3.  GL Line Items                                                            S_ALR_87012282

4.  Statements for GL Accounts, Customers & Vendors  S_ALR_87012332 

5.  Document Journal                                                         S_ALR_87012287

6.  Compact Document Journal                                     S_ALR_87012289

7.  Line Item Journal                                                        S_ALR_87012291

8.  Display of Changed Documents                                 S_ALR_87012293

9.  Invoice Numbers assigned Twice                               S_ALR_87012341

10. Gaps in Document Number Assignments              S_ALR_87012342

11. Posting Totals Document Type wise                          S_ALR_87012344

12. Recurring Entry Documents                                  S_ALR_87012346

Master Data

13. Chart of Accounts                                                S_AL:R_87012326

14. GL Account List                                                        S_AL:R_87012328

15. Display Changes to GL Accounts                             S_ALR_87012308

16. Financial Statement Version                                FSE2

CASH & BANK REPORTS

1. Check Information List                                              FCH6

2. Check Register                                                      FCHN

3. Check Number Ranges                                     S_P99_41000102

TAX REPORTS & REGISTERS

1. List of Internally generated Excise Invoices            J1I7

2. Capital Goods Transfer of Credit                        J2I8                           

3. List of GRs without Excise Invoice                    J1IGR  

4. List of Sub Contract Challans                          J1IFR

5. CENVAT Register                                   J2I9

(Monthly Return under Rule 57AE of the Central excise Rules from 

which Monthly Return under Rule 7 of the CENVAT Credit Rules 2001)

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

ACCOUNTS RECEIVABLE

Information Systems

1. Bill Holdings (Bill of Exchange Receivable List  with ALV facility)

                                                      S-ALR_87009987

2. Customer Balances in Local Currency               S_ALR_87012172

3. Customer Line Items                                           S_ALR_87012197

4. Due Dates Analysis for Open Items                 S_ALR_87012168

5. List of Customer Open Items                       S_ALR_87012173

6. Customer Evaluation with Open Item Sorted List    S_ALR_87012176

7. Customer Payment History                              S_ALR_87012177

8. Customer Open Item Analysis (Overdue Items Balance)   S_ALR_87012178

9. List of Customer Cleared Line Items               S_ALR_87012198

10.List of Down Payments open at key date            S_ALR_87012199

11. Debit & Credit Notes Register – Monthly          S_ALR_87012287

12. 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_87012082

2. Vendor Debit/Credit Memo Register                 S_ALR_87012287

Does a report that lists all of the merchants’ information, including their name, address, mode of payment, and other details? Is there a report similar to that, and what is the name of the table that shows all vendor master data as well?

Navigate to this menu:

Accounts Payable -> Information System -> Reports for AP Accounting -> Master Data in Financial Accounting.


you may be interested in this blog here:-

Order Management System (OMS) in Salesforce: Streamlining Your Sales Operations

Why are developers so fond of ‘REUSE_ALV_GRID_DISPLAY’?

  • Related Posts

    Part 31 of Advance SAPUI5: Using VizFrame Charts in SAPUI5

    The ability to display data graphically is another feature offered by SAPUI5. Charts such as column, bar, pie, and line charts, among others, can be used to do this. We…

    Part 1 of Advance SAPUI5 Part 32: Using SAPUI5 Controls | Icon Tab Bar

    Tabs with icons are displayed in icon tab bars. A tab bar with an icon can be used in two ways. Firstly, when you want to show different views, pages,…

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    You Missed

    Part 31 of Advance SAPUI5: Using VizFrame Charts in SAPUI5

    • By Varad
    • January 27, 2025
    • 31 views
    Part 31 of Advance SAPUI5: Using VizFrame Charts in SAPUI5

    Part 1 of Advance SAPUI5 Part 32: Using SAPUI5 Controls | Icon Tab Bar

    • By Varad
    • January 26, 2025
    • 24 views
    Part 1 of Advance SAPUI5 Part 32: Using SAPUI5 Controls | Icon Tab Bar

    CDS – 23: Fundamentals of CDS Performance Analysis – 1

    • By Varad
    • January 25, 2025
    • 34 views
    CDS – 23: Fundamentals of CDS Performance Analysis – 1

    CDS – 22: If the CDS View Has Aggregate Functions, How to Expand It

    • By Varad
    • January 24, 2025
    • 50 views
    CDS – 22: If the CDS View Has Aggregate Functions, How to Expand It

    BRF+: Data Objects, Applications, and Catalogs

    • By Varad
    • January 23, 2025
    • 61 views
    BRF+: Data Objects, Applications, and Catalogs

    Advanced SAPUI5 – 8 – How to Use Python to Get Weight for SAPUI5 Fiori Apps from the Weigh Scale/Weigh Bridge?

    • By Varad
    • January 22, 2025
    • 50 views
    Advanced SAPUI5 – 8 – How to Use Python to Get Weight for SAPUI5 Fiori Apps from the Weigh Scale/Weigh Bridge?