Totals of gl account per year and document type

[Former Member]

Hello,

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.

[Former Member]

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

S_ALR_87012311

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

https://blogs.sap.com/2017/08/11/sap-fi-reports/

[Former Member]

Thank you for your answer.

[pavankumar_hukkeri]

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)

[Former Member]

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