C_MDQltyMinedRuleTP

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_MDQltyMinedRuleTP.
-- 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: KMDQMNDRULETP

CREATE VIEW C_MDQltyMinedRuleTP AS
SELECT
  MDQltyMinedRuleUUID,
  MDQltyBusinessObjectTypeCode,
  MDQltyMinedRule,
  cast( '' as mdq_rulemining_id) AS MDQltyRuleMining,
  cast( '' as mdq_minedrule_scopefield) AS MDQltyMinedRuleScpField,
  cast( '' as mdq_minedrule_scopefld_table) AS MDQltyMinedRuleScpFieldTable,
  cast( '' as mdq_minedrule_cndnfield) AS MDQltyMinedRuleCndnField,
  cast( '' as mdq_minedrule_cndnfld_table) AS MDQltyMinedRuleCndnFieldTable,
  cast( '' as mdq_minedrule_cndnfld_value) AS MDQltyMinedRuleCndnFieldValue,
  _MDQltyMinedRuleLinkage.MDQltyMinedRuleIsImplemented AS MDQltyMinedRuleIsImplemented,
  _MDQltyMinedRuleLinkage._MDQualityTechnicalRule.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  _MDQltyMinedRuleLinkage._MDQualityTechnicalRule.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  MDQltyMinedRuleRecdVioltnCnt,
  cast(round(fltp_to_dec( _MDQltyMinedRuleRecdInPct.MDQltyMndRuleRecdVioltnInPct as abap.dec(5,2) ), 1 ) as abap.dec(4,1) ) AS MDQltyMndRuleRecdVioltnInPct,
  MDQltyMinedRuleRecdCmplncCnt,
  cast(round(fltp_to_dec( _MDQltyMinedRuleRecdInPct.MDQltyMndRuleRecdCmplncInPct as abap.dec(5,2) ), 1 ) as abap.dec(4,1) ) AS MDQltyMndRuleRecdCmplncInPct,
  MDQltyMinedRuleRecdNotRlvtCnt,
  cast(round(fltp_to_dec( _MDQltyMinedRuleRecdInPct.MDQltyMndRuleRecdNotRlvtInPct as abap.dec(5,2) ), 1 ) as abap.dec(4,1) ) AS MDQltyMndRuleRecdNotRlvtInPct,
  MDQltyMinedRuleStatus,
  MDQltyMinedRuleStsDcsnUsr,
  MDQltyMinedRuleStsDcsnDateTime,
  MDQltyMinedRuleRecdEvalDteTme,
  MDQltyMinedRuleChgdByUsr,
  MDQltyMinedRuleCreationUsr,
  MDQltyMinedRuleCreationDteTme,
  MDQltyMinedRuleChgdDateTime,
  MDQltyMinedRuleChkdFieldTable,
  _MDQltyRuleMiningTblVH._MDQltyModelTableT[ Language = $session.system_language ].MDQltyModelTableName AS MDQltyModelTableName,
  MDQltyMinedRuleChkdField,
  _MDQltyMndRuleChkdFldVH._MDQltyModelFieldText[ Language = $session.system_language ].MDQltyModelDataElementName AS MDQltyModelDataElementName,
  MDQltyMinedRuleChkdFieldValue,
  _MDQltyMinedRuleLinkage._MDQualityBusinessRule.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQltyMinedRuleExpression.MDQltyMinedRuleExpression AS MDQltyMinedRuleExpression,
  _MDQltyMinedRuleExpression.MDQltyMinedRuleTechExpression AS MDQltyMinedRuleTechExpression,
  _MDQltyMinedRuleExpression.MDQltyRuleMnngTechDataSel AS MDQltyRuleMnngTechDataSel,
  _MDQltyMinedRuleExpression.MDQltyRuleMiningDataSelection AS MDQltyRuleMiningDataSelection
FROM I_MDQltyMinedRuleTP
LEFT OUTER JOIN C_MDQltyMinedRuleCndnFldTP AS _MDQltyMinedRuleCndnFieldTP ON MDQltyMinedRuleUUID = _MDQltyMinedRuleCndnFieldTP.MDQltyMinedRuleUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQltyMinedRuleScpFldTP AS _MDQltyMinedRuleScpFieldTP ON MDQltyMinedRuleUUID = _MDQltyMinedRuleScpFieldTP.MDQltyMinedRuleUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQltyMinedRuleMiningTP AS _MDQltyMinedRuleMiningTP ON MDQltyMinedRuleUUID = _MDQltyMinedRuleMiningTP.MDQltyMinedRuleUUID  -- association [0..*]
LEFT OUTER JOIN I_MDQltyMinedRuleLinkage AS _MDQltyMinedRuleLinkage ON MDQltyMinedRuleUUID = _MDQltyMinedRuleLinkage.MDQltyMinedRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_MDQltyMinedRuleRecdInPct AS _MDQltyMinedRuleRecdInPct ON MDQltyMinedRuleUUID = _MDQltyMinedRuleRecdInPct.MDQltyMinedRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyMinedRuleExpression AS _MDQltyMinedRuleExpression ON MDQltyMinedRuleUUID = _MDQltyMinedRuleExpression.MDQltyMinedRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _DcsnByUserContactCard ON MDQltyMinedRuleStsDcsnUsr = _DcsnByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _ChgdByUserContactCard ON MDQltyMinedRuleChgdByUsr = _ChgdByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _CreatedByUserContactCard ON MDQltyMinedRuleCreationUsr = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleChkdFldVH AS _MDQltyMndRuleChkdFldVH ON MDQltyMinedRuleChkdField = _MDQltyMndRuleChkdFldVH.MDQltyModelField AND MDQltyMinedRuleChkdFieldTable = _MDQltyMndRuleChkdFldVH.MDQltyModelTable AND MDQltyBusinessObjectTypeCode = _MDQltyMndRuleChkdFldVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQltyRuleMiningTblVH AS _MDQltyRuleMiningTblVH ON MDQltyMinedRuleChkdFieldTable = _MDQltyRuleMiningTblVH.MDQltyModelTable AND MDQltyBusinessObjectTypeCode = _MDQltyRuleMiningTblVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleDcsnUsrVH AS _MDQltyMndRuleDcsnUsrVH ON MDQltyMinedRuleStsDcsnUsr = _MDQltyMndRuleDcsnUsrVH.UserID AND MDQltyBusinessObjectTypeCode = _MDQltyMndRuleDcsnUsrVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleChangedByUserVH AS _MDQltyMndRuleChangedByUserVH ON MDQltyMinedRuleChgdByUsr = _MDQltyMndRuleChangedByUserVH.UserID AND MDQltyBusinessObjectTypeCode = _MDQltyMndRuleChangedByUserVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleCreatedByUserVH AS _MDQltyMndRuleCreatedByUserVH ON MDQltyMinedRuleCreationUsr = _MDQltyMndRuleCreatedByUserVH.UserID AND MDQltyBusinessObjectTypeCode = _MDQltyMndRuleCreatedByUserVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleLinkdRuleVH AS _MDQltyMndRuleLinkdRuleVH ON MDQualityBusinessRule = _MDQltyMndRuleLinkdRuleVH.MDQualityBusinessRule AND MDQltyBusinessObjectTypeCode = _MDQltyMndRuleLinkdRuleVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusinessRuleVH AS _MDQltyBusinessRuleVH ON MDQltyMinedRuleChkdFieldTable = _MDQltyBusinessRuleVH.MDQltyBusRuleCheckedFieldTable AND MDQltyMinedRuleChkdField = _MDQltyBusinessRuleVH.MDQltyBusRuleCheckedField AND MDQltyBusinessObjectTypeCode = _MDQltyBusinessRuleVH.MDQltyBusinessObjectTypeCode  -- association [0..*]
LEFT OUTER JOIN I_MDQltyMinedRuleStatus AS _MDQltyMinedRuleStatus ON MDQltyMinedRuleStatus = _MDQltyMinedRuleStatus.MDQltyMinedRuleStatus  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleMiningRunVH AS _MDQltyMndRuleMiningRunVH ON MDQltyRuleMining = _MDQltyMndRuleMiningRunVH.MDQltyRuleMining  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleUsedCndnFldVH AS _MDQltyMndRuleUsedCndnFldVH ON MDQltyMinedRuleCndnField = _MDQltyMndRuleUsedCndnFldVH.MDQltyMinedRuleCndnField AND MDQltyMinedRuleCndnFieldTable = _MDQltyMndRuleUsedCndnFldVH.MDQltyMinedRuleCndnFieldTable AND MDQltyBusinessObjectTypeCode = _MDQltyMndRuleUsedCndnFldVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN C_MDQltyMndRuleUsedScpFldVH AS _MDQltyMndRuleUsedScpFldVH ON MDQltyMinedRuleScpField = _MDQltyMndRuleUsedScpFldVH.MDQltyMinedRuleScpField AND MDQltyMinedRuleScpFieldTable = _MDQltyMndRuleUsedScpFldVH.MDQltyMinedRuleScpFieldTable AND MDQltyBusinessObjectTypeCode = _MDQltyMndRuleUsedScpFldVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN I_MDQltyMndRuleImplmtnStatus AS _MDQltyMndRuleImplmtnStatus ON MDQltyMinedRuleIsImplemented = _MDQltyMndRuleImplmtnStatus.MDQltyMinedRuleIsImplemented  -- association [0..1]
;