C_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 C_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 C_CAPostingLockAnalysis_2 AS
SELECT
  CABusinessLockObject,
  CABusinessLockObjectCategory,
  CABusinessProcess,
  CABusinessLockReason,
  CABusinessLockValidFrom,
  CABusinessLockValidTo,
  BusinessPartner,
  ContractAccount,
  _CAPartner.ContractAccountName AS ContractAccountName,
  CABusinessLockValidFromDate,
  LastChangeDate,
  CABusinessLockDuration,
  CABusinessLockSequenceNumber,
  NumberOfCABusinessLocks,
  CABusLockValidToDateYear,
  _ValidToDate.CalendarQuarter AS CABusLockValidToDateQuarter,
  CABusLockValidToDateMonth,
  _ValidToDate.CalendarWeek AS CABusLockValidToDateWeek,
  CABusLockValidFromDateYear,
  _ValidFromDate.CalendarQuarter AS CABusLockValidFromDateQuarter,
  CABusLockValidFromDateMonth,
  _ValidFromDate.CalendarWeek AS CABusLockValidFromDateWeek,
  _LastChangeDate.CalendarYear AS LastChangeDateYear,
  _LastChangeDate.CalendarQuarter AS LastChangeDateQuarter,
  _LastChangeDate.CalendarMonth AS LastChangeDateMonth,
  _LastChangeDate.CalendarWeek AS LastChangeDateWeek,
  CAAuthorizationGroup,
  _ValidFromDate._CalendarQuarter AS _CalendarQuarter,
  _ValidFromDate._CalendarWeek AS _CalendarWeek,
  _LastChangeDate._CalendarYear AS _CalendarYear
FROM P_CAPostingLockAnalysis_2
LEFT OUTER JOIN I_CalendarDate AS _LastChangeDate ON _LastChangeDate.CalendarDate = LastChangeDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarQuarterText AS _ValidToDateQuarterText ON _ValidToDateQuarterText.CalendarQuarter = CABusLockValidToDateQuarter  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonthText AS _ValidToDateMonthText ON _ValidToDateMonthText.CalendarMonth = CABusLockValidToDateMonth  -- association [0..1]
LEFT OUTER JOIN I_CalendarQuarterText AS _ValidFromDateQuarterText ON _ValidFromDateQuarterText.CalendarQuarter = CABusLockValidFromDateQuarter  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonthText AS _ValidFromDateMonthText ON _ValidFromDateMonthText.CalendarMonth = CABusLockValidFromDateMonth  -- association [0..1]
LEFT OUTER JOIN I_CalendarQuarterText AS _LastChangeDateQuarterText ON _LastChangeDateQuarterText.CalendarQuarter = LastChangeDateQuarter  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonthText AS _LastChangeDateMonthText ON _LastChangeDateMonthText.CalendarMonth = LastChangeDateMonth  -- association [0..1]
LEFT OUTER JOIN I_CAPostgAndClrgLockRsnText AS _LockReasonText ON _LockReasonText.CAPostgAndClrgLockReason = CABusinessLockReason  -- association [0..1]
LEFT OUTER JOIN I_CABusinessLockObjectLevelTxt AS _LockObjectLevelText ON _LockObjectLevelText.CABusinessLockObjectLevel = CABusinessLockObjectLevel  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
;