P_WorkRequestOrderUnion

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_WorkRequestOrderUnion.
-- 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: PREQORDUNION

CREATE VIEW P_WorkRequestOrderUnion AS
SELECT
  cast ( MaintenanceOrder as eam_maint_exec_obj ) AS MaintExecutionObject,
  cast ( 'WO' as eam_maint_exec_obj_type) AS MaintExecutionObjectType,
  MaintPriorityType,
  MaintPriority,
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  Equipment,
  FunctionalLocation,
  cast(_FunctionalLocation._SuperiorFunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName as eams_bcv_tplnr_no_conversion ) AS SuperiorFunctionalLocation,
  _FunctionalLocation._SuperiorFunctionalLocation._FunctionalLocationText[ 1:Language = $session.system_language ].FunctionalLocationName AS SuperiorTechnicalObjectName,
  _FunctionalLocation.FunctionalLocationCategory AS FunctionalLocationCategory,
  MaintenanceItem,
  MaintOrdMainWorkCenter AS MainWorkCenter,
  WorkCenterTypeCode,
  MaintOrdMainWorkCenterPlant AS MaintenanceWorkCenterPlant,
  WorkCenterInternalID,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintObjectLocAcctAssgmtNmbr,
  cast( '' as auswk ) AS MalfunctionEffect,
  I_MaintOrderTechObj.CreationDate AS CreationDate,
  I_MaintOrderTechObj.CreationTime AS CreationTime,
  cast(dats_tims_to_tstmp( I_MaintOrderTechObj.CreationDate, I_MaintOrderTechObj.CreationTime, abap_system_timezone($session.client,'NULL'), $session.client,'NULL') as timestamp) as CreationDateTime AS clientNULLastimestampasCreationDateTime,
  CreatedByUser,
  MaintOrdBasicStartDate AS MaintExecObjRequiredStartDate,
  MaintOrdBasicEndDate AS MaintExecObjectRequiredEndDate,
  MaintOrdBasicStartTime AS MaintExecObjRequiredStartTime,
  MaintOrdBasicEndTime AS MaintExecObjectRequiredEndTime,
  LatestAcceptableCompletionDate,
  MaintOrdPersonResponsible AS PersonResponsible,
  cast ('' as qmnam) AS ReportedByUser,
  cast ('' as ad_namtext) AS ReporterFullName,
  MaintenanceProcessingPhase,
  MaintenanceNotification,
  MaintenanceOrder,
  MaintenanceActivityType,
  Assembly,
  SerialNumber,
  _MaintNotificationTechObj.NotificationType AS NotificationType,
  ResponsibleCostCenter,
  OperationSystemCondition,
  MaintenanceOrderType AS OrderType,
  OrderHasLongText AS NotificationHasLongText,
  Currency,
  Material,
  MaintenanceOrderDesc AS DocumentText,
  MaintenanceOrderInternalID,
  cast ('' as qmcod) AS MaintNotificationCode,
  cast ('' as qmgrp) AS MaintNotificationCodeGroup,
  cast ('' as qmkat) AS MaintNotificationCatalog,
  cast ('' as msaus) AS MaintenanceObjectIsDown,
  cast('' as ausvn ) AS MalfunctionStartDate,
  cast('' as auztv ) AS MalfunctionStartTime,
  cast('' as ausvn ) AS MalfunctionEndDate,
  cast('' as auztv ) AS MalfunctionEndTime,
  _MaintNotificationTechObj.NotificationTimeZone AS NotificationTimeZone,
  MaintenancePlant,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment._Location.LocationName AS LocationName,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  _LocationAccountAssignment._ABCIndicator.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment.BusinessArea AS BusinessArea,
  _LocationAccountAssignment.CompanyCode AS CompanyCode,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment._WBSElementBasicData.WBSElementExternalID AS LocAcctAssgmtWBSElementExtID,
  _LocationAccountAssignment.CostCenter AS LocAcctAssgmtCostCenter,
  _LocationAccountAssignment.WBSElementInternalID AS WBSElementInternalID,
  ControllingArea,
  cast ('' as kostl) AS CostCenter,
  cast ('' as anln1) AS MasterFixedAsset,
  cast ('' as ilom_ordst) AS SettlementOrder,
  cast ('' as ps_posid_edit) AS OrdSettlmtWBSElementExternalID,
  cast ('' as maintordhassettlementrules) AS MaintOrdHasSettlementRules,
  ProfitCenter,
  cast ('' as qmobjnr) AS MaintNotifInternalID,
  MaintenanceOrderObjectList,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  MaintOrderProcessingContext,
  _MaintNotificationTechObj._PMNotifMaintenanceData.MaintNotifProcessingContext AS MaintNotifProcessingContext,
  _FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  FunctionalArea,
  OrderProcessingGroup,
  BasicSchedulingType,
  ReferenceElement,
  MaintenanceRevision,
  _MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceRevisionDesc,
  AdditionalDeviceData,
  LastChangeDateTime,
  _LocationAccountAssignment._MaintenancePlant.PlantName AS PlantName,
  cast( hextobin('00000000000000000000000000000000') as maintplanningbucketuuid ) AS MaintPlanningBucketUUID,
  cast( '' as eam_plngbktlabel ) AS MaintPlngBucketLabel,
  MaintOrderRoutingNumber,
  MaintOrdBasicStartDate,
  MaintOrdBasicStartTime,
  MaintOrdBasicEndDate,
  MaintOrdBasicEndTime,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  MaintOrderReferenceDate AS MaintExecObjectReferenceDate,
  MaintOrderReferenceTime AS MaintExecObjectReferenceTime,
  cast( '' as xfeld ) AS MaintenanceOrderHasChecklist,
  cast( ' ' as qplos ) AS InspectionLot,
  cast( ' ' as eams_tech_obj_alpha_conv ) AS MaintChecklistTechnicalObject
FROM I_MaintOrderTechObj
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_SchedulingTypeText AS _SchedulingTypeName ON _SchedulingTypeName.SchedulingType = BasicSchedulingType  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON _BusinessAreaText.BusinessArea = businessarea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeStdVH AS _CompanyCodeStdVH ON _CompanyCodeStdVH.CompanyCode = companycode  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment AND _EquipmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation AND _FunctionalLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON _FunctionalAreaText.FunctionalArea = FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItemBasic AS _MaintenanceItem ON MaintenanceItem = _MaintenanceItem.MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriorityType AS _MaintenancePriorityType ON MaintPriorityType = _MaintenancePriorityType.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriority AS _MaintenancePriority ON MaintPriority = _MaintenancePriority.MaintPriority AND MaintPriorityType = _MaintenancePriority.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanningBucketTP AS _MaintenancePlanningBucket ON _MaintenancePlanningBucket.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON _CostCenterText.CostCenter = ResponsibleCostCenter AND _CostCenterText.ControllingArea = ControllingArea AND _CostCenterText.ValidityEndDate = '12319999' AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _MaintNotificationExtension ON MaintenanceNotification = _MaintNotificationExtension.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintOrderExtension ON MaintenanceOrder = _MaintOrderExtension.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanningBucketVH AS _MaintPlanningBucketVH ON _MaintPlanningBucketVH.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..1]
LEFT OUTER JOIN I_MaintNotificationTechObj AS _MaintNotificationTechObj ON MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdNrOfChecklist AS _MaintOrdNrOfChecklist ON _MaintOrdNrOfChecklist.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PMNotifMaintenanceData
;