C_ProdCmplncTaskEventsInfo

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_ProdCmplncTaskEventsInfo.
-- 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: CPCTEVENTSINFO

CREATE VIEW C_ProdCmplncTaskEventsInfo AS
SELECT
  ProdCmplncEventTaskAssgmtUUID,
  ProdCmplncTaskUUID,
  ProdCmplncEventUUID,
  ProdCmplncEventUUID AS ProdCmplncEventNavgnLink,
  _ProdCmplncEvent.ProdCmplncEventType AS ProdCmplncEventType,
  _ProdCmplncEventTP._ProdCmplncEventTypeTxt[1: Language = $session.system_language].ProdCmplncEventTypeText AS ProdCmplncEventTypeText,
  cast('' as abap.char( 35 )) AS ProdCmplncEventIconType,
  cast('' as text1024) AS ProdCmplncEventSourceObjName,
  cast('' as text1024) AS ProdCmplncEventSourceObjId,
  cast('' as text1024) AS ObjectLinkURL,
  _ProdCmplncEvent.ProdCmplncEventSourceType AS ProdCmplncEventSourceType,
  _ProdCmplncEventTP._ProdCmplncEventSourceTypeTxt[1: Language = $session.system_language].ProdCmplncEventSrceTypeText AS ProdCmplncEventSrceTypeText,
  _ProdCmplncEvent.ProdCmplncEventSourceUUID AS ProdCmplncEventSourceUUID,
  _ProdCmplncEvent.LastChangeDateTime AS LastChangeDateTime,
  _ProdCmplncEventTP._ProdCmplncEventProcStatusTxt[1: Language = $session.system_language].ProdCmplncEventProcgStsCritlty AS ProdCmplncEventProcgStsCritlty,
  _ProdCmplncEventTP._ProdCmplncEventProcStatusTxt[1: Language = $session.system_language].ProdCmplncEventProcgStsText AS ProdCmplncEventProcgStsText,
  _ProdCmplncEventTP.ProdCmplncEventProcgStatus AS ProdCmplncEventProcgStatus
FROM I_ProdCmplncEventTaskAssgmt
LEFT OUTER JOIN I_ProdCmplncEventTP AS _ProdCmplncEventTP ON ProdCmplncEventNavgnLink = _ProdCmplncEventTP.ProdCmplncEventUUID  -- association [0..1]
;