DFKKOPW
Positionen zum Kontokorrentbeleg
DFKKOPW is an SAP database table in S/4HANA. Positionen zum Kontokorrentbeleg. It contains 26 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_CADocumentBPRepetitionItem | view | from | EXTENSION | GP Wiederholungsposition Erweiterung |
| I_CADocumentBPRepetitionItem | view | from | BASIC | Document BP Repetition Item |
| view_o2c_fica_oi | view | inner | Open Items | |
| view_o2c_fica_wl_crde | view | inner | CDS View Credits and Debits for Business Partner | |
| view_o2c_fica_wlo | view | inner | CDS View Worklist for Overdue Items | |
| view_o2c_fica_wlovd | view | inner | Business Partner List for Overdue Items |
Fields (26)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | opbel | opbel_kk | Document Number | |||
| KEY | whgrp | whgrp_kk | Repetition grp | |||
| KEY | opupw | opupw_kk | Repetition Item | |||
| whanz | whanz_kk | Group items | ||||
| gpart | gpart_kk | Bus. Partner | ||||
| vkont | vkont_kk | Contract Acct | ||||
| abwbl | abwbl_kk | Sub. Doc. | ||||
| abwtp | abwtp_kk | Doc.Cat. | ||||
| budat | budat_kk | Posting Date | ||||
| faedn | faedn_kk | Net Due Date | ||||
| faeds | faeds_kk | Disct Due Date | ||||
| persl | persl_kk | Period Key | ||||
| xaesp | xaesp_kk | Change lock | ||||
| mansp | mansp_kk | DunnLockReason | ||||
| augdt | augdt_kk | Clearing | ||||
| augbl | augbl_kk | Clearing Doc. | ||||
| augbd | augbd_kk | Clrg Post. Date | ||||
| augrd | augrd_kk | Clearing Reason | ||||
| augvd | augvd_kk | Clear.Val.Date | ||||
| augob | augob_kk | Canceled | ||||
| xaufl | xaufl_kk | Broken down | ||||
| xragl | xragl_kk | Reverse clrg | ||||
| xpyor | xpyor_kk | Payment Order | ||||
| stzal | stzal_kk | Payment Status | ||||
| _dataaging | data_temperature | Data Aging |
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.
-- Positionen zum Kontokorrentbeleg
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKOPW (
MANDT, -- Client [mandt]
OPBEL, -- Document Number [opbel_kk]
WHGRP, -- Repetition grp [whgrp_kk]
OPUPW, -- Repetition Item [opupw_kk]
WHANZ, -- Group items [whanz_kk]
GPART, -- Bus. Partner [gpart_kk]
VKONT, -- Contract Acct [vkont_kk]
ABWBL, -- Sub. Doc. [abwbl_kk]
ABWTP, -- Doc.Cat. [abwtp_kk]
BUDAT, -- Posting Date [budat_kk]
FAEDN, -- Net Due Date [faedn_kk]
FAEDS, -- Disct Due Date [faeds_kk]
PERSL, -- Period Key [persl_kk]
XAESP, -- Change lock [xaesp_kk]
MANSP, -- DunnLockReason [mansp_kk]
AUGDT, -- Clearing [augdt_kk]
AUGBL, -- Clearing Doc. [augbl_kk]
AUGBD, -- Clrg Post. Date [augbd_kk]
AUGRD, -- Clearing Reason [augrd_kk]
AUGVD, -- Clear.Val.Date [augvd_kk]
AUGOB, -- Canceled [augob_kk]
XAUFL, -- Broken down [xaufl_kk]
XRAGL, -- Reverse clrg [xragl_kk]
XPYOR, -- Payment Order [xpyor_kk]
STZAL, -- Payment Status [stzal_kk]
_DATAAGING, -- Data Aging [data_temperature]
PRIMARY KEY (MANDT, OPBEL, WHGRP, OPUPW)
);
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