I_MAINTORDERSUBOPERTECHOBJ
MaintOrder Sub-Operation w/ Tech. Object
I_MAINTORDERSUBOPERTECHOBJ is a CDS View in S/4HANA. MaintOrder Sub-Operation w/ Tech. Object. It contains 81 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MaintOrderSubOperationTP | view | from | TRANSACTIONAL | MaintOrder Sub-Operation w/ Tech. Object |
Fields (81)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | 1 |
| KEY | MaintenanceOrderOperation | MaintenanceOrderOperation | 1 |
| KEY | MaintenanceOrderSubOperation | MaintenanceOrderSubOperation,MaintOrderSubOperationForEdit | 1 |
| _ActivityType | _ActivityType | 1 | |
| _Assembly | _Assembly | 1 | |
| _CostElement | _CostElement | 1 | |
| _EAMProcessPhase | _EAMProcessPhase | 1 | |
| _EAMProcessSubPhase | _EAMProcessSubPhase | 1 | |
| _MaintenanceOperationComponent | _MaintenanceOperationComponent | 1 | |
| _MaintenanceOrder | _MaintenanceOrder | 1 | |
| _MaintenanceOrderOperation | _MaintenanceOrderOperation | 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 | |
| _PersonResponsible | _PersonResponsible | 1 | |
| _PlannedWorkUnitOfMeasure | _PlannedWorkUnitOfMeasure | 1 | |
| _Plant | _Plant | 1 | |
| _StatusObject | _StatusObject | 1 | |
| _Supplier | _Supplier | 1 | |
| _TechnicalObject | _TechnicalObject | 1 | |
| _TechObjIsEquipOrFuncnlLoc | _TechObjIsEquipOrFuncnlLoc | 1 | |
| _WorkCenter | _WorkCenter | 1 | |
| Assembly | Assembly | 1 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| CapacityRequirementItem | CapacityRequirementItem | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CostElement | CostElement | 1 | |
| Equipment | Equipment | 1 | |
| FunctionalLocation | FunctionalLocation | 1 | |
| IsDeleted | IsDeleted | 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 Sub-Operation w/ Tech. Object'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AbapCatalog.sqlViewName: 'IMTORDSOPTECOBJ'
@ObjectModel.representativeKey: 'MaintenanceOrderSubOperation'
@ObjectModel.semanticKey: [ 'MaintenanceOrder', 'MaintenanceOrderOperation', 'MaintenanceOrderSubOperation' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
define view I_MaintOrderSubOperTechObj
as select from I_MaintenanceOrderSubOperation
association [1..1] to I_MaintOrderTechObj as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [1..1] to I_MaintOrderOperTechObj as _MaintenanceOrderOperation on $projection.MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation
association [0..*] to I_MaintOrderOperComp as _MaintenanceOperationComponent on $projection.MaintenanceOrder = _MaintenanceOperationComponent.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintenanceOperationComponent.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..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
{
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
key I_MaintenanceOrderSubOperation.MaintenanceOrder,
@ObjectModel.foreignKey.association: '_MaintenanceOrderOperation'
key I_MaintenanceOrderSubOperation.MaintenanceOrderOperation,
key I_MaintenanceOrderSubOperation.MaintenanceOrderSubOperation,
@ObjectModel.foreignKey.association: '_TechnicalObject'
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 _MaintOrderOperObjectListLink.MaintenanceItemObject is not null then
case when _MaintOrderOperObjectListLink._MaintenanceItemObject.Equipment <> '' then cast('EAMS_EQUI' as eams_tec_obj_type_value )
when _MaintOrderOperObjectListLink._MaintenanceItemObject.FunctionalLocation <> '' then cast('EAMS_FL' as eams_tec_obj_type_value )
else cast('' as eams_tec_obj_type_value ) end
else case when Equipment != '' then
cast ( 'EAMS_EQUI' as eams_tec_obj_type_value)
when Equipment = '' and
FunctionalLocation != '' then
cast ( 'EAMS_FL' as eams_tec_obj_type_value)
else cast('' as eams_tec_obj_type_value ) end
end as TechObjIsEquipOrFuncnlLoc,
/* Fields */
_MaintenanceOrder._Order.ControllingArea as ControllingArea,
I_MaintenanceOrderSubOperation.MaintOrderRoutingNumber,
I_MaintenanceOrderSubOperation.MaintOrderOperationCounter,
I_MaintenanceOrderSubOperation.OperationControlKey,
I_MaintenanceOrderSubOperation.OperationDescription,
I_MaintenanceOrderSubOperation.MaintOrderOperationInternalID,
I_MaintenanceOrderSubOperation.Equipment,
I_MaintenanceOrderSubOperation.FunctionalLocation,
I_MaintenanceOrderSubOperation.Plant,
I_MaintenanceOrderSubOperation.OperationWorkCenterInternalID,
I_MaintenanceOrderSubOperation.OperationWorkCenterTypeCode,
I_MaintenanceOrderSubOperation.OperationPurgInfoRecdSearchTxt,
I_MaintenanceOrderSubOperation.OperationRequisitionerName,
I_MaintenanceOrderSubOperation.OperationGoodsRecipientName,
I_MaintenanceOrderSubOperation.OpExternalProcessingPrice,
I_MaintenanceOrderSubOperation.OpExternalProcessingPriceUnit,
I_MaintenanceOrderSubOperation.OpExternalProcessingCurrency,
I_MaintenanceOrderSubOperation.OperationTrackingNumber,
I_MaintenanceOrderSubOperation.OperationPurchasingInfoRecord,
I_MaintenanceOrderSubOperation.OperationUnloadingPointName,
I_MaintenanceOrderSubOperation.OpPurchaseOutlineAgreement,
I_MaintenanceOrderSubOperation.OpPurchaseOutlineAgreementItem,
I_MaintenanceOrderSubOperation.OperationSupplier,
I_MaintenanceOrderSubOperation.OperationPersonResponsible,
I_MaintenanceOrderSubOperation.Assembly,
I_MaintenanceOrderSubOperation.OperationSystemCondition,
I_MaintenanceOrderSubOperation.CostCtrActivityType,
I_MaintenanceOrderSubOperation.ReqgCostCenterControllingArea,
I_MaintenanceOrderSubOperation.OperationCalculationControl,
I_MaintenanceOrderSubOperation.OperationWorkPercent,
I_MaintenanceOrderSubOperation.CapacityRequirement,
I_MaintenanceOrderSubOperation.CapacityRequirementItem,
I_MaintenanceOrderSubOperation.PurchaseRequisition,
I_MaintenanceOrderSubOperation.PurchaseRequisitionItem,
I_MaintenanceOrderSubOperation.NumberOfCapacities,
I_MaintenanceOrderSubOperation.CostElement,
I_MaintenanceOrderSubOperation.MaterialGroup,
I_MaintenanceOrderSubOperation.PurchasingGroup,
I_MaintenanceOrderSubOperation.PurchasingOrganization,
I_MaintenanceOrderSubOperation.Language,
I_MaintenanceOrderSubOperation.OperationHasLongText,
I_MaintenanceOrderSubOperation.MaintOperationExecStageCode,
I_MaintenanceOrderSubOperation.MaintOrdOpProcessPhaseCode,
I_MaintenanceOrderSubOperation.MaintOrdOpProcessSubPhaseCode,
I_MaintenanceOrderSubOperation.MaintOperationalChecklistType,
I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationPlannedWork,
I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationPlannedWorkUnit,
I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationDuration,
I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationDurationUnit,
I_MaintenanceOrderSubOperation._OperationPlanningValues._PlannedWorkUnitOfMeasure,
I_MaintenanceOrderSubOperation._WorkCenter.WorkCenter as OperationWorkCenter,
@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,
/* Associations from I_MaintenanceOrderOperation */
I_MaintenanceOrderSubOperation._OperationControlKey,
I_MaintenanceOrderSubOperation._OperationPlanningValues,
I_MaintenanceOrderSubOperation._OpExternalProcessingCurrency,
//I_MaintenanceOrderOperation._PersonResponsible,
I_MaintenanceOrderSubOperation._OperationSystemCondition,
I_MaintenanceOrderSubOperation._Plant,
I_MaintenanceOrderSubOperation._StatusObject,
I_MaintenanceOrderSubOperation._WorkCenter,
I_MaintenanceOrderSubOperation._OperationCalculationControl,
I_MaintenanceOrderSubOperation._Assembly,
I_MaintenanceOrderSubOperation._Language,
I_MaintenanceOrderSubOperation._OperationHasLongText,
I_MaintenanceOrderSubOperation._Supplier,
I_MaintenanceOrderSubOperation._PersonResponsible,
I_MaintenanceOrderSubOperation._MaintOperationExecStageCode,
I_MaintenanceOrderSubOperation._EAMProcessPhase,
I_MaintenanceOrderSubOperation._EAMProcessSubPhase,
/* Local associations */
_MaintenanceOrder,
_MaintenanceOrderOperation,
_MaintenanceOperationComponent,
_TechnicalObject,
_TechObjIsEquipOrFuncnlLoc,
_ActivityType,
_CostElement,
_MaterialGroup,
_MaintOrderOperObjectListLink,
_IsDeleted
}