I_IPUTSCoverageGapDetailer

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_IPUTSCoverageGapDetailer.
-- 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_IPUTSCoverageGapDetailer AS
SELECT
  IPUTSTestPlanUUID,
  IPUTSTestPlanGroupUUID,
  IPUTSTestPlanID,
  IPUTSTestPlanName,
  IPUTSTestProcessID,
  IPUTSTestProcessName,
  IPUTSVariantID,
  IPUTSVariantName,
  IPUTSVariantDescription,
  IPUTSCloudRelease,
  IPUTSLogID,
  IPUTSStatus,
  IPUTSStatusDescription,
  _CoverageGapDetails.update_flag AS IPUTSCoverageFlag,
  cast(concat (concat (concat( '/ui#TestAutomation-createTestPlan&/log/' , IPUTSTestPlan.IPUTSTestPlanID), '/') , IPUTSTestPlan.IPUTSLogID ) as char1024) as IPUTSLogIdURL AS IPUTSLogIDaschar1024asIPUTSLogIdURL,
  IPUTSSystemID,
  IPUTSExecutedOnDate,
  _CoverageGapDetails.created_by AS IPUTSTestPlanCreatedBy,
  _CoverageGapDetails.created_at AS IPUTSCreatedDateTime,
  _CoverageGapDetails.changed_by AS IPUTSTestPlanChangedBy,
  _CoverageGapDetails.changed_at AS IPUTSChangedDateTime
FROM I_IPUTSTestPlanDetail AS IPUTSTestPlan
LEFT OUTER JOIN iputs_a_covgapdt AS _CoverageGapDetails ON IPUTSTestPlanUUID = _CoverageGapDetails.tpname_id  -- association [0..1]
LEFT OUTER JOIN I_IPUTSScpDurationUsrVH AS _UserName ON IPUTSTestPlanCreatedBy = _UserName.IPUTSAuthUser  -- association [1..1]
;