Determining GL Account Balances from tables

[former_member1016972]

I would greatly appreciate assistance with what what ECC tables can produce a report with the following fields without going through the front end:

- Company Code

- GL Account #

- GL Account Name

- Accounting Period

- GL Acct End Balance (for the period)

Thanks so much!

[Gustavo_Vazquez]

Hi Eric,

BAPI BAPI_GL_ACC_GETPERIODBALANCES will provide balances for 1 account.

Tables, as Kenneth mentioned.

Kind Regards

[ankurch]

Hi Eric,

I think you should use standard transaction code "FBL3N" it will covered all your mentioned requirement!

Thanks,

[kenneth_advento]

Hi,

Use tables SKA1, SKB1 and SKAT for the GL master data, then use FAGLFLEXT for the GL account balances.

Hope this can help.