DFKKAVK

Transparent Table Application Table
28 Fields 1 CDS Views

Payment Advice: Header Data

DFKKAVK is an SAP database table in S/4HANA. Payment Advice: Header Data. 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.

-- Payment Advice: Header Data
-- 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