How to create structured account balances report for 16 periods?

[former_member569532]

Hi Experts ,

I have a requirement to dispaly structured account balances report for 16 periods for current and previous year.Kindly anyone advise

how to create this report.From which tables I need get the data,selection screen is same as RFSBWA00(Structured account balances report).

Thanks & Regards,

Anusha.

[vinod_vemuru2]

Hi,

Do you have any issue in using standard program RFSBWA00? Also, check if F.01 helps.

Thanks,

Vinod.

[former_member569532]

Hi Vinod,

Thank you for your reply.

Standard program is displaying the total of amounts for all periods,but my requirement is to display  amounts for individual periods.

Rgds,

Anusha.B

[Marssel700]

Anu,

Go to F.01 and select Balance sheet type "2" in Special evaluations tab. Than you are able to select single period. You also can check F.54 and F.08.

Best Regards

[former_member569532]

Hi Marssel,

Thank you for your reply.

Currently I am using F.54 tcode ,but it is displaying the totals for all selected periods.

But my requirement is to display in the below format.

GL Description  apr13 may13 jun13 july13 aug13 sep13 oct13 nov13 dec13 jan14 feb14 mar14  total13 apr12 may12 jun12 july12 aug12 sep12 oct12 nov12 dec12 jan13 feb13 total.

Kindly advise is there any standard report for this requirement.

Thanks,

Anusha.