CUST_WTH_TAX

Transparent Table Application Table
27 Fields 1 CDS Views

Draft table for entity I_CUSTOMERWITHHOLDINGTAXTP

CUST_WTH_TAX is an SAP database table in S/4HANA. Draft table for entity I_CUSTOMERWITHHOLDINGTAXTP. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CustomerWithHoldingTaxDraft view_entity from BASIC Customer With Holding Tax - Draft

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartner bu_partner Busn. Partner
KEY companycode bukrs Company Code
KEY withholdingtaxtype witht WTax Type
KEY customer kunnr Customer
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
withholdingtaxtypeforedit witht WTax Type
companycodeforedit bukrs Company Code
businesspartnerforedit bu_partner Busn. Partner
countrycode land1 Country/Reg.
withholdingtaxcode wt_withcd W/Tax Code
withholdingtaxagent wt_wtagt WTax Agent
obligationdatebegin wt_agtdf W/Tax Obligated Frm
obligationdateend wt_agtdt Oblig.to W/Tax Until
withholdingtaxnumber wt_wtstcd W/tax number
withholdingtaxcertificate2 wt_exnr Exemption Number
withholdingtaxexmptpercent wt_exrt Exemption Rate
exemptiondatebegin wt_exdf Exempt From
exemptiondateend wt_exdt Exempt To
exemptionreason wt_wtexrs Exempt. Reason
bphasactiveentity sdraft_is_active Is active
customercompanyauthzngroup brgru Authorization
authorizationgroup bu_augrp Authorization Group
isbusinesspurposecompleted bu_xpcpt Purpose Completed
buspartcustomerdraftuuid sdraft_uuid Draft Document ID
businesspartnerdraftuuid sdraft_uuid Draft Document ID

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.

-- Draft table for entity I_CUSTOMERWITHHOLDINGTAXTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUST_WTH_TAX (
    MANDT,                       -- Client [mandt]
    BUSINESSPARTNER,             -- Busn. Partner [bu_partner]
    COMPANYCODE,                 -- Company Code [bukrs]
    WITHHOLDINGTAXTYPE,          -- WTax Type [witht]
    CUSTOMER,                    -- Customer [kunnr]
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    WITHHOLDINGTAXTYPEFOREDIT,   -- WTax Type [witht]
    COMPANYCODEFOREDIT,          -- Company Code [bukrs]
    BUSINESSPARTNERFOREDIT,      -- Busn. Partner [bu_partner]
    COUNTRYCODE,                 -- Country/Reg. [land1]
    WITHHOLDINGTAXCODE,          -- W/Tax Code [wt_withcd]
    WITHHOLDINGTAXAGENT,         -- WTax Agent [wt_wtagt]
    OBLIGATIONDATEBEGIN,         -- W/Tax Obligated Frm [wt_agtdf]
    OBLIGATIONDATEEND,           -- Oblig.to W/Tax Until [wt_agtdt]
    WITHHOLDINGTAXNUMBER,        -- W/tax number [wt_wtstcd]
    WITHHOLDINGTAXCERTIFICATE2,  -- Exemption Number [wt_exnr]
    WITHHOLDINGTAXEXMPTPERCENT,  -- Exemption Rate [wt_exrt]
    EXEMPTIONDATEBEGIN,          -- Exempt From [wt_exdf]
    EXEMPTIONDATEEND,            -- Exempt To [wt_exdt]
    EXEMPTIONREASON,             -- Exempt. Reason [wt_wtexrs]
    BPHASACTIVEENTITY,           -- Is active [sdraft_is_active]
    CUSTOMERCOMPANYAUTHZNGROUP,  -- Authorization [brgru]
    AUTHORIZATIONGROUP,          -- Authorization Group [bu_augrp]
    ISBUSINESSPURPOSECOMPLETED,  -- Purpose Completed [bu_xpcpt]
    BUSPARTCUSTOMERDRAFTUUID,    -- Draft Document ID [sdraft_uuid]
    BUSINESSPARTNERDRAFTUUID,    -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, COMPANYCODE, WITHHOLDINGTAXTYPE, CUSTOMER, DRAFTUUID)
);

Learn More