I_TrackToolUsageHistoryData

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_TrackToolUsageHistoryData.
-- 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.
-- SQL view name: ITTUMHISTORYDATA

CREATE VIEW I_TrackToolUsageHistoryData AS
SELECT
  EquipmentHistoryDocument,
  Equipment,
  EquipmentClaimType,
  EquipmentClaimedByUser,
  EquipmentClaimDateTime,
  EquipmentUnclaimedByUser,
  EquipmentUnclaimDateTime,
  _UsageCountForDoc.NmbrOfObjectsClaimingEquipment AS NmbrOfObjectsClaimingEquipment,
  case when EquipmentClaimDateTime is not initial and EquipmentClaimDateTime > EquipmentUnclaimDateTime then cast( TSTMP_SECONDS_BETWEEN(EquipmentClaimDateTime, tstmp_current_utctimestamp(), 'NULL') as abap.fltp ) when EquipmentClaimDateTime is not initial and EquipmentClaimDateTime < EquipmentUnclaimDateTime then cast( TSTMP_SECONDS_BETWEEN(EquipmentClaimDateTime, EquipmentUnclaimDateTime, 'NULL') as abap.fltp ) end as EquipClaimDurationInSeconds AS fltpendasEquipClaimDurationInSeconds,
  _UsageHistWrkCtr.WorkCenterInternalID AS WorkCenterInternalID,
  _UsageHistoryUser.BusinessPartner AS BusinessPartner
FROM I_TrackToolUsageHistory
LEFT OUTER JOIN I_TrackToolUsageHistoryUser AS _UsageHistoryUser ON EquipmentHistoryDocument = _UsageHistoryUser.EquipmentHistoryDocument  -- association [0..*]
LEFT OUTER JOIN I_TrackToolUsageHistWrkCtr AS _UsageHistWrkCtr ON EquipmentHistoryDocument = _UsageHistWrkCtr.EquipmentHistoryDocument  -- association [0..*]
LEFT OUTER JOIN I_TrackToolUsageHistOpActy AS _UsageHistOpActy ON EquipmentHistoryDocument = _UsageHistOpActy.EquipmentHistoryDocument  -- association [0..*]
LEFT OUTER JOIN I_TrackToolUsageCountForDoc AS _UsageCountForDoc ON EquipmentHistoryDocument = _UsageCountForDoc.EquipmentHistoryDocument AND EquipmentClaimType = _UsageCountForDoc.EquipmentClaimType  -- association [0..1]
;