C_MDQltyProdBusRuleGovIntegTP

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_MDQltyProdBusRuleGovIntegTP.
-- 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: CMDQPRBRMDGINTTP

CREATE VIEW C_MDQltyProdBusRuleGovIntegTP AS
SELECT
  MDQualityBusinessRuleUUID,
  MDQltyBusRuleMDGovIntegType,
  MDQltyMDGovBRFPlusObjectUUID,
  MDQltyMDGovBRFPlusObjectName,
  MDQltyMDGovBRFPlusObjectType,
  MDQltyMDGovBusAddInDefinition,
  MDQltyMDGovBusAddInEnhancement,
  MDQltyMDGovBusAddInImplmtn
FROM I_MDQltyBusRuleMDGovIntegTP
LEFT OUTER JOIN C_MDQltyProductBusinessRuleTP AS _MDQualityBusinessRuleTP ON MDQualityBusinessRuleUUID = _MDQualityBusinessRuleTP.MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyBusRuleMDGovIntegType AS _MDQltyBusRuleMDGovIntegType ON MDQltyBusRuleMDGovIntegType = _MDQltyBusRuleMDGovIntegType.MDQltyBusRuleMDGovIntegType  -- association [0..1]
LEFT OUTER JOIN I_MDQltyBusRuleMDGovIntegTypeT AS _MDQltyBusRuleMDGovIntegTypeT ON MDQltyBusRuleMDGovIntegType = _MDQltyBusRuleMDGovIntegTypeT.MDQltyBusRuleMDGovIntegType  -- association [0..*]
LEFT OUTER JOIN C_MDQltyProdRuleMDGovBRFPlusVH AS _MDQltyBusRuleMDGovBRFPlusVH ON MDQltyMDGovBRFPlusObjectUUID = _MDQltyBusRuleMDGovBRFPlusVH.MDQltyMDGovBRFPlusObjectUUID AND MDQltyMDGovBRFPlusObjectName = _MDQltyBusRuleMDGovBRFPlusVH.MDQltyMDGovBRFPlusObjectName  -- association [0..1]
LEFT OUTER JOIN C_MDQltyProdRuleGovBusAddInVH AS _MDQltyBusRuleMDGovBusAddInVH ON MDQltyMDGovBusAddInImplmtn = _MDQltyBusRuleMDGovBusAddInVH.MDQltyMDGovBusAddInImplmtn AND MDQltyMDGovBusAddInDefinition = _MDQltyBusRuleMDGovBusAddInVH.MDQltyMDGovBusAddInDefinition AND MDQltyMDGovBusAddInEnhancement = _MDQltyBusRuleMDGovBusAddInVH.MDQltyMDGovBusAddInEnhancement  -- association [0..1]
LEFT OUTER JOIN I_MDQltyBusRuleMDGovBusAddIn AS _MDQltyBusRuleMDGovBusAddIn ON MDQltyMDGovBusAddInImplmtn = _MDQltyBusRuleMDGovBusAddIn.MDQltyMDGovBusAddInImplmtn AND MDQltyMDGovBusAddInDefinition = _MDQltyBusRuleMDGovBusAddIn.MDQltyMDGovBusAddInDefinition AND MDQltyMDGovBusAddInEnhancement = _MDQltyBusRuleMDGovBusAddIn.MDQltyMDGovBusAddInEnhancement  -- association [0..1]
;