DFKKTAXEX_DRAFT

Transparent Table Application Table
20 Fields 1 CDS Views

Draft table for entity R_CONTRACCTTAXEXEMPTIONTP

DFKKTAXEX_DRAFT is an SAP database table in S/4HANA. Draft table for entity R_CONTRACCTTAXEXEMPTIONTP. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ContrAcctTaxExemptionDraft view_entity from BASIC Contract Account Tax Exemption - Draft

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY contractaccount vkont_kk Contract Acct
KEY taxcode mwskz Tax Code
KEY caconditiontype kschl_kk Condition Type
KEY custtaxgroupexemptionstartdate j_1aexdf Exempted from
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
taxcodeforedit mwskz Tax Code
caconditiontypeforedit kschl_kk Condition Type
custtxgrpexmpstrtdtfoed j_1aexdf Exempted from
custtaxgroupexemptionenddate j_1aexdt Exempted until
cataxexemptionlicense exnum_kk Exempt.Lic.No.
cataxexemptionrate exrat_kk Exempt Amt Rate
camassrundate laufd_kk Date ID
camassrunid laufi_kk Run ID
cataxexemptionlicenseextended fica_exempt_lic TaxExemp. Lic. Numb.
cataxexemptionlicenseamount fica_exempt_amt Tax-Exempt Limit
cataxexemptionlicensecurrency fica_exempt_amt_curr Tax Exempt Amt Curr
cataxexemptionlicenseissuedate fica_exempt_issdat Tax Exp Issue Date
it_taxcalculationprocedure kalsm_d Procedure

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 R_CONTRACCTTAXEXEMPTIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKTAXEX_DRAFT (
    MANDT,                           -- Client [mandt]
    CONTRACTACCOUNT,                 -- Contract Acct [vkont_kk]
    TAXCODE,                         -- Tax Code [mwskz]
    CACONDITIONTYPE,                 -- Condition Type [kschl_kk]
    CUSTTAXGROUPEXEMPTIONSTARTDATE,  -- Exempted from [j_1aexdf]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    TAXCODEFOREDIT,                  -- Tax Code [mwskz]
    CACONDITIONTYPEFOREDIT,          -- Condition Type [kschl_kk]
    CUSTTXGRPEXMPSTRTDTFOED,         -- Exempted from [j_1aexdf]
    CUSTTAXGROUPEXEMPTIONENDDATE,    -- Exempted until [j_1aexdt]
    CATAXEXEMPTIONLICENSE,           -- Exempt.Lic.No. [exnum_kk]
    CATAXEXEMPTIONRATE,              -- Exempt Amt Rate [exrat_kk]
    CAMASSRUNDATE,                   -- Date ID [laufd_kk]
    CAMASSRUNID,                     -- Run ID [laufi_kk]
    CATAXEXEMPTIONLICENSEEXTENDED,   -- TaxExemp. Lic. Numb. [fica_exempt_lic]
    CATAXEXEMPTIONLICENSEAMOUNT,     -- Tax-Exempt Limit [fica_exempt_amt]
    CATAXEXEMPTIONLICENSECURRENCY,   -- Tax Exempt Amt Curr [fica_exempt_amt_curr]
    CATAXEXEMPTIONLICENSEISSUEDATE,  -- Tax Exp Issue Date [fica_exempt_issdat]
    IT_TAXCALCULATIONPROCEDURE,      -- Procedure [kalsm_d]
    PRIMARY KEY (MANDT, CONTRACTACCOUNT, TAXCODE, CACONDITIONTYPE, CUSTTAXGROUPEXEMPTIONSTARTDATE, DRAFTUUID)
);

Learn More