I_MDQltyRuleMiningField

DDL: I_MDQLTYRULEMININGFIELD SQL: IMDQLTYMNNGFLD Type: view BASIC

Master Data Quality Mining Field

I_MDQltyRuleMiningField is a Basic CDS View that provides data about "Master Data Quality Mining Field" in SAP S/4HANA. It reads from 2 data sources (mdc_model_fields, mdc_modelcfields) and exposes 10 fields with key fields MDQltyModelTable, MDQltyModelField. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
mdc_model_fields mdc_fld left_outer
mdc_modelcfields mdc_fld_cust left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MDQltyModelFieldText _MDQltyModelFieldText $projection.MDQltyModelField = _MDQltyModelFieldText.MDQltyModelField and $projection.MDQltyModelTable = _MDQltyModelFieldText.MDQltyModelTable and _MDQltyModelFieldText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMDQLTYMNNGFLD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Master Data Quality Mining Field view
Search.searchable true view
AbapCatalog.preserveKey true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MDQltyModelTable MDQltyModelTable Table
KEY MDQltyModelField ddic fieldname Field
MDQltyBusinessObjectTypeCode MDQltyBusinessObjectTypeCode Bus. Obj. Type
ABAPDictionaryDataType ddic datatype Field Type
MDQltyModelFieldIsTableKey ddic keyflag Key field
MDQltyModelTableIsRootTable MDQltyModelTableIsRootTable
ABAPDataElement ddic rollname Repr. Data Elem
MDQltyModelFieldIsSelective mdc_model_fields selective Selective
_MDQltyModelFieldText _MDQltyModelFieldText
_MDQltyModelTableT _MDQltyModelTableT

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_MDQltyRuleMiningField.
-- 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: IMDQLTYMNNGFLD

CREATE VIEW I_MDQltyRuleMiningField AS
SELECT
  MDQltyModelTable,
  ddic.fieldname AS MDQltyModelField,
  MDQltyBusinessObjectTypeCode,
  ddic.datatype AS ABAPDictionaryDataType,
  ddic.keyflag AS MDQltyModelFieldIsTableKey,
  MDQltyModelTableIsRootTable,
  ddic.rollname AS ABAPDataElement,
  mdc_fld.selective AS MDQltyModelFieldIsSelective
LEFT OUTER JOIN mdc_model_fields AS mdc_fld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mdc_modelcfields AS mdc_fld_cust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDQltyModelFieldText AS _MDQltyModelFieldText ON MDQltyModelField = _MDQltyModelFieldText.MDQltyModelField AND MDQltyModelTable = _MDQltyModelFieldText.MDQltyModelTable AND _MDQltyModelFieldText.Language = $session.system_language  -- association [0..1]
;