I_MDQualityRuleMapping

DDL: I_MDQUALITYRULEMAPPING Type: view_entity BASIC Package: MDQ_PF_RULE_ENGINE_VAL
12 Fields 2 Data Sources 1 Associations

Master Data Quality Rule Mapping

I_MDQualityRuleMapping is a Basic CDS View that provides data about "Master Data Quality Rule Mapping" in SAP S/4HANA. It reads from 2 data sources (mdq_brf_rule_map, mdq_brf_rule_usg) and exposes 12 fields with key field MDQualityBusinessRuleUUID. It has 1 association to related views. Part of development package MDQ_PF_RULE_ENGINE_VAL.

Data Sources (2)

SourceAliasJoin Type
mdq_brf_rule_map mdq_brf_rule_map from
mdq_brf_rule_usg mdq_brf_rule_usg union

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MDQualityBusinessRule_2 _MDQualityBusinessRule $projection.MDQualityBusinessRuleUUID = _MDQualityBusinessRule.MDQualityBusinessRuleUUID

Annotations (9)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey MDQualityBusinessRuleUUID view
Analytics.technicalName MDQLTYRULMAP view
VDM.viewType #BASIC view
EndUserText.label Master Data Quality Rule Mapping view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MDQualityBusinessRuleUUID rule_uuid Rule UUID
MDQltyTechnicalRuleUUID brfplus_rule_uuid BRFPlus UUID
MDQltyTechnicalRuleScopeUUID brfplus_rule_scp_uuid BRFPlus UUID
MDQltyTechnicalRuleCndnUUID brfplus_rule_con_uuid BRFPlus UUID
MDQltyTechRuleScpDcsnTblUUID brfplus_rule_sdt_uuid BRFPlus UUID
MDQltyTechRuleCndnDcsnTblUUID brfplus_rule_cdt_uuid BRFPlus UUID
MDQltyTechnicalRuleUUID brfplus_rule_uuid BRFPlus UUID
MDQltyTechnicalRuleScopeUUID brfplus_rule_scp_uuid BRFPlus UUID
MDQltyTechnicalRuleCndnUUID brfplus_rule_con_uuid BRFPlus UUID
MDQltyTechRuleScpDcsnTblUUID brfplus_rule_sdt_uuid BRFPlus UUID
MDQltyTechRuleCndnDcsnTblUUID brfplus_rule_cdt_uuid BRFPlus UUID
_MDQualityBusinessRule _MDQualityBusinessRule

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_MDQualityRuleMapping.
-- 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_MDQualityRuleMapping AS
SELECT
  rule_uuid AS MDQualityBusinessRuleUUID,
  brfplus_rule_uuid AS MDQltyTechnicalRuleUUID,
  brfplus_rule_scp_uuid AS MDQltyTechnicalRuleScopeUUID,
  brfplus_rule_con_uuid AS MDQltyTechnicalRuleCndnUUID,
  brfplus_rule_sdt_uuid AS MDQltyTechRuleScpDcsnTblUUID,
  brfplus_rule_cdt_uuid AS MDQltyTechRuleCndnDcsnTblUUID
FROM mdq_brf_rule_map
LEFT OUTER JOIN I_MDQualityBusinessRule_2 AS _MDQualityBusinessRule ON MDQualityBusinessRuleUUID = _MDQualityBusinessRule.MDQualityBusinessRuleUUID  -- association [1..1]
-- UNION with additional select branch(es): mdq_brf_rule_usg
;

Learn More