C_ProdCmplncTaskTP

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_ProdCmplncTaskTP.
-- 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_ProdCmplncTaskTP AS
SELECT
  ProdCmplncTaskUUID,
  CreationDateTime,
  CreatedByUser,
  ProdCmplncTaskType,
  _ProdCmplncTaskTypeText.ProdCmplncTaskTypeText AS ProdCmplncTaskTypeText,
  ProdCmplncTaskAffcdObjUUID,
  ProdCmplncTaskAffcdObjType,
  cast('' as text1024) AS ProdCmplncTaskAffcdObjId,
  cast('' as text1024) AS ProdCmplncTaskAffcdObjName,
  cast('' as abap.char( 35 )) AS ProdCmplncTaskAffcdObjTypeText,
  cast('' as abap.char( 35 )) AS ProdCmplncTaskAffcdObjIconType,
  cast('' as text1024) AS ObjectLinkURL,
  ProdCmplncTaskRefObj,
  ProdCmplncTaskRefObjUUID,
  ProdCmplncTaskRefObjType,
  cast('' as text1024) AS ProdCmplncTaskRefObjName,
  ProdCmplncTaskProcgStatus,
  _ProdCmplncTaskProcStatusTxt.ProdCmplncTaskProcgStsCritlty AS ProdCmplncTaskProcgStsCritlty,
  _ProdCmplncTaskProcStatusTxt.ProdCmplncTaskProcgStsText AS ProdCmplncTaskProcgStsText,
  cast('' as ehfnd_pct_task_proc_stat_text) AS ProdCmplncTaskProcgStsDesc,
  ProdCmplncTaskNmbrOfAttempts,
  ProdCmplncTaskProcgPriority,
  ApplicationLogHandle,
  LastChangeDateTime,
  LastChangedByUser,
  _ProdCmplncTskAffcdObjDets.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  _ProdCmplncTskAffcdObjDets.ProductName AS ProductName,
  _ProdCmplncTskAffcdObjDets.SubstanceInternalName AS SubstanceInternalName,
  _ProdCmplncTskAffcdObjDets.CompanySubstanceName AS CompanySubstanceName,
  _ProdCmplncTskAffcdObjDets.CustListedSubstanceDfltName AS CustListedSubstanceDfltName,
  _ProdCmplncTskAffcdObjDets.CntntListedSubstanceDfltName AS CntntListedSubstanceDfltName,
  _ProdCmplncTskAffcdObjDets.SearchTerm1 AS SearchTerm1,
  _ProdCmplncTskAffcdObjDets.SearchTerm2 AS SearchTerm2,
  _ProdCmplncTskAffcdObjDets.OrganizationBPName1 AS OrganizationBPName1,
  _ProdCmplncTskAffcdObjDets.OrganizationBPName2 AS OrganizationBPName2,
  _ProdCmplncTskAffcdObjDets.OrganizationBPName3 AS OrganizationBPName3,
  _ProdCmplncTskAffcdObjDets.OrganizationBPName4 AS OrganizationBPName4,
  _ProdCmplncTskAffcdObjDets.ChmlCmpstnProductName AS ChmlCmpstnProductName,
  _ProdCmplncTskAffcdObjDets.CmplRqRsltProductName AS CmplRqRsltProductName,
  _ProdCmplncTskAffcdObjDets.Material AS Material,
  _ProdCmplncTskAffcdObjDets.ChmlCmpstnMaterial AS ChmlCmpstnMaterial,
  _ProdCmplncTskAffcdObjDets.CmplRqRsltMaterial AS CmplRqRsltMaterial,
  _ProdCmplncTskAffcdObjDets.ProdCmplncProductOrCompName AS ProdCmplncProductOrCompName,
  _CmplRqVers.CmplRqVersName AS CmplRqVersName,
  _CmplRqVers.CmplRqVersEnglishName AS CmplRqVersEnglishName,
  _CmplRqVers._CmplRqVersTextInCurrentLang.CmplRqVersName AS CmplRqRsltVersName,
  _CmplRqVers.ComplianceRequirement AS ComplianceRequirement
FROM I_ProdCmplncTaskTP
LEFT OUTER JOIN I_ProdCmplncTaskTypeText AS _ProdCmplncTaskTypeText ON ProdCmplncTaskType = _ProdCmplncTaskTypeText.ProdCmplncTaskType AND _ProdCmplncTaskTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProdCmplncTaskProcStatusTxt AS _ProdCmplncTaskProcStatusTxt ON ProdCmplncTaskProcgStatus = _ProdCmplncTaskProcStatusTxt.ProdCmplncTaskProcgStatus AND _ProdCmplncTaskProcStatusTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN P_ProdCmplncTskAffcdObjDets AS _ProdCmplncTskAffcdObjDets ON ProdCmplncTaskUUID = _ProdCmplncTskAffcdObjDets.ProdCmplncTaskUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVers ON ProdCmplncTaskRefObjUUID = _CmplRqVers.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN C_ProdCmplncTaskEventsInfo AS _ProdCmplncTaskEventsInfo ON ProdCmplncTaskUUID = _ProdCmplncTaskEventsInfo.ProdCmplncTaskUUID  -- association [1..*]
;