DFKKREP07

Transparent Table Application Table
52 Fields 1 CDS Views

Tax Report Data (Clearing Time)

DFKKREP07 is an SAP database table in S/4HANA. Tax Report Data (Clearing Time). It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CATaxReportingDocClearing view_entity from BASIC Tax Reporting Document Clearing

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel OPBEL_KK Document Number
KEY opupk OPUPK_KK Item
KEY gpart GPART_KK Bus. Partner
KEY vinfo VINFO_KK Assignment
KEY tzahl TZAHL_KK Counter
applk APPLK_KK ApplicationArea
bukrs BUKRS Company Code
bupla BUPLA Business place
hkont HKONT_KK G/L Account
mwskz MWSKZ Tax Code
strkz STRKZ_KK TxCde:Oth.Taxes
stprz STPRZ_KK Tax rate
xrefs XREFS_KK Ref. oth. taxes
sbash SBASH_KK Tax base in LC
sbasw SBASW_KK Tax Base Amount
sbeth SBETH_KK LC Tax
sbetw SBETW_KK Tax Amount
gebth GEBTH_KK Total amount
gebtw GEBTW_KK Total TC
augbo AUGBO_KK Cl.amt. OI crcy
augbh AUGBH_KK LC clearing amt
augbw AUGBW_KK TC Clearing Amt
hwaer HWAER_KK Currency
twaer TWAER Trans. Currency
tbdat TBDAT_KK Dt. trig. doc.
tldat TLDAT_KK TD doc. date
faedn FAEDN_KK Net Due Date
vmdat VMDAT_KK Plan. rep. date
sdata SDATA_KK Additional data
xblnr EXBEL_KK Offic. Doc. No.
ktosl KTOSL_KK Autom. Posting
kschl KSCHL_STRKZ_KK Tax Item Type
txjcd TXJCD Tax Jur.
txjco TXJCO_KK Orig.jurisdict.
aubel AUBEL_KK Trigger doc
xsatz XSATZ_KK Rec. triggered
refnr OPBEL_KK Document Number
xstor XSTOR_KK Reversed
augrd AUGRD_KK Clearing Reason
cpudt CPUDT Entered On
cputm CPUTM Entered at
exbel_betrh EXBEL_BETRH Total amount LC
exbel_betrw EXBEL_BETRW Total amount TC
ori_opbel ORI_OPBEL_KK Orig. Doc. No.
ori_opupk ORI_OPUPK_KK TransTxItmItemN
tra_opbel DFTAX_TRA_OPBEL_KK Transf.Document
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
taxc_factor TAXC_FACTOR_KK Tax Factor C/R
gsber GSBER Business Area
prgrp PRGRP_VK Product Group
rsart RSART_VX Risk 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.

-- Tax Report Data (Clearing Time)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKREP07 (
    MANDT,        -- Client [MANDT]
    OPBEL,        -- Document Number [OPBEL_KK]
    OPUPK,        -- Item [OPUPK_KK]
    GPART,        -- Bus. Partner [GPART_KK]
    VINFO,        -- Assignment [VINFO_KK]
    TZAHL,        -- Counter [TZAHL_KK]
    APPLK,        -- ApplicationArea [APPLK_KK]
    BUKRS,        -- Company Code [BUKRS]
    BUPLA,        -- Business place [BUPLA]
    HKONT,        -- G/L Account [HKONT_KK]
    MWSKZ,        -- Tax Code [MWSKZ]
    STRKZ,        -- TxCde:Oth.Taxes [STRKZ_KK]
    STPRZ,        -- Tax rate [STPRZ_KK]
    XREFS,        -- Ref. oth. taxes [XREFS_KK]
    SBASH,        -- Tax base in LC [SBASH_KK]
    SBASW,        -- Tax Base Amount [SBASW_KK]
    SBETH,        -- LC Tax [SBETH_KK]
    SBETW,        -- Tax Amount [SBETW_KK]
    GEBTH,        -- Total amount [GEBTH_KK]
    GEBTW,        -- Total TC [GEBTW_KK]
    AUGBO,        -- Cl.amt. OI crcy [AUGBO_KK]
    AUGBH,        -- LC clearing amt [AUGBH_KK]
    AUGBW,        -- TC Clearing Amt [AUGBW_KK]
    HWAER,        -- Currency [HWAER_KK]
    TWAER,        -- Trans. Currency [TWAER]
    TBDAT,        -- Dt. trig. doc. [TBDAT_KK]
    TLDAT,        -- TD doc. date [TLDAT_KK]
    FAEDN,        -- Net Due Date [FAEDN_KK]
    VMDAT,        -- Plan. rep. date [VMDAT_KK]
    SDATA,        -- Additional data [SDATA_KK]
    XBLNR,        -- Offic. Doc. No. [EXBEL_KK]
    KTOSL,        -- Autom. Posting [KTOSL_KK]
    KSCHL,        -- Tax Item Type [KSCHL_STRKZ_KK]
    TXJCD,        -- Tax Jur. [TXJCD]
    TXJCO,        -- Orig.jurisdict. [TXJCO_KK]
    AUBEL,        -- Trigger doc [AUBEL_KK]
    XSATZ,        -- Rec. triggered [XSATZ_KK]
    REFNR,        -- Document Number [OPBEL_KK]
    XSTOR,        -- Reversed [XSTOR_KK]
    AUGRD,        -- Clearing Reason [AUGRD_KK]
    CPUDT,        -- Entered On [CPUDT]
    CPUTM,        -- Entered at [CPUTM]
    EXBEL_BETRH,  -- Total amount LC [EXBEL_BETRH]
    EXBEL_BETRW,  -- Total amount TC [EXBEL_BETRW]
    ORI_OPBEL,    -- Orig. Doc. No. [ORI_OPBEL_KK]
    ORI_OPUPK,    -- TransTxItmItemN [ORI_OPUPK_KK]
    TRA_OPBEL,    -- Transf.Document [DFTAX_TRA_OPBEL_KK]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    TAXC_FACTOR,  -- Tax Factor C/R [TAXC_FACTOR_KK]
    GSBER,        -- Business Area [GSBER]
    PRGRP,        -- Product Group [PRGRP_VK]
    RSART,        -- Risk type [RSART_VX]
    PRIMARY KEY (MANDT, OPBEL, OPUPK, GPART, VINFO, TZAHL)
);

Learn More