Help on gathering GL info from BSEG

[Former Member]

Hey SAP FI gurus!

I would like to ask you for help. I am performing an IT audit on a client that runs SAP R/3 ECC 6.0 and I have to perform a data analysis on the G/L.

Usually, in this situation, I ask for the FBL3N and S_AL0_96000497 report but my client has not been able to generate the full G/L report from the FBL3N. After a lot of discussion, someone in my team end up extracting the BSEG table.

My question is: I know that I have more than G/L entries on BSEG table, so I need to clean the data, remaining only G/L entries. How can I do that? I already tried by selecting the posting key for 40 and 50 values on BSCHL field, but it did no good.

Any ideas?

Regards,

Leonardo Olivo

[Former Member · Accepted solution]

Thank you everyone for the responses.

I´ll try to make myself clearer.

First of all, I am not using Excel. I am using a software called IDEA. It is pretty much like ACL, so number of records is not a concern here.

My problem is: I have the BSEG table, which has not only G/L items, but items from all over FI module (BSIS, BSAS, BSIK, BSAK and so on...). I need only the G/L items so I can verify that every journal entry performed in the G/L during the period is in the balance sheet.

My question is: Is there any way to select items in the BSEG table that are related to G/L (and would be in the BSIS and BSAS table)? I could use the FBL3N report for this, but I do not have this option in this case.

And again, thank you for your time.

Kind regards,

Leonardo Olivo

[Former Member · Accepted solution]

Hi Leonardo,

Help me understand your question as i do not understand when you say "  I have the BSEG table, which has not only G/L items, but items from all over FI module (BSIS, BSAS, BSIK, BSAK and so on...). I need only the G/L items ".

Do you mean that you do not want any AP/ AR Document line items in your BSEG?  If yes than how are you going to match the Trial balance for the period?  Or you already have the AR/AP data.  Whatever the case is, If you want only GL line items in BSEG (excluding AP/AR )than use field KOART and remove line items with values K & D & you will be left with values S & K which are GL & Assets.

Thanks,

Srutha

[ajaycwa1981 · Accepted solution]

Hi

We have a custom program in our client to extract this info for audit purposes. Direct download from se16 dies not work and earlier we had to do in parts I.e for few GLs in each lot and also restricted the period.

This program downloads the file in Sap AL11 directory.

May be you execute Fbl reports once you have selected all GLs from Skb1 table. Execute fbl in background and covert the spool to .txt

Ajay M

[Former Member]

Thank you all for the help.

I extract the K and S records and was able to figure out what was going wrong.

Regards,

Leonardo Olivo

[former_member222241]

Hi,

You can also take extract from table FAGLFLEXA as BSEG may give you dump.

Regards,

Tejas

[former_member188028]

hi,

Restrict KOART = S and try

[Former Member]

Hi Leonardo

I believe you are looking for Account type field for filtering the records.

Remember doing so, you are excluding the records (GLs) hit for other account types. Do check for other account types if you really want to exclude, before implementing filters based on S for Account type

Hope it helps

Regards

Mustafa

[Former Member]

     Since BSEG is a cluster table and fetching data from this table will take more time, it is advisable to use FAGLFLEXA table.

[Former Member]

Hi Leonardo,

Instead of using BSEG, I would suggest you to extract the data from BSIS & BSAS tables and combine both the files to get the period specific data.

Thanks,

Srutha

[Former Member]

Srutha,

Thanks for the tip.

I would use the BSIS and BSAS tables for that - it would be the best way - but all I have is the BSEG table.

I am trying to avoid to ask the client back for more data files because they take a long time to provide me an answer and my deadline is in a week. I want to give the BSEG a try - even if it is not the best option.

Regards,

Leonardo Olivo

[Former Member]

Hi Olivo,

I do not understand your requirement clearly, can you please eloberate further to get a clear feedback from everyone.

if you want to see all GL accounts go to SE17 and enter SKA1 to see list of GL accounts.

Or' if you want extract document numbers by Posting key just dump this file into excel and delet unwanted fields and provide the file to user.

Regards,

Sree

[subhadeep_das]

Hello,

Once you pull out the data, you can export the entire data in excel. There you can do all the clean up activity as per your requirement.

Also i suggest you to run FS00 and got to settings and select Hierarchy Display, this will help you identify all the account groupings.

best regds

Subha

[Former Member]

excel will only help you up to about 1M records and bseg is not an easy table to run queries against as it has another table rfblg behind it whose data is not readable directly. did they mention hana in your audit discussions? the fields i would go after are: BUKRS BELNR GJAHR BUZEI SHKZG VBUND KOSTL ANLN1 SGTXT DMBTR WRBTR HKONT KUNNR LIFNR MENGE PRCTR KSTAR TXJCD KSTRG PSWSL