GL a/c bal Query

[Former Member]

I am working on a query to retrieve GL balances for the month the query is run.

This should include the company code, GL account, GL text, year, period, GL balance for the corresponding period and currency. The should be capable of getting upto date balances of the month selected. Even if run on the specific day of a month should provide with the total balances from the beginning of the month until that day. Only one month should be displayed at a time.

My Question is how to get the balances for each month What tables should I use etc,

for example

abcd 12000 bank account 2007 03 12125.00 USD

Any detailed solution is highly appreciated.

Thanks

krishna

[former_member188826]

GLT0 table has its period column always showing 16. You may access BSIS for open items and BSAS for cleared items to reach daywise transaction, where you can subtotal.You may need Developers help in bringing both these tables data together, if you want in one report.

[Former Member]

This is exactly the problem I am facing as it always pulls up the 16th month. So what are my options to get the GL balances in a query. Do you think BSIS and BSAS totals would provide me with the GL balance on an account.

Please clarify

Thank you

krishna

[former_member188826]

If there were a table that would contain all the records from BSIS and BSAS, that would certainly address your need. Check with the developers.

[Former Member]

Krishna,

Is your questioned answered, if so please mark thread as answered.

Have you any further questions on the topic?

[Former Member]

You can find out the balance of an account per month/period using T Code FS10N.

Hope that helps...

Thanks,

Nandita

[Former Member]

its for an external databse extract and the standard reports would not be sufficient as I need to data exactly in the format described.

[Former Member]

It all depends on the version of SAP you are using.

Classic SAP, GLT0

New GL FAGLFLEXT

Please award points if this is useful