From which table in ECC the extractor 0FI_GL_20 extract CHARTACCTS ?

[Former Member]

Hi Gurus,

I have a couple of questions on 0fi_gl_20 extractor:

1) I want to know from which ECC table the extractor 0fi_gl_20 pulls the chart of accounts data.I searched the help on this extractor http://help.sap.com/saphelp_nw70/Helpdata/en/74/c047de8e5a49808f28295942dc3297/content.htm but the source table of CHARTACCTS field is not listed in the help.

2)Does this extractor pull all available chart of accounts from the ECC system?In our case , we are not able to extract all chart of accounts with this extractor.

Any help on these two questions will be greatly appreaciated.

Thank you,

Goutham Katarapu

[anindya_bose · Accepted solution]

Hello Goutham

1. I guess this Chart of Accounts ( COA) is being pulled from T001 table ( field KTOPL) . So you get COA for a particular company code.

2. Yes, this pull records for all the chart of accounts. I guess you are missing KTOP2 field which is country specific Chart of Accounts. You can find all the COA there.

Regards

Anindya

[Former Member]

Looking at the extract structure for 0FI_GL_20 it appears that KTOPL field is coming from a Special Ledger related table.

You might be able to get some idea if you take a look at the table T074. Not sure if this helps.

There are some prerequisites mentioned in the help.sap.com link that mentions that there is some restriction on general ledgers. Maybe that can give some hints too.

Good Luck.

MP.