02-20-2018 9:32 PM
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.
02-20-2018 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
02-20-2018 10:47 PM
02-20-2018 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)
02-21-2018 12:04 PM
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....