DFKKINVDOC_REV
Stornoauftrag für Fakturierungsbeleg
DFKKINVDOC_REV is an SAP database table in S/4HANA. Stornoauftrag für Fakturierungsbeleg. It contains 24 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CAInvcgDocReversalRequest | view | from | BASIC | Stornoauftrag für Fakt.belege |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| 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.
-- Stornoauftrag für Fakturierungsbeleg
-- 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]
LOEDT, -- Deletion date [loedt_kk]
PRIMARY KEY (MANDT, INVDOCNO, REVTASK)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA