DFKKREP06

Transparent Table Application Table
49 Fields 1 CDS Views

Tax Report Data (Invoicing Time or Triggered)

DFKKREP06 is an SAP database table in S/4HANA. Tax Report Data (Invoicing Time or Triggered). It contains 49 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CATaxReportingDocPosting view_entity from BASIC Tax Reporting Document Posting

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel OPBEL_KK Document Number
KEY opupk LFD_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
sbash SBASH_KK Tax base in LC
sbasw SBASW_KK Tax Base Amount
sbeth SBETH_KK LC Tax
sbetw SBETW_KK Tax Amount
hwaer HWAER_KK Currency
twaer TWAER Trans. Currency
ubdat UBDAT_KK Orig. doc. date
uldat ULDAT_KK Orig. 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
xnabe XNABE_KK Read document
nurel NUREL_KK Item number
refnr OPBEL_KK Document Number
xstor XSTOR_KK Reversed
cpudt CPUDT Entered On
cputm CPUTM Entered at
xteil XTEIL_KK PartReset
gebth GEBTH_KK Total amount
gebtw GEBTW_KK Total TC
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
dp_opupk DP_OPUPK_KK ItemNoDownPayt
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 (Invoicing Time or Triggered)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKREP06 (
    MANDT,        -- Client [MANDT]
    OPBEL,        -- Document Number [OPBEL_KK]
    OPUPK,        -- Item [LFD_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]
    SBASH,        -- Tax base in LC [SBASH_KK]
    SBASW,        -- Tax Base Amount [SBASW_KK]
    SBETH,        -- LC Tax [SBETH_KK]
    SBETW,        -- Tax Amount [SBETW_KK]
    HWAER,        -- Currency [HWAER_KK]
    TWAER,        -- Trans. Currency [TWAER]
    UBDAT,        -- Orig. doc. date [UBDAT_KK]
    ULDAT,        -- Orig. doc. date [ULDAT_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]
    XNABE,        -- Read document [XNABE_KK]
    NUREL,        -- Item number [NUREL_KK]
    REFNR,        -- Document Number [OPBEL_KK]
    XSTOR,        -- Reversed [XSTOR_KK]
    CPUDT,        -- Entered On [CPUDT]
    CPUTM,        -- Entered at [CPUTM]
    XTEIL,        -- PartReset [XTEIL_KK]
    GEBTH,        -- Total amount [GEBTH_KK]
    GEBTW,        -- Total TC [GEBTW_KK]
    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]
    DP_OPUPK,     -- ItemNoDownPayt [DP_OPUPK_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