06-02-2010 9:04 PM
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.
06-02-2010 9:24 PM
06-02-2010 9:24 PM
06-02-2010 9:36 PM
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.
06-02-2010 9:43 PM
>
> 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
06-02-2010 9:48 PM
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.
06-02-2010 10:03 PM
Well, once again, FS10N is for GL accounts not AP accounts (vendors). Or do you mean you want expense rather than revenue accounts?
Rob
06-02-2010 10:20 PM
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.
06-02-2010 10:48 PM
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
06-03-2010 3:56 PM
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?
06-03-2010 4:07 PM
06-03-2010 4:48 PM
06-03-2010 4:53 PM
06-02-2010 9:26 PM
FS10N uses table FAGLFLEXT which are the totals. The line items are found in table FAGLFLEXA.
06-02-2010 9:40 PM
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.
03-03-2011 2:11 PM
Table Name For
GL Ska1 skb1
Customer Kna1 Knb1
Vendor Lfb1 Lfa1
Asset :Anka Ankt
Main tables In Fi