FKK_SEC

Transparent Table Application Table

Security Deposit

FKK_SEC is an SAP database table in S/4HANA. Security Deposit. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CASecurityDeposit view from BASIC Sicherheitsleistung

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY security SECURITY_KK Security
applk APPLK_KK ApplicationArea
non_cash NON_CASH_KK Noncash deposit
reason REASON_KK Request Reason
vkont VKONT_KK Contract Acct
sec_start SEC_START_KK Start Date
sec_return SEC_RETURN_KK Return Date
waers WAERS Currency
opbel OPBEL_KK Document Number
rev_reason REV_REASON_KK Reversal Reason
nrzas NRZAS_KK Payment Form
objtype SWO_OBJTYP Object Type
objkey SEC_OBJTYP_KK Key
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
brgru BRGRU Authorization
ikey IKEY_KK Interest key
x_sec_rev X_SEC_REV_KK Reversed
x_sec_rel X_SEC_REL_KK Released
bukrs BUKRS Company Code
ext_ref_no SEC_XRFNR_KK Ext. Reference

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.

-- Security Deposit
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FKK_SEC (
    MANDT,       -- Client [MANDT]
    SECURITY,    -- Security [SECURITY_KK]
    APPLK,       -- ApplicationArea [APPLK_KK]
    NON_CASH,    -- Noncash deposit [NON_CASH_KK]
    REASON,      -- Request Reason [REASON_KK]
    VKONT,       -- Contract Acct [VKONT_KK]
    SEC_START,   -- Start Date [SEC_START_KK]
    SEC_RETURN,  -- Return Date [SEC_RETURN_KK]
    WAERS,       -- Currency [WAERS]
    OPBEL,       -- Document Number [OPBEL_KK]
    REV_REASON,  -- Reversal Reason [REV_REASON_KK]
    NRZAS,       -- Payment Form [NRZAS_KK]
    OBJTYPE,     -- Object Type [SWO_OBJTYP]
    OBJKEY,      -- Key [SEC_OBJTYP_KK]
    ERDAT,       -- Created On [ERDAT]
    ERNAM,       -- Created By [ERNAM]
    AEDAT,       -- Changed On [AEDAT]
    AENAM,       -- Changed By [AENAM]
    BRGRU,       -- Authorization [BRGRU]
    IKEY,        -- Interest key [IKEY_KK]
    X_SEC_REV,   -- Reversed [X_SEC_REV_KK]
    X_SEC_REL,   -- Released [X_SEC_REL_KK]
    BUKRS,       -- Company Code [BUKRS]
    EXT_REF_NO,  -- Ext. Reference [SEC_XRFNR_KK]
    PRIMARY KEY (MANDT, SECURITY)
);