Download - SAP Standard Reports FICO
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