Skip to Content
0

Totals of gl account per year and document type

Feb 20 at 09:32 PM

60

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vinita Kasliwal Feb 20 at 10:37 PM
0

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/

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your answer.

0
Pavankumar Hukkeri Feb 20 at 11:01 PM
0

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)

Show 1 Share
10 |10000 characters needed characters left 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....

0