P_CAItemLocks

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CAItemLocks.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PCAITEMLOCKS
-- Parameters: P_CABusinessProcess : char2

CREATE VIEW P_CAItemLocks AS
SELECT
  _Lock.CABusinessLockObject AS CABusinessLockObject,
  max(_Lock.CABusinessLockReason) AS CABusinessLockReason,
  min(_Lock.CABusinessLockValidFrom) AS CABusinessLockValidFrom,
  max(_Lock.CABusinessLockValidTo) AS CABusinessLockValidTo,
  max(_Lock.LastChangeDate) AS LastChangeDate,
  max(_BusLockHistory.CABusinessLockSequenceNumber) AS CABusinessLockSequenceNumber,
  1 AS NumberOfLocks,
  count( distinct CABusinessLockReason) AS NumberOfLockReasons
FROM I_CABusinessLock AS _Lock
LEFT OUTER JOIN I_CABusinessLockHistory AS _BusLockHistory ON _Lock.CABusinessLockObject = _BusLockHistory.CABusinessLockObject AND _Lock.CABusinessLockObjectCategory = _BusLockHistory.CABusinessLockObjectCategory AND _Lock.CABusinessProcess = _BusLockHistory.CABusinessProcess AND _Lock.CABusinessLockReason = _BusLockHistory.CABusinessLockReason AND _Lock.CABusinessLockValidTo > _BusLockHistory.CABusinessLockValidTo  -- association [1..*]
;