C_MDQltyProdDimnCatRuleScore

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_MDQltyProdDimnCatRuleScore.
-- 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: CSCOREDIMCATRUL

CREATE VIEW C_MDQltyProdDimnCatRuleScore AS
SELECT
  _MDQltyDimnRuleAssgmtImpact.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQltyDimnRuleAssgmtImpact.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQltyDimnRuleAssgmt._MDQltyDimensionCategory.MDQltyDimensionCategory AS MDQltyDimensionCategory,
  _MDQltyDimnRuleAssgmt._MDQltyDimension.MDQltyDimension AS MDQltyDimension,
  _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionUUID AS MDQltyDimensionUUID,
  _MDQltyDimnRuleAssgmtImpact.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _MDQltyDimnRuleAssgmtImpact.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  _MDQltyProdScoreEvalDetails.MDChgProcessIsLatest AS MDChgProcessIsLatest,
  _MDQltyProdScoreEvalDetails.MDChgProcessFinishDateTime AS MDChgProcessFinishDateTime,
  tstmp_to_dats(_MDQltyProdScoreEvalDetails.MDChgProcessFinishDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as MDChgProcessFinishDate AS clientNULLasMDChgProcessFinishDate,
  _MasterDataChangeProcess.MDChgProcessFinishTime AS MDChgProcessFinishTime,
  _MasterDataChangeProcess.MDChgProcessDescription AS MDChgProcessDescription,
  fltp_to_dec(MDQltyRuleScore as abap.dec(4,1)) AS MDQltyRuleScore,
  fltp_to_dec(_MDQltyDimensionScore.MDQltyDimensionScore as abap.dec(4,1)) AS MDQltyDimensionScore,
  fltp_to_dec(_MDQltyDimnCatScore.MDQltyDimnCategoryScore as abap.dec(4,1)) AS MDQltyDimnCategoryScore,
  _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionCategoryUUID AS MDQltyDimensionCategoryUUID,
  _MDQltyDimnRuleAssgmtImpact.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  _MDQltyDimnRuleAssgmtImpact.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQltyBusinessRuleBaseTableT.MDQltyBusinessRuleBaseTabName AS MDQltyBusinessRuleBaseTabName,
  _MDQltyDimensionCategory.MDQltyEvalTargetThreshold AS MDQltyEvalCatTargetThreshold,
  _MDQltyDimensionCategory.MDQltyEvalWarningThreshold AS MDQltyEvalCatWarningThreshold,
  _MDQltyDimensionCategory.MDQltyEvalCriticalThreshold AS MDQltyEvalCatCriticalThreshold,
  _MDQltyDimension.MDQltyEvalTargetThreshold AS MDQltyEvalDimnTargetThreshold,
  _MDQltyDimension.MDQltyEvalWarningThreshold AS MDQltyEvalDimnWrngThreshold,
  _MDQltyDimension.MDQltyEvalCriticalThreshold AS MDQltyEvalDimnCritlThreshold,
  _MDQltyDimnRuleAssgmtImpact._MDQualityBusinessRule AS _MDQualityBusinessRule
FROM I_MDQltyDimnRuleAssgmtImpact AS _MDQltyDimnRuleAssgmtImpact
INNER JOIN I_MDQltyDimnRuleAssgmt AS _MDQltyDimnRuleAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN C_MDQltyProdScoreEvalDetails AS _MDQltyProdScoreEvalDetails 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 C_MDQltyBusinessRuleVH AS _MDQltyProductBusinessRuleVH ON _MDQltyProductBusinessRuleVH.MDQualityBusinessRule = MDQualityBusinessRule AND _MDQltyProductBusinessRuleVH.MDQltyBusinessObjectTypeCode = '194'  -- association [1..1]
LEFT OUTER JOIN I_MDQltyDimension AS _MDQltyDimension ON _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionUUID = _MDQltyDimension.MDQltyDimensionUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyDimensionCategory AS _MDQltyDimensionCategory ON _MDQltyDimensionCategory.MDQltyDimensionCategoryUUID = _MDQltyDimnRuleAssgmtImpact.MDQltyDimensionCategoryUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyBusinessRuleBaseTableT AS _MDQltyBusinessRuleBaseTableT ON _MDQltyDimnRuleAssgmtImpact.MDQltyBusinessRuleBaseTable = _MDQltyBusinessRuleBaseTableT.MDQltyBusinessRuleBaseTable AND _MDQltyBusinessRuleBaseTableT.MDQltyBusinessObjectTypeCode = '194' AND _MDQltyBusinessRuleBaseTableT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
;