DFKKOP_LOCKSNAP

Transparent Table Application Table
51 Fields 1 CDS Views

Snapshot table for FI-CA business lock analysis

DFKKOP_LOCKSNAP is an SAP database table in S/4HANA. Snapshot table for FI-CA business lock analysis. It contains 51 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CADocBPItemBusLockSnapshot view from BASIC Business Lock Snapshot

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY appid LOCKSNAP_FIORIID_KK App ID
KEY tmstmp TZNTSTMPS Time Stamp
KEY opbel OPBEL_KK Document Number
KEY opupw OPUPW_KK Repetition Item
KEY opupk OPUPK_KK Item
KEY opupz OPUPZ_KK Subitem
loobj1 LOOBJ_KK Lock object
lolevel LOLEVEL_KK Lock Object Category
proid PROID_KK Process
fdate FDATE_KK From
tdate TDATE_KK To
duration TOTALTIME_KK Tot.Duration in Days
gpart GPART_KK Bus. Partner
vkont VKONT_KK Contract Acct
vtref VTREF_KK Contract
vtpos VTPOS_KK Contract Item
vtpid VTPID_KK Contr.Item ID
subap SUBAP_KK Subapplication
lotyp LOTYP_KK Lock Category
lockr LOCKR_KK Lock Reason
vktyp VKTYP_KK Cont. Acct Cat.
adatum ERDAT_I_KK Created on
numofext NUMOFEXT_KK Number of Extensions
bukrs BUKRS Company Code
spart SPART_KK Division
hvorg HVORG_KK Main Trans.
tvorg TVORG_KK Subtransaction
betrw AMOUNT_DISP_KK Amount
waers WAERS_KK Currency
applk APPLK_KK ApplicationArea
validfromyearmonth VALIDFROM_YEARMONTH_KK Year Month
validfromyear VALIDFROM_YEAR_KK Valid from Year
validfromweek VALFROM_YEARWEEK_KK Val. from Year Week
validfromquarter VALIDFROM_YEARQUARTER_KK Year Quarter
validtoyearmonth VALIDTO_YEARMONTH_KK Year Month
validtoyear VALIDTO_YEAR_KK Valid to Year
validtoweek VALTO_YEARWEEK_KK Val. to Year Week
validtoquarter VALIDTO_YEARQUARTER_KK Year Quarter
changeyyearmonth CHANGE_YEARMONTH_KK Year Month
changeyear CHANGE_YEAR_KK Change Year
changeweek CHANGE_YEARWEEK_KK Change Year Week
changequarter CHANGE_YEARQUARTER_KK Year Quarter
durationweeks DURATIONWEEKS_KK Duration in Weeks
durationmonths DURATIONMONTHS_KK Duration in Months
durationquarters DURATIONQUARTERS_KK Duration in Quarters
durationyears DURATIONYEARS_KK Duration in Years
gsber GSBER Business Area
segment SEGMT_KK Segment
vt_begru VT_BEGRU_KK AuthorizGroup Cntrct
multilockr X_MULTILOCKR_KK Multiple Lock Reason

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.

-- Snapshot table for FI-CA business lock analysis
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKOP_LOCKSNAP (
    MANDT,               -- Client [MANDT]
    APPID,               -- App ID [LOCKSNAP_FIORIID_KK]
    TMSTMP,              -- Time Stamp [TZNTSTMPS]
    OPBEL,               -- Document Number [OPBEL_KK]
    OPUPW,               -- Repetition Item [OPUPW_KK]
    OPUPK,               -- Item [OPUPK_KK]
    OPUPZ,               -- Subitem [OPUPZ_KK]
    LOOBJ1,              -- Lock object [LOOBJ_KK]
    LOLEVEL,             -- Lock Object Category [LOLEVEL_KK]
    PROID,               -- Process [PROID_KK]
    FDATE,               -- From [FDATE_KK]
    TDATE,               -- To [TDATE_KK]
    DURATION,            -- Tot.Duration in Days [TOTALTIME_KK]
    GPART,               -- Bus. Partner [GPART_KK]
    VKONT,               -- Contract Acct [VKONT_KK]
    VTREF,               -- Contract [VTREF_KK]
    VTPOS,               -- Contract Item [VTPOS_KK]
    VTPID,               -- Contr.Item ID [VTPID_KK]
    SUBAP,               -- Subapplication [SUBAP_KK]
    LOTYP,               -- Lock Category [LOTYP_KK]
    LOCKR,               -- Lock Reason [LOCKR_KK]
    VKTYP,               -- Cont. Acct Cat. [VKTYP_KK]
    ADATUM,              -- Created on [ERDAT_I_KK]
    NUMOFEXT,            -- Number of Extensions [NUMOFEXT_KK]
    BUKRS,               -- Company Code [BUKRS]
    SPART,               -- Division [SPART_KK]
    HVORG,               -- Main Trans. [HVORG_KK]
    TVORG,               -- Subtransaction [TVORG_KK]
    BETRW,               -- Amount [AMOUNT_DISP_KK]
    WAERS,               -- Currency [WAERS_KK]
    APPLK,               -- ApplicationArea [APPLK_KK]
    VALIDFROMYEARMONTH,  -- Year Month [VALIDFROM_YEARMONTH_KK]
    VALIDFROMYEAR,       -- Valid from Year [VALIDFROM_YEAR_KK]
    VALIDFROMWEEK,       -- Val. from Year Week [VALFROM_YEARWEEK_KK]
    VALIDFROMQUARTER,    -- Year Quarter [VALIDFROM_YEARQUARTER_KK]
    VALIDTOYEARMONTH,    -- Year Month [VALIDTO_YEARMONTH_KK]
    VALIDTOYEAR,         -- Valid to Year [VALIDTO_YEAR_KK]
    VALIDTOWEEK,         -- Val. to Year Week [VALTO_YEARWEEK_KK]
    VALIDTOQUARTER,      -- Year Quarter [VALIDTO_YEARQUARTER_KK]
    CHANGEYYEARMONTH,    -- Year Month [CHANGE_YEARMONTH_KK]
    CHANGEYEAR,          -- Change Year [CHANGE_YEAR_KK]
    CHANGEWEEK,          -- Change Year Week [CHANGE_YEARWEEK_KK]
    CHANGEQUARTER,       -- Year Quarter [CHANGE_YEARQUARTER_KK]
    DURATIONWEEKS,       -- Duration in Weeks [DURATIONWEEKS_KK]
    DURATIONMONTHS,      -- Duration in Months [DURATIONMONTHS_KK]
    DURATIONQUARTERS,    -- Duration in Quarters [DURATIONQUARTERS_KK]
    DURATIONYEARS,       -- Duration in Years [DURATIONYEARS_KK]
    GSBER,               -- Business Area [GSBER]
    SEGMENT,             -- Segment [SEGMT_KK]
    VT_BEGRU,            -- AuthorizGroup Cntrct [VT_BEGRU_KK]
    MULTILOCKR,          -- Multiple Lock Reason [X_MULTILOCKR_KK]
    PRIMARY KEY (MANDT, APPID, TMSTMP, OPBEL, OPUPW, OPUPK, OPUPZ)
);

Learn More