C_MDQualityRuleImportTP

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_MDQualityRuleImportTP.
-- 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_MDQualityRuleImportTP AS
SELECT
  MDQltyRuleImportUUID,
  MDQltyBusinessObjectTypeCode,
  MDQltyRuleImport,
  MDQltyRuleImportName,
  MDQltyRuleImportText,
  MDQltyRuleImportSourceSystem,
  MDQltyRuleImportStatus,
  _MDQualityRuleImportStatus.MDQltyRuleImprtStsCriticality AS MDQltyRuleImprtStsCriticality,
  MDQltyRuleImprtCrtnDateTime,
  MDQltyRuleImportCreatedByUser,
  MDQltyRuleImportChangeDateTime,
  MDQltyRuleImportChangedByUser,
  MDQltyRuleImprtCompltnDateTime,
  MDQltyRuleImprtCompletedByUser,
  MDQltyRuleImportValidationUUID,
  cast( MDQltyRuleImportLogHandle as char22 preserving type ) AS MDQltyRuleImportLogHandle,
  _MDQualityRuleImportDetails.NmbrOfMDQltyImportedRules AS NmbrOfMDQltyImportedRules,
  _MDQualityRuleImportDetails.NmbrOfSeldMDQltyImportedRules AS NmbrOfSeldMDQltyImportedRules,
  _MDQualityRuleImportDetails.MDQltyRuleImportIsNotFinished AS MDQltyRuleImportIsNotFinished
FROM I_MDQualityRuleImportTP
LEFT OUTER JOIN C_MDQualityImportedRuleTP AS _MDQualityImportedRuleTP ON MDQltyRuleImportUUID = _MDQualityImportedRuleTP.MDQltyRuleImportUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQualityRuleImportFileTP AS _MDQualityRuleImportFileTP ON MDQltyRuleImportUUID = _MDQualityRuleImportFileTP.MDQltyRuleImportUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQltyRuleImprtFileContentTP AS _MDQltyRuleImprtFileContentTP ON MDQltyRuleImportUUID = _MDQltyRuleImprtFileContentTP.MDQltyRuleImportUUID  -- association [0..*]
LEFT OUTER JOIN C_MDQualityRuleImportDetails AS _MDQualityRuleImportDetails ON MDQltyRuleImportUUID = _MDQualityRuleImportDetails.MDQltyRuleImportUUID  -- association [0..1]
LEFT OUTER JOIN I_MDQualityRuleImportStatus AS _MDQualityRuleImportStatus ON MDQltyRuleImportStatus = _MDQualityRuleImportStatus.MDQltyRuleImportStatus  -- association [0..1]
LEFT OUTER JOIN I_MDQualityRuleImportStatusT AS _MDQualityRuleImportStatusT ON MDQltyRuleImportStatus = _MDQualityRuleImportStatusT.MDQltyRuleImportStatus  -- association [0..*]
LEFT OUTER JOIN C_MDQualityRuleImportCreatorVH AS _MDQualityRuleImportCreatorVH ON MDQltyRuleImportCreatedByUser = _MDQualityRuleImportCreatorVH.MDQltyRuleImportCreatedByUser AND MDQltyBusinessObjectTypeCode = _MDQualityRuleImportCreatorVH.MDQltyBusinessObjectTypeCode  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _CreatedByUserContactCard ON MDQltyRuleImportCreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_MDCloudUserContactCard AS _CompletedByUserContactCard ON MDQltyRuleImprtCompletedByUser = _CompletedByUserContactCard.ContactCardID  -- association [0..1]
;