T007A

Customizing table · taxTax code configStill live in S/4HANA

The tax-code Customizing table, it registers each tax code per tax procedure and its type, input or output. The percentage rate itself is not here, it lives in condition records, maintained through transaction FTXP.

Primary key: KALSM · MWSKZ (tax procedure · tax code). The same two-character code (A1, V1, …) can exist in several procedures, so the procedure is part of the key.

◆Key fields (T007A)

Field	Key	Used	Description
KALSM	PK	●	Tax calculation procedure, the country procedure the code belongs to (e.g. TAXUS, TAXDE).
MWSKZ	PK	●	Tax code, the two-character code (A1, V1, A0) stamped on documents.
MWART		●	Tax type, V input tax, A output tax (also additional and reverse-charge types).
ZMWSK		○	Target tax code, for deferred tax, the code a line transfers to when it becomes due.
LSTML		○	Country / reporting attributes attached to the code.
, rate,		○	Not in T007A. The percentage sits in condition records (A003 / KONP), maintained via FTXP.

◆How the rate is set

T007A registers that a code exists and its type. The name and the rate live in two other places, this split is why you can’t read a rate straight off T007A.

Object	Holds	Joined on
T007A	The tax code exists, per procedure, and its type (input / output)	KALSM · MWSKZ
T007S	The tax code name / description (texts)	KALSM · MWSKZ
A003 / KONP	The condition records, the actual percentage rate, by code	MWSKZ (via condition key)

The rate is maintained through transaction FTXP, which writes condition records, not T007A. So a tax code can be active in T007A while its rate changes over time in the condition records, with each rate valid for a date range.

◆Tax type (input vs output)

The tax type (MWART) on the code decides which side of the return a line lands on, and which G/L tax account it posts to.

MWART	Type	Meaning
A	Output tax	Tax charged on sales, a liability, payable to the authority.
V	Input tax	Tax paid on purchases, deductible, reclaimed from the authority.

When a document posts with a tax code, the type and rate from config drive the amount, and a summarized line is written to BSET. That is the link between this config table and the transactional tax data.

◆S/4HANA status

T007A is unchanged in S/4HANA, a Customizing table, maintained through transaction FTXP like always. Tax codes and their rates are still defined this way; what changed elsewhere is how the tax data posts (the Universal Journal) and how statutory returns file (Advanced Compliance Reporting).

Because it is Customizing, T007A is small and slow-moving. In an analytics model it is a lookup, the code, its type, and (joined to the condition records) its rate, that you attach to the transactional tax lines in BSET.

◆Where this surfaces, how to read it

The tax code defined here is stamped on a document, drives the tax calculation, and writes a summarized line to BSET
From BSET, the code rolls up onto the VAT return (RFUMSV00) by code and direction
In an analytics model, T007A + T007S + the condition records become the dim_tax_code lookup, code, name, type, rate

◆Reports that use it

Tax Register / VAT Return, the codes defined here drive the output vs input split
Tax Reconciliation, the code-to-G/L-account mapping behind the variance check
Any tax dashboard that labels or filters by tax code, rate, or type

How the data gets out: T007A is a Customizing table, extract it as a lookup via SLT or Table / Table-CDC, joined to the transactional tax lines, never ODP-RFC (SAP Note 3255746). See the extraction pattern →

Need the tax-code config in your model?

We build T007A (plus texts and condition records) as the conformed tax-code dimension behind your VAT layer, code, type, and rate, and you own the code.

Talk to us

Terms on this page

Tax code (MWSKZ): The two-character code stamped on a line, sets the rate, type, and accounts.
Tax procedure (KALSM): The country-specific tax calculation procedure a code belongs to (TAXUS, TAXDE).
Tax type (MWART): Whether a code is input tax (V) or output tax (A).
Output tax: Tax charged on sales, a liability payable to the authority.
Input tax: Tax paid on purchases, deductible, reclaimed from the authority.
FTXP: The transaction that maintains tax codes and their rates.
Condition record: Where the actual percentage rate lives (A003 / KONP), by code and date.
Target tax code (ZMWSK): For deferred tax, the code a line transfers to when it becomes due.
BSET: The tax data document segment, the transactional tax lines these codes drive.
CDS view: Core Data Services, an SAP-supplied, upgrade-safe view onto the data.
ODP-RFC: An older extraction route SAP now bans for non-SAP tools (Note 3255746).