I_MDQltyAnalyticScoresCube

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_MDQltyAnalyticScoresCube.
-- 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: MDQLTYANSCORES

CREATE VIEW I_MDQltyAnalyticScoresCube AS
SELECT
  _MDQltyDimnRuleAssgmtImpact.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQltyDimnRuleAssgmtImpact.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQltyDimnRuleAssgmt._MDQltyDimensionCategory.MDQltyDimensionCategory AS MDQltyDimensionCategory,
  _MDQltyDimnRuleAssgmt._MDQltyDimension.MDQltyDimension AS MDQltyDimension,
  _MDQltyDimnRuleAssgmtImpact.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionUUID AS MDQltyDimensionUUID,
  _MDQltyDimnRuleAssgmtImpact.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _MDQltyDimnRuleAssgmtImpact._MDQualityBusinessRule.MDQltyBusinessRuleOwner AS MDQltyBusinessRuleOwner,
  _MDQltyDimnRuleAssgmtImpact._MDQualityBusinessRule.MDQltyBusRuleCheckedField AS MDQltyBusRuleCheckedField,
  _MDQltyDimnRuleAssgmtImpact._MDQualityBusinessRule.MDQltyBusinessRuleExpert AS MDQltyBusinessRuleExpert,
  _MDQltyDimnRuleAssgmtImpact.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  tstmp_to_dats(_MDQltyScoreEvalDetails.MDChgProcessFinishDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') AS MDChgProcessFinishDate,
  _MDQltyScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  _MDQltyDimnRuleAssgmtImpact.MDQltyRuleScore AS MDQltyRuleScore,
  fltp_to_dec(_MDQltyDimensionScore.MDQltyDimensionScore as abap.dec(4,1)) AS MDQltyDimensionScore,
  _MDQltyDimension.MDQltyEvalTargetThreshold AS MDQltyDimnTargetScoreValue,
  _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionCategoryUUID AS MDQltyDimensionCategoryUUID,
  fltp_to_dec(_MDQltyDimnCatScore.MDQltyDimnCategoryScore as abap.dec(4,1)) AS MDQltyDimnCategoryScore,
  _MDQltyDimensionCategory.MDQltyEvalTargetThreshold AS MDQltyDimnCatTargetScoreValue
FROM I_MDQltyDimnRuleAssgmtImpact AS _MDQltyDimnRuleAssgmtImpact
INNER JOIN I_MDQltyDimnRuleAssgmt AS _MDQltyDimnRuleAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_MDQltyScoreEvalDetails AS _MDQltyScoreEvalDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDQltyDimensionScore AS _MDQltyDimensionScore ON MasterDataChangeProcess = _MDQltyDimensionScore.MasterDataChangeProcess AND _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionUUID = _MDQltyDimensionScore.MDQltyDimensionUUID  -- association [0..*]
LEFT OUTER JOIN I_MDQltyDimnCategoryScore AS _MDQltyDimnCatScore ON MasterDataChangeProcess = _MDQltyDimnCatScore.MasterDataChangeProcess AND _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionCategoryUUID = _MDQltyDimnCatScore.MDQltyDimensionCategoryUUID  -- association [0..*]
LEFT OUTER JOIN I_MDQltyDimension AS _MDQltyDimension ON _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionUUID = _MDQltyDimension.MDQltyDimensionUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyFioriLaunchpadHostPath AS _FldHost ON _FldHost.mandt = $session.client  -- association [0..1]
LEFT OUTER JOIN I_MDQltyDimensionCategory AS _MDQltyDimensionCategory ON _MDQltyDimensionCategory.MDQltyDimensionCategoryUUID = _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionCategoryUUID  -- association [1..1]
;