C_ProdCmplncEventTasksInfo

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_ProdCmplncEventTasksInfo.
-- 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: CPCETASKINFO

CREATE VIEW C_ProdCmplncEventTasksInfo AS
SELECT
  ProdCmplncEventTaskAssgmtUUID,
  ProdCmplncEventUUID,
  ProdCmplncEventTaskAssgmt.ProdCmplncTaskUUID AS ProdCmplncTaskNavgnLink,
  _ProdCmplncTask.ProdCmplncTaskNmbrOfAttempts AS ProdCmplncTaskNmbrOfAttempts,
  _ProdCmplncTask.LastChangeDateTime AS LastChangeDateTime,
  _ProdCmplncTaskTP.ProdCmplncTaskProcgStatus AS ProdCmplncTaskProcgStatus,
  _ProdCmplncTaskProcStatusTxt.ProdCmplncTaskProcgStsText AS ProdCmplncTaskProcgStsText,
  _ProdCmplncTaskProcStatusTxt.ProdCmplncTaskProcgStsCritlty AS ProdCmplncTaskProcgStsCritlty,
  cast('' as ehfnd_pct_task_proc_stat_text ) AS ProdCmplncTaskProcgStsDesc,
  _ProdCmplncTask.ProdCmplncTaskType AS ProdCmplncTaskType,
  _ProdCmplncTask._ProdCmplncTaskTypeText[1: Language = $session.system_language].ProdCmplncTaskTypeText AS ProdCmplncTaskTypeText,
  _ProdCmplncTaskTP.ProdCmplncTaskAffcdObjUUID AS ProdCmplncTaskAffcdObjUUID,
  _ProdCmplncTask.ProdCmplncTaskAffcdObjType AS ProdCmplncTaskAffcdObjType,
  cast('' as text1024) AS ObjectLinkURL,
  cast('' as text1024) AS ProdCmplncTaskAffcdObjName,
  cast('' as text1024) AS ProdCmplncTaskAffcdObjId,
  cast('' as text1024) AS ProdCmplncTaskAffcdObjIconType,
  _ProdCmplncTaskTP._CmplRqVers.CmplRqVersName AS ProdCmplncTaskRefObjName,
  _ProdCmplncTask.ProdCmplncTaskRefObjType AS ProdCmplncTaskRefObjType,
  _ProdCmplncTaskTP.ProdCmplncTaskRefObjUUID AS ProdCmplncTaskRefObjUUID
FROM I_ProdCmplncEventTaskAssgmt AS ProdCmplncEventTaskAssgmt
INNER JOIN I_ProdCmplncTaskTP AS _ProdCmplncTaskTP ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProdCmplncTaskProcStatusTxt AS _ProdCmplncTaskProcStatusTxt ON /* join condition not captured in parsed metadata */
;