I_MfgOrderSFILeadTimeCube

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_MfgOrderSFILeadTimeCube.
-- 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: IMPESFILTMECU

CREATE VIEW I_MfgOrderSFILeadTimeCube AS
SELECT
  SFIConfTimeTotals.ShopFloorItem AS ShopFloorItem,
  SFIConfTimeTotals.OperationActivity AS OperationActivity,
  SFIConfTimeTotals.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIConfTimeTotals.OperationActyVersionCounter AS OperationActyVersionCounter,
  SFIConfTimeTotals._MfgOrder.Material AS Material,
  SFIConfTimeTotals.ManufacturingOrder AS ManufacturingOrder,
  cast(LeadTimePerStatusAgg._ShopFloorItem.ManufacturingOrderItem as manufacturingorderitem preserving type) AS ManufacturingOrderItem,
  cast(SFIConfTimeTotals.Operation as vornr_auf preserving type) AS Operation,
  SFIConfTimeTotals.OperationText AS OperationText,
  SFIConfTimeTotals.WorkCenter AS WorkCenter,
  SFIConfTimeTotals.Plant AS Plant,
  SFIConfTimeTotals.WorkCenterTypeCode AS WorkCenterTypeCode,
  SFIConfTimeTotals.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenterCategoryCode,
  SFIConfTimeTotals.ShopFloorItemExternalID AS ShopFloorItemExternalID,
  cast(LeadTimePerStatusAgg.DurationUnit as mpe_leadtime_uom preserving type) AS LeadTimeUnit,
  cast(LeadTimePerStatusAgg.DurationUnit as durationunit preserving type) AS DurationUnit,
  cast(SFIConfTimeTotals.OverallProductionTimeUnit as mpe_overall_time_uom preserving type ) AS OverallProductionTimeUnit,
  LeadTimePerStatusAgg.ProcessingTimeInSeconds AS ProcessingTimeInSeconds,
  LeadTimePerStatusAgg.QueueTimeInSeconds AS QueueTimeInSeconds,
  LeadTimePerStatusAgg.TimePausedInSeconds AS TimePausedInSeconds,
  LeadTimePerStatusAgg.TimeOnHoldInSeconds AS TimeOnHoldInSeconds,
  LeadTimePerStatusAgg.TimeInBuyOffInSeconds AS TimeInBuyOffInSeconds,
  LeadTimePerStatusAgg.OvrlProductionTimeInSeconds AS OvrlProductionTimeInSeconds,
  LeadTimePerStatusAgg.MaxProcessingTimeInSeconds AS MaxProcessingTimeInSeconds,
  LeadTimePerStatusAgg.MaxQueueTimeInSeconds AS MaxQueueTimeInSeconds,
  LeadTimePerStatusAgg.MaxTimePausedInSeconds AS MaxTimePausedInSeconds,
  LeadTimePerStatusAgg.MaxTimeOnHoldInSeconds AS MaxTimeOnHoldInSeconds,
  LeadTimePerStatusAgg.MaxTimeInBuyOffInSeconds AS MaxTimeInBuyOffInSeconds,
  SFIConfTimeTotals._OpActyNtwkInstance._MfgOrder.MRPArea AS MRPArea,
  SFIConfTimeTotals.ProductionPlant AS ProductionPlant,
  SFIConfTimeTotals.SerialNumber AS SerialNumber,
  SFIConfTimeTotals._OpActyNtwkInstance._OperationActivityNetwork.OperationActivityNetwork AS OperationActivityNetwork,
  SFIConfTimeTotals._OpActyNtwkInstance.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  SFIConfTimeTotals.OpActyNtwkElement AS OpActyNtwkElement,
  SFIConfTimeTotals.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  SFIConfTimeTotals.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  SFIConfTimeTotals.OpActyNtwkElementType AS OpActyNtwkElementType,
  OrderIntBillOfOperationsItem,
  SFIConfTimeTotals.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  SFIConfTimeTotals.OrderOperationInternalID AS OrderOperationInternalID,
  Date.ReportingDateWeek AS EntryDateWeek,
  Date.ReportingDateMonth AS EntryDateMonth,
  Date.ReportingDateYear AS EntryDateYear,
  cast(concat(Date.ReportingDateYear, Date.ReportingDateMonth) as vdm_yearmonth) AS EntryDateYearMonth,
  cast(Date.ReportingPeriod as pph_reportingperiod preserving type) AS ReportingPeriod,
  CreationDate,
  SFIConfTimeTotals._OpActyNtwkInstance AS _OpActyNtwkInstance,
  SFIConfTimeTotals._MfgOrder._Material AS _Material,
  SFIConfTimeTotals._MfgOrder AS _MfgOrder,
  SFIConfTimeTotals._OperationActivityInternalId AS _OperationActivityInternalId,
  SFIConfTimeTotals._ShopFloorItem AS _ShopFloorItem,
  SFIConfTimeTotals._WorkCenterType AS _WorkCenterType,
  SFIConfTimeTotals._WorkCenter AS _WorkCenter,
  AS01092017 _EntryDateMonth AS AS01092017_EntryDateMonth
FROM P_SFILeadTimePerStatusAgg AS LeadTimePerStatusAgg
INNER JOIN P_SFIConfTimeTotals AS SFIConfTimeTotals ON /* join condition not captured in parsed metadata */
INNER JOIN P_PPH_ReportingDate3 AS Date ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _LeadTimeUnit ON DurationUnit = _LeadTimeUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON WorkCenter = _WorkCenterBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterBySemanticKey.Plant  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _EntryDate ON CreationDate = _EntryDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarMonth AS _EntryDateMonth ON EntryDateMonth = _EntryDateMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_ReportingPeriod AS _ReportingPeriod ON ReportingPeriod = _ReportingPeriod.ReportingPeriod  -- association [1..1]
;