DFKKINVDOC_S

Transparent Table Application Table

Source Document for Invoicing/Reversal History

DFKKINVDOC_S is an SAP database table in S/4HANA. Source Document for Invoicing/Reversal History. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CRMS4_IU_P_CDHS view_entity from Convergent Invoice Source Document
I_CABillgDocInvcgDoc view_entity from BASIC Fakturierungsbeleg für Abrechnungsbeleg
I_CAInvcgDocSource view_entity from BASIC Fakturierungsbelegquellen

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY srcdoccat SRCDOCCAT_KK Source Doc.Cat.
KEY srcdocno SRCDOCNO_KK Source Doc. No.
KEY invdocno INVDOCNO_KK Invoic. Doc.
srcdoctype SRCDOCTYPE_KK Source Doc.Type
log_system LOGSYS Logical system
applk APPLK_KK ApplicationArea
invoiced INV_POSTED_KK Document Posted
simulated INV_SIMULATED_KK Doc. Simulated
preliminary INV_PRELIMINARY_KK Prelim.Invoice
reversaldoc INV_REVERSALDOC_KK Reversal Doc.
reverseddoc INV_REVERSEDDOC_KK Rev. Doc. For
crdate INVDOC_CRDAT_KK Invoiced On
crtime INVDOC_CRTIM_KK Invoiced At

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.

-- Source Document for Invoicing/Reversal History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVDOC_S (
    MANDT,        -- Client [MANDT]
    SRCDOCCAT,    -- Source Doc.Cat. [SRCDOCCAT_KK]
    SRCDOCNO,     -- Source Doc. No. [SRCDOCNO_KK]
    INVDOCNO,     -- Invoic. Doc. [INVDOCNO_KK]
    SRCDOCTYPE,   -- Source Doc.Type [SRCDOCTYPE_KK]
    LOG_SYSTEM,   -- Logical system [LOGSYS]
    APPLK,        -- ApplicationArea [APPLK_KK]
    INVOICED,     -- Document Posted [INV_POSTED_KK]
    SIMULATED,    -- Doc. Simulated [INV_SIMULATED_KK]
    PRELIMINARY,  -- Prelim.Invoice [INV_PRELIMINARY_KK]
    REVERSALDOC,  -- Reversal Doc. [INV_REVERSALDOC_KK]
    REVERSEDDOC,  -- Rev. Doc. For [INV_REVERSEDDOC_KK]
    CRDATE,       -- Invoiced On [INVDOC_CRDAT_KK]
    CRTIME,       -- Invoiced At [INVDOC_CRTIM_KK]
    PRIMARY KEY (MANDT, SRCDOCCAT, SRCDOCNO, INVDOCNO)
);