I_MDQualityBusinessRule

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_MDQualityBusinessRule.
-- 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_MDQualityBusinessRule AS
SELECT
  _rule.mdqualitybusinessruleuuid AS MDQualityBusinessRuleUUID,
  _rule.mdqualitybusinessrule AS MDQualityBusinessRule,
  _rule.mdqualitybusinessrulename AS MDQualityBusinessRuleName,
  _rule.mdqltybusinessobjecttypecode AS MDQltyBusinessObjectTypeCode,
  _rule.mdqltybusinessrulebasetable AS MDQltyBusinessRuleBaseTable,
  _rule.mdqltybusinessrulestatus AS MDQltyBusinessRuleStatus,
  _rule.mdqltybusrulecreationdatetime AS MDQltyBusRuleCreationDateTime,
  _rule.mdqltybusrulecreatedbyuser AS MDQltyBusRuleCreatedByUser,
  _rule.mdqltybusrulechangedatetime AS MDQltyBusRuleChangeDateTime,
  _rule.mdqltybusrulechangedbyuser AS MDQltyBusRuleChangedByUser,
  _rule.mdqltybusinessruleowner AS MDQltyBusinessRuleOwner,
  _rule.mdqltybusinessruleexpert AS MDQltyBusinessRuleExpert,
  _rule.mdqltybusrulecheckedfieldtable AS MDQltyBusRuleCheckedFieldTable,
  _rule.mdqltybusrulecheckedfield AS MDQltyBusRuleCheckedField,
  _rule.mdqltybusrulechkdfieldandtable AS MDQltyBusRuleChkdFieldAndTable,
  _rule.mdqltybusruleusgeispermitted AS MDQltyBusRuleUsgeIsPermitted,
  _MDQualityRuleMapping.MDQltyTechnicalRuleUUID AS MDQltyTechnicalRuleUUID,
  _MDQualityRuleMapping.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  _MDQualityRuleMapping.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  _MDQualityRuleMapping.MDQltyTechRuleCndnDcsnTblUUID AS MDQltyTechRuleCndnDcsnTblUUID,
  _MDQualityRuleMapping.MDQltyTechRuleScpDcsnTblUUID AS MDQltyTechRuleScpDcsnTblUUID,
  cast( '' as mdq_tech_rule_status) AS MDQltyRuleImplmtnStatus,
  cast( '' as abap.char(30)) AS MDQltyRuleImplmtnStatusName,
  cast( 0 as abap.int4 ) AS MDQltyRuleImplmtnStsCritlty
FROM mdq_rule_def AS _rule
LEFT OUTER JOIN mdq_rule_def_d AS _draft ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDQualityRuleMapping AS _MDQualityRuleMapping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDQltyBusinessRuleDetails AS _MDQltyBusinessRuleDetails ON MDQualityBusinessRuleUUID = _MDQltyBusinessRuleDetails.MDQualityBusinessRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_MDQualityBusinessRuleStatus AS _MDQualityBusinessRuleStatus ON MDQltyBusinessRuleStatus = _MDQualityBusinessRuleStatus.MDQltyBusinessRuleStatus  -- association [0..1]
;