I_MaintenanceOrder
Maintenance Order
I_MaintenanceOrder is a Basic CDS View that provides data about "Maintenance Order" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderBasic) and exposes 145 fields with key field MaintenanceOrder. It has 60 associations to related views. Part of development package IWO1.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrderBasic | _OrderBasic | from |
Associations (60)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_LogisticsOrder | _Order | _Order.OrderID = $projection.MaintenanceOrder |
| [1..1] | I_OrderCategory | _MaintenanceOrderCategory | $projection.MaintenanceOrderCategory = _MaintenanceOrderCategory.OrderCategory |
| [1..1] | I_OrderType | _MaintenanceOrderType | $projection.MaintenanceOrderType = _MaintenanceOrderType.OrderType |
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
| [0..1] | I_ControllingObjectClass | _ControllingObjectClass | $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass |
| [0..1] | I_CompanyCode | _CompanyCode | $projection.CompanyCode = _CompanyCode.CompanyCode |
| [0..*] | I_CostCenter | _ResponsibleCostCenter | $projection.ControllingArea = _ResponsibleCostCenter.ControllingArea and $projection.ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter |
| [0..*] | I_ProfitCenter | _ProfitCenter | $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter |
| [0..1] | I_Plant | _LocationPlant | $projection.MaintenancePlant = _LocationPlant.Plant |
| [0..1] | I_SchedulingType | _BasicSchedulingType | $projection.BasicSchedulingType = _BasicSchedulingType.SchedulingType |
| [0..1] | I_MaintenanceTaskList | _MaintenanceTaskList | $projection.TaskListType = _MaintenanceTaskList.TaskListType and $projection.TaskListGroup = _MaintenanceTaskList.TaskListGroup and $projection.TaskListGroupCounter = _MaintenanceTaskList.TaskListGroupCounter with default filter _MaintenanceTaskList.ValidityEndDate = '99991231' |
| [0..1] | I_OrderItem | _OrderItem | $projection.MaintenanceOrder = _OrderItem.OrderID and _OrderItem.OrderItem = '0001' |
| [0..*] | I_MaintenanceOrderOperation | _MaintenanceOrderOperation | $projection.MaintOrderRoutingNumber = _MaintenanceOrderOperation.MaintOrderRoutingNumber |
| [0..*] | I_MaintenanceOrderCost | _MaintenanceOrderCost | $projection.MaintenanceOrderInternalID = _MaintenanceOrderCost.MaintenanceOrderInternalID |
| [0..*] | I_MaintenanceOrderComponent_2 | _MaintenanceOrderComponent | $projection.MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder |
| [0..1] | I_LocationAccountAssignment | _LocationAccountAssignment | $projection.MaintObjectLocAcctAssgmtNmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr |
| [0..1] | I_MaintenanceNotification | _MaintenanceNotification | $projection.MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification |
| [0..1] | I_Equipment | _Equipment | $projection.Equipment = _Equipment.Equipment |
| [0..1] | I_Material | _Assembly | $projection.Assembly = _Assembly.Material |
| [0..1] | I_MaintenancePlanBasic | _MaintenancePlan | $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan |
| [0..1] | I_MaintenanceItem | _MaintenanceItem | $projection.MaintenanceItem = _MaintenanceItem.MaintenanceItem |
| [0..1] | I_Plant | _MaintenancePlanningPlant | $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant |
| [0..1] | I_PMNotificationPriorityType | _MaintenancePriorityType | $projection.MaintPriorityType = _MaintenancePriorityType.MaintPriorityType |
| [0..1] | I_PMNotificationPriority | _MaintenancePriority | $projection.MaintPriority = _MaintenancePriority.MaintPriority and $projection.MaintPriorityType = _MaintenancePriority.MaintPriorityType |
| [0..1] | I_WorkCenter | _MainWorkCenter | $projection.WorkCenterInternalID = _MainWorkCenter.WorkCenterInternalID and $projection.WorkCenterTypeCode = _MainWorkCenter.WorkCenterTypeCode |
| [1..1] | I_WorkCenterType | _WorkCenterType | $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode |
| [0..1] | I_MaintenanceActivityType | _MaintenanceActivityType | $projection.MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType |
| [0..*] | I_PlantMaintenancePartner | _MaintenancePartner | $projection.MaintenanceOrderInternalID = _MaintenancePartner.MaintObjectInternalID |
| [0..1] | I_BusinessArea | _BusinessArea | $projection.BusinessArea = _BusinessArea.BusinessArea |
| [0..1] | I_FunctionalArea | _FunctionalArea | $projection.FunctionalArea = _FunctionalArea.FunctionalArea |
| [0..1] | I_MaintenancePlannerGroup | _MaintenancePlannerGroup | $projection.MaintenancePlannerGroup = _MaintenancePlannerGroup.MaintenancePlannerGroup and $projection.MaintenancePlanningPlant = _MaintenancePlannerGroup.MaintenancePlanningPlant |
| [0..1] | I_MaintenanceOrderPhase | _MaintenanceOrderPhase | $projection.MaintenanceProcessingPhase = _MaintenanceOrderPhase.MaintenanceProcessingPhase |
| [0..1] | I_StatusObject | _StatusObject | $projection.MaintenanceOrderInternalID = _StatusObject.StatusObject |
| [1..*] | I_StatusObjectStatus | _StatusObjectStatus | $projection.MaintenanceOrderInternalID = _StatusObjectStatus.StatusObject |
| [0..1] | I_MaintOperationSystCondition | _OperationSystemCondition | $projection.OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition |
| [0..1] | I_Indicator | _OrderHasLongText | $projection.OrderHasLongText = _OrderHasLongText.IndicatorValue |
| [0..1] | I_MaintOrdPlngDegreeCode | _MaintOrdPlngDegreeCode | $projection.MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode |
| [0..1] | I_MaintenanceRevision | _MaintenanceRevision | $projection.MaintenancePlanningPlant = _MaintenanceRevision.MaintenancePlanningPlant and $projection.MaintenanceRevision = _MaintenanceRevision.MaintenanceRevision |
| [0..1] | I_MaintOrderTypeControlParam | _MaintOrderTypeControlParam | $projection.MaintenanceOrderType = _MaintOrderTypeControlParam.OrderType |
| [0..*] | I_StatusObjectActiveStatus | _StatusObjectActiveStatus | $projection.MaintenanceOrderInternalID = _StatusObjectActiveStatus.StatusObject |
| [0..1] | I_User | _CreatedByUser | $projection.CreatedByUser = _CreatedByUser.UserID |
| [0..*] | I_MaintenanceItemObject | _MaintenanceItemObject | $projection.MaintenanceItemObjectList = _MaintenanceItemObject.MaintenanceItemObjectList |
| [0..*] | I_MaintenanceOrderObjectList | _MaintenanceOrderObjectList | $projection.MaintenanceOrderObjectList = _MaintenanceOrderObjectList.MaintenanceOrderObjectList |
| [0..1] | I_OrderProcessingGroup | _OrderProcessingGroup | $projection.ControllingArea = _OrderProcessingGroup.ControllingArea and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup |
| [0..1] | I_WBSElementByInternalKey | _WBSElement | $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID |
| [0..1] | I_ProjectByInternalKey | _Project | $projection.ProjectInternalID = _Project.ProjectInternalID |
| [0..*] | I_CostCenterText | _ResponsibleCostCenterText | $projection.ControllingArea = _ResponsibleCostCenterText.ControllingArea and $projection.ResponsibleCostCenter = _ResponsibleCostCenterText.CostCenter and _ResponsibleCostCenterText.ValidityStartDate <= $session.system_date and _ResponsibleCostCenterText.ValidityEndDate >= $session.system_date |
| [0..1] | I_PMContactCardEmployee | _PMContactEmployee | $projection.PersonnelNumber = _PMContactEmployee.PersonnelNumber |
| [0..1] | I_PersonWorkAgreement_1 | _PersonWorkAgreement | $projection.PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement |
| [0..1] | I_MaintOrderHasOpenMainWork | _MaintOrderHasOpenMainWork | $projection.MaintenanceOrder = _MaintOrderHasOpenMainWork.MaintenanceOrder |
| [0..1] | E_MaintenanceOrder | _MaintenanceOrderExtension | $projection.MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder |
| [0..1] | I_MaintenancePlanPlant | _MaintenancePlanPlant | $projection.MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant |
| [0..1] | I_EAMProcessPhase | _EAMProcessPhase | $projection.MaintOrdProcessPhaseCode = _EAMProcessPhase.EAMProcessPhaseCode |
| [0..1] | I_EAMProcessSubPhase | _EAMProcessSubPhase | $projection.MaintOrdProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode |
| [0..1] | I_CtrlgObjectSettlementRule | _CtrlgObjectSettlementRule | $projection.MaintenanceOrderInternalID = _CtrlgObjectSettlementRule.ControllingObject |
| [0..1] | I_CostingSheetProcedure | _CostingSheetProcedure | $projection.ConditionUsage = _CostingSheetProcedure.ConditionUsage and $projection.ConditionApplication = _CostingSheetProcedure.ConditionApplication and $projection.CostingSheet = _CostingSheetProcedure.CostingSheetProcedure |
| [0..1] | I_InternalOrderOverheadCodeVH | _OverheadCode | $projection.MaintenanceOrderOverheadCode = _OverheadCode.OverheadCode |
| [1..1] | I_CostingVariant | _PlannedCostingVariant | $projection.PlannedCostsCostingVariant = _PlannedCostingVariant.CostingVariant |
| [1..1] | I_CostingVariant | _ActualCostingVariant | $projection.ActualCostsCostingVariant = _ActualCostingVariant.CostingVariant |
| [0..1] | I_WrkPmtMaintOrderRelevance | _WrkPmtMaintOrderRelevance | $projection.MaintenanceOrderInternalID = _WrkPmtMaintOrderRelevance.MaintenanceOrderInternalID |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Maintenance Order | view | |
| VDM.viewType | #BASIC | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AbapCatalog.sqlViewName | IMAINTORDER | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| ObjectModel.representativeKey | MaintenanceOrder | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XL | view |
Fields (145)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | I_MaintenanceOrderBasic | MaintenanceOrder | |
| MaintPriorityType | I_MaintenanceOrderBasic | MaintPriorityType | ||
| MaintPriority | I_MaintenanceOrderBasic | MaintPriority | ||
| MaintenanceProcessingPhase | I_MaintenanceOrderBasic | MaintenanceProcessingPhase | ||
| MaintObjectLocAcctAssgmtNmbr | I_MaintenanceOrderBasic | MaintObjectLocAcctAssgmtNmbr | ||
| MaintenanceNotification | I_MaintenanceOrderBasic | MaintenanceNotification | ||
| Equipment | I_MaintenanceOrderBasic | Equipment | ||
| Assembly | I_MaintenanceOrderBasic | Assembly | ||
| SerialNumber | I_MaintenanceOrderBasic | SerialNumber | ||
| MaintenancePlanningPlant | I_MaintenanceOrderBasic | MaintenancePlanningPlant | ||
| MaintenancePlannerGroup | I_MaintenanceOrderBasic | MaintenancePlannerGroup | ||
| MaintenanceRevision | I_MaintenanceOrderBasic | MaintenanceRevision | ||
| MaintenancePlan | I_MaintenanceOrderBasic | MaintenancePlan | ||
| MaintenanceItem | I_MaintenanceOrderBasic | MaintenanceItem | ||
| MaintenanceActivityType | I_MaintenanceOrderBasic | MaintenanceActivityType | ||
| WorkCenterInternalID | I_MaintenanceOrderBasic | WorkCenterInternalID | ||
| WorkCenterTypeCode | I_MaintenanceOrderBasic | WorkCenterTypeCode | ||
| MaintOrderReferenceDate | I_MaintenanceOrderBasic | MaintOrderReferenceDate | ||
| MaintOrderReferenceTime | I_MaintenanceOrderBasic | MaintOrderReferenceTime | ||
| MainWorkCompletedDateTime | I_MaintenanceOrderBasic | MainWorkCompletedDateTime | ||
| MaintenanceOrderPlanningCode | I_MaintenanceOrderBasic | MaintenanceOrderPlanningCode | ||
| OperationSystemCondition | I_MaintenanceOrderBasic | OperationSystemCondition | ||
| ReferenceElement | I_MaintenanceOrderBasic | ReferenceElement | ||
| MaintenanceItemObjectList | I_MaintenanceOrderBasic | MaintenanceItemObjectList | ||
| MaintenanceOrderObjectList | I_MaintenanceOrderBasic | MaintenanceOrderObjectList | ||
| PersonnelNumber | I_MaintenanceOrderBasic | PersonnelNumber | ||
| MaintOrdProcmtIntegScenario | I_MaintenanceOrderBasic | MaintOrdProcmtIntegScenario | ||
| Material | I_MaintenanceOrderBasic | Material | ||
| MaintOrderRoutingNumber | I_MaintenanceOrderBasic | MaintOrderRoutingNumber | ||
| BusinessArea | I_MaintenanceOrderBasic | BusinessArea | ||
| FunctionalArea | I_MaintenanceOrderBasic | FunctionalArea | ||
| MaintenanceOrderType | I_MaintenanceOrderBasic | MaintenanceOrderType | ||
| MaintenanceOrderCategory | I_MaintenanceOrderBasic | MaintenanceOrderCategory | ||
| MaintenanceOrderDesc | I_MaintenanceOrderBasic | MaintenanceOrderDesc | ||
| ControllingArea | I_MaintenanceOrderBasic | ControllingArea | ||
| CompanyCode | I_MaintenanceOrderBasic | CompanyCode | ||
| ResponsibleCostCenter | I_MaintenanceOrderBasic | ResponsibleCostCenter | ||
| ProfitCenter | I_MaintenanceOrderBasic | ProfitCenter | ||
| ControllingObjectClass | I_MaintenanceOrderBasic | ControllingObjectClass | ||
| TechnicalCompletionDate | I_MaintenanceOrderBasic | TechnicalCompletionDate | ||
| BasicSchedulingType | I_MaintenanceOrderBasic | BasicSchedulingType | ||
| OrdIsNotSchedldAutomatically | I_MaintenanceOrderBasic | OrdIsNotSchedldAutomatically | ||
| MaintOrdBasicStartDate | I_MaintenanceOrderBasic | MaintOrdBasicStartDate | ||
| MaintOrdBasicStartTime | I_MaintenanceOrderBasic | MaintOrdBasicStartTime | ||
| MaintOrdBasicEndDate | I_MaintenanceOrderBasic | MaintOrdBasicEndDate | ||
| MaintOrdBasicEndTime | I_MaintenanceOrderBasic | MaintOrdBasicEndTime | ||
| ScheduledBasicStartDate | I_MaintenanceOrderBasic | ScheduledBasicStartDate | ||
| ScheduledBasicStartTime | I_MaintenanceOrderBasic | ScheduledBasicStartTime | ||
| ScheduledBasicEndDate | I_MaintenanceOrderBasic | ScheduledBasicEndDate | ||
| ScheduledBasicEndTime | I_MaintenanceOrderBasic | ScheduledBasicEndTime | ||
| MaintOrdPersonResponsible | ||||
| MaintenanceOrderInternalID | I_MaintenanceOrderBasic | MaintenanceOrderInternalID | ||
| TaskListGroup | I_MaintenanceOrderBasic | TaskListGroup | ||
| TaskListType | I_MaintenanceOrderBasic | TaskListType | ||
| TaskListGroupCounter | I_MaintenanceOrderBasic | TaskListGroupCounter | ||
| MaintenancePlant | I_MaintenanceOrderBasic | MaintenancePlant | ||
| CreationDate | I_MaintenanceOrderBasic | CreationDate | ||
| CreationTime | I_MaintenanceOrderBasic | CreationTime | ||
| CreatedByUser | I_MaintenanceOrderBasic | CreatedByUser | ||
| OrderHasLongText | I_MaintenanceOrderBasic | OrderHasLongText | ||
| LastChangeByUser | I_MaintenanceOrderBasic | LastChangeByUser | ||
| LastChangeDateTime | I_MaintenanceOrderBasic | LastChangeDateTime | ||
| AdditionalDeviceData | I_MaintenanceOrderBasic | AdditionalDeviceData | ||
| WBSElementInternalID | I_MaintenanceOrderBasic | WBSElementInternalID | ||
| ProjectInternalID | I_MaintenanceOrderBasic | ProjectInternalID | ||
| OrderProcessingGroup | I_MaintenanceOrderBasic | OrderProcessingGroup | ||
| SuperiorProjectNetwork | I_MaintenanceOrderBasic | SuperiorProjectNetwork | ||
| MainWorkCenter | I_MaintenanceOrderBasic | MainWorkCenter | ||
| MainWorkCenterPlant | I_MaintenanceOrderBasic | MainWorkCenterPlant | ||
| CostingSheet | I_MaintenanceOrderBasic | CostingSheet | ||
| Currency | I_MaintenanceOrderBasic | Currency | ||
| LatestAcceptableCompletionDate | I_MaintenanceOrderBasic | LatestAcceptableCompletionDate | ||
| MaintOrdProcessPhaseCode | I_MaintenanceOrderBasic | MaintOrdProcessPhaseCode | ||
| MaintOrdProcessSubPhaseCode | I_MaintenanceOrderBasic | MaintOrdProcessSubPhaseCode | ||
| MaintOrderProcessingContext | I_MaintenanceOrderBasic | MaintOrderProcessingContext | ||
| ServiceDocumentType | I_MaintenanceOrderBasic | ServiceDocumentType | ||
| ServiceDocument | I_MaintenanceOrderBasic | ServiceDocument | ||
| ServiceDocumentItem | I_MaintenanceOrderBasic | ServiceDocumentItem | ||
| ConditionUsage | I_MaintenanceOrderBasic | ConditionUsage | ||
| ConditionApplication | I_MaintenanceOrderBasic | ConditionApplication | ||
| MaintenanceOrderOverheadCode | I_MaintenanceOrderBasic | MaintenanceOrderOverheadCode | ||
| PlannedCostsCostingVariant | I_MaintenanceOrderBasic | PlannedCostsCostingVariant | ||
| ActualCostsCostingVariant | I_MaintenanceOrderBasic | ActualCostsCostingVariant | ||
| MaintenanceCall | I_MaintenanceOrderBasic | MaintenanceCall | ||
| LeadingOrder | I_MaintenanceOrderBasic | LeadingOrder | ||
| PrevLtstAccptblCompletionDate | I_MaintenanceOrderBasic | PrevLtstAccptblCompletionDate | ||
| _Order | _Order | |||
| _MaintenanceOrderCategory | _MaintenanceOrderCategory | |||
| _MaintenanceOrderType | _MaintenanceOrderType | |||
| _ControllingArea | _ControllingArea | |||
| _ResponsibleCostCenter | _ResponsibleCostCenter | |||
| _LocationPlant | _LocationPlant | |||
| _BasicSchedulingType | _BasicSchedulingType | |||
| _LocationAccountAssignment | _LocationAccountAssignment | |||
| _MaintenanceNotification | _MaintenanceNotification | |||
| _Equipment | _Equipment | |||
| _CompanyCode | _CompanyCode | |||
| _MaintenancePlan | _MaintenancePlan | |||
| _MaintenanceItem | _MaintenanceItem | |||
| _OrderItem | _OrderItem | |||
| _MaintenanceTaskList | _MaintenanceTaskList | |||
| _MaintenancePriorityType | _MaintenancePriorityType | |||
| _MaintenancePriority | _MaintenancePriority | |||
| _MaintenanceOrderPhase | _MaintenanceOrderPhase | |||
| _StatusObject | _StatusObject | |||
| _MaintenanceOrderOperation | _MaintenanceOrderOperation | |||
| _MaintenanceOrderComponent | _MaintenanceOrderComponent | |||
| _MainWorkCenter | _MainWorkCenter | |||
| _BusinessArea | _BusinessArea | |||
| _FunctionalArea | _FunctionalArea | |||
| _MaintenancePartner | _MaintenancePartner | |||
| _MaintenanceActivityType | _MaintenanceActivityType | |||
| _MaintenancePlannerGroup | _MaintenancePlannerGroup | |||
| _StatusObjectStatus | _StatusObjectStatus | |||
| _MaintenancePlanningPlant | _MaintenancePlanningPlant | |||
| _Assembly | _Assembly | |||
| _OperationSystemCondition | _OperationSystemCondition | |||
| _MaintenanceOrderCost | _MaintenanceOrderCost | |||
| _WorkCenterType | _WorkCenterType | |||
| _OrderHasLongText | _OrderHasLongText | |||
| _MaintOrdPlngDegreeCode | _MaintOrdPlngDegreeCode | |||
| _MaintenanceRevision | _MaintenanceRevision | |||
| _MaintOrderTypeControlParam | _MaintOrderTypeControlParam | |||
| _StatusObjectActiveStatus | _StatusObjectActiveStatus | |||
| _CreatedByUser | _CreatedByUser | |||
| _MaintenanceItemObject | _MaintenanceItemObject | |||
| _ResponsibleCostCenterText | _ResponsibleCostCenterText | |||
| _ProfitCenter | _ProfitCenter | |||
| _ControllingObjectClass | _ControllingObjectClass | |||
| _OrderProcessingGroup | _OrderProcessingGroup | |||
| _WBSElement | _WBSElement | |||
| _Project | _Project | |||
| _PMContactEmployee | _PMContactEmployee | |||
| _PersonWorkAgreement | _PersonWorkAgreement | |||
| _MaintOrderHasOpenMainWork | _MaintOrderHasOpenMainWork | |||
| _MaintenancePlanPlant | _MaintenancePlanPlant | |||
| _MaintenanceOrderObjectList | _MaintenanceOrderObjectList | |||
| _EAMProcessPhase | _EAMProcessPhase | |||
| _EAMProcessSubPhase | _EAMProcessSubPhase | |||
| _CtrlgObjectSettlementRule | _CtrlgObjectSettlementRule | |||
| _CostingSheetProcedure | _CostingSheetProcedure | |||
| _OverheadCode | _OverheadCode | |||
| _PlannedCostingVariant | _PlannedCostingVariant | |||
| _ActualCostingVariant | _ActualCostingVariant | |||
| _WrkPmtMaintOrderRelevance | _WrkPmtMaintOrderRelevance |
@EndUserText.label: 'Maintenance Order'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:['_LocationAccountAssignment']
@AbapCatalog: { sqlViewName: 'IMAINTORDER', compiler.compareFilter, preserveKey }
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.representativeKey: 'MaintenanceOrder'
@ObjectModel.semanticKey: [ 'MaintenanceOrder' ]
@Metadata.ignorePropagatedAnnotations: true
// BOPF objects are generated from --> I_MaintOrderTechObj !
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
define view I_MaintenanceOrder
as select from I_MaintenanceOrderBasic as _OrderBasic
association [0..1] to I_LogisticsOrder as _Order on _Order.OrderID = $projection.MaintenanceOrder // AUFK (Order master data) and AFKO (Order Header data )
association [1..1] to I_OrderCategory as _MaintenanceOrderCategory on $projection.MaintenanceOrderCategory = _MaintenanceOrderCategory.OrderCategory
association [1..1] to I_OrderType as _MaintenanceOrderType on $projection.MaintenanceOrderType = _MaintenanceOrderType.OrderType
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_ControllingObjectClass as _ControllingObjectClass on $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..*] to I_CostCenter as _ResponsibleCostCenter on $projection.ControllingArea = _ResponsibleCostCenter.ControllingArea
and $projection.ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..1] to I_Plant as _LocationPlant on $projection.MaintenancePlant = _LocationPlant.Plant
association [0..1] to I_SchedulingType as _BasicSchedulingType on $projection.BasicSchedulingType = _BasicSchedulingType.SchedulingType
association [0..1] to I_MaintenanceTaskList as _MaintenanceTaskList on $projection.TaskListType = _MaintenanceTaskList.TaskListType
and $projection.TaskListGroup = _MaintenanceTaskList.TaskListGroup
and $projection.TaskListGroupCounter = _MaintenanceTaskList.TaskListGroupCounter
with default filter _MaintenanceTaskList.ValidityEndDate = '99991231'
/* Order Refurbishment Item */
association [0..1] to I_OrderItem as _OrderItem on $projection.MaintenanceOrder = _OrderItem.OrderID
and _OrderItem.OrderItem = '0001'
association [0..*] to I_MaintenanceOrderOperation as _MaintenanceOrderOperation on $projection.MaintOrderRoutingNumber = _MaintenanceOrderOperation.MaintOrderRoutingNumber
association [0..*] to I_MaintenanceOrderCost as _MaintenanceOrderCost on $projection.MaintenanceOrderInternalID = _MaintenanceOrderCost.MaintenanceOrderInternalID
association [0..*] to I_MaintenanceOrderComponent_2 as _MaintenanceOrderComponent on $projection.MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder
association [0..1] to I_LocationAccountAssignment as _LocationAccountAssignment on $projection.MaintObjectLocAcctAssgmtNmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr
association [0..1] to I_MaintenanceNotification as _MaintenanceNotification on $projection.MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification
association [0..1] to I_Equipment as _Equipment on $projection.Equipment = _Equipment.Equipment
association [0..1] to I_Material as _Assembly on $projection.Assembly = _Assembly.Material
association [0..1] to I_MaintenancePlanBasic as _MaintenancePlan on $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan
association [0..1] to I_MaintenanceItem as _MaintenanceItem on $projection.MaintenanceItem = _MaintenanceItem.MaintenanceItem
association [0..1] to I_Plant as _MaintenancePlanningPlant on $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant
association [0..1] to I_PMNotificationPriorityType as _MaintenancePriorityType on $projection.MaintPriorityType = _MaintenancePriorityType.MaintPriorityType
// Todo: check if I_Priority has to be created
association [0..1] to I_PMNotificationPriority as _MaintenancePriority on $projection.MaintPriority = _MaintenancePriority.MaintPriority
and $projection.MaintPriorityType = _MaintenancePriority.MaintPriorityType
association [0..1] to I_WorkCenter as _MainWorkCenter on $projection.WorkCenterInternalID = _MainWorkCenter.WorkCenterInternalID
and $projection.WorkCenterTypeCode = _MainWorkCenter.WorkCenterTypeCode
association [1..1] to I_WorkCenterType as _WorkCenterType on $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
association [0..1] to I_MaintenanceActivityType as _MaintenanceActivityType on $projection.MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType
association [0..*] to I_PlantMaintenancePartner as _MaintenancePartner on $projection.MaintenanceOrderInternalID = _MaintenancePartner.MaintObjectInternalID
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association [0..1] to I_MaintenancePlannerGroup as _MaintenancePlannerGroup on $projection.MaintenancePlannerGroup = _MaintenancePlannerGroup.MaintenancePlannerGroup
and $projection.MaintenancePlanningPlant = _MaintenancePlannerGroup.MaintenancePlanningPlant
association [0..1] to I_MaintenanceOrderPhase as _MaintenanceOrderPhase on $projection.MaintenanceProcessingPhase = _MaintenanceOrderPhase.MaintenanceProcessingPhase
association [0..1] to I_StatusObject as _StatusObject on $projection.MaintenanceOrderInternalID = _StatusObject.StatusObject
association [1..*] to I_StatusObjectStatus as _StatusObjectStatus on $projection.MaintenanceOrderInternalID = _StatusObjectStatus.StatusObject
association [0..1] to I_MaintOperationSystCondition as _OperationSystemCondition on $projection.OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition
association [0..1] to I_Indicator as _OrderHasLongText on $projection.OrderHasLongText = _OrderHasLongText.IndicatorValue
association [0..1] to I_MaintOrdPlngDegreeCode as _MaintOrdPlngDegreeCode on $projection.MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode
association [0..1] to I_MaintenanceRevision as _MaintenanceRevision on $projection.MaintenancePlanningPlant = _MaintenanceRevision.MaintenancePlanningPlant
and $projection.MaintenanceRevision = _MaintenanceRevision.MaintenanceRevision
association [0..1] to I_MaintOrderTypeControlParam as _MaintOrderTypeControlParam on $projection.MaintenanceOrderType = _MaintOrderTypeControlParam.OrderType
association [0..*] to I_StatusObjectActiveStatus as _StatusObjectActiveStatus on $projection.MaintenanceOrderInternalID = _StatusObjectActiveStatus.StatusObject
association [0..1] to I_User as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.UserID
association [0..*] to I_MaintenanceItemObject as _MaintenanceItemObject on $projection.MaintenanceItemObjectList = _MaintenanceItemObject.MaintenanceItemObjectList
association [0..*] to I_MaintenanceOrderObjectList as _MaintenanceOrderObjectList on $projection.MaintenanceOrderObjectList = _MaintenanceOrderObjectList.MaintenanceOrderObjectList
association [0..1] to I_OrderProcessingGroup as _OrderProcessingGroup on $projection.ControllingArea = _OrderProcessingGroup.ControllingArea
and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup
association [0..1] to I_WBSElementByInternalKey as _WBSElement on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
association [0..1] to I_ProjectByInternalKey as _Project on $projection.ProjectInternalID = _Project.ProjectInternalID
association [0..*] to I_CostCenterText as _ResponsibleCostCenterText on $projection.ControllingArea = _ResponsibleCostCenterText.ControllingArea
and $projection.ResponsibleCostCenter = _ResponsibleCostCenterText.CostCenter
and _ResponsibleCostCenterText.ValidityStartDate <= $session.system_date
and _ResponsibleCostCenterText.ValidityEndDate >= $session.system_date
association [0..1] to I_PMContactCardEmployee as _PMContactEmployee on $projection.PersonnelNumber = _PMContactEmployee.PersonnelNumber
association [0..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement on $projection.PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement
association [0..1] to I_MaintOrderHasOpenMainWork as _MaintOrderHasOpenMainWork on $projection.MaintenanceOrder = _MaintOrderHasOpenMainWork.MaintenanceOrder
association [0..1] to E_MaintenanceOrder as _MaintenanceOrderExtension on $projection.MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder
association [0..1] to I_MaintenancePlanPlant as _MaintenancePlanPlant on $projection.MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant
association [0..1] to I_EAMProcessPhase as _EAMProcessPhase on $projection.MaintOrdProcessPhaseCode = _EAMProcessPhase.EAMProcessPhaseCode
association [0..1] to I_EAMProcessSubPhase as _EAMProcessSubPhase on $projection.MaintOrdProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode
association [0..1] to I_CtrlgObjectSettlementRule as _CtrlgObjectSettlementRule on $projection.MaintenanceOrderInternalID = _CtrlgObjectSettlementRule.ControllingObject
association [0..1] to I_CostingSheetProcedure as _CostingSheetProcedure on $projection.ConditionUsage = _CostingSheetProcedure.ConditionUsage
and $projection.ConditionApplication = _CostingSheetProcedure.ConditionApplication
and $projection.CostingSheet = _CostingSheetProcedure.CostingSheetProcedure
association [0..1] to I_InternalOrderOverheadCodeVH as _OverheadCode on $projection.MaintenanceOrderOverheadCode = _OverheadCode.OverheadCode
association [1..1] to I_CostingVariant as _PlannedCostingVariant on $projection.PlannedCostsCostingVariant = _PlannedCostingVariant.CostingVariant
association [1..1] to I_CostingVariant as _ActualCostingVariant on $projection.ActualCostsCostingVariant = _ActualCostingVariant.CostingVariant
association [0..1] to I_WrkPmtMaintOrderRelevance as _WrkPmtMaintOrderRelevance on $projection.MaintenanceOrderInternalID = _WrkPmtMaintOrderRelevance.MaintenanceOrderInternalID
{
/* Fields */
@ObjectModel.text.element: [ 'MaintenanceOrderDesc' ]
// @ObjectModel.foreignKey.association: '_MaintOrderHasOpenMainWork'
key _OrderBasic.MaintenanceOrder,
@ObjectModel.foreignKey.association: '_MaintenancePriorityType'
_OrderBasic.MaintPriorityType,
@ObjectModel.foreignKey.association: '_MaintenancePriority'
_OrderBasic.MaintPriority,
@ObjectModel.foreignKey.association: '_MaintenanceOrderPhase'
_OrderBasic.MaintenanceProcessingPhase,
@ObjectModel.foreignKey.association: '_LocationAccountAssignment'
_OrderBasic.MaintObjectLocAcctAssgmtNmbr,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintNotifStdVH',
element: 'MaintenanceNotification' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaintenanceNotification'
_OrderBasic.MaintenanceNotification,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_EquipmentStdVH',
element: 'Equipment' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Equipment'
_OrderBasic.Equipment,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Assembly'
_OrderBasic.Assembly,
_OrderBasic.SerialNumber,
@ObjectModel.foreignKey.association: '_MaintenancePlanPlant'
_OrderBasic.MaintenancePlanningPlant,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintPlnrGrpStdVH',
element: 'MaintenancePlannerGroup' },
additionalBinding: [{ localElement: 'MaintenancePlanningPlant',
element: 'MaintenancePlanningPlant' }]
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaintenancePlannerGroup'
_OrderBasic.MaintenancePlannerGroup,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenanceRevisionStdVH',
element: 'MaintenanceRevision' },
additionalBinding: [{ localElement: 'MaintenancePlanningPlant',
element: 'MaintenancePlanningPlant' }]
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaintenanceRevision'
_OrderBasic.MaintenanceRevision,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenancePlanStdVH',
element: 'MaintenancePlan' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaintenancePlan'
_OrderBasic.MaintenancePlan,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenanceItemStdVH',
element: 'MaintenanceItem' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaintenanceItem'
_OrderBasic.MaintenanceItem,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintActyTypeStdVH',
element: 'MaintenanceActivityType' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaintenanceActivityType'
_OrderBasic.MaintenanceActivityType,
@ObjectModel.foreignKey.association: '_MainWorkCenter'
_OrderBasic.WorkCenterInternalID,
@ObjectModel.foreignKey.association: '_WorkCenterType'
_OrderBasic.WorkCenterTypeCode,
_OrderBasic.MaintOrderReferenceDate,
_OrderBasic.MaintOrderReferenceTime,
_OrderBasic.MainWorkCompletedDateTime,
@ObjectModel.foreignKey.association: '_MaintOrdPlngDegreeCode'
_OrderBasic.MaintenanceOrderPlanningCode,
@ObjectModel.foreignKey.association: '_OperationSystemCondition'
_OrderBasic.OperationSystemCondition,
_OrderBasic.ReferenceElement,
_OrderBasic.MaintenanceItemObjectList,
_OrderBasic.MaintenanceOrderObjectList,
_OrderBasic.PersonnelNumber,
/* Fields to be renamed from I_LogisticsOrder (AUFK, AFKO) */
_OrderBasic.MaintOrdProcmtIntegScenario,
_OrderBasic.Material,
_OrderBasic.MaintOrderRoutingNumber,
@ObjectModel.foreignKey.association: '_BusinessArea'
_OrderBasic.BusinessArea,
@ObjectModel.foreignKey.association: '_FunctionalArea'
_OrderBasic.FunctionalArea,
@ObjectModel.foreignKey.association: '_MaintenanceOrderType'
_OrderBasic.MaintenanceOrderType,
@ObjectModel.foreignKey.association: '_MaintenanceOrderCategory'
_OrderBasic.MaintenanceOrderCategory,
@Semantics.text: true
_OrderBasic.MaintenanceOrderDesc,
@ObjectModel.foreignKey.association: '_ControllingArea'
_OrderBasic.ControllingArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
@ObjectModel.foreignKey.association: '_CompanyCode'
_OrderBasic.CompanyCode,
@ObjectModel.foreignKey.association: '_ResponsibleCostCenter'
@ObjectModel.text.association: '_ResponsibleCostCenterText'
_OrderBasic.ResponsibleCostCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProfitCenterStdVH', element: 'ProfitCenter' } } ]
@ObjectModel.foreignKey.association: '_ProfitCenter'
_OrderBasic.ProfitCenter,
@ObjectModel.foreignKey.association: '_ControllingObjectClass'
_OrderBasic.ControllingObjectClass,
_OrderBasic.TechnicalCompletionDate,
@ObjectModel.foreignKey.association: '_BasicSchedulingType'
_OrderBasic.BasicSchedulingType,
_OrderBasic.OrdIsNotSchedldAutomatically,
_OrderBasic.MaintOrdBasicStartDate,
_OrderBasic.MaintOrdBasicStartTime,
_OrderBasic.MaintOrdBasicEndDate,
_OrderBasic.MaintOrdBasicEndTime,
_OrderBasic.ScheduledBasicStartDate,
_OrderBasic.ScheduledBasicStartTime,
_OrderBasic.ScheduledBasicEndDate,
_OrderBasic.ScheduledBasicEndTime,
-- will require DPP protection (todo CE2008)
_OrderBasic.MaintOrdPersonResponsible,
_OrderBasic.MaintenanceOrderInternalID,
_OrderBasic.TaskListGroup,
_OrderBasic.TaskListType,
_OrderBasic.TaskListGroupCounter,
@ObjectModel.foreignKey.association: '_LocationPlant'
_OrderBasic.MaintenancePlant,
@Semantics.systemDate.createdAt: true
_OrderBasic.CreationDate,
@Semantics.systemTime.createdAt: true
_OrderBasic.CreationTime,
@Semantics.user.createdBy: true
_OrderBasic.CreatedByUser,
@ObjectModel.foreignKey.association: '_OrderHasLongText'
_OrderBasic.OrderHasLongText,
@Semantics.user.lastChangedBy: true
_OrderBasic.LastChangeByUser,
@ObjectModel.readOnly: true
_OrderBasic.LastChangeDateTime,
_OrderBasic.AdditionalDeviceData,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_WBSElmntByIntKeyStdVH', element: 'WBSElementInternalID' } } ]
@ObjectModel.foreignKey.association: '_WBSElement'
_OrderBasic.WBSElementInternalID,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProjectByInternalKeyStdVH', element: 'ProjectInternalID' } } ]
@ObjectModel.foreignKey.association: '_Project'
_OrderBasic.ProjectInternalID,
@ObjectModel.foreignKey.association: '_OrderProcessingGroup'
_OrderBasic.OrderProcessingGroup,
_OrderBasic.SuperiorProjectNetwork,
_OrderBasic.MainWorkCenter,
_OrderBasic.MainWorkCenterPlant,
_OrderBasic.CostingSheet,
_OrderBasic.Currency,
// IME: 2002 LACD
_OrderBasic.LatestAcceptableCompletionDate,
// IME:2002 LACD
//
@ObjectModel.foreignKey.association: '_EAMProcessPhase'
_OrderBasic.MaintOrdProcessPhaseCode,
@ObjectModel.foreignKey.association: '_EAMProcessSubPhase'
_OrderBasic.MaintOrdProcessSubPhaseCode,
_OrderBasic.MaintOrderProcessingContext,
_OrderBasic.ServiceDocumentType,
_OrderBasic.ServiceDocument,
_OrderBasic.ServiceDocumentItem,
/* Control Parameters*/
_OrderBasic.ConditionUsage,
_OrderBasic.ConditionApplication,
_OrderBasic.MaintenanceOrderOverheadCode,
_OrderBasic.PlannedCostsCostingVariant,
_OrderBasic.ActualCostsCostingVariant,
/* maintenance plan */
_OrderBasic.MaintenanceCall,
_OrderBasic.LeadingOrder,
_OrderBasic.PrevLtstAccptblCompletionDate,
/* Associations */
_Order,
_MaintenanceOrderCategory,
_MaintenanceOrderType,
_ControllingArea,
_ResponsibleCostCenter,
_LocationPlant,
_BasicSchedulingType,
_LocationAccountAssignment,
_MaintenanceNotification,
_Equipment,
_CompanyCode,
_MaintenancePlan,
_MaintenanceItem,
_OrderItem,
_MaintenanceTaskList,
_MaintenancePriorityType,
_MaintenancePriority,
_MaintenanceOrderPhase,
_StatusObject,
_MaintenanceOrderOperation,
_MaintenanceOrderComponent,
_MainWorkCenter,
_BusinessArea,
_FunctionalArea,
_MaintenancePartner,
_MaintenanceActivityType,
_MaintenancePlannerGroup,
_StatusObjectStatus,
_MaintenancePlanningPlant,
_Assembly,
_OperationSystemCondition,
_MaintenanceOrderCost,
_WorkCenterType,
_OrderHasLongText,
_MaintOrdPlngDegreeCode,
_MaintenanceRevision,
_MaintOrderTypeControlParam,
_StatusObjectActiveStatus,
_CreatedByUser,
_MaintenanceItemObject,
_ResponsibleCostCenterText,
_ProfitCenter,
_ControllingObjectClass,
_OrderProcessingGroup,
_WBSElement,
_Project,
_PMContactEmployee,
_PersonWorkAgreement,
_MaintOrderHasOpenMainWork,
_MaintenancePlanPlant,
_MaintenanceOrderObjectList,
_EAMProcessPhase,
_EAMProcessSubPhase,
_CtrlgObjectSettlementRule,
_CostingSheetProcedure,
_OverheadCode,
_PlannedCostingVariant,
_ActualCostingVariant,
_WrkPmtMaintOrderRelevance
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA