C_MDQltyBusRuleMsgAssignmentTP

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_MDQltyBusRuleMsgAssignmentTP.
-- 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_MDQltyBusRuleMsgAssignmentTP AS
SELECT
  MDQualityBusinessRuleUUID,
  _MDQualityBusinessRuleTP.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  _MDQualityBusinessRuleTP.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  MDQltyBusRuleMsgAssignmentType,
  MDQualityMessageClass,
  MDQualityMessageNumber,
  MDQltyBusinessRuleMessageType,
  MDQualityMessageVariable1Text,
  MDQualityMessageVariable2Text,
  MDQualityMessageVariable3Text,
  MDQualityMessageVariable4Text,
  MDQltyBusRuleMsgHasLongText,
  MDQualityMessageOrignSystAlias,
  _MDQualityBusinessRuleTP._MDQltyBusinessRuleBaseTblVH AS _MDQltyBusinessRuleBaseTblVH
FROM I_MDQltyBusRuleMsgAssignmentTP
LEFT OUTER JOIN C_MDQualityBusinessRuleTP AS _MDQualityBusinessRuleTP ON MDQualityBusinessRuleUUID = _MDQualityBusinessRuleTP.MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQltyBusRuleMsgAssgmtType AS _MDQltyBusRuleMsgAssgmtType ON MDQltyBusRuleMsgAssignmentType = _MDQltyBusRuleMsgAssgmtType.MDQltyBusRuleMsgAssignmentType  -- association [0..1]
LEFT OUTER JOIN I_MDQltyBusRuleMsgAssgmtTypeT AS _MDQltyBusRuleMsgAssgmtTypeT ON MDQltyBusRuleMsgAssignmentType = _MDQltyBusRuleMsgAssgmtTypeT.MDQltyBusRuleMsgAssignmentType  -- association [0..*]
LEFT OUTER JOIN C_MDQltyBusRuleMessageClassVH AS _MDQltyBusRuleMessageClassVH ON MDQualityMessageClass = _MDQltyBusRuleMessageClassVH.MDQualityMessageClass  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusRuleMessageNmbrVH AS _MDQltyBusRuleMessageNmbrVH ON MDQualityMessageClass = _MDQltyBusRuleMessageNmbrVH.MDQualityMessageClass AND MDQualityMessageNumber = _MDQltyBusRuleMessageNmbrVH.MDQualityMessageNumber  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusRuleMsgVariableVH AS _MDQltyBusRuleMsgVarblText1 ON MDQltyBusinessObjectTypeCode = _MDQltyBusRuleMsgVarblText1.MDQltyBusinessObjectTypeCode AND I_MDQltyBusRuleMsgAssignmentTP.MDQualityMessageVariable1Text = _MDQltyBusRuleMsgVarblText1.MDQltyBusRuleChkdFieldAndTable  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusRuleMsgVariableVH AS _MDQltyBusRuleMsgVarblText2 ON MDQltyBusinessObjectTypeCode = _MDQltyBusRuleMsgVarblText2.MDQltyBusinessObjectTypeCode AND I_MDQltyBusRuleMsgAssignmentTP.MDQualityMessageVariable2Text = _MDQltyBusRuleMsgVarblText2.MDQltyBusRuleChkdFieldAndTable  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusRuleMsgVariableVH AS _MDQltyBusRuleMsgVarblText3 ON MDQltyBusinessObjectTypeCode = _MDQltyBusRuleMsgVarblText3.MDQltyBusinessObjectTypeCode AND I_MDQltyBusRuleMsgAssignmentTP.MDQualityMessageVariable3Text = _MDQltyBusRuleMsgVarblText3.MDQltyBusRuleChkdFieldAndTable  -- association [0..1]
LEFT OUTER JOIN C_MDQltyBusRuleMsgVariableVH AS _MDQltyBusRuleMsgVarblText4 ON MDQltyBusinessObjectTypeCode = _MDQltyBusRuleMsgVarblText4.MDQltyBusinessObjectTypeCode AND I_MDQltyBusRuleMsgAssignmentTP.MDQualityMessageVariable4Text = _MDQltyBusRuleMsgVarblText4.MDQltyBusRuleChkdFieldAndTable  -- association [0..1]
LEFT OUTER JOIN I_MDQltyBusRuleMessageType AS _MDQltyBusRuleMessageType ON MDQltyBusinessRuleMessageType = _MDQltyBusRuleMessageType.MDQltyBusinessRuleMessageType  -- association [0..1]
LEFT OUTER JOIN I_MDQltyBusRuleMsgShortText AS _MDQltyBusRuleMsgShortText ON MDQualityMessageClass = _MDQltyBusRuleMsgShortText.MDQualityMessageClass AND MDQualityMessageNumber = _MDQltyBusRuleMsgShortText.MDQualityMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_MDQltyBusRuleMessageClassT AS _MDQltyBusRuleMessageClassT ON _MDQltyBusRuleMessageClassT.MDQualityMessageClass = MDQualityMessageClass  -- association [0..*]
LEFT OUTER JOIN I_MDQltyBusRuleMessageTypeT AS _MDQltyBusRuleMessageTypeT ON MDQltyBusinessRuleMessageType = _MDQltyBusRuleMessageTypeT.MDQltyBusinessRuleMessageType  -- association [0..*]
;