I_MDQualityTechnicalRule

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_MDQualityTechnicalRule.
-- 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_MDQualityTechnicalRule AS
SELECT
  _dq_rule.mdqualitybusinessruleuuid AS MDQualityBusinessRuleUUID,
  _dq_rule.mdqltybusinessobjecttypecode AS MDQltyBusinessObjectTypeCode,
  _dq_rule.mdqualitybusinessrule AS MDQualityBusinessRule,
  I_MDQualityRuleMapping.MDQltyTechnicalRuleUUID AS MDQltyTechnicalRuleUUID,
  I_MDQualityRuleMapping.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  I_MDQualityRuleMapping.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  cast( '' as mdq_brfplus_object_name ) AS MDQltyTechnicalRuleScope,
  cast( '' as mdq_brfplus_object_name) AS MDQltyTechnicalRuleCondition,
  cast( '' as mdq_tech_rule_status) AS MDQltyTechnicalRuleScopeStatus,
  cast( 0 as abap.int4) AS MDQltyTechRuleScpCriticality,
  cast( 0 as abap.int4 ) AS MDQltyTechRuleCndnCriticality,
  cast( '' as mdq_tech_rule_status) AS MDQltyTechnicalRuleCndnStatus,
  cast( '' as abap.char(30)) AS MDQltyTechRuleCndnStatusName,
  cast( '' as abap.char(30)) AS MDQltyTechRuleScopeStatusName,
  I_MDQualityRuleMapping.MDQltyTechRuleScpDcsnTblUUID AS MDQltyTechRuleScpDcsnTblUUID,
  cast( '' as mdq_brfplus_object_name) AS MDQltyTechRuleScpDecisionTable,
  cast( '' as mdq_tech_rule_status) AS MDQltyTechRuleScpDcsnTblSts,
  cast( '' as abap.char(30)) AS MDQltyTechScpDcsnTblStsName,
  cast( 0 as abap.int4 ) AS MDQltyTechScpDcsnTblCritlty,
  I_MDQualityRuleMapping.MDQltyTechRuleCndnDcsnTblUUID AS MDQltyTechRuleCndnDcsnTblUUID,
  cast( '' as mdq_brfplus_object_name) AS MDQltyTechRuleCndnDcsnTable,
  cast( '' as mdq_tech_rule_status) AS MDQltyTechRuleCndnDcsnTblSts,
  cast( '' as abap.char(30)) AS MDQltyTechCndnDcsnTblStsName,
  cast( 0 as abap.int4 ) AS MDQltyTechCndnDcsnTblCritlty,
  cast( '' as abap_boolean preserving type ) AS MDQltyTechRuleScopeHasDcsnTbl,
  cast( '' as abap_boolean preserving type ) AS MDQltyTechRuleCndnHasDcsnTbl,
  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 _dq_rule
LEFT OUTER JOIN I_MDQualityRuleMapping ON /* join condition not captured in parsed metadata */
;