C_CmplRqRsltChmCmInSubChkTP

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_CmplRqRsltChmCmInSubChkTP.
-- 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: CCRRCCISLCTP

CREATE VIEW C_CmplRqRsltChmCmInSubChkTP AS
SELECT
  CmplRqRslt.ActiveCmplRqRsltUUID AS ActiveCmplRqRsltUUID,
  CmplRqRslt.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  CmplRqRslt.ChmlSuplrMatlUUID AS ChmlSuplrMatlUUID,
  CmplRqRslt.SubstanceUUID AS SubstanceUUID,
  CmplRqRslt.ChemicalCustomerMaterialUUID AS ChemicalCustomerMaterialUUID,
  CmplRqRslt.ComplianceRequirement AS ComplianceRequirement,
  cast(_CalculatedCmplncStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type) AS CmplRqRsltCalculatedStatusName,
  cast(_ManuallySetCmplncStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type) AS CmplRqRsltManualCmplncStsName,
  cast(_PreliminaryStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type) AS CmplRqRsltPrelimCmplncStsName,
  _PreliminaryStsVH.CmplRqRsltCmplncStsCriticality AS CmplRqRsltPrelimCmplncStsCritl,
  cast(_ReleasedCmplncStsVH._Text[1: Language = $session.system_language ].CmplRqRsltCmplncStsTxt as ehpma_crr_mkt_stat_text preserving type) AS CmplRqRsltReldCmplncStsName,
  _ReleasedCmplncStsVH.CmplRqRsltCmplncStsCriticality AS CmplRqRsltReldCmplncStsCritlty,
  cast( '' as ad_namtext ) AS CmplRqRsltProcessorName,
  cast( '' as ad_namtext ) AS ReleasedByUserName,
  _CmplRqRsltProcgStsTxt[1: Language = $session.system_language ].ProcessingStatusText AS CmplRqRsltProcessingStatusName,
  CmplRqRslt._ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  cast ( '' as ehfnd_cci_raw_material_name ) AS ChmlCmplncInfoCombinedMaterial,
  CmplRqRslt._ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  CmplRqRslt._ChmlCmplncInfo.ChmlCmplncProdIsResearched AS ChmlCmplncProdIsResearched,
  cast( '' as ehfnd_cci_is_sold ) AS MaterialIsSold,
  cast( '' as ehfnd_cci_is_transported ) AS MaterialIsTransported,
  cast( '' as ehfnd_cci_is_sourced ) AS MaterialIsSourced,
  cast( '' as ehfnd_cci_is_produced ) AS MaterialIsProduced,
  cast( '' as ehpma_application ) AS ChmlCmplncApplication,
  _CmplRqRsltChmlCmpstn.ChmlCompositionUUID AS ChmlCompositionUUID,
  _CmplRqRsltChmlCmpstn.MatlBsdCmpstnUUID AS MatlBsdCmpstnUUID,
  _CmplRqRsltChmlCmpstn.ChmlCompositionType AS ChmlCompositionType,
  cast( 0 as abap.int2 ) AS CmplRqVersNmbrOfCmplncStmnt,
  cast( '' as abap.char( 1 ) ) AS CmplRqVersInvtryListIsExisting,
  cast( '' as abap.char( 1 ) ) AS CmplRqVersRstrcnListIsExisting,
  cast( '' as abap.char( 1 ) ) AS CmplRqVersMntrgListIsExisting,
  cast( '' as abap.char( 1 ) ) AS CmplRqVersExmpListIsExisting,
  CmplRqRslt.ValidityStartDateTime AS ValidityStartDateTime,
  CmplRqRslt.ValidityEndDateTime AS ValidityEndDateTime
FROM I_CmplRqRsltSubstListChkTP AS CmplRqRslt
LEFT OUTER JOIN C_CmplRqRsltSubLiChkStmntTP AS _CmplRqRsltCmplncStmnt ON CmplRqRsltUUID = _CmplRqRsltCmplncStmnt.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltSubLiChkExmpTP AS _CmplRqRsltExemption ON CmplRqRsltUUID = _CmplRqRsltExemption.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN I_CmplRqRslt AS _ReleasedCmplRqRslt ON ChmlCmplncInfoUUID = _ReleasedCmplRqRslt.ChmlCmplncInfoUUID AND CmplRqVersUUID = _ReleasedCmplRqRslt.CmplRqVersUUID AND _ReleasedCmplRqRslt.CmplRqRsltProcessingStatus = 'RE'  -- association [0..1]
LEFT OUTER JOIN I_CmplRqRsltCalcdCmplncStsVH AS _CalculatedCmplncStsVH ON CmplRqRsltCalculatedStatus = _CalculatedCmplncStsVH.CmplRqRsltCmplncSts  -- association [1..1]
LEFT OUTER JOIN I_CmplncRqmtRsltCmplncStsVH AS _PreliminaryStsVH ON CmplRqRsltPrelimCmplncSts = _PreliminaryStsVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN I_CmplRqRsltProcgStsTxt AS _CmplRqRsltProcgStsTxt ON CmplRqRsltProcessingStatus = _CmplRqRsltProcgStsTxt.CmplRqRsltProcessingStatus  -- association [1..*]
LEFT OUTER JOIN I_CmplRqRsltMnlCmplncStsCalcVH AS _ManuallySetCmplncStsVH ON CmplRqRsltManualStatus = _ManuallySetCmplncStsVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN I_CmplncRqmtRsltCmplncStsVH AS _ReleasedCmplncStsVH ON CmplRqRsltReldCmplncSts = _ReleasedCmplncStsVH.CmplRqRsltCmplncSts  -- association [0..1]
LEFT OUTER JOIN I_CmplRqVersEnhanced AS _CmplRqVers ON CmplRqVersUUID = _CmplRqVers.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN C_SubAsChmCmInSubChkInvtryList AS _SubAsChmCmInSubChkInvtryList ON ActiveCmplRqRsltUUID = _SubAsChmCmInSubChkInvtryList.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_SubAsChmCmInSubChkRstrcnList AS _SubAsChmCmInSubChkRstrcnList ON ActiveCmplRqRsltUUID = _SubAsChmCmInSubChkRstrcnList.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_SubAsChmCmInSubChkMntrgList AS _SubAsChmCmInSubChkMntrgList ON ActiveCmplRqRsltUUID = _SubAsChmCmInSubChkMntrgList.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltRawMatlIssue AS _CmplRqRsltRawMatlIssue ON ActiveCmplRqRsltUUID = _CmplRqRsltRawMatlIssue.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_CmplRqRsltSuplrMatlAssmtSts AS _CmplRqRsltSuplrMatlAssmtSts ON ActiveCmplRqRsltUUID = _CmplRqRsltSuplrMatlAssmtSts.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN P_CmplRqRsltChmlCmpstn AS _CmplRqRsltChmlCmpstn ON ActiveCmplRqRsltUUID = _CmplRqRsltChmlCmpstn.CmplRqRsltUUID  -- association [1..1]
LEFT OUTER JOIN C_NmbrOfSubstAssmtByCritlty AS _NmbrOfSubstAssmtByCritlty ON ActiveCmplRqRsltUUID = _NmbrOfSubstAssmtByCritlty.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_NmbrOfRawMatlAssmtByCritlty AS _NmbrOfRawMatlAssmtByCritlty ON ActiveCmplRqRsltUUID = _NmbrOfRawMatlAssmtByCritlty.CmplRqRsltUUID  -- association [0..*]
LEFT OUTER JOIN C_NmbrOfSupMaAssmtByCritlty AS _NmbrOfSupMaAssmtByCritlty ON ActiveCmplRqRsltUUID = _NmbrOfSupMaAssmtByCritlty.CmplRqRsltUUID  -- association [0..*]
;