DFKKBPLOCKH

Transparent Table Application Table
17 Fields 1 CDS Views

FI-CA: Business Partner Locks - History

DFKKBPLOCKH is an SAP database table in S/4HANA. FI-CA: Business Partner Locks - History. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CABusinessPartnerLockHistory view from BASIC Historie der zentralen Geschäftspartner-Sperre

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY gpart GPART_KK Bus. Partner
KEY val_date UDATUM Date
KEY val_time UZEIT Time
lockr_md LOCKR_MD_KK Mast.Data Lock
lockr_dd SPPOS_KK Posting Lock
lockr_dunning MANSP_KK DunnLockReason
lockr_inc_pay EZASP_KK Incoming Lock
lockr_out_pay AZASP_KK Outgoing Lock
fdate FDATE_KK From
tdate TDATE_KK To
lockt LOCK_COMMENT_KK Comment
ernam SYUNAME User Name
erdat UDATUM Date
ertim UZEIT Time
aenam SYUNAME User Name
xbpld XBPLD_KK Lock Deleted

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: Business Partner Locks - History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKBPLOCKH (
    MANDT,          -- Client [MANDT]
    GPART,          -- Bus. Partner [GPART_KK]
    VAL_DATE,       -- Date [UDATUM]
    VAL_TIME,       -- Time [UZEIT]
    LOCKR_MD,       -- Mast.Data Lock [LOCKR_MD_KK]
    LOCKR_DD,       -- Posting Lock [SPPOS_KK]
    LOCKR_DUNNING,  -- DunnLockReason [MANSP_KK]
    LOCKR_INC_PAY,  -- Incoming Lock [EZASP_KK]
    LOCKR_OUT_PAY,  -- Outgoing Lock [AZASP_KK]
    FDATE,          -- From [FDATE_KK]
    TDATE,          -- To [TDATE_KK]
    LOCKT,          -- Comment [LOCK_COMMENT_KK]
    ERNAM,          -- User Name [SYUNAME]
    ERDAT,          -- Date [UDATUM]
    ERTIM,          -- Time [UZEIT]
    AENAM,          -- User Name [SYUNAME]
    XBPLD,          -- Lock Deleted [XBPLD_KK]
    PRIMARY KEY (MANDT, GPART, VAL_DATE, VAL_TIME)
);

Learn More