Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Totals of gl account per year and document type

Former Member
0 Kudos


I want to display the totals gl account (HKONT) per year and document type (BKPF -BLART).I made report selecting data from BSEG and BKPF but I cannot run it for whole year (there are million records) only for specific gl account. Can I use FAGLFLTEXT and BKPF for this report? Do you know if there is field for totals of gl account (HKONT) in FAGLFLEXT?

thank you in advance.


Active Contributor
0 Kudos

There may be some standard reports that you can use

I am not an FI expert but I found this on which could be used


also refer to a blog I wrote sometime back for the std available FI reports

0 Kudos

Thank you for your answer.

0 Kudos

Check following report which provides totals based on GL account

Two SAP Standard Reports for GL A/c balances that fulfills our regular and usual reporting requirements:

TCode: S_ALR_87012277 – GL Account Balances

TCode: S_ALR_87012301 – Totals and BalancesTcode: S_PL0_86000030 - G/L Account Balances (New)

I have also same requirement, but i have not find any report, but i was find one report, it is near to match our requirement try, other wise by using this report develop new report.

S_ALR_87012311 - GL Account Balances and line items(Poland)

0 Kudos

Thank you for your answer.

I saw the mentioned TCODE but it is not exactly this that I want. I run one report but the problem is that there are million records. This means problem in performance and export to excel....