KNBW

Transparent Table Application Table
15 Fields 2 CDS Views

Customer master record (withholding tax types) X

KNBW is an SAP database table in S/4HANA. Customer master record (withholding tax types) X. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BusinessPartnerCustWhdgTax view from BASIC Customer Withholding tax core view
I_CustomerWithTax view from BASIC Customer WithHolding Tax

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY bukrs BUKRS Company Code
KEY witht WITHT WTax Type
wt_withcd WT_WITHCD W/Tax Code
wt_agent WT_WTAGT WTax Agent
wt_agtdf WT_AGTDF W/Tax Obligated Frm
wt_agtdt WT_AGTDT Oblig.to W/Tax Until
wt_wtstcd WT_WTSTCD W/tax number
wt_exnr WT_EXNR Exemption Number
wt_exrt WT_EXRT Exemption Rate
wt_exdf WT_EXDF Exempt From
wt_exdt WT_EXDT Exempt To
wt_wtexrs WT_WTEXRS Exempt. Reason
qsrec WT_QSREC Recipient Type

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.

-- Customer master record (withholding tax types) X
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNBW (
    MANDT,      -- Client [MANDT]
    KUNNR,      -- Customer [KUNNR]
    BUKRS,      -- Company Code [BUKRS]
    WITHT,      -- WTax Type [WITHT]
    WT_WITHCD,  -- W/Tax Code [WT_WITHCD]
    WT_AGENT,   -- WTax Agent [WT_WTAGT]
    WT_AGTDF,   -- W/Tax Obligated Frm [WT_AGTDF]
    WT_AGTDT,   -- Oblig.to W/Tax Until [WT_AGTDT]
    WT_WTSTCD,  -- W/tax number [WT_WTSTCD]
    WT_EXNR,    -- Exemption Number [WT_EXNR]
    WT_EXRT,    -- Exemption Rate [WT_EXRT]
    WT_EXDF,    -- Exempt From [WT_EXDF]
    WT_EXDT,    -- Exempt To [WT_EXDT]
    WT_WTEXRS,  -- Exempt. Reason [WT_WTEXRS]
    QSREC,      -- Recipient Type [WT_QSREC]
    PRIMARY KEY (MANDT, KUNNR, BUKRS, WITHT)
);

Learn More