Trial Balance Report

[Former Member]

Dear All,

There is no specific report to be customized for trial balance, so we want to develop a trial balance report. Want to know what are the tables that are used for generating a trial balance.

[Former Member · Accepted solution]

Hi,

I suggest you create another nonleading ledger with 366 posting periods, if this is a very critical requirement. But beware about server constraints with respect to space and processing speed. Is there a valid business reason to require a TB on any date? Given that there are lots of provisioning and other periodic entries that are not posted on a daily basis, what exact benefit will be achieved by obtaining this trial balance?

If the focus is only on a specific set of GL accounts, you could run S_ALR_87012332 or S_ALR_87012282 for this specific set in the background on a daily basis (at a time when system access is low). Or run F.01 on a daily basis and mail it to all concerned (of course this will not take care of backdated entries).

Rgds

Shivram.

[Former Member · Accepted solution]

Thanks to you all.

[Former Member · Accepted solution]

Hi,

you can use table BSIS for day wise Trial Balance.

Please check this.

[Former Member]

Hi,

A trial balance is simply a list of all GL balances. Use TCode F.01 (with a dummy FSV) to obtain this. If you want to have multiple columns with different periods, then you could create drilldown reports (TCode FSI1 and FSI4 if you are using classical GL or FGI1 and FGI4 if you are using new GL). The last option would be to write ABAP code which uses GLT0 or FAGLFLEXT depending on whether you are on classical GL or New GL.

Rgds

Shivram.

[Former Member]

Thanks for the quick response to you all. As per amit, the FAGLFLEXT would give the period wise balance but if i want to use on a particular day then what would you suggest. Is there any altrenative for this.

[Former Member]

Hi,

For trial balance you can refer to GLT0 or FAGLFLEXT depending on the version being used. This will give you period wise balances. If a trial balance is required for a day, it will be difficult as you might then have to sum up the values from BSEG table which is not advisable.

Hope this helps

Thanks and Regards,

Anit