P_RSHMaintAssetBoard

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_RSHMaintAssetBoard.
-- 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: PRSHMNTASTBRD
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_RSHMaintAssetBoard AS
SELECT
  I_MaintenanceOrder.MaintenanceOrderInternalID AS MaintAssetBoardRowObjID,
  cast( I_MaintenanceOrder.MaintenanceOrder as char50) AS MaintAssetBoardReadableKey,
  cast( MaintenanceOrderDesc as char200) AS MaintAssetBoardRowDescription,
  _LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _LocationAccountAssignment._FunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName AS FunctionalLocationName,
  Equipment,
  _Equipment._EquipmentText[ 1: Language = $session.system_language ].EquipmentName AS EquipmentName,
  'leaf ' AS MaintAssetBoardRowIsExpanded,
  '1_ORDER' AS MaintAssetBoardRowObjType,
  I_MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  coalesce(_Equipment.AuthorizationGroup, _LocationAccountAssignment._FunctionalLocation.AuthorizationGroup ) as AuthorizationGroup AS AuthorizationGroupasAuthorizationGroup,
  I_MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  OperationSystemCondition,
  _OrderStatus.ProcessingStatus AS ProcessingStatus,
  coalesce( _MaterialStatus.MaterialStatus , 30 ) AS MaterialStatus,
  I_MaintenanceOrder.MaintPriority AS MaintPriority,
  I_MaintenanceOrder.MaintPriorityType AS MaintPriorityType,
  cast( _MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc as rsh_eam_priority_text preserving type ) AS MaintPriorityDesc,
  MaintenanceActivityType,
  _MaintenanceActivityType._Text[ 1: Language = $session.system_language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  cast( MainWorkCenter as rsh_eam_maint_work_center ) AS MainWorkCenter,
  cast( MainWorkCenterPlant as rsh_eam_main_workcenter_plant ) AS MainWorkCenterPlant,
  cast ( MaintOrdProcessPhaseCode as eam_maint_ord_proc_phase_code preserving type) AS MaintOrdProcessPhaseCode,
  _EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdProcessPhaseDesc,
  cast ( MaintOrdProcessSubPhaseCode as eam_maint_ord_proc_sph_code preserving type) AS MaintOrdProcessSubPhaseCode,
  _EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdProcessSubPhaseDesc,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment._ABCIndicator._Text[1:Language = $session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS SortField,
  cast( I_MaintenanceOrder.MaintenanceRevision as rsh_eam_maint_event ) AS MaintenanceEvent,
  I_MaintenanceOrder._MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceRevisionDesc,
  I_MaintenanceOrder.BasicSchedulingType AS BasicSchedulingType,
  I_MaintenanceOrder.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  cast(I_MaintenanceOrder._Project.Project as rsh_eam_project preserving type ) AS Project,
  I_MaintenanceOrder._Project.ProjectDescription AS ProjectDescription,
  cast( I_MaintenanceOrder._WBSElement.WBSElement as rsh_eam_wbs_element preserving type ) AS WBSElement,
  cast( I_MaintenanceOrder._WBSElement.WBSDescription as rsh_eam_wbs_element_desc preserving type ) AS WBSDescription,
  I_MaintenanceOrder.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _LocationAccountAssignment.FunctionalLocation AS SuperiorFunctionalLocation,
  Equipment AS SuperordinateEquipment,
  I_MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  cast( '' as warpl ) AS MaintenancePlan,
  cast( '' as wapos ) AS MaintenanceItem,
  I_MaintenanceOrder.MaintOrderProcessingContext AS MaintOrderProcessingContext,
  I_MaintenanceOrder.ServiceDocument AS ServiceDocument,
  I_MaintenanceOrder.ServiceDocumentItem AS ServiceDocumentItem,
  I_MaintenanceOrder.ServiceDocumentType AS ServiceDocumentType,
  I_MaintenanceOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  Superior.MaintObjectInternalID AS MaintAssetBoardParentRowObjID,
  FLoc.AuthorizationGroup AS AuthorizationGroup,
  '' AS MaterialStatusCode,
  FLoc._LocationAccountAssignment._WorkCenter.WorkCenter AS TechObjProductionWorkCenter,
  FLoc._LocationAccountAssignment._WorkCenter.Plant AS TechObjProdnWorkCenterPlant,
  cast( 00000000000000 as timestamp ) AS OrderStartDateTime,
  cast( 00000000000000 as timestamp ) AS OrderEndDateTime,
  cast( '00000000' as co_gstrs ) AS ScheduledBasicEndDate
FROM I_MaintenanceOrder
INNER JOIN P_RSHOrderProcessingStatus AS _OrderStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FunctionalLocation AS Superior ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintenanceItem AS MItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintPlanCallObject ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintPlanCallHistory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RSHOrderMaterialStatus AS _MaterialStatus ON _MaterialStatus.StatusObject = I_MaintenanceOrder.MaintenanceOrderInternalID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_FunctionalLocation
;