Tables for GL accounts and Profit centers

[Former Member]

Good day!

What is the database table for GL accounts and also for Profit centers? Thank you!

[former_member197292 · Accepted solution]

Hi,

Try table FAGLFLEXT.

[Former Member · Accepted solution]

Hi Bijay! FAGLFLEXT does not exist in SE16 nor in SE11.

[Former Member · Accepted solution]

FAGLFLEXT is available only from ECC 5.0 and higher,

For master data use

G/L :

SKAS G/L Account Master (Chart of Accounts )

SKB1 G/L Account Master (Company Code)

PC:

CEPC Profit Center Master Data Table

Regards

Sach!n

[PRASANTH_GOP9 · Accepted solution]

Hi,

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..

Regards,

Praisty

[Former Member · Accepted solution]

Thanks, Praisty!

I have used SKAT and CEPC.