I_MaintenanceStrategy

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_MaintenanceStrategy.
-- 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: IMAINTSTRAT

CREATE VIEW I_MaintenanceStrategy AS
SELECT
  t351.strat AS MaintenanceStrategy,
  t351.zeieh AS MaintenanceTaskPerformanceUnit,
  t351.leieh AS MaintenanceStrategyActyUnit,
  t351.zyk1g AS MaintenanceStrategyCycTotDurn,
  t351.zyk2g AS MaintenanceStrategyCycDurn,
  t351.zyk1k AS MaintPackageMinimumStepValue,
  t351.zyk2k AS PerfBasedMaintPckgMinStepValue,
  t351.anzp1 AS NumberOfMaintenancePackages,
  t351.anzp2 AS NumberOfPerfBasedMaintPackages,
  t351.tole1 AS LateCompletionTolerancePercent,
  t351.tole2 AS EarlyCompletionTolerancePct,
  t351.vers1 AS LateCompletionShiftInPercent,
  t351.vers2 AS EarlyCompletionShiftInPercent,
  t351.termk AS MaintStrategySchedulingCode,
  t351.horiz AS MaintenanceCallHorizonPercent,
  cast(t351.horiz_qualifier as eam_cc_callhorizon_calc_type preserving type) AS MaintenanceCallHorizonCalcType,
  t351.fabkl AS FactoryCalendar,
  t351.authgr AS AuthorizationGroup
FROM t351
LEFT OUTER JOIN I_MaintenanceStrategyT AS _MaintenanceStrategyText ON _MaintenanceStrategyText.MaintenanceStrategy = MaintenanceStrategy  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaintenanceStrategyUnit ON _MaintenanceStrategyUnit.UnitOfMeasure = MaintenanceTaskPerformanceUnit  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON _FactoryCalendar.FactoryCalendar = FactoryCalendar  -- association [0..1]
;