I_MaintenanceJobPackage

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 I_MaintenanceJobPackage.
-- 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: IMNTJOBPCKG

CREATE VIEW I_MaintenanceJobPackage AS
SELECT
  MaintenanceJobPackageUUID,
  MaintenanceJobPackageBuildUUID,
  MaintenanceJobPackage,
  MaintenanceJobPackageName,
  MaintenanceOrder,
  MaintenanceOrderType,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenancePlant,
  PlantSection,
  ABCIndicator,
  Equipment,
  EquipmentCategory,
  FunctionalLocation,
  FunctionalLocationCategory,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterTypeCode,
  MainWorkCenterPlant,
  Assembly,
  WBSElementInternalID,
  ProjectInternalID,
  MaintenanceRevision,
  ResponsibleCostCenter,
  ControllingArea,
  MaintOrdPersonResponsible,
  MaintenanceActivityType,
  OrderSystemCondition,
  MaintPriority,
  MaintPriorityType,
  MaintOrdBasicStartDate,
  MaintOrdBasicEndDate,
  LatestAcceptableCompletionDate,
  MaintenancePlan,
  MaintenanceItem,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  BusinessArea,
  OperationWorkCenterInternalID,
  OperationControlKey,
  CostCtrActivityType,
  OperationPersonResponsible,
  OperationSystemCondition,
  OperationPurgInfoRecdSearchTxt,
  MaintOperationExecStageCode,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecEndDte,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecEndDte,
  OpActualExecutionStartDate,
  OpActualExecutionEndDate,
  OperationEquipment,
  MaintJobPckgOpsEquipCategory,
  OperationFunctionalLocation,
  MaintJobPckgOpsFuncLocCategory,
  OperationMaintenanceNotif,
  MaintOperationalChecklistType,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM eam_mjp
LEFT OUTER JOIN I_MaintJobPackageOperation AS _MaintJobPackageOperation ON MaintenanceJobPackageUUID = _MaintJobPackageOperation.MaintenanceJobPackageUUID  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceJobPackageBuild AS _MaintenanceJobPackageBuild ON MaintenanceJobPackageBuildUUID = _MaintenanceJobPackageBuild.MaintenanceJobPackageBuildUUID  -- association [1..1]
LEFT OUTER JOIN I_MaintJobPackageOutputItem AS _MaintJobPackageOutputItem ON MaintenanceJobPackage = _MaintJobPackageOutputItem.MaintenanceJobPackage  -- association [0..*]
LEFT OUTER JOIN I_MaintJobPackageStatus AS _MaintJobPackageStatus ON MaintenanceJobPackage = _MaintJobPackageStatus.MaintenanceJobPackage  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceJobPackageTotals AS _MaintenanceJobPackageTotals ON MaintenanceJobPackageUUID = _MaintenanceJobPackageTotals.MaintenanceJobPackageUUID  -- association [1..1]
LEFT OUTER JOIN I_UserDescription AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserDescription AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _OperationWorkCenter ON OperationWorkCenterInternalID = _OperationWorkCenter.WorkCenterInternalID AND _OperationWorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_OrderType AS _MaintenanceOrderType ON MaintenanceOrderType = _MaintenanceOrderType.OrderType  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhase AS _MaintOrdProcessPhase ON MaintOrdProcessPhaseCode = _MaintOrdProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _MaintOrdProcessSubPhase ON MaintOrdProcessSubPhaseCode = _MaintOrdProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhase AS _MaintOrdOpProcessPhase ON MaintOrdOpProcessPhaseCode = _MaintOrdOpProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _MaintOrdOpProcessSubPhase ON MaintOrdOpProcessSubPhaseCode = _MaintOrdOpProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_ProjectByInternalKey AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOperationExecStageCode ON MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanBasic AS _MaintenancePlan ON MaintenancePlan = _MaintenancePlan.MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlant ON MaintenancePlant = _MaintenancePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ABCIndicator AS _ABCIndicator ON ABCIndicator = _ABCIndicator.ABCIndicator  -- 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_MaintenancePlannerGroup AS _MaintenancePlannerGroup ON MaintenancePlannerGroup = _MaintenancePlannerGroup.MaintenancePlannerGroup AND MaintenancePlanningPlant = _MaintenancePlannerGroup.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItem AS _MaintenanceItem ON MaintenanceItem = _MaintenanceItem.MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _MaintOrderEquipment ON Equipment = _MaintOrderEquipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_EquipmentCategory AS _MaintOrderEquipmentCategory ON EquipmentCategory = _MaintOrderEquipmentCategory.EquipmentCategory  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceRevision AS _MaintenanceRevision ON MaintenancePlanningPlant = _MaintenanceRevision.MaintenancePlanningPlant AND MaintenanceRevision = _MaintenanceRevision.MaintenanceRevision  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _MaintOrderOpSystemCondition ON OrderSystemCondition = _MaintOrderOpSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _MaintOrdPersonResponsible ON MaintOrdPersonResponsible = _MaintOrdPersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _MaintOrdFunctionalLocation ON FunctionalLocation = _MaintOrdFunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationCategory AS _MaintOrdFuncLocationCategory ON FunctionalLocationCategory = _MaintOrdFuncLocationCategory.FunctionalLocationCategory  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _MainWorkCenter ON MainWorkCenterInternalID = _MainWorkCenter.WorkCenterInternalID AND MainWorkCenterTypeCode = _MainWorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MainWorkCenterPlant ON MainWorkCenterPlant = _MainWorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON ControllingArea = _ResponsibleCostCenter.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter AND _ResponsibleCostCenter.ValidityEndDate >= $session.system_date AND _ResponsibleCostCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlKey ON OperationControlKey = _OperationControlKey.OperationControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _MaintOrdOpPersonResponsible ON OperationPersonResponsible = _MaintOrdOpPersonResponsible.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _OperationSystemCondition ON OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _MaintOrdOpEquipment ON OperationEquipment = _MaintOrdOpEquipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_EquipmentCategory AS _MaintOrderOpEquipmentCategory ON MaintJobPckgOpsEquipCategory = _MaintOrderOpEquipmentCategory.EquipmentCategory  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _MaintOrdOpFunctionalLocation ON OperationFunctionalLocation = _MaintOrdOpFunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationCategory AS _MaintOrdOpFuncLocCategory ON MaintJobPckgOpsFuncLocCategory = _MaintOrdOpFuncLocCategory.FunctionalLocationCategory  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _OpCostCenterActivityType ON CostCtrActivityType = _OpCostCenterActivityType.CostCtrActivityType AND ControllingArea = _OpCostCenterActivityType.ControllingArea AND _OpCostCenterActivityType.ValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _OperationNotification ON OperationMaintenanceNotif = _OperationNotification.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceChecklistType AS _ChecklistType ON MaintOperationalChecklistType = _ChecklistType.MaintOperationalChecklistType  -- association [0..1]
;