DFKKREP07

Transparent Table Application Table
49 Fields 1 CDS Views

Daten Steuerbericht (Ausgleichszeitpunkt)

DFKKREP07 is an SAP database table in S/4HANA. Daten Steuerbericht (Ausgleichszeitpunkt). It contains 49 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 (49)

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

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.

-- Daten Steuerbericht (Ausgleichszeitpunkt)
-- 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]
    PRIMARY KEY (MANDT, OPBEL, OPUPK, GPART, VINFO, TZAHL)
);

Learn More