DFKKLOCKSH

Transparent Table Application Table
17 Fields 3 CDS Views

Business Lock Histories

DFKKLOCKSH is an SAP database table in S/4HANA. Business Lock Histories. It contains 17 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CABusinessLockHistory view_entity from BASIC Business Lock History
view_o2c_fica_lock view left_outer Business Locks
view_o2c_fica_pyl view left_outer Payment Locks With History

Fields (17)

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 lfdnr LFDNR_KK Sequence Number
lockr LOCKR_KK Lock Reason
fdate FDATE_KK From
tdate TDATE_KK To
gpart GPART_KK Bus. Partner
cond_loobj LOOBJ_KK Lock object
actkey ACTKEY_KK Activity
uname SYUNAME User Name
adatum UDATUM Date
azeit UZEIT Time
luname SYUNAME User Name
ldatum UDATUM Date
lzeit UZEIT Time

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.

-- Business Lock Histories
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKLOCKSH (
    CLIENT,      -- Client [MANDT]
    LOOBJ1,      -- Lock object [LOOBJ_KK]
    LOTYP,       -- Lock Category [LOTYP_KK]
    PROID,       -- Process [PROID_KK]
    LFDNR,       -- Sequence Number [LFDNR_KK]
    LOCKR,       -- Lock Reason [LOCKR_KK]
    FDATE,       -- From [FDATE_KK]
    TDATE,       -- To [TDATE_KK]
    GPART,       -- Bus. Partner [GPART_KK]
    COND_LOOBJ,  -- Lock object [LOOBJ_KK]
    ACTKEY,      -- Activity [ACTKEY_KK]
    UNAME,       -- User Name [SYUNAME]
    ADATUM,      -- Date [UDATUM]
    AZEIT,       -- Time [UZEIT]
    LUNAME,      -- User Name [SYUNAME]
    LDATUM,      -- Date [UDATUM]
    LZEIT,       -- Time [UZEIT]
    PRIMARY KEY (CLIENT, LOOBJ1, LOTYP, PROID, LFDNR)
);

Learn More