Tables for GL accounts and Profit centers
What is the database table for GL accounts and also for Profit centers? Thank you!
Prasanth Gopisetty replied
SKA1 G/L Account Master (Chart of Accounts) - You can get GL accounts as per chart of accounts.
SKAT G/L Account Master Record (Chart of Accounts- Description) - You can get GL accounts as per the COA description.
SKB1 G/L account master (company code) - You can get GL accounts as per company code.
You can view profit centres in CEPC table. If you give controlling area, you can get all the profit centres under that controlling area.
Whenever you update the profit center(PRCTR) in an accounting doc, you will find it in BSEG table.
Hope new GL is not activated in your version.I suspect you are using old version of SAP. Thats the reason why you are unable to view the FAGLFLEXT table.
Because FAGLFLEXT is the Totals Table for accounting entries and GLT0 is the older version of totals table(G/L account master record transaction figures).
Hope this helps..