C_MDQltyProductTechnicalRule

DDL: C_MDQLTYPRODUCTTECHNICALRULE SQL: CMDQPRODTECHRULE Type: view CONSUMPTION
14 Fields 1 Data Sources

Master Data Quality Technical Rule for Product

C_MDQltyProductTechnicalRule is a Consumption CDS View that provides data about "Master Data Quality Technical Rule for Product" in SAP S/4HANA. It reads from 1 data source (I_MDQualityTechnicalRule) and exposes 14 fields with key field MDQualityBusinessRuleUUID.

Data Sources (1)

SourceAliasJoin Type
I_MDQualityTechnicalRule I_MDQualityTechnicalRule from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMDQPRODTECHRULE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey MDQualityBusinessRuleUUID view
VDM.viewType #CONSUMPTION view
EndUserText.label Master Data Quality Technical Rule for Product view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MDQualityBusinessRuleUUID MDQualityBusinessRuleUUID Rule UUID
MDQualityBusinessRule MDQualityBusinessRule Rule Definition ID
MDQltyBusinessObjectTypeCode MDQltyBusinessObjectTypeCode Bus. Obj. Type
MDQltyTechnicalRuleUUID MDQltyTechnicalRuleUUID
MDQltyTechnicalRuleScopeUUID MDQltyTechnicalRuleScopeUUID
MDQltyTechnicalRuleCndnUUID MDQltyTechnicalRuleCndnUUID
MDQltyTechnicalRuleScope MDQltyTechnicalRuleScope
MDQltyTechnicalRuleCondition MDQltyTechnicalRuleCondition
MDQltyTechnicalRuleScopeStatus MDQltyTechnicalRuleScopeStatus
MDQltyTechnicalRuleCndnStatus MDQltyTechnicalRuleCndnStatus
MDQltyTechRuleCndnCriticality MDQltyTechRuleCndnCriticality
MDQltyTechRuleScpCriticality MDQltyTechRuleScpCriticality
MDQltyTechRuleCndnStatusName MDQltyTechRuleCndnStatusName
MDQltyTechRuleScopeStatusName MDQltyTechRuleScopeStatusName

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_MDQltyProductTechnicalRule.
-- 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: CMDQPRODTECHRULE

CREATE VIEW C_MDQltyProductTechnicalRule AS
SELECT
  MDQualityBusinessRuleUUID,
  MDQualityBusinessRule,
  MDQltyBusinessObjectTypeCode,
  MDQltyTechnicalRuleUUID,
  MDQltyTechnicalRuleScopeUUID,
  MDQltyTechnicalRuleCndnUUID,
  MDQltyTechnicalRuleScope,
  MDQltyTechnicalRuleCondition,
  MDQltyTechnicalRuleScopeStatus,
  MDQltyTechnicalRuleCndnStatus,
  MDQltyTechRuleCndnCriticality,
  MDQltyTechRuleScpCriticality,
  MDQltyTechRuleCndnStatusName,
  MDQltyTechRuleScopeStatusName
FROM I_MDQualityTechnicalRule
;

Learn More