C_RSHOpUnassignedWork

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 C_RSHOpUnassignedWork.
-- 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: CRSHOPUNASWORK

CREATE VIEW C_RSHOpUnassignedWork AS
SELECT
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintPriority,
  _MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _MaintenancePriority.MaintPriorityType AS MaintPriorityType,
  cast( '' as rsh_eam_priority_colorcodetext) AS MaintPriorityColorCodeText,
  OperationControlKey,
  MaintenanceOrderType AS OrderType,
  MaintenanceActivityType,
  cast( MainWorkCenter as rsh_eam_main_workcenter ) AS WorkCenter,
  cast( Plant as rsh_eam_work_center_plant ) AS Plant,
  cast( _MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc as rsh_eam_priority_text preserving type ) AS MaintPriorityDesc,
  _MaintenanceActivityType._Text[ 1: Language = $session.system_language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  cast( '' as rsh_eam_processing_status_text ) AS ProcessingStatusText,
  cast (0 as rsh_eam_unassigned_work ) AS MaintOrdOperationsUnassgWork,
  cast (0 as rsh_eam_unassigned_work ) AS MaintOrdOperationsTotUnassgWrk,
  'FUTURE' AS PeriodType,
  '10' AS MaintOperationAssignmentStatus,
  cast( '' as rsh_eams_ord_tec_obj ) AS TechnicalObjectLabel,
  cast( '' as rsh_eam_ord_tec_obj_type_value) AS TechObjIsEquipOrFuncnlLoc,
  cast( '' as rsh_eam_abc_ind ) AS ABCIndicator,
  Operations.Equipment AS Equipment,
  Operations.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  Operations.OperationPersonResponsible AS OperationPersonResponsible,
  Operations.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  Operations.MaintenanceOrderType AS MaintenanceOrderType,
  Operations.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  Operations.MaintenanceRevision AS MaintenanceRevision,
  Operations.MainWorkCenter AS MainWorkCenter,
  Operations.MainWorkCenterPlant AS MainWorkCenterPlant,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _LocationAccountAssignment.FunctionalLocation AS FunctionalLocation
FROM I_RSHOperationAndSubOperation AS Operations
;