Standard report in SAP that displays GL account balances for multiple years

[nimisha_tambi1]

Is there a way to configure or use a standard report that shows GL Balances by multiple fiscal years.  In FAGLB03, F.08 and S_ALR_87012277 you can only select one fiscal year.

Also, in S_PL0_86000030 & S_PL0_86000032 you can compare only 2 fiscal years.

Please suggest a report where you can view Balances for multiple years.

Regards,

Nimisha

[Former Member · Accepted solution]

Hi Nimisha,

You have below options:-

1) Execute above reports fiscal year wise and export it to excel. Merge data of all excels in a single sheet and analyze accordingly.

2) Create Z report with reference to standard reports and ask ABAPer to give option of multiple fiscal year (From-To).

3) Take excel dump from SAP tables like BSEG, FAGLFLEXA etc.

Thanks and Regards,

Anurag

[former_member198032]

Hi,

in this thread you can find a step by step on how to create it in report painter:

Hope this was helpful for you.

Regards,

Cristiano

[former_member182098]

Please create your own report painter report, which is much easy and flexible.

Posted by would be handy for you.

Instead of months you select years.

[nimisha_tambi1]

I will have to try the steps that is mentioned in the link. I appreciate your response. I will update if I am able to follow all of the steps mentioned.

[nimisha_tambi1]

I will appreciate if I could get more responses. Thanks

[Former Member]

Hi, use drill down report, tcode FGI0, you can use existing or create new one

[Former Member]

Hi,

Try to use report painter functionalty. You can easily copy the existing one and change according to your requirements. Most of the balance & line item reports on G/L accounts, customers or vendors are based on the report painter.

Regards,

Barhan