DFKKIA

Transparent Table Application Table
24 Fields 1 CDS Views

FI-CA: Database table for FKKIA - intrst supp

DFKKIA is an SAP database table in S/4HANA. FI-CA: Database table for FKKIA - intrst supp. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAInterestSupplement view from BASIC Interest supplement to state Interest

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY iopbel IOPBEL_KK Interest Doc.No
KEY iopupk OPUPK_KK Item
KEY opbel OPBEL_KK Document Number
KEY opupw OPUPW_KK Repetition Item
KEY opupk OPUPK_KK Item
KEY opupz OPUPZ_KK Subitem
KEY lfdnr LFDNR_KK Sequence Number
abdat ABDAT_KK From-Date
bisdat BISDT_KK To Date
abwbl ABWBL_KK Sub. Doc.
abwtp ABWTP_KK Doc.Cat.
ityp ITYP_KK Interest Cat.
waers WAERS Currency
betrw BETRW_KK Amount
ikey IKEY_KK Interest key
irate ERATE Int Rate
ibtrg IBTRG_KK Interest Amount
intgrp GROUP_KK Group Number
round ROUND_KK Rounding Item
security SECURITY_KK Security
ikeyd IKEYD_KK Key Date
inold INOLD_KK Int.Calculated
itaxn ITAXN_KK Tax Item

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.

-- FI-CA: Database table for FKKIA - intrst supp
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKIA (
    MANDT,     -- Client [MANDT]
    IOPBEL,    -- Interest Doc.No [IOPBEL_KK]
    IOPUPK,    -- Item [OPUPK_KK]
    OPBEL,     -- Document Number [OPBEL_KK]
    OPUPW,     -- Repetition Item [OPUPW_KK]
    OPUPK,     -- Item [OPUPK_KK]
    OPUPZ,     -- Subitem [OPUPZ_KK]
    LFDNR,     -- Sequence Number [LFDNR_KK]
    ABDAT,     -- From-Date [ABDAT_KK]
    BISDAT,    -- To Date [BISDT_KK]
    ABWBL,     -- Sub. Doc. [ABWBL_KK]
    ABWTP,     -- Doc.Cat. [ABWTP_KK]
    ITYP,      -- Interest Cat. [ITYP_KK]
    WAERS,     -- Currency [WAERS]
    BETRW,     -- Amount [BETRW_KK]
    IKEY,      -- Interest key [IKEY_KK]
    IRATE,     -- Int Rate [ERATE]
    IBTRG,     -- Interest Amount [IBTRG_KK]
    INTGRP,    -- Group Number [GROUP_KK]
    ROUND,     -- Rounding Item [ROUND_KK]
    SECURITY,  -- Security [SECURITY_KK]
    IKEYD,     -- Key Date [IKEYD_KK]
    INOLD,     -- Int.Calculated [INOLD_KK]
    ITAXN,     -- Tax Item [ITAXN_KK]
    PRIMARY KEY (MANDT, IOPBEL, IOPUPK, OPBEL, OPUPW, OPUPK, OPUPZ, LFDNR)
);

Learn More