WITH_ITEM

Transparent table · taxWithholding line itemsStill live in S/4HANA

The withholding-tax line-item table — one row per withholding type per FI line: the base, the withholding code, and the amount withheld from a vendor payment. This is the table behind the Withholding Tax report (extended withholding tax).

Primary key: BUKRS · BELNR · GJAHR · BUZEI · WITHT (company code · document · fiscal year · line · withholding type). One FI line can carry several withholding types, so the type is part of the key.

◆Key fields (WITH_ITEM)

Field	Key	In reports	Description
BUKRS	PK	●	Company code — the reporting entity.
BELNR	PK	●	Accounting document number.
GJAHR	PK	●	Fiscal year.
BUZEI	PK	●	The FI line the withholding sits on.
WITHT	PK	●	Withholding tax type — the category (contractor, professional, royalty).
WT_WITHCD		●	Withholding tax code — the specific code that carries the rate in config.
QSATZ		●	Withholding rate. Can be blank even when the code is configured (SAP KBA 1773154).
WT_QSSHB		●	Withholding base amount — what the tax is calculated on.
WT_QBSHB		●	Withholding tax amount — the amount withheld and remitted.
WT_QBUIHB		○	Withholding amount in document currency.

◆How WITH_ITEM relates to the document

WITH_ITEM holds the withholding; the vendor and the document dates sit on the lines and header it shares a key with.

Object	Holds	Joined on
BSEG	The vendor line — the supplier (LIFNR) the tax was withheld from	BUKRS · BELNR · GJAHR · BUZEI
BKPF	Document header — posting date, document type	BUKRS · BELNR · GJAHR
WITH_ITEM	One withholding line per type, on that FI line	BUKRS · BELNR · GJAHR · BUZEI · WITHT

A single vendor invoice can have more than one withholding type — e.g. income tax plus a surcharge — so WITH_ITEM can hold several rows for one FI line, one per type. The vendor comes from the BSEG line, not WITH_ITEM itself.

◆The rate gotcha (QSATZ)

The single most common trap reading WITH_ITEM: the rate field can be empty on the line even when the code is configured with a rate.

Where	Field	What it means
WITH_ITEM	QSATZ	The rate on the line — can be 0 even for a rated code (SAP KBA 1773154).
T059Z	QSATZ	The configured rate for the withholding code — the reliable source.
T059P	WT_WITHCD	The withholding type — gross vs net basis, accumulation rules.

Source the rate from config (T059Z), not the line. If QSATZ is 0 on WITH_ITEM but the code is rated, treat it as a flag — the withholding may not have posted, or the line predates the rate. The withheld amount (WT_QBSHB) is what reconciles to the G/L, regardless of the rate field.

◆S/4HANA status

WITH_ITEM is not replaced — it is a live transparent table under extended withholding tax, the model S/4HANA uses. Classic withholding (a single code per vendor) is gone; extended withholding (multiple types per line, the modern model) is what WITH_ITEM serves.

Withholding posts at invoice or at payment depending on the type. The withheld amount lands on a withholding G/L account and must reconcile there and to each vendor’s certificate / return — which is exactly what the Withholding Tax report checks.

◆Where this surfaces — how to read it

WITH_ITEM joined to BSEG for the vendor and BKPF for the dates — the full withholding picture per vendor
T059Z joined for the configured rate — the reliable rate, not the QSATZ on the line
LFBW — the vendor withholding master, to see which types should apply to a supplier

◆Reports that use it

Withholding Tax — withheld by type, code, and vendor, from this table
Vendor 1099 / withholding-certificate reporting — the per-vendor remittance summary
Any AP dashboard that breaks a vendor’s gross payment into net, tax, and withholding

How the data gets out: a SAP-compliant extract of WITH_ITEM joined to BSEG via SLT or Table / Table-CDC — never ODP-RFC (SAP Note 3255746). See the extraction pattern →

Need a withholding layer in your model?

We build WITH_ITEM as a conformed withholding fact — by type, code, and vendor, with the rate sourced from config and reconciled to the G/L — and you own the code.

Talk to us

Terms on this page

Withholding tax: Tax deducted at payment and remitted to the authority on the vendor's behalf.
Withholding type (WITHT): The category of withholding — contractor, professional services, royalties.
Withholding code (WT_WITHCD): The specific code under a type — carries the rate in config.
Withholding base (WT_QSSHB): The amount the withholding is calculated on.
QSATZ: The rate on the line — can be blank even for a rated code (KBA 1773154).
T059Z: The withholding-code config table — the reliable source of the rate.
Extended withholding tax: The modern model — multiple withholding types per line. What S/4HANA uses.
LFBW: The vendor withholding master — which types apply to a supplier.
BSEG: The accounting line items — the vendor line the withholding sits on.
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).