I_ChmlCmplncMktKeyFig

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 I_ChmlCmplncMktKeyFig.
-- 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 I_ChmlCmplncMktKeyFig AS
SELECT
  _ChmlCmplncInfo.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  cast(_RelatedPPCount.CountRelPP as ehpma_number_of_pp preserving type ) AS NmbrOfChmlCmplncPckgdProducts,
  cast(_CoverageCt.recordCount as ehpma_number_of_countries preserving type ) AS NmbrOfChmlCmplncMktCountries,
  cast(_ComplReqCt.recordCount as ehfnd_cci_number_of_crr preserving type ) AS NmbrOfCmplRqRslts,
  cast(_ComplReqIpCt.recordCount as ehfnd_cci_number_of_crr_ip preserving type ) AS NmbrOfInProcessCmplRqRslts,
  cast(_ComplReqReCt.recordCount as ehfnd_cci_number_of_crr_re preserving type ) AS NmbrOfReleasedCmplRqRslts,
  case when _ComplReqReCt.recordCount = 0 or _ComplReqReCt.recordCount is null then 0 when _ComplReqCt.recordCount = 0 or _ComplReqCt.recordCount is null then 0 else ceil( cast( _ComplReqReCt.recordCount as float ) / cast( _ComplReqCt.recordCount as float ) * 100.0 - 0.5 ) end as ReleasedCmplRqRsltsPct AS 5endasReleasedCmplRqRsltsPct,
  case when _ComplReqIpCt.recordCount = 0 or _ComplReqIpCt.recordCount is null then 0 when _ComplReqCt.recordCount = 0 or _ComplReqCt.recordCount is null then 0 else ceil( cast( _ComplReqIpCt.recordCount as float ) / cast( _ComplReqCt.recordCount as float ) * 100.0 - 0.5 ) end as InProcessCmplRqRsltsPct AS 5endasInProcessCmplRqRsltsPct,
  ProdStewardshipRespUnit,
  MaterialIsSold,
  MaterialIsTransported,
  MaterialIsSourced,
  MaterialIsProduced,
  MaterialIsDisposed,
  MaterialIsEmissionRelevant
FROM I_ChmlCmplncInfo AS _ChmlCmplncInfo
LEFT OUTER JOIN P_ChmlCmplMktReqAndCovGrpSum AS _SumReqAndCov ON ChmlCmplncInfoUUID = _SumReqAndCov.chemicalcomplianceuuid  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplncInfoRelPPCt AS _RelatedPPCount ON ChmlCmplncInfoUUID = _RelatedPPCount.chemicalcomplianceproduuid  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplMktCovCt AS _CoverageCt ON ChmlCmplncInfoUUID = _CoverageCt.chemicalcomplianceuuid  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplRqRsltInProcCt AS _ComplReqIpCt ON ChmlCmplncInfoUUID = _ComplReqIpCt.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplRqRsltReldCt AS _ComplReqReCt ON ChmlCmplncInfoUUID = _ComplReqReCt.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplRqRsltCt AS _ComplReqCt ON ChmlCmplncInfoUUID = _ComplReqCt.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_OTRText AS _OTRText ON _OTRText.Language = $session.system_language  -- association [0..*]
;