I_MaintenanceItemData

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_MaintenanceItemData.
-- 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: IMAINTITEMDATA

CREATE VIEW I_MaintenanceItemData AS
SELECT
  MaintenanceItem,
  MaintObjectLocAcctAssgmtNmbr,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  BusinessArea,
  MainWorkCenterInternalID,
  WorkCenterTypeCode,
  cast( _MainWorkCenter.WorkCenter as gewrk preserving type ) AS MainWorkCenter,
  _MainWorkCenter.Plant AS MainWorkCenterPlant,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  Equipment,
  Assembly,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceItemDescription,
  MaintenancePlan,
  MaintenancePlanItemPosition,
  MaintenanceStrategy,
  MaintenancePlanCategory,
  NotificationType,
  MaintenanceNotification,
  MaintPriorityType,
  MaintPriority,
  MaintenanceOrder,
  MaintenanceActivityType,
  MaintenanceOrderType,
  SerialNumber,
  Material,
  OperationSystemCondition,
  MaintenanceItemIsInactive,
  ObjectInternalID,
  MaintObjectCategory,
  SalesDocument,
  PurchaseOrder,
  PurchaseOrderItem,
  SettlementOrder AS SettlementOrdForServiceProcmt,
  LastChangeDateTime,
  MaintPlanLastChangeDateTime,
  ImmediateReleaseIsBlocked,
  CycleSetSequence,
  ReferenceElement,
  _LocationAccountAssignment.WorkCenterInternalID AS WorkCenterInternalID,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  _LocationAccountAssignment._WorkCenter.Plant AS WorkCenterPlant,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment.SettlementOrder AS SettlementOrder,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.CompanyCode AS CompanyCode,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment.WBSElementInternalID AS WBSElementInternalID,
  cast( _LocationAccountAssignment._WBSElementBasicData.WBSElement as ps_posid preserving type ) AS WBSElement,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _MainWorkCenter._Plant AS _Plant,
  _LocationAccountAssignment._ABCIndicator AS _ABCIndicator,
  _LocationAccountAssignment._SettlementOrder AS _SettlementOrder,
  _LocationAccountAssignment._PlantSection AS _PlantSection,
  _LocationAccountAssignment._CompanyCode AS _CompanyCode,
  _LocationAccountAssignment._ControllingArea AS _ControllingArea,
  _LocationAccountAssignment._CostCenter AS _CostCenter,
  _LocationAccountAssignment._WBSElementBasicData AS _WBSElementBasicData,
  _LocationAccountAssignment._Location AS _Location,
  _LocationAccountAssignment._MaintenancePlant AS _MaintenancePlant,
  _LocationAccountAssignment._FunctionalLocation AS _FunctionalLocation
FROM I_MaintenanceItemTechObj
LEFT OUTER JOIN I_EquipmentData AS _EquipmentData ON Equipment = _EquipmentData.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationData AS _FunctionalLocationData ON FunctionalLocation = _FunctionalLocationData.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _WorkCenterPlant ON WorkCenterPlant = _WorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON workcenterinternalid = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _MainWorkCenterBySemanticKey ON MainWorkCenter = _MainWorkCenterBySemanticKey.WorkCenter AND MainWorkCenterPlant = _MainWorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON workcenter = _WorkCenterBySemanticKey.WorkCenter AND WorkCenterPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanPlant ON MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceItemBasic AS _MaintenanceItemExtension ON _MaintenanceItemExtension.MaintenanceItem = MaintenanceItem  -- association [0..1]
;