Tax Tables

[Former Member]

Hi,

I need to prepare a list of all the Tax codes, its description, which G/L account it post to, for what country code and company code.

I am know sure which all tables i need to combine to get all this information under one spreadsheet. Can somebody please help me here.

Thanks

[Former Member]

Hi Shelina,

Check table - T007S for tax code names etc

SKB1 - G/L Acct Master (Company code)

SKA1 - G/L Acct. Master (Chart of Accounts)

SKAT - G/L Acct. Master Record (Chart of Accounts - Description)

Other way is Go to Tcode: FTXP. There you will get the tax codes , just input one tax code and country, then check the field by pressing F1, there you can find out the table and field. After going to the transaction, then press on accounts there you can find the G/L to which this tax code postings will happen.

Hope this helps.

Thanks,

Viswanath