topic Re: Gl Transaction Table in Application Development and Automation Discussions

Gl Transaction Table

Former Member — Wed, 02 Jun 2010 20:04:25 GMT

Does anyone know the GL transaction table name? I am looking for GL Code that was hit, amount, currency, debit/credit, and any reference. My end goal is to see all transactions that make up AP in a given year. I am able to see a summary view by using transaction code FS10N, but need to see the detail. Any help is appreciated. Thank you very much.

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 20:24:32 GMT

Are you looking for AP or GL items. they're not the same.

Rob

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 20:26:15 GMT

FS10N uses table FAGLFLEXT which are the totals. The line items are found in table FAGLFLEXA.

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 20:36:12 GMT

I know that AP and GL are not the same items, but shouldn't every transaction hit the GL?

I tried using SE16 to find table FAGLFLEXA, but I receive a message,"No table entries found for specified key". I was able to find table GLT0, which had the totals, but I'm still looking for the line items. Any other suggestions? Thanks.

Re: Gl Transaction Table

brad_bohn — Wed, 02 Jun 2010 20:40:39 GMT


FS10N uses table FAGLFLEXT which are the totals. The line items are found in table FAGLFLEXA

Assuming you've implemented the New G/L functionality...that's not the case for non-New G/L company codes. There's plenty of us out here that haven't adopted it just because SAP came up with it ;-).

To the poster, just trace the transaction (drill into the summary) and you'll find the info you need but you'll be viewing the detail of a reconciliation account, not a sub-ledger (A/P) account.

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 20:43:27 GMT


> I know that AP and GL are not the same items, but shouldn't every transaction hit the GL?

No - there can be corrections (ie from one vendor to another for example).

There are lots of tables involved. You have to tell us what you are trying to do.

Rob

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 20:48:55 GMT

What I really want to do is find all line items that make up the total debit balance for 2009 under our AP account as shown under FS10N. My ultimate goal is to have amount, other gl code, cost center, text, vendor id, etc. I hope that I explained that well. Thank you again.

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 21:03:55 GMT

Well, once again, FS10N is for GL accounts not AP accounts (vendors). Or do you mean you want expense rather than revenue accounts?

Rob

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 21:20:02 GMT

Thank you for helping me on this...I'm very new to SAP and only have some dB experience in Great Plains, two different animals. Yes, I would like to see the expense accounts or other accounts hit. Our end goal is to see what our AP spend consisted of for 2009. I've seen tables such as BSAK, BSEG, BKPF, PAYR, and REGUP. My concern is making sure that what I am pulling is indeed accurate. Thanks again, it means a lot.

Re: Gl Transaction Table

Former Member — Wed, 02 Jun 2010 21:48:22 GMT

I'm still not 100% on your requirements, but I think this is what you're trying to do:

For fiscal year 2009 and the company code(s) you are interested in, go to tables BSIK (vendor open items) and BSAK (vendor cleared items) and get all the vendor items you are interested in. You will get document number, fiscal year and company code from here.

Then go to BSEG, using the document number, fiscal year and company code you just got and look for the GL items for each of the documents.

This will be a slow process depending on how much you have to read.

Rob

Re: Gl Transaction Table

Former Member — Thu, 03 Jun 2010 14:56:35 GMT

Thank you again Rob. However, I am not sure why I would need the vendor open items. I only want to see items that cleared or that were paid from AP. Do you know how I can check the figure once I join those tables?

Re: Gl Transaction Table

Former Member — Thu, 03 Jun 2010 15:07:28 GMT

If you only want cleared items, don't use BSIK at all.

Rob

Re: Gl Transaction Table

Former Member — Thu, 03 Jun 2010 15:48:04 GMT

OK Thank you. Any advice on how to reconcile the number?

Re: Gl Transaction Table

Former Member — Thu, 03 Jun 2010 15:53:14 GMT

Your business analyst should help with that.

Rob

Re: Gl Transaction Table

Former Member — Thu, 03 Mar 2011 14:11:07 GMT

Table Name For

GL Ska1 skb1

Customer Kna1 Knb1

Vendor Lfb1 Lfa1

Asset :Anka Ankt

Main tables In Fi