DFKKINVDOC_REV

Transparent Table Application Table

Reversal Request for Invoicing Document

DFKKINVDOC_REV is an SAP database table in S/4HANA. Reversal Request for Invoicing Document. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAInvcgDocReversalRequest view_entity from BASIC Stornoauftrag für Fakt.belege

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY invdocno INVDOCNO_KK Invoic. Doc.
KEY revtask REVTASK_INV_KK Reversal Task
status REVTRIG_STATUS_KK Reversal Status
revreason REVREASON_KK Reversal Reason
stodt STODT_KK Reversal date
inv_type INV_TYPE_KK Invoicing Type
inv_process INV_PROCESS_KK Invoicing Proc.
inv_category INV_CATEGORY_KK Invoicing Cat.
gpart GPART_CI_KK Bus. Partner
gpart_sel GPART_SEL_KK Bus.Part.Sel.
vkont VKONT_CI_KK Contract Acct
vkont_sel VKONT_SEL_KK CtrAcct for Sel
mdcat MDCAT_CI_KK MasterData Type
keypp KEYPP_KK Subarea
invdoc_crdate INVDOC_CRDAT_KK Invoiced On
invdoc_crtime INVDOC_CRTIM_KK Invoiced At
invpercat INVPERCAT_KK Period Category
invperiod INVPERIOD_KK Invoicing Per.
faedn FAEDN_KK Net Due Date
total_curr BLWAE_KK Currency
total_amt BETRW_KK Amount
archived INVDOC_ARCHIVED_KK Doc. Archived
crname REVTRIG_CRNAM_KK Created By
crdate REVTRIG_CRDAT_KK Created On
crtime REVTRIG_CRTIM_KK Created At
loedt LOEDT_KK Deletion date

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.

-- Reversal Request for Invoicing Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKINVDOC_REV (
    MANDT,          -- Client [MANDT]
    INVDOCNO,       -- Invoic. Doc. [INVDOCNO_KK]
    REVTASK,        -- Reversal Task [REVTASK_INV_KK]
    STATUS,         -- Reversal Status [REVTRIG_STATUS_KK]
    REVREASON,      -- Reversal Reason [REVREASON_KK]
    STODT,          -- Reversal date [STODT_KK]
    INV_TYPE,       -- Invoicing Type [INV_TYPE_KK]
    INV_PROCESS,    -- Invoicing Proc. [INV_PROCESS_KK]
    INV_CATEGORY,   -- Invoicing Cat. [INV_CATEGORY_KK]
    GPART,          -- Bus. Partner [GPART_CI_KK]
    GPART_SEL,      -- Bus.Part.Sel. [GPART_SEL_KK]
    VKONT,          -- Contract Acct [VKONT_CI_KK]
    VKONT_SEL,      -- CtrAcct for Sel [VKONT_SEL_KK]
    MDCAT,          -- MasterData Type [MDCAT_CI_KK]
    KEYPP,          -- Subarea [KEYPP_KK]
    INVDOC_CRDATE,  -- Invoiced On [INVDOC_CRDAT_KK]
    INVDOC_CRTIME,  -- Invoiced At [INVDOC_CRTIM_KK]
    INVPERCAT,      -- Period Category [INVPERCAT_KK]
    INVPERIOD,      -- Invoicing Per. [INVPERIOD_KK]
    FAEDN,          -- Net Due Date [FAEDN_KK]
    TOTAL_CURR,     -- Currency [BLWAE_KK]
    TOTAL_AMT,      -- Amount [BETRW_KK]
    ARCHIVED,       -- Doc. Archived [INVDOC_ARCHIVED_KK]
    CRNAME,         -- Created By [REVTRIG_CRNAM_KK]
    CRDATE,         -- Created On [REVTRIG_CRDAT_KK]
    CRTIME,         -- Created At [REVTRIG_CRTIM_KK]
    LOEDT,          -- Deletion date [LOEDT_KK]
    PRIMARY KEY (MANDT, INVDOCNO, REVTASK)
);