DFKKKO

Transparent Table Application Table
57 Fields 2 CDS Views

Header Data in Open Item Accounting Document

DFKKKO is an SAP database table in S/4HANA. Header Data in Open Item Accounting Document. It contains 57 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CADocumentHeader view_entity from EXTENSION Belegkopf Erweiterung
I_CADocument view_entity from BASIC Contract Accounting Document

Fields (57)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel OPBEL_KK Document Number
fikey FIKEY_KK Reconcil. Key
applk APPLK_KK ApplicationArea
blart BLART_KK Document Type
herkf HERKF_KK Document Origin
ernam ERNAM Created By
cpudt CPUDT Entered On
cputm CPUTM Entered at
waers BLWAE_KK Currency
bldat BLDAT Document Date
budat BUDAT_KK Posting Date
wwert WWERT_D Translatn Date
xblnr XBLNR_KK Reference
rlgrd RLGRD_KK Return Reason
abgrd BUGRD_KK Posting Reason
xeibh XEIBH_KK Single Document
xbwer XBWER_KK Valuation doc.
awtyp AWTYP Ref. procedure
awkey AWKEY Reference Key
stbel STBEL_KK Rev. Doc. For
stmet STMET_INT_KK Reversal Method
bltyp BLTYP_KK Document Class
aginf AGINF_KK Clearing Info
stbuk STBUK_KK Tax comp. code
storb STORB_KK Revers.document
appdx APPDX_KK Doc supps
awsys AWSYS Logical System
versn VERSN_KK Version
c4eye C4EYE_KK Check Reason
c4eyp C4EYP_KK Process
tatyp TATYP_KK Transact.type
hbbla HBBLA_KK Tfr Doc. Type
xcsha XCSHA_KK Cash Flow
utloc UTLOC_UT_KK Storage Location
xtxch XTXCH_KK New Tax Code
vatdate VATDATE_KK Tax Report Date
fulfilldate VATDATE2_KK Tax Settlement Date
wnper WNPER_KK Special Period
xsing XSING_KK Indiv. Posting
keypp KEYPP_KK Subarea
_dataaging DATA_TEMPERATURE Data Aging
xdaag XDAAG_KK Data Aging
trsla TRSLA_KK Subledger App
locok LOCOK_KK LC Amount Correct
bttype FINS_BTTYPE Bus. Trans. Category
cbttype FINS_CUSTBTTYPE Bus. Trans. Type
closingstep FINS_CLOSINGSTEP Closing Step
chdate AEDAT Changed On
chtime AETIM_KK Time
cadoctype CADOCTYPE_KK Ref. Doc. Type
glo_ref1_hd FKK_GLO_REF1_HD Reference
glo_dat1_hd FKK_GLO_DAT1_HD Date
gsfnr GSFNR_VK Bus. Trans. No.
belnr BELNR_VK Document Number
rbart RBART_VK Legal Rel. Type
rbznr RBZNR_VK Legal Rel. No.

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.

-- Header Data in Open Item Accounting Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKKO (
    MANDT,        -- Client [MANDT]
    OPBEL,        -- Document Number [OPBEL_KK]
    FIKEY,        -- Reconcil. Key [FIKEY_KK]
    APPLK,        -- ApplicationArea [APPLK_KK]
    BLART,        -- Document Type [BLART_KK]
    HERKF,        -- Document Origin [HERKF_KK]
    ERNAM,        -- Created By [ERNAM]
    CPUDT,        -- Entered On [CPUDT]
    CPUTM,        -- Entered at [CPUTM]
    WAERS,        -- Currency [BLWAE_KK]
    BLDAT,        -- Document Date [BLDAT]
    BUDAT,        -- Posting Date [BUDAT_KK]
    WWERT,        -- Translatn Date [WWERT_D]
    XBLNR,        -- Reference [XBLNR_KK]
    RLGRD,        -- Return Reason [RLGRD_KK]
    ABGRD,        -- Posting Reason [BUGRD_KK]
    XEIBH,        -- Single Document [XEIBH_KK]
    XBWER,        -- Valuation doc. [XBWER_KK]
    AWTYP,        -- Ref. procedure [AWTYP]
    AWKEY,        -- Reference Key [AWKEY]
    STBEL,        -- Rev. Doc. For [STBEL_KK]
    STMET,        -- Reversal Method [STMET_INT_KK]
    BLTYP,        -- Document Class [BLTYP_KK]
    AGINF,        -- Clearing Info [AGINF_KK]
    STBUK,        -- Tax comp. code [STBUK_KK]
    STORB,        -- Revers.document [STORB_KK]
    APPDX,        -- Doc supps [APPDX_KK]
    AWSYS,        -- Logical System [AWSYS]
    VERSN,        -- Version [VERSN_KK]
    C4EYE,        -- Check Reason [C4EYE_KK]
    C4EYP,        -- Process [C4EYP_KK]
    TATYP,        -- Transact.type [TATYP_KK]
    HBBLA,        -- Tfr Doc. Type [HBBLA_KK]
    XCSHA,        -- Cash Flow [XCSHA_KK]
    UTLOC,        -- Storage Location [UTLOC_UT_KK]
    XTXCH,        -- New Tax Code [XTXCH_KK]
    VATDATE,      -- Tax Report Date [VATDATE_KK]
    FULFILLDATE,  -- Tax Settlement Date [VATDATE2_KK]
    WNPER,        -- Special Period [WNPER_KK]
    XSING,        -- Indiv. Posting [XSING_KK]
    KEYPP,        -- Subarea [KEYPP_KK]
    _DATAAGING,   -- Data Aging [DATA_TEMPERATURE]
    XDAAG,        -- Data Aging [XDAAG_KK]
    TRSLA,        -- Subledger App [TRSLA_KK]
    LOCOK,        -- LC Amount Correct [LOCOK_KK]
    BTTYPE,       -- Bus. Trans. Category [FINS_BTTYPE]
    CBTTYPE,      -- Bus. Trans. Type [FINS_CUSTBTTYPE]
    CLOSINGSTEP,  -- Closing Step [FINS_CLOSINGSTEP]
    CHDATE,       -- Changed On [AEDAT]
    CHTIME,       -- Time [AETIM_KK]
    CADOCTYPE,    -- Ref. Doc. Type [CADOCTYPE_KK]
    GLO_REF1_HD,  -- Reference [FKK_GLO_REF1_HD]
    GLO_DAT1_HD,  -- Date [FKK_GLO_DAT1_HD]
    GSFNR,        -- Bus. Trans. No. [GSFNR_VK]
    BELNR,        -- Document Number [BELNR_VK]
    RBART,        -- Legal Rel. Type [RBART_VK]
    RBZNR,        -- Legal Rel. No. [RBZNR_VK]
    PRIMARY KEY (MANDT, OPBEL)
);

Learn More