DFKKCOLL

Transparent Table Application Table
23 Fields 1 CDS Views

Admin. Data for Submission of Receivables for Coll. Agency

DFKKCOLL is an SAP database table in S/4HANA. Admin. Data for Submission of Receivables for Coll. Agency. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CATransferToCollAgency view from BASIC Forderungsabgabe an Inkassobüro

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel OPBEL_KK Document Number
KEY inkps INKPS_KK Collection item
inkgp INKGP_KK CollsAgency BP
bukrs BUKRS Company Code
gpart GPART_KK Bus. Partner
vkont VKONT_KK Contract Acct
agdat AGDAT_KK Submission Date
aggrd AGGRD_KK Subm. Reason
waers WAERS_KK Currency
betrw BETRW_KK Amount
betrz BETRZ_KK Payment Amount
ninkb NINKB_KK Uncollectable
intbt INTST_KK Interest rec.
charb CHGST_KK Charge receivb.
xblnr XBLNR_KK Reference
agsta AGSTA_KK Subm. Status
xsold XSOLD_KK Sold
nrzas NRZAS_KK Payment Form
rudat RUDAT_KK Callback Date
rugrd DEAGR_KK Callback Reason
collcase_id COLLCASE_ID_KK External Case No.
cologrp COLOGRP_BP_KK Col.GroupBus.Partner

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.

-- Admin. Data for Submission of Receivables for Coll. Agency
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKCOLL (
    MANDT,        -- Client [MANDT]
    OPBEL,        -- Document Number [OPBEL_KK]
    INKPS,        -- Collection item [INKPS_KK]
    INKGP,        -- CollsAgency BP [INKGP_KK]
    BUKRS,        -- Company Code [BUKRS]
    GPART,        -- Bus. Partner [GPART_KK]
    VKONT,        -- Contract Acct [VKONT_KK]
    AGDAT,        -- Submission Date [AGDAT_KK]
    AGGRD,        -- Subm. Reason [AGGRD_KK]
    WAERS,        -- Currency [WAERS_KK]
    BETRW,        -- Amount [BETRW_KK]
    BETRZ,        -- Payment Amount [BETRZ_KK]
    NINKB,        -- Uncollectable [NINKB_KK]
    INTBT,        -- Interest rec. [INTST_KK]
    CHARB,        -- Charge receivb. [CHGST_KK]
    XBLNR,        -- Reference [XBLNR_KK]
    AGSTA,        -- Subm. Status [AGSTA_KK]
    XSOLD,        -- Sold [XSOLD_KK]
    NRZAS,        -- Payment Form [NRZAS_KK]
    RUDAT,        -- Callback Date [RUDAT_KK]
    RUGRD,        -- Callback Reason [DEAGR_KK]
    COLLCASE_ID,  -- External Case No. [COLLCASE_ID_KK]
    COLOGRP,      -- Col.GroupBus.Partner [COLOGRP_BP_KK]
    PRIMARY KEY (MANDT, OPBEL, INKPS)
);

Learn More