SAP Table T007A

Tax Keys

T007A (Tax Keys) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T007A to other SAP tables.

T007A table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D T683 CHAR 6 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
PRUEF Indicator: Error Message for Invalid Tax Amount ? PRUEF_007 CHAR 1 0
X Yes
NULL No
MWART Tax Type MWART CHAR 1 0
A Output tax
V Input tax
XMSTU Single-Character Indicator CHAR1 CHAR 1 0
ZMWSK Target Tax Code (for Deferred Tax) DZMWSK T007A CHAR 2 0
EGRKZ EU Code / Code EGRKZ CHAR 1 0
NULL Non-EU-Relevant
1 Delivery of Goods Within the EU
2 Services Within the EU
3 Subcontracting Within the EU
4 Output Tax for Services within the EU
5 Reverse Charge EU: Service with Tax with Zero Balance
6 HU: Triangular Deal with Country Outside the EU
7 As for value '1', but tax balance zero
8 As for value '3', but tax balance zero
9 Acquisition Tax or General Tax with Zero Balance
A Reverse Charge with Tax with Zero Balance
M Spain: EU Goods Delivery - After Tax-Exempt Import
H EU Goods Delivery - After Tax-Exempt Import by Fiscal Agent
B Non-EU-Relevant, No Check on Input Tax Acct/Output Tax Acct
XSLTA Indicator: Tax code for sales taxes XSLTA_007A CHAR 1 0
X Yes
NULL No
PROCD SAP internal product code (external interface) PROCD_TTXP CHAR 10 0
TXIND Tax Category for US Taxes TXIND_007A CHAR 1 0
0 Sales Tax (Customer Use Tax if needed)
1 Consumer Use Tax
2 Service Tax
3 Lease Tax
TXREL 'Tax Relevant' Indicator (Only for External Tax System) TXREL_007A CHAR 1 0
NULL Is relevant to tax; external system decides
0 Is relevant to tax; external system decides
1 Is always relevant to tax; external system is not used
2 Is not relevant to tax; external system is not used
LSTML Country for Tax Return LAND1_STML T005 CHAR 3 0
J_1BUSAGE Tax Calculation: Material Usage J_1BTXMMU CHAR 1 0
1 Production/sales
2 Consumption
J_1BISS Tax Calculation: Service Without ICMS/IPI J_1BTXMMIS CHAR 1 0
X Yes
NULL No
J_1BTAXLW1 Tax law: ICMS J_1BTAXLW1 J_1BATL1 CHAR 3 0
J_1BTAXLW2 Tax law: IPI J_1BTAXLW2 J_1BATL2 CHAR 3 0
J_1BTXICEX ICMS Stored as "Exempt" Instead of "Other Basis" J_1BTXICEX CHAR 1 0
X Yes
NULL No
J_1BTXIPEX IPI Stored as "Exempt" Instead of "Other Basis" J_1BTXIPEX CHAR 1 0
X Yes
NULL No
TOLERANCE Tolerance Percentage Rate for Tax Calculation TAX_TOLERANCE DEC 3 1
ZMWSK_ESA Target Tax Code for Deferred EU Acquisition Tax, Output Tax DZMWEA T007A CHAR 2 0
ZMWSK_ESE Target Tax Code for Deferred EU Acquisition Tax, Input Tax DZMWEE T007A CHAR 2 0
NEWDEFTAX New Deferred Tax Code: Yes/No NEWDEFTAX CHAR 1 0
X Yes
NULL No
J_1BTAXLW4 COFINS Tax Law J_1BTAXLW4 J_1BATL4A CHAR 3 0
J_1BTAXLW5 PIS Tax Law J_1BTAXLW5 J_1BATL5 CHAR 3 0

T007A foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T007A J_1BTAXLW1 T007A MANDT J_1BATL1 Tax Law ICMS MANDT
T007A J_1BTAXLW1 T007A J_1BTAXLW1 J_1BATL1 Tax Law ICMS TAXLAW
T007A J_1BTAXLW2 T007A MANDT J_1BATL2 Tax Law IPI MANDT
T007A J_1BTAXLW2 T007A J_1BTAXLW2 J_1BATL2 Tax Law IPI TAXLAW
T007A J_1BTAXLW4 SYST MANDT J_1BATL4A Tax Laws COFINS MANDT
T007A J_1BTAXLW4 T007A J_1BTAXLW4 J_1BATL4A Tax Laws COFINS TAXLAW
T007A J_1BTAXLW5 SYST MANDT J_1BATL5 Tax Laws PIS MANDT
T007A J_1BTAXLW5 T007A J_1BTAXLW5 J_1BATL5 Tax Laws PIS TAXLAW
T007A KALSM 'TX' T683 Pricing procedures KAPPL
T007A KALSM T007A KALSM T683 Pricing procedures KALSM
T007A KALSM T007A MANDT T683 Pricing procedures MANDT
T007A KALSM 'A' T683 Pricing procedures KVEWE
T007A LSTML T007A MANDT T005 Countries MANDT
T007A LSTML T007A LSTML T005 Countries LAND1
T007A MANDT T007A MANDT T000 Clients MANDT
T007A ZMWSK SYST MANDT T007A Tax Keys MANDT
T007A ZMWSK * T007A Tax Keys KALSM
T007A ZMWSK T007A ZMWSK T007A Tax Keys MWSKZ
T007A ZMWSK_ESA T007A ZMWSK_ESA T007A Tax Keys MWSKZ
T007A ZMWSK_ESA SYST MANDT T007A Tax Keys MANDT
T007A ZMWSK_ESA * T007A Tax Keys KALSM
T007A ZMWSK_ESE SYST MANDT T007A Tax Keys MANDT
T007A ZMWSK_ESE * T007A Tax Keys KALSM
T007A ZMWSK_ESE T007A ZMWSK_ESE T007A Tax Keys MWSKZ