C_CmplRqRsltSubstSubLiChkTP

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_CmplRqRsltSubstSubLiChkTP.
-- 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: CCRRSUBSTSLCTP

CREATE VIEW C_CmplRqRsltSubstSubLiChkTP AS
SELECT
  CmplRqRslt.CmplRqRsltUUID AS CmplRqRsltUUID,
  CmplRqRslt.ActiveCmplRqRsltUUID AS ActiveCmplRqRsltUUID,
  CmplRqRslt.SubstanceUUID AS SubstanceUUID,
  CmplRqRslt.CmplRqVersUUID AS CmplRqVersUUID,
  CmplRqRslt.ComplianceRequirement AS ComplianceRequirement,
  cast(_ManualStatusVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type ) AS CmplRqRsltManualCmplncStsName,
  Processor,
  cast( '' as ad_namtext ) AS CmplRqRsltProcessorName,
  CmplRqRsltStatusRemark,
  cast( '' as ehfnd_sub_substance_name_ltd ) AS SubstanceName,
  cast( '' as ehfnd_chm_cas_no ) AS CASNumber,
  _CmplRqVers.CmplRqVersName AS CmplRqVersName,
  _CmplRqVersExemptionCount.CmplRqVersNmbrOfExemptions AS CmplRqVersNmbrOfExemptions,
  _CmplRqVersActionCount.CmplRqVersNmbrOfActions AS CmplRqVersNmbrOfActions,
  _CmplRqRsltListTypeExisting.CmplRqVersInvtryListIsExisting AS CmplRqVersInvtryListIsExisting,
  _CmplRqRsltListTypeExisting.CmplRqVersRstrcnListIsExisting AS CmplRqVersRstrcnListIsExisting,
  cast(_ManualStatusVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type) AS CmplRqRsltPrelimCmplncStsName,
  _ManualStatusVH.CmplRqRsltCmplncStsCriticality AS CmplRqRsltCmplncStsCriticality
FROM I_CmplRqRsltSubstListChkTP AS CmplRqRslt
LEFT OUTER JOIN C_SubstanceSubLiChkExmpTP AS _CmplRqRsltExemption ON CmplRqRsltUUID = _CmplRqRsltExemption.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltSubstListChkActnTP AS _CmplRqRsltSubstanceAction ON CmplRqRsltUUID = _CmplRqRsltSubstanceAction.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltSubLiChkActnInfoTP AS _CmplRqRsltActnInfo ON CmplRqRsltUUID = _CmplRqRsltActnInfo.CmplRqRsltUUID  -- association [0..1]
LEFT OUTER JOIN C_SubAsSubstSubLiChkInvtryList AS _SubAsSubstSubLiChkInvtryList ON ActiveCmplRqRsltUUID = _SubAsSubstSubLiChkInvtryList.CmplRqRsltSubstUUID  -- association [0..*]
LEFT OUTER JOIN C_SubAsSubstSubLiChkRstrcnList AS _SubAsSubstSubLiChkRstrcnList ON ActiveCmplRqRsltUUID = _SubAsSubstSubLiChkRstrcnList.CmplRqRsltSubstUUID  -- association [0..*]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVers ON CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqRsltCmplncStsSubstVH AS _ManualStatusVH ON CmplRqRsltManualStatus = _ManualStatusVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN P_CmplRqVersExemptionCount AS _CmplRqVersExemptionCount ON CmplRqVersUUID = _CmplRqVersExemptionCount.CmplRqVersUUID AND _CmplRqVersExemptionCount.ProdCmplncPhrsEnabledField = 'EHFND_CRR_SUB_EXM_PH_UUID'  -- association [0..1]
LEFT OUTER JOIN P_CmplRqVersActionCount AS _CmplRqVersActionCount ON CmplRqVersUUID = _CmplRqVersActionCount.CmplRqVersUUID AND _CmplRqVersActionCount.ProdCmplncPhrsEnabledField = 'EHFND_CRR_ACTION_PH_UUID'  -- association [0..1]
LEFT OUTER JOIN P_CmplRqRsltListTypeExisting AS _CmplRqRsltListTypeExisting ON ActiveCmplRqRsltUUID = _CmplRqRsltListTypeExisting.CmplRqRsltUUID  -- association [1..1]
;