C_MDQltyBusinessRuleVH

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_MDQltyBusinessRuleVH.
-- 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.

CREATE VIEW C_MDQltyBusinessRuleVH AS
SELECT
  MDQualityBusinessRule,
  MDQltyBusinessObjectTypeCode,
  MDQualityBusinessRuleUUID,
  MDQualityBusinessRuleName,
  MDQltyBusinessRuleBaseTable,
  MDQltyBusinessRuleOwner,
  MDQltyBusinessRuleStatus,
  _MDQualityBusinessRuleStatus.MDQltyBusRuleStatusCriticality AS MDQltyBusRuleStatusCriticality,
  MDQltyBusRuleCheckedField,
  MDQltyBusRuleCheckedFieldTable,
  MDQltyBusRuleChkdFieldAndTable,
  MDQltyTechnicalRuleUUID,
  MDQltyTechnicalRuleScopeUUID,
  MDQltyTechnicalRuleCndnUUID,
  MDQltyTechRuleScpDcsnTblUUID,
  MDQltyTechRuleCndnDcsnTblUUID,
  MDQltyRuleImplmtnStatus,
  MDQltyRuleImplmtnStatusName,
  MDQltyRuleImplmtnStsCritlty,
  _MDQltyBusinessRuleDetails.MDQltyBusRuleScopeDescription AS MDQltyBusRuleScopeDescription
FROM I_MDQualityBusinessRule AS _MDQltyBusinessRule
LEFT OUTER JOIN I_MDQltyBusinessRuleDetails AS _MDQltyBusinessRuleDetails ON MDQualityBusinessRuleUUID = _MDQltyBusinessRuleDetails.MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQualityBusinessRuleStatus AS _MDQualityBusinessRuleStatus ON MDQltyBusinessRuleStatus = _MDQualityBusinessRuleStatus.MDQltyBusinessRuleStatus  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusinessRuleBaseTblVH AS _MDQltyBusinessRuleBaseTblVH ON MDQltyBusinessRuleBaseTable = _MDQltyBusinessRuleBaseTblVH.MDQltyBusinessRuleBaseTable AND MDQltyBusinessObjectTypeCode = _MDQltyBusinessRuleBaseTblVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQualityBusRuleOwnerVH AS _MDQualityBusRuleOwnerVH ON MDQltyBusinessRuleOwner = _MDQualityBusRuleOwnerVH.UserID AND MDQltyBusinessObjectTypeCode = _MDQualityBusRuleOwnerVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN I_MDQualityBusinessRuleStatusT AS _MDQualityBusinessRuleStatusT ON MDQltyBusinessRuleStatus = _MDQualityBusinessRuleStatusT.MDQltyBusinessRuleStatus  -- association [0..*]
LEFT OUTER JOIN I_MDQltyModelTableT AS _MDQltyBusinessRuleBaseTableT ON MDQltyBusinessRuleBaseTable = _MDQltyBusinessRuleBaseTableT.MDQltyModelTable AND MDQltyBusinessObjectTypeCode = _MDQltyBusinessRuleBaseTableT.MDQltyBusinessObjectTypeCode  -- association [0..*]
LEFT OUTER JOIN I_MDQltyBusRuleChkdFieldText AS _MDQltyBusRuleChkdFieldText ON MDQltyBusRuleCheckedField = _MDQltyBusRuleChkdFieldText.MDQltyBusRuleCheckedField AND MDQltyBusRuleCheckedFieldTable = _MDQltyBusRuleChkdFieldText.MDQltyBusRuleCheckedFieldTable  -- association [0..*]
;