DFKKLOCKS

Transparent Table Application Table

FI-CA: Betriebswirtschaftliche Sperren

DFKKLOCKS is an SAP database table in S/4HANA. FI-CA: Betriebswirtschaftliche Sperren. It contains 18 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CABusinessLock view_entity from BASIC Contract Accounting Business Lock
view_o2c_fica_lock view from Business Locks
view_o2c_fica_loext view from Business Locks Extensions
view_o2c_fica_pyl view from Payment Locks With History

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY loobj1 loobj_kk Lock object
KEY lotyp lotyp_kk Lock Category
KEY proid proid_kk Process
KEY lockr lockr_kk Lock Reason
KEY fdate fdate_kk From
KEY tdate tdate_kk To
KEY gpart gpart_kk Bus. Partner
KEY vkont vkont_kk Contract Acct
cond_loobj loobj_kk Lock object
actkey actkey_kk Activity
uname syuname User Name
adatum udatum Date
azeit uzeit Time
protected protected_kk Protected
laufd laufd_kk Date ID
laufi laufi_kk Run ID
lockt lock_comment_kk Comment

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: Betriebswirtschaftliche Sperren
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKLOCKS (
    CLIENT,      -- Client [mandt]
    LOOBJ1,      -- Lock object [loobj_kk]
    LOTYP,       -- Lock Category [lotyp_kk]
    PROID,       -- Process [proid_kk]
    LOCKR,       -- Lock Reason [lockr_kk]
    FDATE,       -- From [fdate_kk]
    TDATE,       -- To [tdate_kk]
    GPART,       -- Bus. Partner [gpart_kk]
    VKONT,       -- Contract Acct [vkont_kk]
    COND_LOOBJ,  -- Lock object [loobj_kk]
    ACTKEY,      -- Activity [actkey_kk]
    UNAME,       -- User Name [syuname]
    ADATUM,      -- Date [udatum]
    AZEIT,       -- Time [uzeit]
    PROTECTED,   -- Protected [protected_kk]
    LAUFD,       -- Date ID [laufd_kk]
    LAUFI,       -- Run ID [laufi_kk]
    LOCKT,       -- Comment [lock_comment_kk]
    PRIMARY KEY (CLIENT, LOOBJ1, LOTYP, PROID, LOCKR, FDATE, TDATE, GPART, VKONT)
);