1. Home
  2. Resources
  3. SAP Tables
  4. REEXC_TAX_CODE_X - Tax Code and Additional Fields (T007A/T007S)

SAP Table REEXC_TAX_CODE_X

Tax Code and Additional Fields (T007A/T007S)

REEXC_TAX_CODE_X (Tax Code and Additional Fields (T007A/T007S)) 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 REEXC_TAX_CODE_X to other SAP tables.

REEXC_TAX_CODE_X 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
SPRAS Language Key SPRAS LANG 1 0
TEXT1 Name for value-added tax TEXT1_007S CHAR 50 0

REEXC_TAX_CODE_X foreign key relationships

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