P_RSHMaintAssetBoardShapes

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_RSHMaintAssetBoardShapes.
-- 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: PRSHMNTASTBRDSHP

CREATE VIEW P_RSHMaintAssetBoardShapes AS
SELECT
  cast('ORDER' as char50 ) AS MaintAssetBoardShapeType,
  coalesce(_Equipment.AuthorizationGroup, _LocationAccountAssignment._FunctionalLocation.AuthorizationGroup ) as AuthorizationGroup AS AuthorizationGroupasAuthorizationGroup,
  OperationSystemCondition,
  _MaintenanceOrder._MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceEventText,
  cast( _MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc as rsh_eam_priority_text preserving type ) AS MaintPriorityDesc,
  cast( _MaintenanceOrder.MainWorkCenter as rsh_eam_maint_work_center ) AS MainWorkCenter,
  cast('' as eam_plngbktlabel ) AS MaintPlngBucketLabel,
  cast('' as eam_plngbktdesc ) AS MaintPlanningBucketDescription,
  cast('' as rsh_eam_person_resp_name ) AS PersonFullName,
  concat(I_MaintenanceItem.ObjectInternalID, cast( I_MaintPlanCallObject.MaintenancePlanCallNumber as char50)) AS MaintAssetBoardShapeID,
  I_MaintenanceOrder._OperationSystemCondition.ProdnWrkCtrIsRsrvdByPlntMaint AS ProdnWrkCtrIsRsrvdByPlntMaint,
  I_MaintenanceItem._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  ' ' AS MaintenanceOrder,
  ' ' AS MaintenanceOrderDesc,
  '' AS MaintenanceOrderType,
  '' AS MaintenanceOrderInternalID,
  cast ( '' as rsh_eam_maint_event ) AS MaintenanceEvent,
  '' AS MaintPriority,
  '' AS MainWorkCenterPlant,
  MaintOrdBasicStartDate AS StartDate,
  MaintOrdBasicEndDate AS EndDate,
  _LocationAccountAssignment._FunctionalLocation.AuthorizationGroup AS AuthorizationGroup,
  Equipment,
  I_MaintenanceItem.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintenanceItem.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintenanceItem.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.MaintenanceOrderInternalID AS MaintAssetBoardRowObjID
FROM I_MaintenanceOrder AS _MaintenanceOrder
INNER JOIN I_MaintenanceItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintPlanCallObject ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintenanceOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintPlanCallHistory ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_MaintenancePlanBasic
;