Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

G/L Account tables in FI

Former Member
0 Kudos

Hi Experts,

I am solving a performance issue in a report which displays G/L account balances in balance sheet. The report retrieves data from SKA1,GLT0, BSIS, BSAS etc. When I check the report it does not have balances in 17 acoounts. While I am checking the data in tables I found 34000 G/L account documents (open) in these accounts in BSEG table but I dont find anything in BSIS also in BSAS.

All G/L account open items should be there in BSIS but there are some documents which r there in BSEG but not in BSIS. What should be the reason? Is there any other tables?

<REMOVED BY MODERATOR>

Thanks in Advance.

Edited by: Alvaro Tejada Galindo on Apr 7, 2008 12:14 PM

1 ACCEPTED SOLUTION

rahul2000
Contributor
0 Kudos

Hi Lakshmi...

Dont check for your open items of a G/L account in BSEG table...

Go to Tcode FBL3N and give u r G/L account and company code....and run it.

There you will get the open items,cleared items

How are you finding the accounting documents in BSEG table that are cleared??

Actually in BSEG table...for those accounting documents that are cleared,their corresponding AUGBL(Clearing document No) will be updated.

All G/L account open items should be there in BSIS but there are some documents which r there in BSEG but not in BSIS. What should be the reason? Is there any other tables?

Ans:- In BSIS table i guess you will find open items as u have rightly said....but what is happening here is that u would be looking for those documents that may have been cleared....for eg...

Doc no 1 has 5 line items.....out of which 3 are cleared...and 2 are open....so i guess u r not able to find it in BSIS table..

I am not currently on my SAP system but i guess that still you should be able to find these 2 open items in BSIS table.

Its a bit of contradiction in the above two statments....Do get back to me...

<REMOVED BY MODERATOR>

Edited by: Rahul Bhat on Apr 5, 2008 8:33 AM

Edited by: Alvaro Tejada Galindo on Apr 7, 2008 12:14 PM

17 REPLIES 17

Former Member
0 Kudos

First run standard report FS10N to check balance amount in any of these G/Ls . Once its sure the balance is there then check the repiort. Logic should be

1. get G/L acc master record transaction figures from GLT0

2. then get open item details from BSIS & cleared from BSAS

anya

rahul2000
Contributor
0 Kudos

Hi Lakshmi...

Dont check for your open items of a G/L account in BSEG table...

Go to Tcode FBL3N and give u r G/L account and company code....and run it.

There you will get the open items,cleared items

How are you finding the accounting documents in BSEG table that are cleared??

Actually in BSEG table...for those accounting documents that are cleared,their corresponding AUGBL(Clearing document No) will be updated.

All G/L account open items should be there in BSIS but there are some documents which r there in BSEG but not in BSIS. What should be the reason? Is there any other tables?

Ans:- In BSIS table i guess you will find open items as u have rightly said....but what is happening here is that u would be looking for those documents that may have been cleared....for eg...

Doc no 1 has 5 line items.....out of which 3 are cleared...and 2 are open....so i guess u r not able to find it in BSIS table..

I am not currently on my SAP system but i guess that still you should be able to find these 2 open items in BSIS table.

Its a bit of contradiction in the above two statments....Do get back to me...

<REMOVED BY MODERATOR>

Edited by: Rahul Bhat on Apr 5, 2008 8:33 AM

Edited by: Alvaro Tejada Galindo on Apr 7, 2008 12:14 PM

Former Member
0 Kudos

Hi Rahul/anya,

Thank you for ur responses. I am looking in Clearing document (AUGBL) it is not updated for all the documents . Anya, actually I have done the same thing in the report. But when I am checking the output with the old report(the one has performence issue) some G./L account balances are missing in my report. All these account docs in these G/L accounts are open items in BSEG table but I didnot found any data in BSIS and BSAS thats the reason I am not getting any data from these G/L accounts in my report. I think it must be data integrity problem. What is your idea on this..?

old report is retrieving data from BSEG.

Thanks once again.

Best regards,

Former Member
0 Kudos

One more thing all these missing G/L accounts in my report output are Tax related. Any idea about tax related tables in FI

0 Kudos

Hi lakshmi,

I was able to fing open items in BSIS and cleared in BSAS.

I am not understanding as to how this problem might have been occuring in your system.

Well tax code i guess u will have to get from BSEG table itself..(MWSKZ).

Edited by: Rahul Bhat on Apr 7, 2008 6:40 AM

Former Member
0 Kudos

Thanks Rahul.

0 Kudos

hi Lakshmi,

Have you been able to find out a solution to this?

Plz do let me know as to how you have overcome it.

Also what is your report about?

Is it to display open items for which service tax is applicable?

Edited by: Rahul Bhat on Apr 8, 2008 6:42 AM

Former Member
0 Kudos

Hi Rahul,

Report displays the G/l account balances in balance sheetFI. Still my problem is not solved. I have to get the data from BSEG only. I didnot find any alternative way.Well but I found some Function modules which gives the G/L account balance in Local currency. which might be useful to you guys.

BAPI_GL_ACC_GETBALANCE

BAPI_GL_ACC_GETCURRENTBALANCE

BAPI_GL_ACC_GETPERIODBALANCES

also G_ACCOUNT_BALANCE_ACC_GET.

all these function modules getting only local currency data but I need document currency too so these are not useful to me..

But my report output is matching with FBL3N. FBL3N is not showing the missing G/L accounts. All the accounting docs in these GL accounts BUZID is T. Do you know what does that mean??

Are you working on the same kind of thing?I can help you if you need anything. Please let me know if you have any idea?

Best regards,

Former Member
0 Kudos

My suggestion would be to first run FS10N (as noted above) for the GL Accounts in question, and then drilldown into the line item level for a specified month to confirm that SAP itself can retrieve the necessary data correctly (this will eliminate the possibility of corruption in your system if the numbers match). If all looks good, you can use ST05 (SQL Trace) to determine how SAP is retrieving the the lines items - from ST05 you can also drill into the ABAP code that is generating the select statements, which means you'll be able to set "soft" breakpoints and run the process again so you can step through the process flow.

As for "BUZID", the help for the field gives some useful information - "T" is for Tax, "G" is assigned delivery costs etc. As for which index table to find them in, typically they would start life in BSIS and move to BSAS once (if!) cleared... I tried a random sample on one system and all showed up in one or the other field.

Jonathan

0 Kudos

Hi Lakshmi,

No I am not working on something like this....I was working on a service tax report and it was related to FBL3N.

I will try to find out more about BUZID eq T and revert back.

Former Member
0 Kudos

Hi Jonathan,

Thank you so much for your reply. I have already analysed FS10N transaction. First I thought it is usefull for me. SAP is bringing data using LDB_PROCESS Function module. But the problem is we can get only local cureency from there but I want document currency also in my report.

Best Regards,

laxmi.

Former Member
0 Kudos

Thanks Rahul, Let me know if you have any info..

Best Regards,

Lakshmi.

Former Member
0 Kudos

Did you look at the database tables that ST05 is reporting? - I don't have an SAP system in front of me but the LDB_PROCESS would appear to be the logical database driver, so you want to see which underlying tables are delivering the data - ST05 will show you this if you run it across the relevant transactions & reports.

Jonathan

Former Member
0 Kudos

I think this will help u:

Former Member
0 Kudos

Thank you so much, Thanks a million urjose. Can you please tell me where I need to set the flag. PLz reply as soon as possible.

Former Member
0 Kudos

With this program you get an internal table with the following fields:

WAERS | RTCUR | FLAG_TCUR | GSBER | DATA

Example:

MXN| USD| | | Standard Table[17x7(126)]

USD| USD| X | | Standard Table[17x7(126)]

MXN| MXN| | | Standard Table[17x7(126)]

MXN| MXN| X | | Standard Table[17x7(126)]

If you want to get the Amount as FS10N in USD you go to row 2

If you want to get the Amount as FS10N in MXN you go to row 4

If you want to get the Total Amount of all Currencies in Local Currency you need to compute the data in rows 2 and 4.

The data is inside the field DATA, it is an internal table that contain the data as you see it in FS10N.

I hope to be clear =S

Former Member
0 Kudos

Thanks urjose. But for G/L accounts which local currency indicator is set (skb1-Xsalh = X) everything it is getting in local currency only. I think it is not possible to get it. Anyhow thanks once again.