I_MAINTORDEROPERATIONTP
MaintOrder Operation w/ Technical Object
I_MAINTORDEROPERATIONTP is a CDS View in S/4HANA. MaintOrder Operation w/ Technical Object. It contains 82 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MaintOrderOperationTP | view | from | CONSUMPTION | Maintenance Order Operation with Draft |
| C_MaintOrderOpForAction | view | from | CONSUMPTION | Maintenance Order Operation for Action |
| P_ObjPgMaintOrderAndOperation | view | from | CONSUMPTION | Union of Operation and Sub Operation |
Fields (82)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | 2 |
| KEY | MaintenanceOrderOperation | MaintenanceOrderOperation | 2 |
| _ActivityType | _ActivityType | 1 | |
| _Assembly | _Assembly | 1 | |
| _CostElement | _CostElement | 1 | |
| _EAMProcessPhase | _EAMProcessPhase | 2 | |
| _EAMProcessSubPhase | _EAMProcessSubPhase | 2 | |
| _MaintOperationExecStageCode | _MaintOperationExecStageCode | 2 | |
| _MaintOrderOperObjectListLink | _MaintOrderOperObjectListLink | 1 | |
| _MaterialGroup | _MaterialGroup | 1 | |
| _OperationCalculationControl | _OperationCalculationControl | 2 | |
| _OperationControlKey | _OperationControlKey | 1 | |
| _OperationHasLongText | _OperationHasLongText | 1 | |
| _OperationPlanningValues | _OperationPlanningValues | 1 | |
| _OperationSystemCondition | _OperationSystemCondition | 1 | |
| _OpExternalProcessingCurrency | _OpExternalProcessingCurrency | 1 | |
| _OverallStatus | _OverallStatus | 1 | |
| _PersonResponsible | _PersonResponsible | 1 | |
| _Plant | _Plant | 1 | |
| _StatusObject | _StatusObject | 1 | |
| _StatusObjectActiveStatus | _StatusObjectActiveStatus | 1 | |
| _Supplier | _Supplier | 1 | |
| _TechnicalObject | _TechnicalObject | 2 | |
| _TechObjIsEquipOrFuncnlLoc | _TechObjIsEquipOrFuncnlLoc | 2 | |
| _WorkCenter | _WorkCenter | 2 | |
| 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 | 2 | |
| FunctionalLocation | FunctionalLocation | 2 | |
| IsFinallyConfirmed | IsFinallyConfirmed | 1 | |
| Language | Language | 1 | |
| MaintOperationalChecklistType | MaintOperationalChecklistType | 1 | |
| MaintOperationExecStageCode | MaintOperationExecStageCode | 1 | |
| MaintOrderOperationCounter | MaintOrderOperationCounter | 2 | |
| MaintOrderOperationForEdit | MaintOrderOperationForEdit | 2 | |
| MaintOrderOperationInternalID | MaintOrderOperationInternalID | 2 | |
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | 2 | |
| MaintOrdOpProcessPhaseCode | MaintOrdOpProcessPhaseCode | 2 | |
| MaintOrdOpProcessSubPhaseCode | MaintOrdOpProcessSubPhaseCode | 2 | |
| MaterialGroup | MaterialGroup | 1 | |
| NumberOfCapacities | NumberOfCapacities | 1 | |
| OperationCalculationControl | OperationCalculationControl | 2 | |
| OperationControlKey | OperationControlKey | 1 | |
| OperationDescription | OperationDescription | 2 | |
| OperationDuration | OperationDuration | 2 | |
| OperationDurationUnit | OperationDurationUnit | 2 | |
| OperationGoodsRecipientName | OperationGoodsRecipientName | 1 | |
| OperationHasLongText | OperationHasLongText | 1 | |
| OperationPersonResponsible | OperationPersonResponsible | 1 | |
| OperationPlannedWork | OperationPlannedWork | 2 | |
| OperationPlannedWorkUnit | OperationPlannedWorkUnit | 2 | |
| OperationPurchasingInfoRecord | OperationPurchasingInfoRecord | 1 | |
| OperationPurgInfoRecdSearchTxt | OperationPurgInfoRecdSearchTxt | 1 | |
| OperationRequisitionerName | OperationRequisitionerName | 1 | |
| OperationSupplier | OperationSupplier | 1 | |
| OperationSystemCondition | OperationSystemCondition | 1 | |
| OperationTrackingNumber | OperationTrackingNumber | 1 | |
| OperationUnloadingPointName | OperationUnloadingPointName | 1 | |
| OperationWorkCenter | OperationWorkCenter | 2 | |
| OperationWorkCenterInternalID | OperationWorkCenterInternalID | 2 | |
| OperationWorkCenterTypeCode | OperationWorkCenterTypeCode | 2 | |
| OperationWorkPercent | OperationWorkPercent | 1 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 1 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 1 | |
| OpExternalProcessingPriceUnit | OpExternalProcessingPriceUnit | 1 | |
| OpPurchaseOutlineAgreement | OpPurchaseOutlineAgreement | 1 | |
| OpPurchaseOutlineAgreementItem | OpPurchaseOutlineAgreementItem | 1 | |
| Plant | Plant | 2 | |
| PurchaseRequisition | PurchaseRequisition | 1 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| ReqgCostCenterControllingArea | ReqgCostCenterControllingArea | 1 | |
| TechnicalObject | TechnicalObject | 2 | |
| TechObjIsEquipOrFuncnlLoc | TechObjIsEquipOrFuncnlLoc | 2 |
@AbapCatalog.sqlViewName: 'IMAINTORDOPTP'
@EndUserText.label: 'MaintOrder Operation w/ Technical Object'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.draftEnabled: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.writeDraftPersistence: 'MAINTORDOPER_D'
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey: [ 'MaintenanceOrder','MaintenanceOrderOperation' ]
define view I_MaintOrderOperationTP
as select from I_MaintOrderOperTechObj
association [1..1] to I_MaintOrderTP as _MaintOrderTP on _MaintOrderTP.MaintenanceOrder = $projection.MaintenanceOrder
association [0..*] to I_MaintOrderComponentTP as _MaintOrderComponentTP on _MaintOrderComponentTP.MaintenanceOrder = $projection.MaintenanceOrder
and _MaintOrderComponentTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
association [0..*] to I_MaintOrderSubOperationTP as _MaintOrderSubOperationTP on _MaintOrderSubOperationTP.MaintenanceOrder = $projection.MaintenanceOrder
and _MaintOrderSubOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
association [0..1] to I_StatusObjectStatus as _IsDeletedStatus on _IsDeletedStatus.StatusObject = $projection.MaintOrderOperationInternalID
and _IsDeletedStatus.StatusCode = 'I0013'
and _IsDeletedStatus.StatusIsInactive = ' '
{
key I_MaintOrderOperTechObj.MaintenanceOrder,
key I_MaintOrderOperTechObj.MaintenanceOrderOperation,
I_MaintOrderOperTechObj.MaintenanceOrderOperation as MaintOrderOperationForEdit,
I_MaintOrderOperTechObj.TechnicalObject,
I_MaintOrderOperTechObj.TechObjIsEquipOrFuncnlLoc,
I_MaintOrderOperTechObj.ControllingArea,
I_MaintOrderOperTechObj.MaintOrderRoutingNumber,
I_MaintOrderOperTechObj.MaintOrderOperationCounter,
I_MaintOrderOperTechObj.OperationControlKey,
I_MaintOrderOperTechObj.OperationDescription,
I_MaintOrderOperTechObj.MaintOrderOperationInternalID,
I_MaintOrderOperTechObj.Equipment,
I_MaintOrderOperTechObj.FunctionalLocation,
I_MaintOrderOperTechObj.Plant,
I_MaintOrderOperTechObj.OperationWorkCenterInternalID,
I_MaintOrderOperTechObj.OperationWorkCenterTypeCode,
I_MaintOrderOperTechObj.OperationPurgInfoRecdSearchTxt,
I_MaintOrderOperTechObj.OperationRequisitionerName,
I_MaintOrderOperTechObj.OperationGoodsRecipientName,
I_MaintOrderOperTechObj.OpExternalProcessingPrice,
I_MaintOrderOperTechObj.OpExternalProcessingPriceUnit,
I_MaintOrderOperTechObj.OpExternalProcessingCurrency,
I_MaintOrderOperTechObj.OperationTrackingNumber,
I_MaintOrderOperTechObj.OperationPurchasingInfoRecord,
I_MaintOrderOperTechObj.OperationUnloadingPointName,
I_MaintOrderOperTechObj.OpPurchaseOutlineAgreement,
I_MaintOrderOperTechObj.OpPurchaseOutlineAgreementItem,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_Supplier_VH',
element: 'Supplier' }
}]
// ]--GENERATED
I_MaintOrderOperTechObj.OperationSupplier,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PersWrkAgrmtSrchHelp',
element: 'PersonWorkAgreement' }
}]
// ]--GENERATED
I_MaintOrderOperTechObj.OperationPersonResponsible,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
// ]--GENERATED
I_MaintOrderOperTechObj.Assembly,
I_MaintOrderOperTechObj.OperationSystemCondition,
I_MaintOrderOperTechObj.CostCtrActivityType,
I_MaintOrderOperTechObj.ReqgCostCenterControllingArea,
I_MaintOrderOperTechObj.OperationCalculationControl,
I_MaintOrderOperTechObj.OperationWorkPercent,
I_MaintOrderOperTechObj.CapacityRequirement,
I_MaintOrderOperTechObj.CapacityRequirementItem,
I_MaintOrderOperTechObj.PurchaseRequisition,
I_MaintOrderOperTechObj.PurchaseRequisitionItem,
I_MaintOrderOperTechObj.NumberOfCapacities,
I_MaintOrderOperTechObj.OperationPlannedWork,
I_MaintOrderOperTechObj.OperationPlannedWorkUnit,
I_MaintOrderOperTechObj.OperationDuration,
I_MaintOrderOperTechObj.OperationDurationUnit,
I_MaintOrderOperTechObj.OperationWorkCenter,
I_MaintOrderOperTechObj.ConfirmationTotalQuantity,
I_MaintOrderOperTechObj.MaterialGroup,
I_MaintOrderOperTechObj.CostElement,
I_MaintOrderOperTechObj.PurchasingGroup,
I_MaintOrderOperTechObj.PurchasingOrganization,
I_MaintOrderOperTechObj.Language,
I_MaintOrderOperTechObj.OperationHasLongText,
I_MaintOrderOperTechObj.EAMOverallObjectStatusProfile,
//--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_EAMOverallStatusStdVH',
element: 'EAMOverallStatus' },
additionalBinding: [{ localElement: 'EAMOverallObjectStatusProfile',
element: 'EAMOverallStatusProfile' }]
}]
// ]--GENERATED
I_MaintOrderOperTechObj.EAMOverallObjectStatus,
@ObjectModel.readOnly: true
I_MaintOrderOperTechObj.IsDeleted,
@ObjectModel.readOnly: true
I_MaintOrderOperTechObj.IsFinallyConfirmed,
@ObjectModel.readOnly
// @UI.hidden: true
-- used for MaintenanceOrderOperation semantic object binding:
cast( ' ' as uvorn preserving type ) as MaintenanceOrderSubOperation,
//cast( _MaintOrderSubOperationTP.MaintenanceOrderSubOperation as vornr preserving type ) as MaintenanceOrderSubOperation,
I_MaintOrderOperTechObj.MaintOperationExecStageCode,
@ObjectModel.readOnly
I_MaintOrderOperTechObj.MaintOrdOpProcessPhaseCode,
@ObjectModel.readOnly
I_MaintOrderOperTechObj.MaintOrdOpProcessSubPhaseCode,
I_MaintOrderOperTechObj.MaintOperationalChecklistType,
/* Associations */
I_MaintOrderOperTechObj._ActivityType,
I_MaintOrderOperTechObj._CostElement,
I_MaintOrderOperTechObj._MaterialGroup,
I_MaintOrderOperTechObj._Assembly,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
_MaintOrderTP,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_MaintOrderComponentTP,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_MaintOrderSubOperationTP,
I_MaintOrderOperTechObj._MaintenanceSubOperation,
I_MaintOrderOperTechObj._OperationCalculationControl,
I_MaintOrderOperTechObj._OperationControlKey,
I_MaintOrderOperTechObj._OperationPlanningValues,
I_MaintOrderOperTechObj._OperationSystemCondition,
I_MaintOrderOperTechObj._OpExternalProcessingCurrency,
I_MaintOrderOperTechObj._PlannedWorkUnitOfMeasure,
I_MaintOrderOperTechObj._Plant,
I_MaintOrderOperTechObj._StatusObject,
I_MaintOrderOperTechObj._TechnicalObject,
I_MaintOrderOperTechObj._TechObjIsEquipOrFuncnlLoc,
I_MaintOrderOperTechObj._WorkCenter,
I_MaintOrderOperTechObj._MaintOrderOperObjectListLink,
I_MaintOrderOperTechObj._OperationHasLongText,
I_MaintOrderOperTechObj._Supplier,
I_MaintOrderOperTechObj._PersonResponsible,
I_MaintOrderOperTechObj._StatusObjectActiveStatus,
I_MaintOrderOperTechObj._OverallStatus,
I_MaintOrderOperTechObj._MaintenanceOrder,
I_MaintOrderOperTechObj._DurationUnitOfMeasure,
I_MaintOrderOperTechObj._MaintOperationExecStageCode,
I_MaintOrderOperTechObj._EAMProcessPhase,
I_MaintOrderOperTechObj._EAMProcessSubPhase
}
where
I_MaintOrderOperTechObj.IsDeleted = '' --where _IsDeletedStatus.StatusObject is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTORDEROPERTECHOBJ"
],
"ASSOCIATED":
[
"I_COSTCENTERACTIVITYTYPE",
"I_COSTELEMENT",
"I_CURRENCY",
"I_EAMOVERALLSTATUS",
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_INDICATOR",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDERCOMPONENTTP",
"I_MAINTORDEROPEROBJECTLISTLINK",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDERSUBOPERATIONTP",
"I_MAINTORDERSUBOPERTECHOBJ",
"I_MAINTORDERTECHOBJ",
"I_MAINTORDERTP",
"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_MAINTORDEROPERTECHOBJ"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/