P_CAPostingLockAnalysis_2

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_CAPostingLockAnalysis_2.
-- 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.

CREATE VIEW P_CAPostingLockAnalysis_2 AS
SELECT
  CABusinessLockObject,
  CABusinessLockObjectCategory,
  CABusinessProcess,
  CABusinessLockReason,
  CABusinessLockValidFrom,
  CABusinessLockValidTo,
  BusinessPartner,
  ContractAccount,
  LastChangeDate,
  cast( dats_days_between(CABusinessLockValidFrom,CABusinessLockValidTo) + 1 as totaltime_kk ) AS CABusinessLockDuration,
  cast(1 as abap.int4) AS NumberOfCABusinessLocks,
  _LockReason._Text[1:Language = $session.system_language].CAPostgAndClrgLockReasonName AS CAPostgAndClrgLockReasonName,
  cast( right(left(CABusinessLockValidFrom, 6),2) as calendarmonth) AS CABusLockValidFromDateMonth,
  cast( right(left(CABusinessLockValidTo, 6),2) as calendarmonth) AS CABusLockValidToDateMonth,
  cast( left(CABusinessLockValidFrom, 4) as validto_year_kk) AS CABusLockValidFromDateYear,
  cast( left(CABusinessLockValidTo, 4) as validto_year_kk) AS CABusLockValidToDateYear,
  Lock._ContractAccountPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  '000' AS CABusinessLockSequenceNumber
FROM I_CABusinessLock AS Lock
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _ValidToDate ON _ValidToDate.CalendarDate = CAValidToDateAdjusted  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _ValidFromDate ON _ValidFromDate.CalendarDate = CAValidFromDateAdjusted  -- association [0..1]
LEFT OUTER JOIN I_CAPostgAndClrgLockReason AS _LockReason ON CABusinessLockReason = _LockReason.CAPostgAndClrgLockReason  -- association [1]
LEFT OUTER JOIN P_CABusinessLockExtension2 AS _Extension ON CABusinessLockObject = _Extension.CABusinessLockObject AND CABusinessLockObjectCategory = _Extension.CABusinessLockObjectCategory AND CABusinessProcess = _Extension.CABusinessProcess AND CABusinessLockReason = _Extension.CABusinessLockReason  -- association [0..1]
-- UNION ALL with additional select branch(es): I_CABusinessPartnerLock
;