I_MAINTENANCEORDEROPERATION
Maintenance Order Operation
I_MAINTENANCEORDEROPERATION is a CDS View in S/4HANA. Maintenance Order Operation. It contains 60 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MaintOrdOpRdyForExec | view_entity | from | CONSUMPTION | Maintenance Order Operation Status |
| C_MalfunctionReportWorkItem | view | from | CONSUMPTION | Malfunction Report Work Items |
| C_ObjPgMaintOrderOpAggrgData | view_entity | from | CONSUMPTION | Maintenance Order Operation Aggregate Data |
| C_WorkPermitOrderOperationVH | view_entity | from | CONSUMPTION | Work Permit Order Operations |
| I_MaintOrderHasOpenMainWork | view_entity | from | COMPOSITE | I_MaintOrderHasOpenMainWork |
| I_MaintOrderOperTechObj | view | from | COMPOSITE | MaintOrder Operation w/ Technical Object |
| I_MaintOrdOpStdVH | view | from | COMPOSITE | Maintenance Order Operation |
| I_WrkPmtMaintOperation | view | from | BASIC | Work Permit Maintenance Order Operation |
| P_MaintenanceJobAndWorkItem | view_entity | left_outer | COMPOSITE | Maintenance Job and Work Item |
| P_RSHOperationExplicitRelation | view | inner | CONSUMPTION | Operations with explicit Relations |
| P_RSHOperationsWOExplicitRelat | view | from | CONSUMPTION | Operations without explicit Relations |
Fields (60)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder,PredecessorOrder,SuccessorOrder | 8 |
| KEY | MaintenanceOrderOperation | MaintenanceOrderOperation,PredecessorOperation,SuccessorOperation | 4 |
| KEY | MaintOrderOperationCounter | MaintOrderOperationCounter | 4 |
| KEY | MaintOrderOperationInternalID | MaintOrderOperationInternalID,StatusObject | 5 |
| _Assembly | _Assembly | 1 | |
| _Language | _Language | 1 | |
| _MaintenanceOrder | _MaintenanceOrder | 3 | |
| _MaintOperationExecStageCode | _MaintOperationExecStageCode | 1 | |
| _OperationCalculationControl | _OperationCalculationControl | 1 | |
| _OperationControlKey | _OperationControlKey | 1 | |
| _OperationHasLongText | _OperationHasLongText | 1 | |
| _OperationPlanningValues | _OperationPlanningValues | 1 | |
| _OperationSystemCondition | _OperationSystemCondition | 1 | |
| _OpExternalProcessingCurrency | _OpExternalProcessingCurrency | 1 | |
| _PersonResponsible | _PersonResponsible | 1 | |
| _Plant | _Plant | 2 | |
| _StatusObject | _StatusObject | 1 | |
| _Supplier | _Supplier | 1 | |
| _WorkCenter | _WorkCenter | 3 | |
| Assembly | Assembly | 1 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| CapacityRequirementItem | CapacityRequirementItem | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CostElement | CostElement | 1 | |
| Equipment | Equipment | 1 | |
| FunctionalLocation | FunctionalLocation | 1 | |
| Language | Language | 1 | |
| MaintOperationExecStageCode | MaintOperationExecStageCode | 1 | |
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | 4 | |
| MaintOrdOpProcessPhaseCode | MaintOrdOpProcessPhaseCode | 2 | |
| MaintOrdOpProcessSubPhaseCode | MaintOrdOpProcessSubPhaseCode | 2 | |
| MaterialGroup | MaterialGroup | 1 | |
| NumberOfCapacities | NumberOfCapacities | 1 | |
| OperationCalculationControl | OperationCalculationControl | 1 | |
| OperationControlKey | OperationControlKey | 1 | |
| OperationDescription | OperationDescription | 3 | |
| OperationGoodsRecipientName | OperationGoodsRecipientName | 1 | |
| OperationHasLongText | OperationHasLongText | 1 | |
| OperationPersonResponsible | OperationPersonResponsible,PersonResponsible | 4 | |
| OperationPurchasingInfoRecord | OperationPurchasingInfoRecord | 1 | |
| OperationPurgInfoRecdSearchTxt | OperationPurgInfoRecdSearchTxt | 1 | |
| OperationRequisitionerName | OperationRequisitionerName | 1 | |
| OperationSupplier | OperationSupplier | 1 | |
| OperationSystemCondition | OperationSystemCondition | 1 | |
| OperationTrackingNumber | OperationTrackingNumber | 1 | |
| OperationUnloadingPointName | OperationUnloadingPointName | 1 | |
| OperationWorkCenterInternalID | OperationWorkCenterInternalID | 3 | |
| OperationWorkCenterTypeCode | OperationWorkCenterTypeCode | 3 | |
| OperationWorkPercent | OperationWorkPercent | 1 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 1 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 1 | |
| OpExternalProcessingPriceUnit | OpExternalProcessingPriceUnit | 1 | |
| OpPurchaseOutlineAgreement | OpPurchaseOutlineAgreement | 1 | |
| OpPurchaseOutlineAgreementItem | OpPurchaseOutlineAgreementItem | 1 | |
| Plant | Plant | 4 | |
| PurchaseRequisition | PurchaseRequisition | 1 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| ReqgCostCenterControllingArea | ReqgCostCenterControllingArea | 1 |
@AbapCatalog.sqlViewName: 'IMAINTORDOP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Maintenance Order Operation'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MaintenanceOrderOperation'
@ObjectModel.semanticKey: [ 'MaintenanceOrder', 'MaintenanceOrderOperation' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.privilegedAssociations: ['_StatusObjectActiveStatus']
define view I_MaintenanceOrderOperation
as select from I_MaintOrderOperationBasic as _Operation
association [1..1] to I_MaintOrderOperPlanningValues as _OperationPlanningValues on $projection.MaintOrderRoutingNumber = _OperationPlanningValues.MaintOrderRoutingNumber
and $projection.MaintOrderOperationCounter = _OperationPlanningValues.MaintOrderOperationCounter
association [0..1] to I_MaintenanceOrder as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [0..*] to I_MaintenanceOrderComponent_2 as _MaintenanceOrderComponent on $projection.MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder
and $projection.MaintOrderRoutingNumber = _MaintenanceOrderComponent.MaintOrderRoutingNumber
and $projection.MaintOrderOperationCounter = _MaintenanceOrderComponent.MaintOrderOperationCounter
association [0..*] to I_MaintenanceOrderSubOperation as _MaintenanceOrderSubOperation on $projection.MaintenanceOrder = _MaintenanceOrderSubOperation.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation
association [0..1] to I_WorkCenter as _WorkCenter on $projection.OperationWorkCenterInternalID = _WorkCenter.WorkCenterInternalID
and $projection.OperationWorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode
association [0..1] to I_Currency as _OpExternalProcessingCurrency on $projection.OpExternalProcessingCurrency = _OpExternalProcessingCurrency.Currency
association [0..1] to I_StatusObject as _StatusObject on $projection.MaintOrderOperationInternalID = _StatusObject.StatusObject
association [0..1] to I_OperationControlProfile as _OperationControlKey on $projection.OperationControlKey = _OperationControlKey.OperationControlProfile
association [0..1] to I_MaintOperationSystCondition as _OperationSystemCondition on $projection.OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_OperationCalculationControl as _OperationCalculationControl on $projection.OperationCalculationControl = _OperationCalculationControl.OperationCalculationControl
association [0..1] to I_Material as _Assembly on $projection.Assembly = _Assembly.Material
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
association [0..1] to I_Indicator as _OperationHasLongText on $projection.OperationHasLongText = _OperationHasLongText.IndicatorValue
association [0..*] to I_StatusObjectActiveStatus as _StatusObjectActiveStatus on $projection.MaintOrderOperationInternalID = _StatusObjectActiveStatus.StatusObject
association [0..1] to I_Supplier as _Supplier on $projection.OperationSupplier = _Supplier.Supplier
association [0..1] to I_Equipment as _Equipment on $projection.Equipment = _Equipment.Equipment
association [0..1] to I_FunctionalLocation as _FunctionalLocation on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
--association [0..1] to I_Employment as _PersonResponsible on $projection.OperationPersonResponsible = _PersonResponsible.EmploymentInternalID
association [0..1] to I_PersonWorkAgreement_1 as _PersonResponsible on $projection.OperationPersonResponsible = _PersonResponsible.PersonWorkAgreement
association [0..1] to I_MaintenanceOrderConfirmation as _MaintenanceOrderConf on $projection.MaintOrderConfirmation = _MaintenanceOrderConf.MaintOrderConf
and $projection.MaintOrderConfCntrValue = _MaintenanceOrderConf.MaintOrderConfCntrValue
association [0..*] to I_OrderProdnResourceTool as _MaintOrderProdnRsceTool on _MaintOrderProdnRsceTool.OrderInternalBillOfOperations = $projection.MaintOrderRoutingNumber
and _MaintOrderProdnRsceTool.OrderIntBillOfOperationsItem = $projection.MaintOrderOperationCounter
association [0..*] to I_CostCenterActivityTypeText as _CostCenterActivityTypeText on $projection.ControllingArea = _CostCenterActivityTypeText.ControllingArea
and $projection.CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType
association [0..1] to I_PMContactCardEmployee as _PMContactEmployee on $projection.OperationPersonResponsible = _PMContactEmployee.PersonnelNumber
association [0..1] to I_WorkAssignment as _WorkAssignment on $projection.OperationPersonResponsible = _WorkAssignment.WorkAssignment
association [1..1] to I_MaintOperationExecStageCode as _MaintOperationExecStageCode on $projection.MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode
association [0..1] to I_EAMProcessPhase as _EAMProcessPhase on $projection.MaintOrdOpProcessPhaseCode = _EAMProcessPhase.EAMProcessPhaseCode
association [0..1] to I_EAMProcessSubPhase as _EAMProcessSubPhase on $projection.MaintOrdOpProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode
{
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenanceOrderStdVH',
element: 'MaintenanceOrder' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
key _Operation.MaintenanceOrder,
@EndUserText.label: 'Operation'
@ObjectModel.text.element: ['OperationDescription']
key _Operation.MaintenanceOrderOperation,
'0000' as MaintenanceOrderSubOperation,
_Operation.MaintOrderRoutingNumber,
_Operation.MaintOrderOperationCounter,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PlantStdVH',
element: 'Plant' }
}]
@ObjectModel.foreignKey.association: '_Plant'
_Operation.Plant,
_Operation.OperationWorkCenterTypeCode,
_Operation.OperationWorkCenterInternalID,
@ObjectModel.foreignKey.association: '_OperationControlKey'
_Operation.OperationControlKey,
@Semantics.text
_Operation.OperationDescription,
_Operation.OperationStandardTextCode,
@ObjectModel.foreignKey.association: '_Language'
_Operation.Language,
_Operation.NumberOfTimeTickets,
// afvc.loart as WageType,
// afvc.qualf as Suitability,
// afvc.logrp as WageGroup,
_Operation.OperationPurgInfoRecdSearchTxt,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_Supplier_VH',
element: 'Supplier' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Supplier'
_Operation.OperationSupplier,
// @Semantics.quantity.unitOfMeasure: 'OperationBaseUnitOfMeasure'
// afvv.bmsch as OperationQuantity,
// @Semantics.unitOfMeasure: true
// afvv.meinh as OperationBaseUnitOfMeasure,
@Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
@DefaultAggregation: #NONE
_Operation.OpExternalProcessingPrice,
_Operation.MaintOrdOpProcgPriceUnitValue as OpExternalProcessingPriceUnit,
_Operation.CostElement,
@ObjectModel.foreignKey.association: '_OpExternalProcessingCurrency'
@Semantics.currencyCode: true
_Operation.OpExternalProcessingCurrency,
_Operation.OperationPurchasingInfoRecord,
_Operation.PurchasingOrganization,
_Operation.PurchasingGroup,
_Operation.MaterialGroup,
_Operation.OpPurchaseOutlineAgreement,
_Operation.OpPurchaseOutlineAgreementItem,
_Operation.OperationRequisitionerName,
_Operation.OperationTrackingNumber,
@DefaultAggregation: #NONE
_Operation.NumberOfCapacities,
_Operation.OperationWorkPercent,
_Operation.OperationCalculationControl,
_Operation.ActivityType,
_Operation.OperationSystemCondition,
//afvc.vertl as DistrCapReqmts,
_Operation.OperationGoodsRecipientName,
_Operation.OperationUnloadingPointName,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PersWrkAgrmtSrchHelp',
element: 'PersonWorkAgreement' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_PersonResponsible'
_Operation.OperationPersonResponsible,
//afvc.fordn as FrameworkOrder,
//afvc.fordp as ItemoOfFrameworkOrder,
//afvv.plifz as PlannedDeliveryTimeInDays,
//@Semantics.quantity.unitOfMeasure: 'NormalDurationUnit'
//afvv.dauno as NormalDurationOfActivity,
//@Semantics.unitOfMeasure: true
//afvv.daune as NormalDurationUnit,
//afvv.einsa as TypeConstraintStartDate,
//afvv.einse as TypeConstraintFinishDate,
//@Semantics.quantity.unitOfMeasure: 'UnitForWork'
//afvv.arbei as WorkInvolvedInActivity,
// @Semantics.unitOfMeasure: true
// afvv.arbeh as UnitForWork,
// afvv.ntanf as ConstraintActivityStartDateBas,
// afvv.ntanz as ConstraintActivityStartTimeBas,
// afvv.ntend as ConstraintActivityEndDateBas,
// afvv.ntenz as ConstraintActivityEndTimeBas,
// afvv.aufkt as ExecutionFactor,
// 'Inspection Rounds'-related fields
_Operation.Equipment,
_Operation.FunctionalLocation, // <-- This is in internal labelling!
// afvc.frdlb as ExtProcOperationSubcontracting,
//afvu.ilart_op as MaintenanceActivityType,
_Operation.BusinessArea,
//afvc.projn as WBSElement,
_Operation.ProfitCenter,
_Operation.CostingSheet,
// afvc.zschl as Overheadkey,
_Operation.TaxJurisdiction,
//afvc.scope as ObjectClass,
_Operation.FunctionalArea,
// @Semantics.quantity.unitOfMeasure: 'UnitForOffsetToStart'
// afvv.offstb as OffsetToSubOperationStart,
// @Semantics.unitOfMeasure: true
// afvv.ehoffb as UnitForOffsetToStart,
// @Semantics.quantity.unitOfMeasure: 'UnitForOffsetToFinish'
// afvv.offste as OffsetToSubOperationFinish,
// @Semantics.unitOfMeasure: true
// afvv.ehoffe as UnitForOffsetToFinish,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_Assembly'
_Operation.Assembly, //long one - 40 char
// afvc.fldlogsdelivisheldonshore as HoldOnShore,
@ObjectModel.foreignKey.association: '_MaintOperationExecStageCode'
_Operation.MaintOperationExecStageCode,
_Operation.CostCtrActivityType,
_Operation.ReqgCostCenterControllingArea,
_Operation.CapacityRequirement,
_Operation.CapacityRequirementItem,
_Operation.PurchaseRequisition,
_Operation.MaintOrderOperationInternalID,
_Operation.PurchaseRequisitionItem,
_Operation.MaintOrderConfirmation,
_Operation.OperationMilestoneUsageCode,
_Operation.MaintOrderConfCntrValue,
@ObjectModel.foreignKey.association: '_OperationHasLongText'
_Operation.OperationHasLongText,
-- needed for some associations, e.g. activity type
_Operation.ControllingArea,
@ObjectModel.foreignKey.association: '_EAMProcessPhase'
_Operation.MaintOrdOpProcessPhaseCode,
@ObjectModel.foreignKey.association: '_EAMProcessSubPhase'
_Operation.MaintOrdOpProcessSubPhaseCode,
_Operation.MaintOperationalChecklistType,
// associations :
_MaintenanceOrderComponent,
_MaintenanceOrderSubOperation,
_MaintenanceOrder,
_StatusObject,
_OpExternalProcessingCurrency,
_OperationPlanningValues,
_WorkCenter,
_OperationControlKey,
_OperationSystemCondition,
_Plant,
_OperationCalculationControl,
_Assembly,
_Language,
_OperationHasLongText,
_StatusObjectActiveStatus,
_Supplier,
_PersonResponsible,
_FunctionalLocation,
_Equipment,
_MaintenanceOrderConf,
_MaintOrderProdnRsceTool,
_CostCenterActivityTypeText,
_PMContactEmployee,
_WorkAssignment,
_MaintOperationExecStageCode,
_EAMProcessPhase,
_EAMProcessSubPhase
}