I_MDQualityImportedRuleData

DDL: I_MDQUALITYIMPORTEDRULEDATA SQL: IMDQIMPRULEDATA Type: view BASIC
12 Fields 1 Data Sources 2 Associations

Master Data Quality Imported Rule Data

I_MDQualityImportedRuleData is a Basic CDS View that provides data about "Master Data Quality Imported Rule Data" in SAP S/4HANA. It reads from 1 data source (mdq_rule_data) and exposes 12 fields with key fields MDQltyRuleRepository, MDQualityRule, MDQualityRuleVersion. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mdq_rule_data mdq_rule_data from

Associations (2)

CardinalityTargetAliasCondition
[1] I_User _User $projection.MDQualityRuleCreatedBy = _User.UserID
[1] I_MDQualityRuleRepository _RuleRepository $projection.MDQltyRuleRepository = _RuleRepository.MDQltyRuleRepository

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMDQIMPRULEDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Master Data Quality Imported Rule Data view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MDQltyRuleRepository mdq_rule_data rule_repository Rule Repository
KEY MDQualityRule mdq_rule_data rule_id Rule ID
KEY MDQualityRuleVersion mdq_rule_data version XML Vers.
MDQualityRuleURL mdq_rule_data url URLContract
MDQualityRuleCrtnUTCDateTime mdq_rule_data created_on Variant created on
MDQualityRuleCreatedBy mdq_rule_data created_by Version Created By
MDQualityRuleLastChgUTCDteTme mdq_rule_data changed_on Variant Changed on
MDQualityRuleLastChgByUsr mdq_rule_data changed_by User Name
MDQualityRuleVersionIsCurrent mdq_rule_data is_current_version True
MDQualityExternalRuleVersion mdq_rule_data external_version External Version
_User _User
_RuleRepository _RuleRepository

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_MDQualityImportedRuleData.
-- 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: IMDQIMPRULEDATA

CREATE VIEW I_MDQualityImportedRuleData AS
SELECT
  mdq_rule_data.rule_repository AS MDQltyRuleRepository,
  mdq_rule_data.rule_id AS MDQualityRule,
  mdq_rule_data.version AS MDQualityRuleVersion,
  mdq_rule_data.url AS MDQualityRuleURL,
  mdq_rule_data.created_on AS MDQualityRuleCrtnUTCDateTime,
  mdq_rule_data.created_by AS MDQualityRuleCreatedBy,
  mdq_rule_data.changed_on AS MDQualityRuleLastChgUTCDteTme,
  mdq_rule_data.changed_by AS MDQualityRuleLastChgByUsr,
  mdq_rule_data.is_current_version AS MDQualityRuleVersionIsCurrent,
  mdq_rule_data.external_version AS MDQualityExternalRuleVersion
FROM mdq_rule_data
LEFT OUTER JOIN I_User AS _User ON MDQualityRuleCreatedBy = _User.UserID  -- association [1]
LEFT OUTER JOIN I_MDQualityRuleRepository AS _RuleRepository ON MDQltyRuleRepository = _RuleRepository.MDQltyRuleRepository  -- association [1]
;

Learn More