I_UtilitiesServiceDurationTP

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_UtilitiesServiceDurationTP.
-- 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_UtilitiesServiceDurationTP AS
SELECT
  CustMgmtObjectType,
  CustMgmtActivity,
  CreatedByUser,
  _UserData.UserDescription AS UserDescription,
  _ServiceDefect.ServiceDefectCodeCatalog AS ServiceDefectCodeCatalog,
  _ServiceDefect.ServiceDefectCodeGroup AS ServiceDefectCodeGroup,
  _ServiceDefect.ServiceDefectCode AS ServiceDefectCode,
  _ServiceDefect.DefectCodeText AS DefectCodeText,
  DistributionChannel,
  _DistributionChannelText.DistributionChannelName AS DistributionChannelName,
  CustMgmtActivityStartDateTime,
  CustMgmtActivityEndDateTime,
  cast(WorkDuration as abap.decfloat16) AS WorkDuration
FROM I_UtilitiesServiceDuration
LEFT OUTER JOIN I_UtilitiesServiceDefectTP AS _ServiceDefect ON _ServiceDefect.ServiceObjectType = CustMgmtObjectType AND _ServiceDefect.ServiceDocument = CustMgmtActivity AND _ServiceDefect.SrvcDocTypeDefectCodeProfType = 'F'  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserData ON _UserData.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON _DistributionChannelText.DistributionChannel = DistributionChannel AND _DistributionChannelText.Language = $session.system_language  -- association [0..1]
;