C_ChgRecdLfcycStChgDocOvPg

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_ChgRecdLfcycStChgDocOvPg.
-- 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: CCHGRECLIFSTATUS

CREATE VIEW C_ChgRecdLfcycStChgDocOvPg AS
SELECT
  Document.ChangeDocumentUUID AS ChangeDocumentUUID,
  ChangeDocObjectClass,
  ChangeDocument,
  cast( '1' as /plmb/number_of_change_records) AS NmbrOfChgRecdByLfcycStatus,
  ChangeRecordLifecycleStatus,
  _ChgRecLifecycleStatusTxt.ChangeRecordLifecycleStatusTxt AS ChangeRecordLifecycleStatusTxt,
  CreatedByUser,
  Document.CreationDate AS CreationDate,
  Document.CreationTime AS CreationTime,
  ChangeRecord,
  ChangeRecordType,
  ChgRecordDescriptionText,
  Partner,
  Document.YearMonth AS YearMonth,
  _CalendarMonthText.CalendarMonthName AS CalendarMonthName,
  Document.CalendarYear AS CalendarYear,
  Document.CalendarMonth AS CalendarMonth,
  Document.YearQuarter AS YearQuarter,
  _CalendarQuarterText.CalendarQuarterName AS CalendarQuarterName,
  Document.YearWeek AS YearWeek,
  Document.CalendarWeek AS CalendarWeek,
  CONCAT_WITH_SPACE(cast(Document.CalendarYear as abap.char( 4 )), _CalendarMonthText.CalendarMonthName, 1 ) AS YearMonthName,
  CONCAT_WITH_SPACE(cast(Document.CalendarYear as abap.char( 4 )), _CalendarQuarterText.CalendarQuarterName,1) AS YearQuarterName,
  CONCAT_WITH_SPACE(cast(Document.CalendarYear as abap.char( 4 )), CONCAT( 'CW', cast(Document.CalendarWeek as abap.char(2)) ),1) AS YearWeekName
FROM I_ChgRecordLifeCycleStatusLog AS Document
LEFT OUTER JOIN P_LtstChgDocForChgRecdByWk AS _LatestRecordByWk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_LtstChgDocForChgRecByMnth AS _LatestRecordByMnth ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_LtstChgDocForChgRecdByQtr AS _LatestRecordByQtr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChgRecLifecycleStatusTxt AS _ChgRecLifecycleStatusTxt ON Document.ChangeRecordLifecycleStatus = _ChgRecLifecycleStatusTxt.ChangeRecordLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonthText AS _CalendarMonthText ON _CalendarMonthText.CalendarMonth = Document.CalendarMonth AND _CalendarMonthText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_CalendarQuarterText AS _CalendarQuarterText ON _CalendarQuarterText.CalendarQuarter = Document.CalendarQuarter AND _CalendarQuarterText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_CalendarDate AS _Calendar01 ON _Calendar01.CalendarDate = Document.FourMonthsInThePast  -- association [0..*]
LEFT OUTER JOIN I_CalendarDate AS _Calendar02 ON _Calendar02.CalendarDate = Document.FourQuartersInThePast  -- association [0..*]
;