DFKKOPW

Transparent Table Application Table
35 Fields 6 CDS Views

Items in contract account document

DFKKOPW is an SAP database table in S/4HANA. Items in contract account document. It contains 35 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
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 (35)

KeyField Data ElementDescription DomainTypeLength
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
pnnum PNNUM_KK Pre-Notif.
pnhkf PNHKF_KK Mandate Origin
pnexd PNEXD_KK Exec.Date
deaktiv DEAKTIV Deactivated
solldat ABSDAT BBR/part.bill
einmalanf EINMALANF One-time req.
vorauszahl VORAUSZAHL Advance payment
abrabs ABRABS1 BB/bill dates
logno LOGNO Logical Line 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.

-- Items in contract account document
-- 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]
    PNNUM,       -- Pre-Notif. [PNNUM_KK]
    PNHKF,       -- Mandate Origin [PNHKF_KK]
    PNEXD,       -- Exec.Date [PNEXD_KK]
    DEAKTIV,     -- Deactivated [DEAKTIV]
    SOLLDAT,     -- BBR/part.bill [ABSDAT]
    EINMALANF,   -- One-time req. [EINMALANF]
    VORAUSZAHL,  -- Advance payment [VORAUSZAHL]
    ABRABS,      -- BB/bill dates [ABRABS1]
    LOGNO,       -- Logical Line No. [LOGNO]
    PRIMARY KEY (MANDT, OPBEL, WHGRP, OPUPW)
);

Learn More