C_MDQltyProductBusinessRuleVH

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_MDQltyProductBusinessRuleVH.
-- 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: CMDQPRODBSRULEVH

CREATE VIEW C_MDQltyProductBusinessRuleVH AS
SELECT
  MDQualityBusinessRule,
  MDQualityBusinessRuleUUID,
  MDQualityBusinessRuleName,
  MDQltyBusinessRuleBaseTable,
  MDQltyBusinessRuleOwner,
  MDQltyBusinessRuleStatus,
  MDQltyBusRuleCheckedField,
  MDQltyBusRuleCheckedFieldTable,
  _MDQltyBusinessRuleDetails.MDQltyBusRuleScopeDescription AS MDQltyBusRuleScopeDescription,
  _MDQltyTechnicalRule.MDQltyTechnicalRuleUUID AS MDQltyTechnicalRuleUUID,
  _MDQltyTechnicalRule.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  _MDQltyTechnicalRule.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  _MDQltyTechnicalRule.MDQltyTechnicalRuleScope AS MDQltyTechnicalRuleScope,
  _MDQltyTechnicalRule.MDQltyTechnicalRuleCondition AS MDQltyTechnicalRuleCondition,
  MDQltyBusinessObjectTypeCode
FROM I_MDQualityBusinessRule AS _MDQltyProductBusinessRule
LEFT OUTER JOIN I_MDQualityBusinessRuleStatusT AS _MDQualityBusinessRuleStatusT ON MDQltyBusinessRuleStatus = _MDQualityBusinessRuleStatusT.MDQltyBusinessRuleStatus  -- association [*]
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_MDQltyProdBusRuleBaseTblVH AS _MDQltyProdBusRuleBaseTblVH ON MDQltyBusinessRuleBaseTable = _MDQltyProdBusRuleBaseTblVH.MDQltyBusinessRuleBaseTable  -- association [0..1]
LEFT OUTER JOIN C_MDQltyProductBusRuleOwnerVH AS _MDQltyProductBusRuleOwnerVH ON MDQltyBusinessRuleOwner = _MDQltyProductBusRuleOwnerVH.UserID  -- association [0..1]
LEFT OUTER JOIN C_MDQualityTechnicalRule AS _MDQltyTechnicalRule ON MDQualityBusinessRuleUUID = _MDQltyTechnicalRule.MDQualityBusinessRuleUUID  -- association [0..1]
;