LOCK

15 Fields

LOCK is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CABPItemNumber CABPItemNumber 1
KEY CABusinessLockObject CABusinessLockObject 1
KEY CABusinessLockReason CABusinessLockReason 6
KEY CABusinessLockValidFrom CABusinessLockValidFrom 6
KEY CABusinessLockValidTo CABusinessLockValidTo 6
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CASubItemNumber CASubItemNumber 1
KEY ContractAccount ContractAccount 1
CABusinessLockDuration CABusinessLockDuration 1
CABusinessLockObjectCategory CABusinessLockObjectCategory 1
CABusinessLockSequenceNumber CABusinessLockSequenceNumber 4
CABusinessProcess CABusinessProcess 1
CreationDate LastChangeDate 2
LastChangeDate LastChangeDate 5

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LOCK (
    BUSINESSPARTNER,
    CABPITEMNUMBER,
    CABUSINESSLOCKOBJECT,
    CABUSINESSLOCKREASON,
    CABUSINESSLOCKVALIDFROM,
    CABUSINESSLOCKVALIDTO,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    CONTRACTACCOUNT,
    CABUSINESSLOCKDURATION,
    CABUSINESSLOCKOBJECTCATEGORY,
    CABUSINESSLOCKSEQUENCENUMBER,
    CABUSINESSPROCESS,
    CREATIONDATE,
    LASTCHANGEDATE,
    PRIMARY KEY (BUSINESSPARTNER, CABPITEMNUMBER, CABUSINESSLOCKOBJECT, CABUSINESSLOCKREASON, CABUSINESSLOCKVALIDFROM, CABUSINESSLOCKVALIDTO, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, CONTRACTACCOUNT)
);

Learn More