Table of balance

[Former Member]

Hi,

When do a balance report that include openning balance, movement,ending balance, however I don't know the table that store the balance of G/L account of one period by one period. The movement is stored in table: BSEG(BSAD\BSID\BSAS\BSIS\BSAK\BSIK). To G/L account balance, can expert tell me about this?

Thanks a lot!

[bpawanchand]

Hi

SKA1 G/L Account Master (Chart of Accounts)

SKAT G/L Account Master Record (Chart of Accounts- Description)

SKB1 G/L account master (company code)

Regards

pavan

[Former Member]

Thanks Pavan.

However, the table that I want to know is G/L account balance information. The table : SKAT.SKA1,SKB1 just is master data not include the balance information.

So, there still is a issue.

[Former Member]

Hi

For GL balances monthwise you can get from table GLT0 (G/L account master record transaction figures)

With Regards

Nikunj Shah

[Former Member]

Very thanks!

It's table that I want to get.

GLT0 : legal ledger summary. Exclude profit centre and function area.

GLPCT: profit centre ledger.Exclude function area.

GLFUNCT: COGS ledger . Exclude profit centre.

GLT1:Local direct posting ledger. Exclude profit centre.

Edited by: bill ma on Jul 16, 2008 8:18 AM

[Former Member]

Sorry about that, it still is a issue.

The table GLT0 is summarized lines for the master record transactions, which does not have periodical / monthly break-downs.The table that I want to get is should inculde periodical / monthly break-downs. Can expert told me the table name?

Thanks a lot!

[Former Member]

I think the earlier answer GLT0 is correct. It has both the opening balance and the monthly summary.

Rob

[Former Member]

Hi,

glt0 is a correct one. I have used the table for G/L Account Balance information.

Thanks,

Ravi kanth.