C_ProdCmplncEventTP

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_ProdCmplncEventTP.
-- 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_ProdCmplncEventTP AS
SELECT
  ProdCmplncEventUUID,
  ProdCmplncEventType,
  _ProdCmplncEventTypeTxt.ProdCmplncEventTypeText AS ProdCmplncEventTypeSearchTxt,
  cast('' as text1024) AS ProdCmplncEventTypeText,
  ProdCmplncEventSourceType,
  ProdCmplncEventProcgStatus,
  cast (_ProdCmplncEventProcStatusTxt.ProdCmplncEventProcgStsText as ehfnd_pce_evt_proc_stat_text preserving type ) AS ProdCmplncEventProcgStsText,
  _ProdCmplncEventProcStatusTxt.ProdCmplncEventProcgStsCritlty AS ProdCmplncEventProcgStsCritlty,
  LastChangeDateTime,
  CreatedByUser,
  ProdCmplncEventSourceUUID,
  _ProdCmplncEventSourceTypeTxt.ProdCmplncEventSrceTypeText AS ProdCmplncEventSrceTypeText,
  cast('' as text1024) AS ProdCmplncEventSourceObjId,
  cast('' as text1024) AS ProdCmplncEventSourceObjName,
  cast('' as text1024) AS ObjectLinkURL,
  cast('' as abap.char( 35 )) AS ProdCmplncEventIconType,
  ProdCmplncEventNmbrOfAttempts,
  cast ( ApplicationLogHandle as abap.sstring(22) ) AS ApplicationLogHandle,
  _InitiatingObjectDetails.CmplncPrpsName AS CmplncPrpsName,
  _InitiatingObjectDetails.CmplncPrps AS CmplncPrps,
  _InitiatingObjectDetails.CmplRqVers AS CmplRqVers,
  _InitiatingObjectDetails.CmplRqVersEnglishName AS CmplRqVersEnglishName,
  _InitiatingObjectDetails.CmplRqRsltVersName AS CmplRqRsltVersName,
  _InitiatingObjectDetails.CmplRqVersID AS CmplRqVersID,
  _InitiatingObjectDetails.ComplianceRequirement AS ComplianceRequirement,
  _InitiatingObjectDetails.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  _InitiatingObjectDetails.ProductName AS ProductName,
  _InitiatingObjectDetails.Material AS Material,
  _InitiatingObjectDetails.Specification AS Specification,
  _InitiatingObjectDetails.ChmlCmpstnCmplncInternalName AS ChmlCmpstnCmplncInternalName,
  _InitiatingObjectDetails.ChmlCmpstnProductName AS ChmlCmpstnProductName,
  _InitiatingObjectDetails.ChmlCmpstnMaterial AS ChmlCmpstnMaterial,
  _InitiatingObjectDetails.ChmlCmpstnChmlCmplncInfoSpec AS ChmlCmpstnChmlCmplncInfoSpec,
  _InitiatingObjectDetails.CmplRqRsltProductName AS CmplRqRsltProductName,
  _InitiatingObjectDetails.CmplRqRsltMaterial AS CmplRqRsltMaterial,
  _InitiatingObjectDetails.CmplRqRsltChmlCmplncInfoSpec AS CmplRqRsltChmlCmplncInfoSpec,
  _InitiatingObjectDetails.CmplRqRsltSuplrMatlIntName AS CmplRqRsltSuplrMatlIntName,
  _InitiatingObjectDetails.CmplRqRsltFirstName AS CmplRqRsltFirstName,
  _InitiatingObjectDetails.CmplRqRsltLastName AS CmplRqRsltLastName,
  _InitiatingObjectDetails.CmplRqRsltOrgBPName1 AS CmplRqRsltOrgBPName1,
  _InitiatingObjectDetails.CmplRqRsltOrgBPName2 AS CmplRqRsltOrgBPName2,
  _InitiatingObjectDetails.CmplRqRsltGroupBPName1 AS CmplRqRsltGroupBPName1,
  _InitiatingObjectDetails.CmplRqRsltGroupBPName2 AS CmplRqRsltGroupBPName2,
  _InitiatingObjectDetails.CmplRqRsltSuplrMatlMaterial AS CmplRqRsltSuplrMatlMaterial,
  _InitiatingObjectDetails.CmplRqRsltChmlSuplrMatlSpec AS CmplRqRsltChmlSuplrMatlSpec,
  _InitiatingObjectDetails.CmplRqRsltCustLstdSubstName AS CmplRqRsltCustLstdSubstName,
  _InitiatingObjectDetails.CmplRqRsltCntntLstdSubstName AS CmplRqRsltCntntLstdSubstName,
  _InitiatingObjectDetails.CmplRqRsltSubstanceSpec AS CmplRqRsltSubstanceSpec,
  _InitiatingObjectDetails.CmplRqRsltCustLstdSubst AS CmplRqRsltCustLstdSubst,
  _InitiatingObjectDetails.CmplRqRsltCntntLstdSubst AS CmplRqRsltCntntLstdSubst,
  _InitiatingObjectDetails.CmplRqRsltCmplRq AS CmplRqRsltCmplRq,
  _InitiatingObjectDetails.CompanySubstanceName AS CompanySubstanceName,
  _InitiatingObjectDetails.CustListedSubstanceDfltName AS CustListedSubstanceDfltName,
  _InitiatingObjectDetails.CntntListedSubstanceDfltName AS CntntListedSubstanceDfltName,
  _InitiatingObjectDetails.SubstanceSpecification AS SubstanceSpecification,
  _InitiatingObjectDetails.CustListedSubstance AS CustListedSubstance,
  _InitiatingObjectDetails.CntntListedSubstance AS CntntListedSubstance,
  _InitiatingObjectDetails.ChmlSuplrMatlChmCmInProdName AS ChmlSuplrMatlChmCmInProdName,
  _InitiatingObjectDetails.ChmlSuplrMatlChmCmInIntName AS ChmlSuplrMatlChmCmInIntName,
  _InitiatingObjectDetails.OrganizationBPName1 AS OrganizationBPName1,
  _InitiatingObjectDetails.OrganizationBPName2 AS OrganizationBPName2,
  _InitiatingObjectDetails.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _InitiatingObjectDetails.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _InitiatingObjectDetails.ChmlSuplrMatlMaterial AS ChmlSuplrMatlMaterial,
  _InitiatingObjectDetails.ChmlSuplrMatlChmCmInSpec AS ChmlSuplrMatlChmCmInSpec,
  NmbrOfProdCmplncTasksInPrgrs,
  NmbrOfProdCmplncTasksCompleted,
  NmbrOfProdCmplncTasksFailed,
  _ProdCmplncEvtCntctCard.FirstName AS FirstName,
  _ProdCmplncEvtCntctCard.LastName AS LastName,
  _ProdCmplncEvtCntctCard.FullName AS FullName
FROM I_ProdCmplncEventTP AS _ProdCmplncEventTP
LEFT OUTER JOIN P_ProdCmplncEvtInitObjDets AS _InitiatingObjectDetails ON ProdCmplncEventUUID = _InitiatingObjectDetails.ProdCmplncEventUUID  -- association [1..1]
LEFT OUTER JOIN C_ProdCmplncEventTasksInfo AS _ProdCmplncEvtTaskInfo ON ProdCmplncEventUUID = _ProdCmplncEvtTaskInfo.ProdCmplncEventUUID  -- association [1..*]
LEFT OUTER JOIN I_ProdCmplncEventTypeTxt AS _ProdCmplncEventTypeTxt ON ProdCmplncEventType = _ProdCmplncEventTypeTxt.ProdCmplncEventType AND _ProdCmplncEventTypeTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProdCmplncEventSourceTypeTxt AS _ProdCmplncEventSourceTypeTxt ON ProdCmplncEventSourceType = _ProdCmplncEventSourceTypeTxt.ProdCmplncEventSourceType AND _ProdCmplncEventSourceTypeTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProdCmplncEventProcStatusTxt AS _ProdCmplncEventProcStatusTxt ON ProdCmplncEventProcgStatus = _ProdCmplncEventProcStatusTxt.ProdCmplncEventProcgStatus AND _ProdCmplncEventProcStatusTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProdCmplncEvtCntctCard AS _ProdCmplncEvtCntctCard ON CreatedByUser = _ProdCmplncEvtCntctCard.ContactCardID  -- association [1..1]
;