Gl Transaction Table

[Former Member]

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.

[Former Member]

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

Rob

[Former Member]

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.

[Former Member]

>

> 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

[Former Member]

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.

[Former Member]

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

Rob

[Former Member]

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.

[Former Member]

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

[Former Member]

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?

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

Your business analyst should help with that.

Rob

[Former Member]

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

[brad_bohn]

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.

[former_member231065]

Table Name For

GL Ska1 skb1

Customer Kna1 Knb1

Vendor Lfb1 Lfa1

Asset :Anka Ankt

Main tables In Fi