C_MDQualityImportedRuleData

DDL: C_MDQUALITYIMPORTEDRULEDATA SQL: CMDQIMPRULEDATA Type: view CONSUMPTION
15 Fields 1 Data Sources 3 Associations

Master Data Quality Imported Rule Data

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

Data Sources (1)

SourceAliasJoin Type
I_MDQualityImportedRuleData I_MDQualityImportedRuleData from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MDQltyImportedRuleDataText _RuleDataText $projection.MDQltyRuleRepository = _RuleDataText.MDQltyRuleRepository and $projection.MDQualityRule = _RuleDataText.MDQualityRule and $projection.MDQualityRuleVersion = _RuleDataText.MDQualityRuleVersion and _RuleDataText.Language = $session.system_language
[0..1] I_MDQltyRuleVersionValdtyText _RuleVersionValidityText $projection.MDQualityRuleVersionIsCurrent = _RuleVersionValidityText.MDQualityRuleVersionIsCurrent and _RuleVersionValidityText.Language = $session.system_language
[1] I_MDQualityRuleRepository _RuleRepository $projection.MDQltyRuleRepository = _RuleRepository.MDQltyRuleRepository

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMDQIMPRULEDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED 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 #CONSUMPTION view
Search.searchable true view
UI.headerInfo.typeName Imported Rule view
UI.headerInfo.typeNamePlural Imported Rules view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MDQltyRuleRepository I_MDQualityImportedRuleData MDQltyRuleRepository Rule Repository
KEY MDQualityRule I_MDQualityImportedRuleData MDQualityRule Rule
KEY MDQualityRuleVersion I_MDQualityImportedRuleData MDQualityRuleVersion XML Vers.
MDQualityRuleURL I_MDQualityImportedRuleData MDQualityRuleURL URLContract
MDQualityExternalRuleVersion I_MDQualityImportedRuleData MDQualityExternalRuleVersion External Rule Version
MDQualityRuleCrtnUTCDateTime I_MDQualityImportedRuleData MDQualityRuleCrtnUTCDateTime Variant created on
MDQualityRuleCreatedBy I_MDQualityImportedRuleData MDQualityRuleCreatedBy Version Created By
MDQualityRuleCreatedByUsrName
MDQualityRuleVersionIsCurrent I_MDQualityImportedRuleData MDQualityRuleVersionIsCurrent Version Validity
MDQualityRuleVersionValidity _RuleVersionValidityText MDQualityRuleVersionValidity
MDQualityRuleDesc _RuleDataText MDQualityRuleDesc
MDQualityRuleLongText _RuleDataText MDQualityRuleLongText
_RuleDataText _RuleDataText
_RuleVersionValidityText _RuleVersionValidityText
_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 C_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: CMDQIMPRULEDATA

CREATE VIEW C_MDQualityImportedRuleData AS
SELECT
  I_MDQualityImportedRuleData.MDQltyRuleRepository AS MDQltyRuleRepository,
  I_MDQualityImportedRuleData.MDQualityRule AS MDQualityRule,
  I_MDQualityImportedRuleData.MDQualityRuleVersion AS MDQualityRuleVersion,
  I_MDQualityImportedRuleData.MDQualityRuleURL AS MDQualityRuleURL,
  I_MDQualityImportedRuleData.MDQualityExternalRuleVersion AS MDQualityExternalRuleVersion,
  I_MDQualityImportedRuleData.MDQualityRuleCrtnUTCDateTime AS MDQualityRuleCrtnUTCDateTime,
  I_MDQualityImportedRuleData.MDQualityRuleCreatedBy AS MDQualityRuleCreatedBy,
  I_MDQualityImportedRuleData._User.UserDescription AS MDQualityRuleCreatedByUsrName,
  I_MDQualityImportedRuleData.MDQualityRuleVersionIsCurrent AS MDQualityRuleVersionIsCurrent,
  _RuleVersionValidityText.MDQualityRuleVersionValidity AS MDQualityRuleVersionValidity,
  _RuleDataText.MDQualityRuleDesc AS MDQualityRuleDesc,
  _RuleDataText.MDQualityRuleLongText AS MDQualityRuleLongText
FROM I_MDQualityImportedRuleData
LEFT OUTER JOIN I_MDQltyImportedRuleDataText AS _RuleDataText ON MDQltyRuleRepository = _RuleDataText.MDQltyRuleRepository AND MDQualityRule = _RuleDataText.MDQualityRule AND MDQualityRuleVersion = _RuleDataText.MDQualityRuleVersion AND _RuleDataText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MDQltyRuleVersionValdtyText AS _RuleVersionValidityText ON MDQualityRuleVersionIsCurrent = _RuleVersionValidityText.MDQualityRuleVersionIsCurrent AND _RuleVersionValidityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MDQualityRuleRepository AS _RuleRepository ON MDQltyRuleRepository = _RuleRepository.MDQltyRuleRepository  -- association [1]
;

Learn More