C_MaintJobPackageOperationTP

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_MaintJobPackageOperationTP.
-- 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 C_MaintJobPackageOperationTP AS
SELECT
  MaintJobPackageOperationUUID,
  MaintenanceJobPackageUUID,
  MaintenanceJobPackageBuildUUID,
  MaintenanceOrder,
  _MaintenanceOrderOperation._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  _MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  _MaintenanceOrderOperation.Equipment AS Equipment,
  _MaintenanceOrderOperation._Equipment._EquipmentText.EquipmentName : localized AS EquipmentNamelocalized,
  _MaintenanceOrderOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText.MaintOpExecutionStageName : localized AS MaintOpExecutionStageNamelocalized,
  _MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText.MaintOpExecStageShortText : localized AS MaintOpExecStageShortTextlocalized,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _MaintenanceOrderOperation._OperationPlanningValues._PlannedWorkUnitOfMeasure._Text.UnitOfMeasureName : localized AS UnitOfMeasureNamelocalized,
  _MaintenanceOrderOperation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  _MaintenanceOrderOperation._EAMProcessPhase._EAMProcessPhaseText.EAMProcessPhaseCodeDesc : localized AS EAMProcessPhaseCodeDesclocalized,
  _MaintenanceOrderOperation.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  _MaintenanceOrderOperation._EAMProcessSubPhase._EAMProcessSubPhaseText.EAMProcessSubPhaseCodeDesc : localized AS EAMProcessSubPhaseCodeDesclocalized,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _MaintenanceOrderOperation._MaintenanceOrder.MaintPriority AS MaintPriority,
  _MaintenanceOrderOperation._MaintenanceOrder._MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _MaintenanceOrderOperation.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _MaintenanceOrderOperation._WorkCenter.WorkCenter AS WorkCenter,
  _MaintenanceOrderOperation._WorkCenter._Text.WorkCenterText : localized AS WorkCenterTextlocalized,
  _MaintenanceOrderOperation.OperationControlKey AS OperationControlKey,
  _MaintenanceOrderOperation._OperationControlKey._Text.OperationControlProfileName : localized AS OperationControlProfileNamelocalized,
  _MaintenanceOrderOperation.ActivityType AS ActivityType,
  _MaintenanceOrderOperation._CostCenterActivityTypeText[ 1: ValidityEndDate = '99991231' and Language = $session.system_language ].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _MaintenanceOrderOperation.OperationPersonResponsible AS OperationPersonResponsible,
  _MaintenanceOrderOperation._PersonResponsible.PersonFullName AS OperationPersonRespName,
  _MaintenanceOrderOperation.OperationSystemCondition AS OperationSystemCondition,
  _MaintenanceOrderOperation._OperationSystemCondition._Text.OperationSystemConditionText : localized AS OperationSystemConditionTextlocalized,
  cast( _MaintenanceOrderOperation.FunctionalLocation as tplnr_unconverted preserving type ) AS FunctionalLocation,
  _MaintenanceOrderOperation._FunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _MaintenanceOrderOperation._FunctionalLocation._FunctionalLocationText.FunctionalLocationName : localized AS FunctionalLocationNamelocalized,
  _MaintenanceOrderOperation.OperationPurgInfoRecdSearchTxt AS OperationPurgInfoRecdSearchTxt,
  _MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject.MaintenanceNotification AS OperationMaintenanceNotif,
  _MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject._MaintenanceNotification.NotificationText AS OperationMaintNotificationText,
  _MaintenanceOrderOperation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  _MaintOrderOperTechObj._MaintenanceOrder.MaintenanceOrderInternalID AS MaintenanceOrderInternalID
FROM R_MaintJobPackageOperationTP
;