C_MDQualityBusinessRuleTP_2

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_MDQualityBusinessRuleTP_2.
-- 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_MDQualityBusinessRuleTP_2 AS
SELECT
  MDQualityBusinessRuleUUID,
  MDQltyBusRuleCreationDateTime,
  MDQltyBusRuleCreatedByUser,
  MDQltyBusRuleChangeDateTime,
  MDQltyBusRuleChangedByUser,
  MDQualityBusinessRule,
  MDQltyBusinessObjectTypeCode,
  MDQualityBusinessRuleName,
  MDQltyBusinessRuleBaseTable,
  _MDQltyBusinessRuleBaseTableT.MDQltyBusinessRuleBaseTabName : localized AS MDQltyBusinessRuleBaseTabNamelocalized,
  MDQltyBusinessRuleStatus,
  _MDQualityBusinessRuleStatusT.MDQltyBusinessRuleStatusName : localized AS MDQltyBusinessRuleStatusNamelocalized,
  MDQltyBusRuleStatusCriticality,
  MDQltyTechnicalRuleScopeUUID,
  MDQltyTechnicalRuleCndnUUID,
  MDQltyTechRuleScpDcsnTblUUID,
  MDQltyTechRuleCndnDcsnTblUUID,
  MDQltyBusinessRuleOwner,
  MDQltyBusinessRuleExpert,
  MDQltyBusRuleCheckedField,
  _MDQltyBusRuleChkdFieldText.MDQltyBusRuleCheckedFieldName : localized AS MDQltyBusRuleCheckedFieldNamelocalized,
  MDQltyBusRuleCheckedFieldTable,
  MDQltyBusRuleChkdFieldAndTable,
  MDQltyBusRuleHasDimnAssigned,
  _MDQltyBusRuleDimnAssgmtIndT.MDQltyBusRuleHasDimnAssgdText : localized AS MDQltyBusRuleHasDimnAssgdTextlocalized,
  _MDQltyBusRuleEvalResults.MasterDataChangeProcess AS MasterDataChangeProcess,
  _MDQltyBusRuleEvalResults.MDQltyRuleScore AS MDQltyRuleScore,
  _MDQltyBusRuleEvalResults.MDQltyRuleScoreString AS MDQltyRuleScoreString,
  _MDQltyBusRuleEvalResults.MDQltyBusinessRuleHasNoResults AS MDQltyBusinessRuleHasNoResults,
  _MDQltyBusRuleEvalResults.MDQltyNmbrOfFailedEvalRslts AS MDQltyNmbrOfFailedEvalRslts,
  _MDQltyBusRuleEvalResults.MDQltyNmbrOfSuccssflEvalRslts AS MDQltyNmbrOfSuccssflEvalRslts,
  _MDQltyBusRuleEvalResults.MDChgProcessFinishDateTime AS MDChgProcessFinishDateTime,
  _MDQltyBusRuleEvalResults.MDQltyFailedEvalRsltsCritlty AS MDQltyFailedEvalRsltsCritlty,
  _MDQltyBusRuleEvalResults.MDQltySuccssflEvalRsltsCritlty AS MDQltySuccssflEvalRsltsCritlty,
  MDQltyBusRuleMsgAssignmentType,
  _MDQltyBusRuleMsgAssgmtTypeT.MDQltyBusRuleMsgAssgmtTypeName : localized AS MDQltyBusRuleMsgAssgmtTypeNamelocalized,
  _MDQltyBusRuleMsgAssgmtType.MDQRuleMsgAssgmtTypeIsDefault AS MDQRuleMsgAssgmtTypeIsDefault,
  _MDQualityRAPBasedSwitch.MDChgProcRAPBsdSwitchIsActive AS MDChgProcRAPBsdSwitchIsActive,
  MDQltyBusRuleBusRsnDescription,
  MDQltyBusinessRuleDescription,
  MDQltyBusRuleScopeDescription,
  MDQltyBusRuleDataOwnerText,
  MDQltyBusRuleBusContactText,
  MDQltyBusRuleDetailsURL,
  MDQltyBusRuleDetailsURLText,
  MDQltyBusRuleDetailsLink,
  cast( MDQltyBusRuleGnrtnLogHandle as char22 preserving type ) AS MDQltyBusRuleGnrtnLogHandle,
  _MDQltyBusRuleMsgShortText.MDQualityMessageShortText : localized AS MDQualityMessageShortTextlocalized,
  _MDQltyBusRuleMessageTypeT.MDQltyBusRuleMessageTypeText : localized AS MDQltyBusRuleMessageTypeTextlocalized,
  MDQltyBusinessRuleMessageType,
  MDQualityMessageClass,
  MDQualityMessageNumber,
  MDQualityMessageVariable1Text,
  MDQualityMessageVariable2Text,
  MDQualityMessageVariable3Text,
  MDQualityMessageVariable4Text,
  _MDQltyBusRuleUsageDetails.MDQltyBusRuleHasUsagesAssigned AS MDQltyBusRuleHasUsagesAssigned,
  _MDQltyBusRuleUsageDetails.MDQltyBusRuleHasOnlyNotRdyUsgs AS MDQltyBusRuleHasOnlyNotRdyUsgs,
  _MDQltyBusRuleUsageDetails.MDQltyBusRuleHasRdyCheckUsages AS MDQltyBusRuleHasRdyCheckUsages,
  virtual MDQltyBusRuleHideScore: boole_d AS virtualMDQltyBusRuleHideScoreboole_d,
  virtual MDQltyBusRuleHideContacts: boole_d AS virtualMDQltyBusRuleHideContactsboole_d
FROM R_MDQualityBusinessRuleTP_2
LEFT OUTER JOIN C_MDQltyBusRuleSimlnDetail AS _MDQltyBusRuleSimlnDetail ON MDQualityBusinessRuleUUID = _MDQltyBusRuleSimlnDetail.MDQualityBusinessRuleUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQltyBusRuleDimnAssignment AS _MDQltyBusRuleDimnAssignment ON MDQualityBusinessRuleUUID = _MDQltyBusRuleDimnAssignment.MDQualityBusinessRuleUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQualityTechnicalRule AS _MDQualityTechnicalRule ON MDQualityBusinessRuleUUID = _MDQualityTechnicalRule.MDQualityBusinessRuleUUID  -- association [0..1]
LEFT OUTER JOIN C_MDQualityBusinessRuleChange AS _MDQualityBusinessRuleChange ON MDQualityBusinessRuleUUID = _MDQualityBusinessRuleChange.MDQualityBusinessRuleUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQltyBusRuleChangeDetails AS _MDQltyBusRuleChangeDetails ON MDQualityBusinessRuleUUID = _MDQltyBusRuleChangeDetails.MDQualityBusinessRuleUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQltyBusRuleChangeUser AS _MDQltyBusRuleChangeUser ON MDQualityBusinessRuleUUID = _MDQltyBusRuleChangeUser.MDQualityBusinessRuleUUID  -- association [0..*]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _RuleOwnerContactCard ON MDQltyBusinessRuleOwner = _RuleOwnerContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _RuleExpertContactCard ON MDQltyBusinessRuleExpert = _RuleExpertContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _CreatedByUserContactCard ON MDQltyBusRuleCreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _ChangedByUserContactCard ON MDQltyBusRuleChangedByUser = _ChangedByUserContactCard.ContactCardID  -- association [0..1]
;