P_MaintTechObjBreakdown

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_MaintTechObjBreakdown.
-- 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.

CREATE VIEW P_MaintTechObjBreakdown AS
SELECT
  TechObjBrkDwn.LeadingMaintNotification AS LeadingMaintNotification,
  TechObjBrkDwn.MaintenancePlant AS MaintenancePlant,
  TechObjBrkDwn.MaintenanceNotification AS MaintenanceNotification,
  TechObjBrkDwn.MalfunctionStartDate AS MalfunctionStartDate,
  TechObjBrkDwn.MalfunctionEndDate AS MalfunctionEndDate,
  TechObjBrkDwn.MalfunctionStartTime AS MalfunctionStartTime,
  TechObjBrkDwn.MalfunctionEndTime AS MalfunctionEndTime,
  TechObjBrkDwn.S1MalfunctionStartDateTime AS S1MalfunctionStartDateTime,
  TechObjBrkDwn.S1MalfunctionEndDateTime AS S1MalfunctionEndDateTime,
  TechObjBrkDwn.EffctvMalfunctionEndDateTime AS EffctvMalfunctionEndDateTime,
  TechObjBrkDwn.EffctvMalfunctionStartDateTime AS EffctvMalfunctionStartDateTime,
  TechObjBrkDwn.TechnicalObject AS TechnicalObjectForJoin,
  cast( TechObjBrkDwn.TechnicalObject as eams_tec_obj ) AS TechnicalObject,
  TechObjBrkDwn.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFunLocForJoin,
  cast( TechObjBrkDwn.TechObjIsEquipOrFuncnlLoc as eams_tec_obj_type_value ) AS TechObjIsEquipOrFuncnlLoc,
  TechObjBrkDwn.NumberOfReportedBreakdowns AS NumberOfReportedBreakdowns,
  _TechnicalObject.TechnicalObjectType AS TechnicalObjectType,
  _TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  _TechnicalObject.AssetManufacturerName AS AssetManufacturerName,
  _TechnicalObject.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  _TechnicalObject.ConstructionMaterial AS ConstructionMaterial,
  _TechnicalObject.ManufacturerCountry AS ManufacturerCountry,
  _TechnicalObject.AuthorizationGroup AS AuthorizationGroup,
  _TechnicalObject.ConstructionYear AS ConstructionYear,
  _TechnicalObject.ConstructionMonth AS ConstructionMonth,
  TechObjBrkDwn.UnitOfMeasure AS UnitOfMeasure,
  TechObjBrkDwn.TimeBetweenRepairInHours AS TimeBetweenRepairInHours,
  TechObjBrkDwn.TotalRepairTimeInHours AS TotalRepairTimeInHours,
  _TechnicalObject.Equipment AS Equipment,
  _TechnicalObject._ManufacturerCountry AS _ManufacturerCountry,
  _TechnicalObject._TechnicalObjectType AS _TechnicalObjectType
FROM P_MaintObjBrkdwnTableFunction
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON TechnicalObjectForJoin = _TechnicalObject.TechnicalObject AND TechObjIsEquipOrFunLocForJoin = _TechnicalObject.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _Date ON MalfunctionEndDate = _Date.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON TechObjIsEquipOrFunLocForJoin = _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_EquipmentTimeSeg AS _EquipmentTimeSeg ON _EquipmentTimeSeg.Equipment = Equipment AND _EquipmentTimeSeg.ValidityStartDate <= MalfunctionStartDate AND _EquipmentTimeSeg.ValidityEndDate > MalfunctionStartDate  -- association [0..1]
;