FI reports in the SAP system

1.   Transaction KSB1

This report is a must-have if you would like to see all cost center information and vendor details, you have a need to enter detail cost element Cost Center and display Reports.

2.   GR55 :

Enter the below details for the 2016 year and Period as 1 for July. It will give all accounting documents in one place. This is also the input to the custom logic I mentioned above.  This is one of the best profit and loss report overview reports.

If specific fields are needed it may be found from the table

3.   FBL3N  GL account line item display

The user enters the invoice number and if you need to do reconciliation for that below are some of the specific logic that you can build on your own using the database tables.

4.   F.01 Financial statement: Balance sheet etc

This gives you an overall picture of the different reporting  period from last and current year and on overall indicator of total revenue each year

5.   S_ALR_87013604 FI CO reconciliation report for group currency

Report for reconciliation for each company code and controlling area.

6.   S_ALR_87013614 Current period

Cost center group report for cumulative analysis related to each period.

7.   S_ALR_87013611  Planed/ Actual cost and variance.

One of the main report for cost center analysis for planned / Actual costs and highlights the variance

8.   S_ALR_87013625 Actual / Target / Variance

Similar to the  above report this one helps for  cost center analysis for Actual / Target and variance in values across different cost centers

9.KOB1 Cost

This report has a list of line items  posted on internal orders

KOb1 shows Actual cost for line items

KOB2 shows the commitment for line items

KOb3 shows the variance for each of the line items

10.                KE30 Customer profitability report

There are some templates provided by SAP for creating those reports for being costing based or account  based and is one of the

11. F.41  Vendor balance line item wise

If you have vendors which are not quite active this report is quite useful in identifying those vendors and probably taking action like deactivating them or  deciding to use them in vendor evaluation criteria.

12. F.42: Vendor balance in local currency

Useful when you have a lot of vendors who work from different countries and if they charge in their home currency. The report displays  amount  converted from all in your local currency as defined in the system

Other reports : 

s_alr_87013603 Reconciliation of Fi/CO reports in company code currency

S_ALR_87012401 – Payment Medium International – Load Data Medium Exchange File to Disk

S_P00_07000221 – EC Sales List in Data Medium Exchange Format

S_ALR_87012400 – EC Sales List

S_ALR_87012178 Customer open items by a balance of overdue items

s_alr_87012172 For Custom balance in local currency and It shows a total per company code and total across all company code

1.    Controlling

2.    S_ALR_87013611 Cost Centers: Actual/Plan/Variance

3.    S_ALR_87013612 Range: Cost Centers

4.    S_ALR_87013613 Range: Cost Elements

5.    S_ALR_87013614 Cost Centers: Current Period/Cumulative

6.    S_ALR_87013616 Cost Centers: Breakdown by Business Transaction

7.    S_ALR_87013617 Range: Activity Types

8.    S_ALR_87013618 Range: Statistical Key Figures

9.    S_ALR_87013619 Range: Assigned Orders/WBS Elements

10. S_ALR_87013620 Cost Centers: Actual/Plan/Commitments

11. S_ALR_87013621 Range: Actual/Plan/Commitments

12. S_ALR_87013623 Cost Centers: Quarterly Comparison

13. S_ALR_87013624 Cost Centers: Fiscal Year Comparison

14. S_ALR_87013625 Cost Centers: Actual/Target/Variance

15. S_ALR_87013626 Range: Cost Elements

16. KSBL Cost Centers: Planning Overview

17. S_ALR_87013630 Activity Types: Plan Receivers

18. KSBT Cost Centers: Activity Prices

19. KSB1 Cost Centers: Actual Line Items

20. KSB2 Cost Centers: Commitment Line Items

21. KSBP Cost Centers: Plan Line Items

22. KSB5 CO Documents: Actual Costs

23. KABP CO Plan Documents

24. KS13 Cost Centers: Master Data Report

25. KA23 Cost Elements: Master Data Report

26. KL13 Activity Types: Master Data Report

27. KK04 Statistical Key Figures: Master Data Report

28. S_ALR_87013631 Cost Centers: Rolling Year

29. S_ALR_87013632 Cost Centers: Average Costs

30. S_ALR_87013633 Cost Centers: Actual/Plan/Variance/Previous year

31. S_ALR_87013635 Area: Actual/Plan 2 Currencies

32. S_ALR_87013636 Cost Centers: Object Comparison

33. S_ALR_87013637 Area: Internal Business Volume

34. S_ALR_87013638 Cost Centers: Current/Cumulative/Fiscal Year

35. S_ALR_87013639 Cost Centers: Actual/Target from Summarization

36. S_ALR_87013640 Cost Centers: Period Breakdown Actual/Plan

37. S_ALR_87013641 Cost Centers: Period Breakdown Actual/Target

38. S_ALR_87013642 Cost Centers: Breakdown Resources

39. S_ALR_87013643 Range: Orders

40. S_ALR_87013645 Statistical Key Figures: Period Breakdown

41. S_ALR_87013646 Activity Types: Period Breakdown

42. S_ALR_87013648 Range: Actual/Budget/Commitments

43. S_ALR_87012993 Orders: Actual/Plan/Variance

44. S_ALR_87012994 Orders: Current Period/Cumulative

45. S_ALR_87012995 List: Orders

46. S_ALR_87012996 List: Orders by Cost Element

47. S_ALR_87012997 List: Cost Elements by Order

48. S_ALR_87012998 Orders: Breakdown by Partner

49. S_ALR_87012999 Orders: Actual/Plan/Commitments

50. S_ALR_87013000 List: Actual/Plan/Commitments

51. S_ALR_87013001 Orders: Actual Yearly Comparison

52. S_ALR_87013002 Orders: Actual quarterly comparison

53. S_ALR_87013003 Orders: Actual Period Comparison

54. KABL Order: Planning Overview

55. S_ALR_87013004 Order: Plan Yearly Comparison

56. S_ALR_87013005 Orders: Plan Quarterly Comparison

57. S_ALR_87013006 Orders: Plan Period Comparison

58. KOB1 Orders: Actual Line Items

59. KOB2 Orders: Commitment Line Items

60. KOBP Orders: Plan Line Items

61. KOB4 Orders: Budget Line Items

62. KSB5 CO Documents: Actual Costs

63. KABP CO Plan Documents

64. KO2B Display Budget Document

65. KOK5 Internal Orders

66. KOSRLIST_OR Settlement Rules

67. KA23 Cost Elements

68. KK04 Statistical Key Figures

69. S_ALR_87013010 Orders: Breakdown by Period

70. S_ALR_87013011 Orders: Actual/Plan/Price Variance

71. S_ALR_87013012 Orders: Actual/Plan/Consumption

72. S_ALR_87013013 Orders: Actual in Transaction/Object/Group Currencies

73. S_ALR_87013014 List: Cost Elements (True Postings)

74. S_ALR_87013015 List: Actual Debit/Credit

75. S_ALR_87013016 List: Plan Debit/Credit

76. S_ALR_87013017 List: Actual/Plan/Variance, Cumulative

77. S_ALR_87013018 List: Total Plan/Actual/Commitments

78. S_ALR_87013019 List: Budget/Actual/Commitments

79. KOC4 Cost Analysis

80. General Ledger

81. S_PL0_86000028 Fin. Statement: Actual/Actual Comparison

82. S_ALR_87012284 Financial Statements

83. S_PL0_86000029 Fin. Statement: Plan/Actual Comparison

84. S_ALR_87012271 Cash Flow (Direct Method)

85. S_ALR_87012272 Cash Flow (Indirect Method) Variant 1

86. S_ALR_87012273 Cash Flow (Indirect Method) Variant 2

87. FSIB Background Processing

88. S_ALR_87012277 G/L Account Balances

89. S_PL0_86000030 G/L Account Balances (New)

90. S_PL0_86000031 Transaction Figures: Account Balance

91. S_ALR_87012301 Totals and Balances

92. S_PL0_86000032 Structured Account Balances

93. S_ALR_87012282 G/L Line Items, List for Printing

94. S_ALR_87012332 G/L Account Statements

95. S_AC0_52000887 Profit Center Receivables

96. S_AC0_52000888 Profit Center Payables

97. S_ALR_87012287 Document Journal

98. S_ALR_87012289 Compact Document Journal

99. S_ALR_87012291 Line Item Journal

100.              S_ALR_87012293 Display of Changed Documents

101.              S_ALR_87012341 Invoice Numbers Allocated Twice

102.              S_ALR_87012342 Gaps in Document Number Assignment

103.              S_ALR_87012344 Posting Totals

104.              S_ALR_87012346 Recurring Entry Documents

105.              S_ALR_87012347 Line Items Extract

106.              S_ALR_87012326 Chart of Accounts

107.              S_ALR_87012328 G/L Account List

108.              S_ALR_87012330 Account Assignment Manual

109.              S_ALR_87012308 Display Changes to G/L Accounts

110.              S_ALR_87012333 G/L Accounts List

111.              Bank

112.              S_ALR_87012309 Cashbook

113.              S_ALR_87012348 Cashed Checks per Bank Account

114.              S_ALR_87012349 Outstanding Checks Analysis per G/L Account and V

115.              S_ALR_87012351 Payment Advice Overview

116.              S_ALR_87012350 G/L Account Payment Advice Notes

117.              S_ALR_87012353 Payment Advice Overview (Header and Item Data)

118.              S_ALR_87012352 G/L Account Payment Advice Notes

119.              S_ALR_87012355 Payment Advice Notes: Reorganization

120.              S_ALR_87012354 G/L Account Reorganization

121.              S_ALR_87012322 Bill of Exchange List

122.              S_ALR_87012321 SAP Minimal Variant

123.              S_ALR_87012324 Extended Bill of Exchange Information

124.              S_ALR_87012323 SAP Minimal Variant

125.              Accounts Payable

126.              S_ALR_87012077 Vendor Information System

127.              S_ALR_87012082 Vendor Balances in Local Currency

128.              S_ALR_87012093 Vendor Business

129.              S_ALR_87012079 Transaction Figures: Account Balance

130.              S_ALR_87012080 Transaction Figures: Special Sales

131.              S_ALR_87012081 Transaction Figures: Sales

132.              S_ALR_87012078 Due Date Analysis for Open Items

133.              S_ALR_87012103 List of Vendor Line Items

134.              S_ALR_87012083 List of Vendor Open Items for Printing

135.              S_ALR_87012084 Open Items u2013 Vendor Due Date Forecast

136.              S_ALR_87012085 Vendor Payment History with OI Sorted List

137.              S_ALR_87012104 List of Cleared Vendor Items for Printing

138.              S_ALR_87012105 List of Down Payments Open On Key Date u2013 Vendors

139.              S_ALR_87012086 Vendor List

140.              S_ALR_87012087 Address List

141.              S_ALR_87012089 Display Changes to Vendors

142.              S_ALR_87012090 Display/Confirm Critical Vendor Changes

143.              S_P99_41000099 Payment List

144.              S_P99_41000101 Check Register

145.              S_ALR_87012119 Cashed Checks

146.              S_P99_41000102 Number Ranges for Checks

147.              Accounts Receivable

148.              S_ALR_87012167 Accounts Receivable Information System

149.              S_ALR_87012172 Customer Balances in Local Currency

150.              S_ALR_87012186 Customer Sales

151.              S_ALR_87012169 Transaction Figures: Account Balance

152.              S_ALR_87012170 Transaction Figures: Special Sales

153.              S_ALR_87012171 Transaction Figures: Sales

154.              S_ALR_87012168 Due Date Analysis for Open Items

155.              S_ALR_87012197 List of Customer Line Items

156.              S_ALR_87012173 List of Customer Open Items for Printing

157.              S_ALR_87012174 List of Customer Open Items

158.              S_ALR_87012175 Open Items u2013 Customer Due Date Forecast

159.              S_ALR_87012176 Customer Evaluation with OI Sorted List

160.              S_ALR_87012177 Customer Payment History

161.              S_ALR_87012178 Customer Open Item Analysis by Balance of Overdue Items

162.              S_ALR_87012198 List of Cleared Customer Items for Printing

163.              S_ALR_87012199 List Of Down Payments Open On Key Date u2013 Customers

164.              S_ALR_87012179 Customer List

165.              S_ALR_87012180 Address List

166.              S_ALR_87012182 Display Changes to Customers

167.              S_ALR_87012183 Display/Confirm Critical Customer Changes

168.              S_ALR_87012195 Customer Master Data Comparison

169.              Fixed Assets

170.              AW01N Asset Explorer

171.              S_ALR_87011963 u2026 by Asset Number

172.              S_ALR_87011964 u2026 by Asset Class

173.              S_ALR_87011965 u2026 by Business Area

174.              S_ALR_87011966 u2026 by Cost Center

175.              S_ALR_87011967 u2026 by Plant

176.              S_ALR_87011968 u2026 by Location

177.              S_ALR_87011969 u2026 by Asset Super Number

178.              S_ALR_87011970 u2026 by Worklist

179.              S_ALR_87010125 Sample for address data for an asset

180.              S_ALR_87010127 Real Estate and Similar Rights

181.              S_ALR_87010129 Transportation Equipment

182.              S_ALR_87011978 Asset Balances for Group Assets

183.              S_ALR_87011979 u2026 by Cost Center

184.              S_ALR_87011980 u2026 by Location

185.              S_ALR_87011981 u2026 by Asset Class

186.              S_ALR_87011982 u2026 by Plant

187.              S_ALR_87010137 Bar Codes

188.              S_ALR_87010139 Leasing

189.              S_ALR_87010141 Liabilities from Leasing Agreements

190.              S_ALR_87011990 Asset History Sheet

191.              S_ALR_87011992 Liabilities from Leasing Agreements

192.              S_ALR_87011994 Asset Balances

193.              S_ALR_87012004 Total Depreciation

194.              S_ALR_87012006 Ordinary Depreciation

195.              S_ALR_87012007 Special Depreciation

196.              S_ALR_87012008 Unplanned Depreciation

197.              S_ALR_87012009 Transfer of Reserves

198.              S_ALR_87012011 Write-Ups

199.              S_ALR_87012013 Depreciation Comparison

200.              S_ALR_87012015 Manual Depreciation

201.              S_ALR_87012018 Depreciation and Interest

202.              S_ALR_87010173 Revaluation

203.              S_P99_41000192 Posted depreciation by asset and posting period

204.              S_ALR_87010175 Posted depreciation, related to cost centers

205.              S_ALR_87012936 Depreciation on Capitalized Assets (Depreciation Simulation)

206.              S_ALR_87012026 Depreciation Current Year

207.              S_ALR_87012028 Net Worth Valuation

208.              S_ALR_87012030 Insurance Values

209.              S_ALR_87012033 Gain for transfer of reserves

210.              S_ALR_87012035 Depreciation Current Year

211.              S_ALR_87012037 Changes to Asset Master Records

212.              S_ALR_87012039 Asset Transactions

213.              S_ALR_87012041 Asset Portfolio (Current Book Values)

214.              S_ALR_87012043 G/L Account Balances

215.              S_ALR_87012048 Asset transactions

216.              S_ALR_87012050 Asset Acquisitions

217.              S_ALR_87012052 Asset Retirements

218.              S_ALR_87012054 Intracompany Asset Transfers

219.              S_ALR_87012056 Directory of Unposted Assets

220.              S_ALR_87012058 List of Origins of Asset Debits

221.              S_ALR_87012060 List of Origins by Cost Elements

222.              S_ALR_87012075 Asset History