GL Open Balance

[Former Member]

Hello Experts,

I am working on open GL balance conversion and I have to extract the balances of GL balance sheet accounts and our system is in SAP R/3 4.6c.

Could you please let me know what are the tables and the logic that I have to use to get the open GL balance?

Is there any possibility that I can extract the data as of a date rather than month end like balace as of May 22 rather than May 31st?

Any input is much appreciated.

Regards,

Harish R

[kishore_babu15]

Hi Haresh,

You can use GLT0 table for period selection only. better idea user use BSIS table for GL open Item balances.

In future you want to migrate the future version this program logic can't copy for new version. In ECC 6.0 GLT0 table changed to FAGLFLEXT table.

Regards,

Kishore K

[Former Member]

Hi,

If you need open balance, you can surely get it from the logic I gave you (i.e. from BSIS and BSAS table). System will give you balance only for the GL selected in the selection screen by the user. It will not give all line items. You will only get the line item of the selected G/L. No need to go to GLT0 table at all.

Could I clarify you now?

Regards

K Khatri

[Former Member]

Hi all

Sorry - I only saw this question now, and you hve hopefully found a solution already. If you haven't...

Surely the easiest way though is to call the FM called BAPI_GL_ACC_GETPERIODBALANCES.

This BAPI gives you the information for all periods, in a table, much like it appears in FS10N. The balance is one of the columns in the result table ACCOUNT_BALANCES.

Regards,

Casper

[Former Member]

Hi,

If you are doing it through query, then you will need to carry out ABAP coding alongwith the the functional process of query writing. SDF is the logical database, which can be used for your data extract.

What I would suggest is to go for ABAP development. If you are looking for open balances as on a particular key date, then you can extract the data of BSAS and BSIS table both which are falling on the key date (To be selected by user as we do in FBL3N report).

If I could not resolve your problem, please let me know for further clarification.

Thanks & Regards

K Khatri

[Former Member]

I am not looking at the line items and I need open balance. BSIS and BSAS has transactions at item level right? If I use them then I have to add all those line items to get the balance. But if I use GLT0 then I would get balance. The problem is what logic I have to use to get the balance from GLT0 table?

[Former Member]

Hi,

- you could write an extract program or build a query based on GLT0 table

- unfortunately, it goes by period and not a spefic date

- again it always shows the period as last period of your fiscal year variant (say 16 if you use standard K4 variant)

- way to get balance as of a period is to

a. extract/list the output of glto for a given company code/fiscal year

b. you would find amounts in 3 currencies - TC, LC and GC

c. and for each currency - you find BCF (c/f) and amounts for each period

d. you need to add up BCF and as many columns as you need (if you need for 9/2009, add BCF and next 9 columns for each currency

- would suggest a abap program.

Hope this clarifies.

Rgds.

[santosh_kavitkar]

Hi Harish,

You can use table table BSIS to get open GL Account balance as on date.

Regards,

Santosh

[Former Member]

Hi,

Do you want a report to see the opening balances of GL on a key date ?

Regards

K Khatri

[Former Member]

Thanks for the reply.

I am looking at writing a query to extract the balances of some 200 odd GL balance sheet accounts. We are on 4.6c and I guess I should use GLT0 to get the balance?

Regards,

Harish R