DFKKTAXEX

Transparent Table Application Table
14 Fields 1 CDS Views

Table of FI-CA Tax Exemptions

DFKKTAXEX is an SAP database table in S/4HANA. Table of FI-CA Tax Exemptions. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ContractAccountTaxExemption view_entity from BASIC Contract Account Tax Exemption

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vkont VKONT_KK Contract Acct
KEY mwskz MWSKZ Tax Code
KEY kschl KSCHL_KK Condition Type
KEY exdfr J_1AEXDF Exempted from
exdto J_1AEXDT Exempted until
exnum EXNUM_KK Exempt.Lic.No.
exrat EXRAT_KK Exempt Amt Rate
laufd LAUFD_KK Date ID
laufi LAUFI_KK Run ID
exempt_lic FICA_EXEMPT_LIC TaxExemp. Lic. Numb.
exempt_amt FICA_EXEMPT_AMT Tax-Exempt Limit
exempt_amt_curr FICA_EXEMPT_AMT_CURR Tax Exempt Amt Curr
exempt_issdat FICA_EXEMPT_ISSDAT Tax Exp Issue Date

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.

-- Table of FI-CA Tax Exemptions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKTAXEX (
    MANDT,            -- Client [MANDT]
    VKONT,            -- Contract Acct [VKONT_KK]
    MWSKZ,            -- Tax Code [MWSKZ]
    KSCHL,            -- Condition Type [KSCHL_KK]
    EXDFR,            -- Exempted from [J_1AEXDF]
    EXDTO,            -- Exempted until [J_1AEXDT]
    EXNUM,            -- Exempt.Lic.No. [EXNUM_KK]
    EXRAT,            -- Exempt Amt Rate [EXRAT_KK]
    LAUFD,            -- Date ID [LAUFD_KK]
    LAUFI,            -- Run ID [LAUFI_KK]
    EXEMPT_LIC,       -- TaxExemp. Lic. Numb. [FICA_EXEMPT_LIC]
    EXEMPT_AMT,       -- Tax-Exempt Limit [FICA_EXEMPT_AMT]
    EXEMPT_AMT_CURR,  -- Tax Exempt Amt Curr [FICA_EXEMPT_AMT_CURR]
    EXEMPT_ISSDAT,    -- Tax Exp Issue Date [FICA_EXEMPT_ISSDAT]
    PRIMARY KEY (MANDT, VKONT, MWSKZ, KSCHL, EXDFR)
);

Learn More