Skip to Content

Totals of gl account per year and document type

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 20 at 10:37 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20 at 11:01 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded

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