T007A table in SAP ERP or S/4HANA stores Tax Keys data. There are total 27 fields in T007A table. The Tax Keys table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of T007A table. It is in Financial Accounting General Services ‘Basis’ (FBASCORE) ABAP package and is part of the Financial Accounting (FI) module.
SAP T007A Table Fields
Following is the list of fields that are available in SAP T007A table. The primary key fields of Tax Keys table in SAP are MANDT (Client), KALSM (Procedure (Pricing, Output Control, Acct. Det., Costing,…)), MWSKZ (Tax on sales/purchases code).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,…) | KALSM_D | T683 | CHAR(6) |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR(2) | |
| PRUEF | Indicator: Error Message for Invalid Tax Amount ? | PRUEF_007 | CHAR(1) | |
| MWART | Tax Type | MWART | CHAR(1) | |
| XMSTU | Single-Character Flag | CHAR1 | CHAR(1) | |
| ZMWSK | Target Tax Code (for Deferred Tax) | DZMWSK | T007A | CHAR(2) |
| EGRKZ | EU Code/Code | EGRKZ | CHAR(1) | |
| XSLTA | Indicator: Tax Code for Sales Taxes | XSLTA_007A | CHAR(1) | |
| PROCD | SAP Internal Product Code (External Interface) | PROCD_TTXP | CHAR(10) | |
| TXIND | Tax Category for US Taxes | TXIND_007A | CHAR(1) | |
| TXREL | ‘Tax Relevant’ Indicator (Only for External Tax System) | TXREL_007A | CHAR(1) | |
| LSTML | Country for Tax Return | LAND1_STML | T005 | CHAR(3) |
| J_1BUSAGE | Tax Calculation: Material Usage | J_1BTXMMU | CHAR(1) | |
| J_1BISS | Tax Calculation: Service Without ICMS/IPI | J_1BTXMMIS | CHAR(1) | |
| J_1BTAXLW1 | Tax law: ICMS | J_1BTAXLW1 | J_1BATL1 | CHAR(3) |
| J_1BTAXLW2 | Tax law: IPI | J_1BTAXLW2 | J_1BATL2 | CHAR(3) |
| J_1BTXICEX | ICMS Stored as “Exempt” Instead of “Other Basis” | J_1BTXICEX | CHAR(1) | |
| J_1BTXIPEX | IPI Stored as “Exempt” Instead of “Other Basis” | J_1BTXIPEX | CHAR(1) | |
| TOLERANCE | Tolerance Percentage Rate for Tax Calculation | TAX_TOLERANCE | DEC(3) | |
| ZMWSK_ESA | Target Tax Code for Deferred EU Acquisition Tax, Output Tax | DZMWEA | T007A | CHAR(2) |
| ZMWSK_ESE | Target Tax Code for Deferred EU Acquisition Tax, Input Tax | DZMWEE | T007A | CHAR(2) |
| NEWDEFTAX | New Deferred Tax Code: Yes/No | NEWDEFTAX | CHAR(1) | |
| J_1BTAXLW4 | COFINS Tax Law | J_1BTAXLW4 | J_1BATL4A | CHAR(3) |
| J_1BTAXLW5 | PIS Tax Law | J_1BTAXLW5 | J_1BATL5 | CHAR(3) |
| XINACT | Set Tax Code to “Inactive” – No Further Use | XINACT | CHAR(1) | |
| MOSSC | MOSS Tax Reporting Country for Electronic Service | MOSSC | * | CHAR(3) |
