I_MaintenanceItemSituation

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_MaintenanceItemSituation.
-- 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 I_MaintenanceItemSituation AS
SELECT
  MaintenanceItem,
  MaintenanceItemDescription,
  Equipment,
  cast ( _LocationAccountAssignment.FunctionalLocation as tplnr_unconverted ) AS FunctionalLocation,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  AdditionalDeviceData,
  Assembly,
  BusinessArea,
  CreatedByUser,
  CreationDate,
  CycleSetSequence,
  ImmediateReleaseIsBlocked,
  LastChangeDate,
  LastChangedByUser,
  MaintCmplncCalculationMethod,
  MaintCmplncStrtDteOffsetInDays,
  MaintCmplncEndDateOffsetInDays,
  MaintenanceActivityType,
  MaintenanceItemHasLongText,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  SettlementRuleIsMaintained,
  _MainWorkCenter.WorkCenter AS MainWorkCenter,
  _MainWorkCenter.Plant AS MainWorkCenterPlant,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  MaintenancePlan,
  _MaintenancePlan.MaintPlanFreeDefinedAttrib AS MaintPlanFreeDefinedAttrib,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.CompanyCode AS CompanyCode,
  _LocationAccountAssignment.FixedAsset AS FixedAsset,
  _LocationAccountAssignment.MasterFixedAsset AS MasterFixedAsset,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  ServiceContract,
  ServiceContractItem,
  ServiceOrderTemplate,
  _LocationAccountAssignment.StandingOrderNumber AS StandingOrderNumber,
  MaintenanceStrategy,
  MaintenancePlanCategory,
  NotificationType,
  MaintenanceNotification,
  case _MaintenancePlanCatParam.MaintenancePlanCallObject when '' then _MaintOrderTypeControlParam.MaintPriorityType when '2' then _PMNotificationType.MaintPriorityType end as MaintPriorityType AS MaintPriorityTypeendasMaintPriorityType,
  MaintPriority,
  MaintenanceOrder,
  MaintenanceOrderType,
  SerialNumber,
  Material,
  OperationSystemCondition,
  NumberOfTaskListExecutions,
  SalesDocument,
  SettlementOrder,
  Product,
  MaintenanceItemObjectList,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  cast (_LocationAccountAssignment._WBSElementBasicData.WBSElement as ps_posid_edit ) AS WBSElement,
  ServiceDocumentType,
  MaintNotifTskIsAutomlyDtmnd,
  MaintObjectLocAcctAssgmtNmbr
FROM I_MaintenanceItem AS _MaintenanceItem
LEFT OUTER JOIN E_MaintenanceItemBasic AS _MaintenanceItemExtension ON MaintenanceItem = _MaintenanceItemExtension.MaintenanceItem  -- association [0..1]
;