P_SFILeadTimePerStatusAgg

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 P_SFILeadTimePerStatusAgg.
-- 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: PMPESFILTMSTAG

CREATE VIEW P_SFILeadTimePerStatusAgg AS
SELECT
  ConfTimeTotals.ShopFloorItem AS ShopFloorItem,
  ConfTimeTotals.OpActyNtwkInstance AS OpActyNtwkInstance,
  ConfTimeTotals.OperationActivity AS OperationActivity,
  SFI_LeadTime_per_Status.OperationActyVersionCounter AS OperationActyVersionCounter,
  SFI_LeadTime_per_Status.DurationUnit AS DurationUnit,
  cast(sum(ProcessingTimeInSeconds) as mpe_timeinprocessinsec) AS ProcessingTimeInSeconds,
  cast(max(MaxProcessingTimeInSeconds) as mpe_maxprocessingtimeinsec) AS MaxProcessingTimeInSeconds,
  cast(sum (QueueTimeInSeconds) as mpe_timeinqueueinsec preserving type) AS QueueTimeInSeconds,
  cast(max(MaxQueueTimeInSeconds) as mpe_maxqueuetimeinsec) AS MaxQueueTimeInSeconds,
  cast(sum (TimePausedInSeconds)as mpe_timepaused_insec preserving type) AS TimePausedInSeconds,
  cast(max(MaxTimePausedInSeconds) as mpe_maxtimepausedinsec) AS MaxTimePausedInSeconds,
  cast(sum (TimeOnHoldInSeconds) as mpe_timeonholdinsec preserving type) AS TimeOnHoldInSeconds,
  cast(max(MaxTimeOnHoldInSeconds) as mpe_maxtimeonholdinsec) AS MaxTimeOnHoldInSeconds,
  cast(sum(TimeInBuyOffInSeconds) as mpe_timeinbuyoffinsec preserving type) AS TimeInBuyOffInSeconds,
  cast(max(MaxTimeInBuyOffInSeconds) as mpe_maxtimeinbuyoffinsec) AS MaxTimeInBuyOffInSeconds,
  cast(sum(OvrlTimeInProductionInSeconds) as ovrltimeinproductioninsec) AS OvrlProductionTimeInSeconds,
  cast(max(MaxOvrlTimeInProdnInSeconds) as mpe_maxovrlprodntimeinsec) AS MaxOvrlTimeInProdnInSeconds,
  cast(substring(cast(ConfTimeTotals._ShopFloorItem.CreationDateTime as abap.char(32)),1,8) as mpe_create_date) AS CreationDate,
  WorkCenterInternalID,
  ConfTimeTotals.WorkCenter AS WorkCenter,
  ConfTimeTotals.Plant AS Plant,
  WorkCenterTypeCode,
  ConfTimeTotals._OperationActivityInternalId AS _OperationActivityInternalId,
  ConfTimeTotals._OpActyNtwkInstance AS _OpActyNtwkInstance,
  ConfTimeTotals._ShopFloorItem AS _ShopFloorItem
FROM P_SFILeadTimePerStatus AS SFI_LeadTime_per_Status
INNER JOIN P_SFIConfTimeTotals AS ConfTimeTotals ON /* join condition not captured in parsed metadata */
;