P_MaintenanceSingleCycle

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_MaintenanceSingleCycle.
-- 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: PMNTSINGLECYCLE

CREATE VIEW P_MaintenanceSingleCycle AS
SELECT
  MaintenancePlan,
  NumberOfControlTableEntities,
  ComparisonOperator,
  cast ( unit_conversion( quantity => MaintPlanCycleIntervalCount, source_unit => _UnitOfMeasure._Dimension.UnitOFMeasureSiUnit, target_unit => MaintenanceTaskPerformanceUnit, error_handling=> 'KEEP_UNCONVERTED' ) as abap.dec(22,0) ) as MaintPlanCycleIntervalCount AS dec220asMaintPlanCycleIntervalCount,
  MaintenanceTaskPerformanceUnit,
  MaintPlanCycleDesc,
  Language,
  cast ( unit_conversion( quantity => MaintPlanCycleStartOffsetValue, source_unit => _UnitOfMeasure._Dimension.UnitOFMeasureSiUnit, target_unit => MaintenanceTaskPerformanceUnit, error_handling=> 'KEEP_UNCONVERTED' ) as abap.dec(22,0) ) as MaintPlanCycleStartOffsetValue AS dec220asMaintPlanCycleStartOffsetValue,
  MeasuringPoint,
  MaintCycleNextPlndCntrRdng,
  EventSchedulingIsInactive,
  CycleSetSequence,
  CycleSetSequenceRepeatFactor
FROM I_MaintenanceCycle
LEFT OUTER JOIN I_MaintenancePlan AS _MaintenancePlan ON _MaintenancePlan.MaintenancePlan = MaintenancePlan  -- association [1..1]
;