I_MaintItemObjListTechObj

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_MaintItemObjListTechObj.
-- 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: IMNTITMOBJLISTTO

CREATE VIEW I_MaintItemObjListTechObj AS
SELECT
  MaintenanceItemObjectList,
  MaintenanceItemObject,
  Equipment,
  FunctionalLocation,
  cast ( 'EAMS_EQUI' as eams_tec_obj_type_value ) AS TechObjIsEquipOrFuncnlLoc,
  cast ( Equipment as eams_tec_obj ) AS TechnicalObject,
  cast ( Equipment as eams_tech_obj_conv ) AS TechnicalObjectLabel,
  cast ( _EquipmentText[1:Language = $session.system_language].EquipmentName as eams_tec_obj_des ) AS TechnicalObjectDescription,
  Assembly,
  Material,
  SerialNumber,
  MaintenanceNotification,
  MaintObjectLocAcctAssgmtNmbr,
  SortField,
  Product
FROM I_MaintenanceItemObject
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation  -- association [0..*]
-- UNION ALL with additional select branch(es): I_MaintenanceItemObject
;