T059Z
Withholding tax code (enhanced functions)
T059Z is an SAP database table in S/4HANA. Withholding tax code (enhanced functions). It contains 16 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_Extendedwhldgtaxcode | view | from | BASIC | Extended Withholding Tax Code |
| P_Extendedwhldgtaxcode | view_entity | from | BASIC |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | land1 | LAND1 | Country/Reg. | |||
| KEY | witht | WITHT | WTax Type | |||
| KEY | wt_withcd | WT_WITHCD | W/Tax Code | |||
| qscod | WT_OWTCD | Off. W/Tax Key | ||||
| qproz | QPROZ | Percentage Subject to Tax | ||||
| qsatz | WT_QSATZ | WTax Rate | ||||
| qsatr | WT_QSATR | Red. WTax Rate | ||||
| xqfor | XQFOR | WTax Formula | ||||
| regio | REGIO | Region | ||||
| fprcd | FPRCD | Prov. Tax Code | ||||
| qekar | QEKAR | Income Type | ||||
| wt_posin | WT_POSIN | Posting Indicator | ||||
| wt_ratez | WT_RATEZ | WTax Rate Num. | ||||
| wt_raten | WT_RATEN | WTax Rate Den. | ||||
| withcd2 | WITHCD2 | WTax Key |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Withholding tax code (enhanced functions)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T059Z (
MANDT, -- Client [MANDT]
LAND1, -- Country/Reg. [LAND1]
WITHT, -- WTax Type [WITHT]
WT_WITHCD, -- W/Tax Code [WT_WITHCD]
QSCOD, -- Off. W/Tax Key [WT_OWTCD]
QPROZ, -- Percentage Subject to Tax [QPROZ]
QSATZ, -- WTax Rate [WT_QSATZ]
QSATR, -- Red. WTax Rate [WT_QSATR]
XQFOR, -- WTax Formula [XQFOR]
REGIO, -- Region [REGIO]
FPRCD, -- Prov. Tax Code [FPRCD]
QEKAR, -- Income Type [QEKAR]
WT_POSIN, -- Posting Indicator [WT_POSIN]
WT_RATEZ, -- WTax Rate Num. [WT_RATEZ]
WT_RATEN, -- WTax Rate Den. [WT_RATEN]
WITHCD2, -- WTax Key [WITHCD2]
PRIMARY KEY (MANDT, LAND1, WITHT, WT_WITHCD)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA