I_MAINTORDEROPERTECHOBJ
MaintOrder Operation w/ Technical Object
I_MAINTORDEROPERTECHOBJ is a CDS View in S/4HANA. MaintOrder Operation w/ Technical Object. It contains 86 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MaintOrderOperationTP | view | from | TRANSACTIONAL | MaintOrder Operation w/ Technical Object |
Fields (86)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | 1 |
| KEY | MaintenanceOrderOperation | MaintenanceOrderOperation,MaintOrderOperationForEdit | 1 |
| _ActivityType | _ActivityType | 1 | |
| _Assembly | _Assembly | 1 | |
| _CostElement | _CostElement | 1 | |
| _DurationUnitOfMeasure | _DurationUnitOfMeasure | 1 | |
| _EAMProcessPhase | _EAMProcessPhase | 1 | |
| _EAMProcessSubPhase | _EAMProcessSubPhase | 1 | |
| _MaintenanceOrder | _MaintenanceOrder | 1 | |
| _MaintenanceSubOperation | _MaintenanceSubOperation | 1 | |
| _MaintOperationExecStageCode | _MaintOperationExecStageCode | 1 | |
| _MaintOrderOperObjectListLink | _MaintOrderOperObjectListLink | 1 | |
| _MaterialGroup | _MaterialGroup | 1 | |
| _OperationCalculationControl | _OperationCalculationControl | 1 | |
| _OperationControlKey | _OperationControlKey | 1 | |
| _OperationHasLongText | _OperationHasLongText | 1 | |
| _OperationPlanningValues | _OperationPlanningValues | 1 | |
| _OperationSystemCondition | _OperationSystemCondition | 1 | |
| _OpExternalProcessingCurrency | _OpExternalProcessingCurrency | 1 | |
| _OverallStatus | _OverallStatus | 1 | |
| _PersonResponsible | _PersonResponsible | 1 | |
| _PlannedWorkUnitOfMeasure | _PlannedWorkUnitOfMeasure | 1 | |
| _Plant | _Plant | 1 | |
| _StatusObject | _StatusObject | 1 | |
| _StatusObjectActiveStatus | _StatusObjectActiveStatus | 1 | |
| _Supplier | _Supplier | 1 | |
| _TechnicalObject | _TechnicalObject | 1 | |
| _TechObjIsEquipOrFuncnlLoc | _TechObjIsEquipOrFuncnlLoc | 1 | |
| _WorkCenter | _WorkCenter | 1 | |
| Assembly | Assembly | 1 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| CapacityRequirementItem | CapacityRequirementItem | 1 | |
| ConfirmationTotalQuantity | ConfirmationTotalQuantity | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CostElement | CostElement | 1 | |
| EAMOverallObjectStatus | EAMOverallObjectStatus | 1 | |
| EAMOverallObjectStatusProfile | EAMOverallObjectStatusProfile | 1 | |
| Equipment | Equipment | 1 | |
| FunctionalLocation | FunctionalLocation | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsFinallyConfirmed | IsFinallyConfirmed | 1 | |
| Language | Language | 1 | |
| MaintOperationalChecklistType | MaintOperationalChecklistType | 1 | |
| MaintOperationExecStageCode | MaintOperationExecStageCode | 1 | |
| MaintOrderOperationCounter | MaintOrderOperationCounter | 1 | |
| MaintOrderOperationInternalID | MaintOrderOperationInternalID | 1 | |
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | 1 | |
| MaintOrdOpProcessPhaseCode | MaintOrdOpProcessPhaseCode | 1 | |
| MaintOrdOpProcessSubPhaseCode | MaintOrdOpProcessSubPhaseCode | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| NumberOfCapacities | NumberOfCapacities | 1 | |
| OperationCalculationControl | OperationCalculationControl | 1 | |
| OperationControlKey | OperationControlKey | 1 | |
| OperationDescription | OperationDescription | 1 | |
| OperationDuration | OperationDuration | 1 | |
| OperationDurationUnit | OperationDurationUnit | 1 | |
| OperationGoodsRecipientName | OperationGoodsRecipientName | 1 | |
| OperationHasLongText | OperationHasLongText | 1 | |
| OperationPersonResponsible | OperationPersonResponsible | 1 | |
| OperationPlannedWork | OperationPlannedWork | 1 | |
| OperationPlannedWorkUnit | OperationPlannedWorkUnit | 1 | |
| OperationPurchasingInfoRecord | OperationPurchasingInfoRecord | 1 | |
| OperationPurgInfoRecdSearchTxt | OperationPurgInfoRecdSearchTxt | 1 | |
| OperationRequisitionerName | OperationRequisitionerName | 1 | |
| OperationSupplier | OperationSupplier | 1 | |
| OperationSystemCondition | OperationSystemCondition | 1 | |
| OperationTrackingNumber | OperationTrackingNumber | 1 | |
| OperationUnloadingPointName | OperationUnloadingPointName | 1 | |
| OperationWorkCenter | OperationWorkCenter | 1 | |
| OperationWorkCenterInternalID | OperationWorkCenterInternalID | 1 | |
| OperationWorkCenterTypeCode | OperationWorkCenterTypeCode | 1 | |
| OperationWorkPercent | OperationWorkPercent | 1 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 1 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 1 | |
| OpExternalProcessingPriceUnit | OpExternalProcessingPriceUnit | 1 | |
| OpPurchaseOutlineAgreement | OpPurchaseOutlineAgreement | 1 | |
| OpPurchaseOutlineAgreementItem | OpPurchaseOutlineAgreementItem | 1 | |
| Plant | Plant | 1 | |
| PurchaseRequisition | PurchaseRequisition | 1 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| ReqgCostCenterControllingArea | ReqgCostCenterControllingArea | 1 | |
| TechnicalObject | TechnicalObject | 1 | |
| TechObjIsEquipOrFuncnlLoc | TechObjIsEquipOrFuncnlLoc | 1 |
@EndUserText.label: 'MaintOrder Operation w/ Technical Object'
@VDM.viewType: #COMPOSITE
--@Analytics: { dataCategory: #DIMENSION }
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('REQUIRED')
@AbapCatalog.sqlViewName: 'IMTORDOPRTECOBJ'
@AbapCatalog.preserveKey: true
@ObjectModel.representativeKey: 'MaintenanceOrderOperation'
@ObjectModel.semanticKey: [ 'MaintenanceOrder', 'MaintenanceOrderOperation' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@Metadata.allowExtensions: true
@AccessControl.privilegedAssociations: [ '_ObjectOverallStatus' ]
define view I_MaintOrderOperTechObj
as select from I_MaintenanceOrderOperation
association [1..1] to I_MaintOrderTechObj as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [0..*] to I_MaintOrderOperComp as _MaintenanceOperationComponent on $projection.MaintenanceOrder = _MaintenanceOperationComponent.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintenanceOperationComponent.MaintenanceOrderOperation
association [0..*] to I_MaintOrderSubOperTechObj as _MaintenanceSubOperation on $projection.MaintenanceOrder = _MaintenanceSubOperation.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintenanceSubOperation.MaintenanceOrderOperation
association [0..1] to I_TechnicalObject as _TechnicalObject on $projection.TechnicalObject = _TechnicalObject.TechnicalObject
and $projection.TechObjIsEquipOrFuncnlLoc = _TechnicalObject.TechObjIsEquipOrFuncnlLoc
association [0..1] to I_TechObjIsEquipOrFuncnlLoc as _TechObjIsEquipOrFuncnlLoc on $projection.TechObjIsEquipOrFuncnlLoc = _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc
association [0..*] to I_CostCenterActivityType as _ActivityType on $projection.ControllingArea = _ActivityType.ControllingArea
and $projection.CostCtrActivityType = _ActivityType.CostCtrActivityType
association [0..1] to I_CostElement as _CostElement on $projection.ControllingArea = _CostElement.ControllingArea
and $projection.CostElement = _CostElement.CostElement
association [0..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup = _MaterialGroup.MaterialGroup
association [0..*] to I_EAMObjectOverallStatus as _ObjectOverallStatus on $projection.MaintOrderOperationInternalID = _ObjectOverallStatus.StatusObject
association [0..1] to I_MaintOrderOperObjectListLink as _MaintOrderOperObjectListLink on $projection.MaintOrderOperationCounter = _MaintOrderOperObjectListLink.MaintOrderOperationCounter
and $projection.MaintOrderRoutingNumber = _MaintOrderOperObjectListLink.MaintOrderRoutingNumber
association [0..*] to I_StatusObjectStatus as _StatusObjectStatus on $projection.MaintOrderOperationInternalID = _StatusObjectStatus.StatusObject
association [0..1] to I_Indicator as _IsDeleted on $projection.IsDeleted = _IsDeleted.IndicatorValue
association [0..1] to I_Indicator as _IsFinallyConfirmed on $projection.IsFinallyConfirmed = _IsFinallyConfirmed.IndicatorValue
{
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
key I_MaintenanceOrderOperation.MaintenanceOrder,
key I_MaintenanceOrderOperation.MaintenanceOrderOperation,
/* @ObjectModel.foreignKey.association: '_TechnicalObject'
case when I_MaintenanceOrderOperation.Equipment != '' then
cast( I_MaintenanceOrderOperation.Equipment as eams_tech_obj_conv )
when I_MaintenanceOrderOperation.Equipment = '' and
I_MaintenanceOrderOperation.FunctionalLocation != '' then
cast( I_MaintenanceOrderOperation.FunctionalLocation as eams_tech_obj_conv )
else cast('' as eams_tech_obj_conv ) end as TechnicalObject,*/
@ObjectModel.foreignKey.association: '_TechnicalObject'
/* cast( case when _MaintOrdOpWithNotifAndEquip.OperationMaintenanceNotif is not null then
_MaintOrdOpWithNotifAndEquip._MaintNotificationTechObj.TechnicalObject
else case when I_MaintenanceOrderOperation.Equipment != '' then
cast( I_MaintenanceOrderOperation.Equipment as eams_tech_obj_conv )
when I_MaintenanceOrderOperation.Equipment = '' and
I_MaintenanceOrderOperation.FunctionalLocation != '' then
cast( I_MaintenanceOrderOperation.FunctionalLocation as eams_tech_obj_conv )
else cast('' as eams_tech_obj_conv ) end
end as eams_tech_obj_conv ) as TechnicalObject,*/
/*cast( coalesce( _MaintOrderOperObjectListLink._MaintenanceItemObject._PMNotifMaintenanceData._Equipment.Equipment,
coalesce( _MaintOrderOperObjectListLink._MaintenanceItemObject._PMNotifMaintenanceData._LocationAccountAssignment._FunctionalLocation.FunctionalLocation,
coalesce( _MaintOrderOperObjectListLink._MaintenanceItemObject._Equipment.Equipment,
coalesce( _MaintOrderOperObjectListLink._MaintenanceItemObject._FunctionalLocation.FunctionalLocation,
coalesce( _FunctionalLocation.FunctionalLocation, Equipment ) ) ) ) ) as eams_tech_obj_conv ) as TechnicalObject,*/
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_TechnicalObjectStdVH',
element: 'TechnicalObject' },
additionalBinding: [{ localElement: 'TechObjIsEquipOrFuncnlLoc',
element: 'TechObjIsEquipOrFuncnlLoc' }]
}]
cast( case when _MaintOrderOperObjectListLink.MaintenanceItemObject is not null then
case when _MaintOrderOperObjectListLink._MaintenanceItemObject.Equipment <> '' then _MaintOrderOperObjectListLink._MaintenanceItemObject.Equipment
else _MaintOrderOperObjectListLink._MaintenanceItemObject.FunctionalLocation end
else case when Equipment != '' then
Equipment
when Equipment = '' and
FunctionalLocation != '' then
FunctionalLocation
else '' end
end as eams_tec_obj ) as TechnicalObject,
/* @ObjectModel.foreignKey.association: '_TechObjIsEquipOrFuncnlLoc'
case when I_MaintenanceOrderOperation.Equipment != '' then
cast ( 'EAMS_EQUI' as eams_tec_obj_type_value)
when I_MaintenanceOrderOperation.Equipment = '' and
I_MaintenanceOrderOperation.FunctionalLocation != '' then
cast ( 'EAMS_FL' as eams_tec_obj_type_value)
else cast('' as eams_tec_obj_type_value ) end as TechObjIsEquipOrFuncnlLoc,*/
/*@ObjectModel.foreignKey.association: '_TechObjIsEquipOrFuncnlLoc'
@UI.textArrangement: #TEXT_ONLY
cast( case when _MaintOrderOperObjectListLink._MaintenanceItemObject._PMNotifMaintenanceData._Equipment.Equipment is not null
or _MaintOrderOperObjectListLink._MaintenanceItemObject._Equipment.Equipment is not null
or Equipment <> ''
then 'EAMS_EQUI'
when _MaintOrderOperObjectListLink._MaintenanceItemObject._PMNotifMaintenanceData._LocationAccountAssignment._FunctionalLocation.FunctionalLocation is not null
or _MaintOrderOperObjectListLink._MaintenanceItemObject._FunctionalLocation.FunctionalLocation is not null
or _FunctionalLocation.FunctionalLocation is not null
then 'EAMS_FL'
else ''
end as eams_tec_obj_type_value ) as TechObjIsEquipOrFuncnlLoc,*/
@ObjectModel.foreignKey.association: '_TechObjIsEquipOrFuncnlLoc'
@UI.textArrangement: #TEXT_ONLY
cast( case when _MaintOrderOperObjectListLink.MaintenanceItemObject is not null then
case when _MaintOrderOperObjectListLink._MaintenanceItemObject.Equipment <> '' then 'EAMS_EQUI'
when _MaintOrderOperObjectListLink._MaintenanceItemObject.FunctionalLocation <> '' then 'EAMS_FL'
else '' end
else case when Equipment != '' then
'EAMS_EQUI'
when Equipment = '' and
FunctionalLocation != '' then
'EAMS_FL'
else '' end
end as eams_tec_obj_type_value ) as TechObjIsEquipOrFuncnlLoc,
/* Fields */
_MaintenanceOrder._Order.ControllingArea as ControllingArea,
I_MaintenanceOrderOperation.MaintOrderRoutingNumber,
I_MaintenanceOrderOperation.MaintOrderOperationCounter,
I_MaintenanceOrderOperation.OperationControlKey,
I_MaintenanceOrderOperation.OperationDescription,
I_MaintenanceOrderOperation.MaintOrderOperationInternalID,
I_MaintenanceOrderOperation.Equipment,
I_MaintenanceOrderOperation.FunctionalLocation,
I_MaintenanceOrderOperation.Plant,
I_MaintenanceOrderOperation.OperationWorkCenterInternalID,
I_MaintenanceOrderOperation.OperationWorkCenterTypeCode,
I_MaintenanceOrderOperation.OperationPurgInfoRecdSearchTxt,
I_MaintenanceOrderOperation.OperationRequisitionerName,
I_MaintenanceOrderOperation.OperationGoodsRecipientName,
I_MaintenanceOrderOperation.OpExternalProcessingPrice,
I_MaintenanceOrderOperation.OpExternalProcessingPriceUnit,
I_MaintenanceOrderOperation.OpExternalProcessingCurrency,
I_MaintenanceOrderOperation.OperationTrackingNumber,
I_MaintenanceOrderOperation.OperationPurchasingInfoRecord,
I_MaintenanceOrderOperation.OperationUnloadingPointName,
I_MaintenanceOrderOperation.OpPurchaseOutlineAgreement,
I_MaintenanceOrderOperation.OpPurchaseOutlineAgreementItem,
I_MaintenanceOrderOperation.OperationSupplier,
I_MaintenanceOrderOperation.OperationPersonResponsible,
I_MaintenanceOrderOperation.Assembly,
I_MaintenanceOrderOperation.OperationSystemCondition,
I_MaintenanceOrderOperation.CostCtrActivityType,
I_MaintenanceOrderOperation.ReqgCostCenterControllingArea,
I_MaintenanceOrderOperation.OperationCalculationControl,
I_MaintenanceOrderOperation.OperationWorkPercent,
I_MaintenanceOrderOperation.CapacityRequirement,
I_MaintenanceOrderOperation.CapacityRequirementItem,
I_MaintenanceOrderOperation.PurchaseRequisition,
I_MaintenanceOrderOperation.PurchaseRequisitionItem,
I_MaintenanceOrderOperation.NumberOfCapacities,
I_MaintenanceOrderOperation.MaterialGroup,
I_MaintenanceOrderOperation.CostElement,
I_MaintenanceOrderOperation.PurchasingGroup,
I_MaintenanceOrderOperation.PurchasingOrganization,
I_MaintenanceOrderOperation.Language,
I_MaintenanceOrderOperation.OperationHasLongText,
I_MaintenanceOrderOperation.MaintOperationExecStageCode,
I_MaintenanceOrderOperation.MaintOrdOpProcessPhaseCode,
I_MaintenanceOrderOperation.MaintOrdOpProcessSubPhaseCode,
I_MaintenanceOrderOperation.MaintOperationalChecklistType,
I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWork,
I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWorkUnit,
I_MaintenanceOrderOperation._OperationPlanningValues.OperationDuration,
I_MaintenanceOrderOperation._OperationPlanningValues.OperationDurationUnit,
I_MaintenanceOrderOperation._OperationPlanningValues._PlannedWorkUnitOfMeasure,
cast( I_MaintenanceOrderOperation._OperationPlanningValues.ConfirmationTotalQuantity as eams_total_actual_work ) as ConfirmationTotalQuantity,
I_MaintenanceOrderOperation._WorkCenter.WorkCenter as OperationWorkCenter,
_ObjectOverallStatus.EAMOverallObjectStatusProfile,
_ObjectOverallStatus.EAMOverallObjectStatus,
// @todo create private view for objects in status 'deleted'
@ObjectModel.foreignKey.association: '_IsDeleted'
case when _StatusObjectStatus[1: StatusCode = 'I0013'].StatusCode is not null
and _StatusObjectStatus[1: StatusCode = 'I0013'].StatusIsInactive <> 'X'
then 'X' else ''
end as IsDeleted,
@ObjectModel.foreignKey.association: '_IsFinallyConfirmed'
cast(
case when _StatusObjectStatus[1: StatusCode = 'I0009'].StatusCode is not null
and _StatusObjectStatus[1: StatusCode = 'I0009'].StatusIsInactive <> 'X'
then 'X' else '' end
as eams_finally_confirmed ) as IsFinallyConfirmed,
/* Associations from I_MaintenanceOrderOperation */
I_MaintenanceOrderOperation._OperationControlKey,
I_MaintenanceOrderOperation._OperationPlanningValues,
I_MaintenanceOrderOperation._OpExternalProcessingCurrency,
I_MaintenanceOrderOperation._OperationSystemCondition,
I_MaintenanceOrderOperation._Plant,
I_MaintenanceOrderOperation._StatusObject,
I_MaintenanceOrderOperation._WorkCenter,
I_MaintenanceOrderOperation._OperationCalculationControl,
I_MaintenanceOrderOperation._Assembly,
I_MaintenanceOrderOperation._Language,
I_MaintenanceOrderOperation._OperationHasLongText,
I_MaintenanceOrderOperation._Supplier,
I_MaintenanceOrderOperation._PersonResponsible,
I_MaintenanceOrderOperation._MaintOperationExecStageCode,
/* Local associations */
_MaintenanceOrder,
_MaintenanceSubOperation,
_MaintenanceOperationComponent,
_TechnicalObject,
_TechObjIsEquipOrFuncnlLoc,
_ActivityType,
_CostElement,
_MaterialGroup,
_MaintOrderOperObjectListLink,
//_MaintOrdOpWithNotifAndEquip,
_StatusObjectActiveStatus,
_IsFinallyConfirmed,
_ObjectOverallStatus,
_ObjectOverallStatus._OverallStatus,
_IsDeleted,
_OperationPlanningValues._DurationUnitOfMeasure,
_EAMProcessPhase,
_EAMProcessSubPhase
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EAMOBJECTOVERALLSTATUS",
"I_LOGISTICSORDER",
"I_MAINTENANCEITEMOBJECT",
"I_MAINTENANCEORDEROPERATION",
"I_MAINTORDEROPEROBJECTLISTLINK",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDERTECHOBJ",
"I_STATUSOBJECTSTATUS",
"I_WORKCENTER"
],
"ASSOCIATED":
[
"I_COSTCENTERACTIVITYTYPE",
"I_COSTELEMENT",
"I_CURRENCY",
"I_EAMOBJECTOVERALLSTATUS",
"I_EAMOVERALLSTATUS",
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_INDICATOR",
"I_LANGUAGE",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDEROPERCOMP",
"I_MAINTORDEROPEROBJECTLISTLINK",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDERSUBOPERTECHOBJ",
"I_MAINTORDERTECHOBJ",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_OPERATIONCALCULATIONCONTROL",
"I_OPERATIONCONTROLPROFILE",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_STATUSOBJECT",
"I_STATUSOBJECTACTIVESTATUS",
"I_STATUSOBJECTSTATUS",
"I_SUPPLIER",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_UNITOFMEASURE",
"I_WORKCENTER"
],
"BASE":
[
"I_EAMOBJECTOVERALLSTATUS",
"I_MAINTENANCEORDEROPERATION",
"I_MAINTORDEROPERPLANNINGVALUES"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/