DFKKAVK

Transparent Table Application Table
28 Fields 1 CDS Views

Zahlungsavis: Kopfdaten

DFKKAVK is an SAP database table in S/4HANA. Zahlungsavis: Kopfdaten. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_DFKKAVK view from CDS view for Payment Advice

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY avkey avkey_kk Payment Advice Note
xinka xinka_kk Collectn agency
xinku xinku_kk Coll.data transferd
gpart gpart_av_kk Business partn.
vkont vkont_av_kk Contract Acct
waers waers_kk Currency
selt1 selta_kk Selection Cat.
staav staav_kk P.adv.status
totam totam_kk Total amount
bukrs bukrs_av_kk CC paymt onAcct
avdat avdat_kk AdviceDate
applk applk_kk ApplicationArea
erdat erdat Created On
ertim ertim_kk Time
ernam ernam Created By
aedat aedat Changed On
aetim aetim_kk Time
aenam aenam Changed By
apdat apdat_kk Applied on
aptim aptim_kk Time
apnam apnam_kk Applied by
apbel apbel_kk Usage Doc.
xbdir xbdir_kk Biller Direct
valto valto_kk Expiration Date
pytyp pytyp_kk Payment Type
xfcca xfcca_kk Financial C.C.
xlockboxa xlockboxa_kk AdviceLockbox

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.

-- Zahlungsavis: Kopfdaten
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKAVK (
    MANDT,      -- Client [mandt]
    AVKEY,      -- Payment Advice Note [avkey_kk]
    XINKA,      -- Collectn agency [xinka_kk]
    XINKU,      -- Coll.data transferd [xinku_kk]
    GPART,      -- Business partn. [gpart_av_kk]
    VKONT,      -- Contract Acct [vkont_av_kk]
    WAERS,      -- Currency [waers_kk]
    SELT1,      -- Selection Cat. [selta_kk]
    STAAV,      -- P.adv.status [staav_kk]
    TOTAM,      -- Total amount [totam_kk]
    BUKRS,      -- CC paymt onAcct [bukrs_av_kk]
    AVDAT,      -- AdviceDate [avdat_kk]
    APPLK,      -- ApplicationArea [applk_kk]
    ERDAT,      -- Created On [erdat]
    ERTIM,      -- Time [ertim_kk]
    ERNAM,      -- Created By [ernam]
    AEDAT,      -- Changed On [aedat]
    AETIM,      -- Time [aetim_kk]
    AENAM,      -- Changed By [aenam]
    APDAT,      -- Applied on [apdat_kk]
    APTIM,      -- Time [aptim_kk]
    APNAM,      -- Applied by [apnam_kk]
    APBEL,      -- Usage Doc. [apbel_kk]
    XBDIR,      -- Biller Direct [xbdir_kk]
    VALTO,      -- Expiration Date [valto_kk]
    PYTYP,      -- Payment Type [pytyp_kk]
    XFCCA,      -- Financial C.C. [xfcca_kk]
    XLOCKBOXA,  -- AdviceLockbox [xlockboxa_kk]
    PRIMARY KEY (MANDT, AVKEY)
);

Learn More