I_MDQualityEvaluationSetting

DDL: I_MDQUALITYEVALUATIONSETTING SQL: IMDQEVALSETTING Type: view BASIC

Master Data Quality Evaluation Setting

I_MDQualityEvaluationSetting is a Basic CDS View that provides data about "Master Data Quality Evaluation Setting" in SAP S/4HANA. It reads from 1 data source (mdq_eval_setting) and exposes 16 fields with key field MDQualityEvaluationSetting. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mdq_eval_setting mdq_eval_setting from

Associations (7)

CardinalityTargetAliasCondition
[0..*] I_MDQltyEvaluationSettingText _Text $projection.MDQualityEvaluationSetting = _Text.MDQualityEvaluationSetting
[0..*] I_MDQltyRuleRepositoryText _RuleRepositoryText $projection.MDQltyRuleRepository = _RuleRepositoryText.MDQltyRuleRepository
[1] I_MDQualityRuleRepository _RuleRepository $projection.MDQltyRuleRepository = _RuleRepository.MDQltyRuleRepository
[1] I_User _MDQltyEvalSttgCrtedByUsrName $projection.MDQltyEvalSettingCreatedByUser = _MDQltyEvalSttgCrtedByUsrName.UserID
[1] I_User _MDQltyEvalSttgLastChgByUsr $projection.MDQltyEvalSttgLastChgByUsr = _MDQltyEvalSttgLastChgByUsr.UserID
[0..*] I_MDQualityDataProviderText _DataProviderText $projection.MDQltyEvalSettingDataProvider = _DataProviderText.MDQualityDataProvider
[0..*] I_MDQltyDataImportTypeText _DataImportTypeText $projection.MDQltyEvalSettingImportType = _DataImportTypeText.MDQltyDataImportType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDQEVALSETTING view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey MDQualityEvaluationSetting view
EndUserText.label Master Data Quality Evaluation Setting view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MDQualityEvaluationSetting mdq_eval_setting evaluation_setting Evaluation Setting
MDQltyRuleRepository mdq_eval_setting rule_repository Rule Repository
MDQltyEvalSettingImportType mdq_eval_setting import_type Import Type
MDQltyEvalSettingDataProvider mdq_eval_setting data_provider Data Provider
MDQltyEvalSttgDataPrvdrSttg mdq_eval_setting data_provider_setting Provider Settings
MDQltyEvalSettingCreatedByUser mdq_eval_setting created_by Version Created By
MDQltyEvalSttgCrtnUTCDteTme mdq_eval_setting created_on Variant created on
MDQltyEvalSttgLastChgByUsr mdq_eval_setting changed_by User Name
MDQltyEvalSttgLastChgUTCDteTme mdq_eval_setting changed_on Variant Changed on
_MDQltyEvalSttgCrtedByUsrName _MDQltyEvalSttgCrtedByUsrName
_MDQltyEvalSttgLastChgByUsr _MDQltyEvalSttgLastChgByUsr
_Text _Text
_RuleRepositoryText _RuleRepositoryText
BusinessObjectType _RuleRepository BusinessObjectType Object Type
_DataProviderText _DataProviderText
_DataImportTypeText _DataImportTypeText

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_MDQualityEvaluationSetting.
-- 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: IMDQEVALSETTING

CREATE VIEW I_MDQualityEvaluationSetting AS
SELECT
  mdq_eval_setting.evaluation_setting AS MDQualityEvaluationSetting,
  mdq_eval_setting.rule_repository AS MDQltyRuleRepository,
  mdq_eval_setting.import_type AS MDQltyEvalSettingImportType,
  mdq_eval_setting.data_provider AS MDQltyEvalSettingDataProvider,
  mdq_eval_setting.data_provider_setting AS MDQltyEvalSttgDataPrvdrSttg,
  mdq_eval_setting.created_by AS MDQltyEvalSettingCreatedByUser,
  mdq_eval_setting.created_on AS MDQltyEvalSttgCrtnUTCDteTme,
  mdq_eval_setting.changed_by AS MDQltyEvalSttgLastChgByUsr,
  mdq_eval_setting.changed_on AS MDQltyEvalSttgLastChgUTCDteTme,
  _RuleRepository.BusinessObjectType AS BusinessObjectType
FROM mdq_eval_setting
LEFT OUTER JOIN I_MDQltyEvaluationSettingText AS _Text ON MDQualityEvaluationSetting = _Text.MDQualityEvaluationSetting  -- association [0..*]
LEFT OUTER JOIN I_MDQltyRuleRepositoryText AS _RuleRepositoryText ON MDQltyRuleRepository = _RuleRepositoryText.MDQltyRuleRepository  -- association [0..*]
LEFT OUTER JOIN I_MDQualityRuleRepository AS _RuleRepository ON MDQltyRuleRepository = _RuleRepository.MDQltyRuleRepository  -- association [1]
LEFT OUTER JOIN I_User AS _MDQltyEvalSttgCrtedByUsrName ON MDQltyEvalSettingCreatedByUser = _MDQltyEvalSttgCrtedByUsrName.UserID  -- association [1]
LEFT OUTER JOIN I_User AS _MDQltyEvalSttgLastChgByUsr ON MDQltyEvalSttgLastChgByUsr = _MDQltyEvalSttgLastChgByUsr.UserID  -- association [1]
LEFT OUTER JOIN I_MDQualityDataProviderText AS _DataProviderText ON MDQltyEvalSettingDataProvider = _DataProviderText.MDQualityDataProvider  -- association [0..*]
LEFT OUTER JOIN I_MDQltyDataImportTypeText AS _DataImportTypeText ON MDQltyEvalSettingImportType = _DataImportTypeText.MDQltyDataImportType  -- association [0..*]
;