I_LCMContextAggr

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 I_LCMContextAggr.
-- 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: ILCMCONTEXTAGGR

CREATE VIEW I_LCMContextAggr AS
SELECT
  LglCntntMContextUUID,
  LglCntntMContextStatus,
  1 AS FldCtrlLglCntntMContextStatus,
  1 AS FldCtrlLglCntntMProfile,
  LglCntntMPrevCntxtVers,
  _NextLglCntntMContext.LglCntntMContextUUID AS LglCntntMNextCntxtUUID,
  _NextLglCntntMContext.LglCntntMContextVersion AS LglCntntMNextCntxt,
  concat_with_space(_NextLglCntntMContext.LglCntntMContextTitle, _NextLglCntntMContext.LglCntntMContext, 1) AS LglCntntMNextCntxtTitle,
  _PreviousLglCntntMContext.LglCntntMContextUUID AS LglCntntMPrevCntxtUUID,
  _PreviousLglCntntMContext.LglCntntMContextVersion AS LglCntntMPrevCntxt,
  concat_with_space(_PreviousLglCntntMContext.LglCntntMContextTitle, _PreviousLglCntntMContext.LglCntntMContext, 1) AS LglCntntMPrevCntxtTitle,
  cast( concat( 'CONTEXT', concat( LglCntntMContext, LglCntntMContextVersion )) as cdobjectv ) AS ChangeDocObject,
  IsEndOfPurposeBlocked,
  LglCntntMProfile,
  cast( 1 as abap.int8 ) AS LglCntntMNumerator,
  LglCntntMMainOrgType
FROM I_LglCntntMContextBasic
LEFT OUTER JOIN I_LglCntntMContextBasic AS _PreviousLglCntntMContext ON LglCntntMPrevCntxtVers = _PreviousLglCntntMContext.LglCntntMContextUUID  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMContextBasic AS _NextLglCntntMContext ON LglCntntMContextUUID = _NextLglCntntMContext.LglCntntMPrevCntxtVers  -- association [0..1]
;