I_MaintenanceRevision

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_MaintenanceRevision.
-- 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: IMAINTREVISION

CREATE VIEW I_MaintenanceRevision AS
SELECT
  t352r.iwerk AS MaintenancePlanningPlant,
  t352r.revnr AS MaintenanceRevision,
  t352r.revtx AS MaintenanceRevisionDesc,
  t352r.revty AS MaintenanceEventType,
  cast( t352r.revbd as eam_revision_start_date preserving type ) AS RevisionStartDate,
  cast( case when t352r.revbz = '' then '000000' else t352r.revbz end as eam_revision_start_time preserving type ) AS RevisionStartTime,
  cast( t352r.reved as eam_revision_end_date preserving type ) AS RevisionEndDate,
  cast( case when t352r.revez = '' then '000000' else t352r.revez end as eam_revision_end_time preserving type ) AS RevisionEndTime,
  cast( t352r.revab as xfeld ) AS RevisionIsCompleted,
  t352r.erdat AS CreationDate,
  t352r.ernam AS CreatedByUser,
  t352r.aedat AS LastChangeDate,
  t352r.aenam AS LastChangedByUser,
  _NumberRangeIntervals.externind AS IsExternalNumberRange,
  _RevisionType.wps_control AS MaintenanceEventTypeCategory
FROM t352r
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsCompleted ON _IsCompleted.IndicatorValue = RevisionIsCompleted  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanPlant ON MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN nriv AS _NumberRangeIntervals ON _NumberRangeIntervals.nrrangenr = '01' AND _NumberRangeIntervals.object = 'WPS_REV' AND _NumberRangeIntervals.subobject = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN diwps_revty_t AS _RevisionType ON MaintenanceEventType = _RevisionType.revty  -- association [0..1]
;