I_MDQualityBusinessRuleTP

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_MDQualityBusinessRuleTP.
-- 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 I_MDQualityBusinessRuleTP AS
SELECT
  MDQualityBusinessRuleUUID,
  MDQualityBusinessRuleUUID AS MDQltyBusinessRuleActiveUUID,
  MDQualityBusinessRule,
  MDQualityBusinessRuleName,
  MDQltyBusinessObjectTypeCode,
  MDQltyBusinessRuleBaseTable,
  MDQltyBusinessRuleStatus,
  MDQltyBusRuleCreationDateTime,
  MDQltyBusRuleCreatedByUser,
  MDQltyBusRuleChangeDateTime,
  MDQltyBusRuleChangedByUser,
  MDQltyBusinessRuleOwner,
  MDQltyBusinessRuleExpert,
  MDQltyBusRuleCheckedField,
  MDQltyBusRuleCheckedFieldTable,
  MDQltyBusRuleChkdFieldAndTable,
  cast('X' as abap_boolean preserving type ) AS MDQltyBusinessRuleHasNoResults,
  cast( coalesce( _MDQltyBusRuleMndRuleLinkage.MDQltyRuleHasLinkedMinedRules, '' ) as mdq_rule_linked_to_mined_rule preserving type ) AS MDQltyRuleHasLinkedMinedRules,
  MDQltyBusRuleUsgeIsPermitted,
  case when MDQltyBusRuleUsgeIsPermitted = '' or MDQltyBusRuleUsgeIsPermitted is null then 'X' end AS MDQltyBusRuleUsgeIsForbidden,
  _MDQualityRAPBasedSwitch.MDChgProcRAPBsdSwitchIsActive AS MDChgProcRAPBsdSwitchIsActive
FROM I_MDQualityBusinessRule_2
LEFT OUTER JOIN I_MDQltyBusinessRuleDetailsTP AS _MDQltyBusinessRuleDetailsTP ON MDQualityBusinessRuleUUID = _MDQltyBusinessRuleDetailsTP.MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyBusRuleMDGovIntegTP AS _MDQltyBusRuleMDGovIntegTP ON MDQualityBusinessRuleUUID = _MDQltyBusRuleMDGovIntegTP.MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyBusRuleMsgAssignmentTP AS _MDQltyBusRuleMsgAssignmentTP ON MDQualityBusinessRuleUUID = _MDQltyBusRuleMsgAssignmentTP.MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyMinedRuleLinkageTP AS _MDQltyMinedRuleLinkageTP ON MDQualityBusinessRuleUUID = _MDQltyMinedRuleLinkageTP.MDQualityBusinessRuleUUID  -- association [0..*]
LEFT OUTER JOIN I_MDQltyBusRuleMndRuleLinkage AS _MDQltyBusRuleMndRuleLinkage ON MDQltyBusinessRuleActiveUUID = _MDQltyBusRuleMndRuleLinkage.MDQualityBusinessRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_MDQltyBusinessRuleUsageTP AS _MDQltyBusinessRuleUsageTP ON MDQualityBusinessRuleUUID = _MDQltyBusinessRuleUsageTP.MDQualityBusinessRuleUUID  -- association [0..*]
LEFT OUTER JOIN I_MDQualityRAPBasedSwitch AS _MDQualityRAPBasedSwitch ON MDQltyBusinessObjectTypeCode = _MDQualityRAPBasedSwitch.MDQltyBusinessObjectTypeCode  -- association [0..1]
;