I_MDQltyBusinessRuleDetails

DDL: I_MDQLTYBUSINESSRULEDETAILS Type: view_entity BASIC
9 Fields 1 Data Sources 1 Associations

Master Data Quality Business Rule Details

I_MDQltyBusinessRuleDetails is a Basic CDS View that provides data about "Master Data Quality Business Rule Details" in SAP S/4HANA. It reads from 1 data source (mdq_rule_defd) and exposes 9 fields with key field MDQualityBusinessRuleUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mdq_rule_defd mdq_rule_defd from

Associations (1)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MDQualityBusinessRuleUUID view
Analytics.technicalName IMDQBSRULEDETS view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Master Data Quality Business Rule Details view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MDQualityBusinessRuleUUID mdqualitybusinessruleuuid Rule UUID
MDQltyBusinessRuleDescription mdqltybusinessruledescription Description
MDQltyBusRuleScopeDescription mdqltybusrulescopedescription Scope
MDQltyBusRuleBusRsnDescription mdqltybusrulebusrsndescription Business Reason
MDQltyBusRuleDetailsURL mdqltybusruledetailsurl Rule URL
MDQltyBusRuleDetailsURLText mdqltybusruledetailsurltext Rule URL Text
MDQltyBusRuleDataOwnerText mdqltybusruledataownertext Data Owner
MDQltyBusRuleBusContactText mdqltybusrulebuscontacttext Business Contact
_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_MDQltyBusinessRuleDetails.
-- 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_MDQltyBusinessRuleDetails AS
SELECT
  MDQualityBusinessRuleUUID,
  MDQltyBusinessRuleDescription,
  MDQltyBusRuleScopeDescription,
  MDQltyBusRuleBusRsnDescription,
  MDQltyBusRuleDetailsURL,
  MDQltyBusRuleDetailsURLText,
  MDQltyBusRuleDataOwnerText,
  MDQltyBusRuleBusContactText
FROM mdq_rule_defd
LEFT OUTER JOIN I_MDQualityBusinessRule AS _MDQualityBusinessRule ON MDQualityBusinessRuleUUID = _MDQualityBusinessRule.MDQualityBusinessRuleUUID  -- association [1..1]
;

Learn More