I_MaintOrderOperationTP
MaintOrder Operation w/ Technical Object
I_MaintOrderOperationTP is a Transactional CDS View that provides data about "MaintOrder Operation w/ Technical Object" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOperTechObj) and exposes 90 fields with key fields MaintenanceOrder, MaintenanceOrderOperation. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintOrderOperTechObj | I_MaintOrderOperTechObj | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_MaintOrderTP | _MaintOrderTP | _MaintOrderTP.MaintenanceOrder = $projection.MaintenanceOrder |
| [0..*] | I_MaintOrderComponentTP | _MaintOrderComponentTP | _MaintOrderComponentTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderComponentTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation |
| [0..*] | I_MaintOrderSubOperationTP | _MaintOrderSubOperationTP | _MaintOrderSubOperationTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderSubOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation |
| [0..1] | I_StatusObjectStatus | _IsDeletedStatus | _IsDeletedStatus.StatusObject = $projection.MaintOrderOperationInternalID and _IsDeletedStatus.StatusCode = 'I0013' and _IsDeletedStatus.StatusIsInactive = ' ' |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IMAINTORDOPTP | view | |
| EndUserText.label | MaintOrder Operation w/ Technical Object | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.writeDraftPersistence | MAINTORDOPER_D | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view |
Fields (90)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | I_MaintOrderOperTechObj | MaintenanceOrder | |
| KEY | MaintenanceOrderOperation | I_MaintOrderOperTechObj | MaintenanceOrderOperation | |
| MaintOrderOperationForEdit | I_MaintOrderOperTechObj | MaintenanceOrderOperation | ||
| TechnicalObject | I_MaintOrderOperTechObj | TechnicalObject | ||
| TechObjIsEquipOrFuncnlLoc | I_MaintOrderOperTechObj | TechObjIsEquipOrFuncnlLoc | ||
| ControllingArea | I_MaintOrderOperTechObj | ControllingArea | ||
| MaintOrderRoutingNumber | I_MaintOrderOperTechObj | MaintOrderRoutingNumber | ||
| MaintOrderOperationCounter | I_MaintOrderOperTechObj | MaintOrderOperationCounter | ||
| OperationControlKey | I_MaintOrderOperTechObj | OperationControlKey | ||
| OperationDescription | I_MaintOrderOperTechObj | OperationDescription | ||
| MaintOrderOperationInternalID | I_MaintOrderOperTechObj | MaintOrderOperationInternalID | ||
| Equipment | I_MaintOrderOperTechObj | Equipment | ||
| FunctionalLocation | I_MaintOrderOperTechObj | FunctionalLocation | ||
| Plant | I_MaintOrderOperTechObj | Plant | ||
| OperationWorkCenterInternalID | I_MaintOrderOperTechObj | OperationWorkCenterInternalID | ||
| OperationWorkCenterTypeCode | I_MaintOrderOperTechObj | OperationWorkCenterTypeCode | ||
| OperationPurgInfoRecdSearchTxt | I_MaintOrderOperTechObj | OperationPurgInfoRecdSearchTxt | ||
| OperationRequisitionerName | I_MaintOrderOperTechObj | OperationRequisitionerName | ||
| OperationGoodsRecipientName | I_MaintOrderOperTechObj | OperationGoodsRecipientName | ||
| OpExternalProcessingPrice | I_MaintOrderOperTechObj | OpExternalProcessingPrice | ||
| OpExternalProcessingPriceUnit | I_MaintOrderOperTechObj | OpExternalProcessingPriceUnit | ||
| OpExternalProcessingCurrency | I_MaintOrderOperTechObj | OpExternalProcessingCurrency | ||
| OperationTrackingNumber | I_MaintOrderOperTechObj | OperationTrackingNumber | ||
| OperationPurchasingInfoRecord | I_MaintOrderOperTechObj | OperationPurchasingInfoRecord | ||
| OperationUnloadingPointName | I_MaintOrderOperTechObj | OperationUnloadingPointName | ||
| OpPurchaseOutlineAgreement | I_MaintOrderOperTechObj | OpPurchaseOutlineAgreement | ||
| OpPurchaseOutlineAgreementItem | I_MaintOrderOperTechObj | OpPurchaseOutlineAgreementItem | ||
| OperationSupplier | I_MaintOrderOperTechObj | OperationSupplier | ||
| OperationPersonResponsible | I_MaintOrderOperTechObj | OperationPersonResponsible | ||
| Assembly | I_MaintOrderOperTechObj | Assembly | ||
| OperationSystemCondition | I_MaintOrderOperTechObj | OperationSystemCondition | ||
| CostCtrActivityType | I_MaintOrderOperTechObj | CostCtrActivityType | ||
| ReqgCostCenterControllingArea | I_MaintOrderOperTechObj | ReqgCostCenterControllingArea | ||
| OperationCalculationControl | I_MaintOrderOperTechObj | OperationCalculationControl | ||
| OperationWorkPercent | I_MaintOrderOperTechObj | OperationWorkPercent | ||
| CapacityRequirement | I_MaintOrderOperTechObj | CapacityRequirement | ||
| CapacityRequirementItem | I_MaintOrderOperTechObj | CapacityRequirementItem | ||
| PurchaseRequisition | I_MaintOrderOperTechObj | PurchaseRequisition | ||
| PurchaseRequisitionItem | I_MaintOrderOperTechObj | PurchaseRequisitionItem | ||
| NumberOfCapacities | I_MaintOrderOperTechObj | NumberOfCapacities | ||
| OperationPlannedWork | I_MaintOrderOperTechObj | OperationPlannedWork | ||
| OperationPlannedWorkUnit | I_MaintOrderOperTechObj | OperationPlannedWorkUnit | ||
| OperationDuration | I_MaintOrderOperTechObj | OperationDuration | ||
| OperationDurationUnit | I_MaintOrderOperTechObj | OperationDurationUnit | ||
| OperationWorkCenter | I_MaintOrderOperTechObj | OperationWorkCenter | ||
| ConfirmationTotalQuantity | I_MaintOrderOperTechObj | ConfirmationTotalQuantity | ||
| MaterialGroup | I_MaintOrderOperTechObj | MaterialGroup | ||
| CostElement | I_MaintOrderOperTechObj | CostElement | ||
| PurchasingGroup | I_MaintOrderOperTechObj | PurchasingGroup | ||
| PurchasingOrganization | I_MaintOrderOperTechObj | PurchasingOrganization | ||
| Language | I_MaintOrderOperTechObj | Language | ||
| OperationHasLongText | I_MaintOrderOperTechObj | OperationHasLongText | ||
| EAMOverallObjectStatusProfile | I_MaintOrderOperTechObj | EAMOverallObjectStatusProfile | ||
| EAMOverallObjectStatus | I_MaintOrderOperTechObj | EAMOverallObjectStatus | ||
| IsDeleted | I_MaintOrderOperTechObj | IsDeleted | ||
| IsFinallyConfirmed | I_MaintOrderOperTechObj | IsFinallyConfirmed | ||
| MaintOperationExecStageCode | I_MaintOrderOperTechObj | MaintOperationExecStageCode | ||
| MaintOrdOpProcessPhaseCode | I_MaintOrderOperTechObj | MaintOrdOpProcessPhaseCode | ||
| MaintOrdOpProcessSubPhaseCode | I_MaintOrderOperTechObj | MaintOrdOpProcessSubPhaseCode | ||
| MaintOperationalChecklistType | I_MaintOrderOperTechObj | MaintOperationalChecklistType | ||
| _ActivityType | I_MaintOrderOperTechObj | _ActivityType | ||
| _CostElement | I_MaintOrderOperTechObj | _CostElement | ||
| _MaterialGroup | I_MaintOrderOperTechObj | _MaterialGroup | ||
| _Assembly | I_MaintOrderOperTechObj | _Assembly | ||
| _MaintOrderTP | _MaintOrderTP | |||
| _MaintOrderComponentTP | _MaintOrderComponentTP | |||
| _MaintOrderSubOperationTP | _MaintOrderSubOperationTP | |||
| _MaintenanceSubOperation | I_MaintOrderOperTechObj | _MaintenanceSubOperation | ||
| _OperationCalculationControl | I_MaintOrderOperTechObj | _OperationCalculationControl | ||
| _OperationControlKey | I_MaintOrderOperTechObj | _OperationControlKey | ||
| _OperationPlanningValues | I_MaintOrderOperTechObj | _OperationPlanningValues | ||
| _OperationSystemCondition | I_MaintOrderOperTechObj | _OperationSystemCondition | ||
| _OpExternalProcessingCurrency | I_MaintOrderOperTechObj | _OpExternalProcessingCurrency | ||
| _PlannedWorkUnitOfMeasure | I_MaintOrderOperTechObj | _PlannedWorkUnitOfMeasure | ||
| _Plant | I_MaintOrderOperTechObj | _Plant | ||
| _StatusObject | I_MaintOrderOperTechObj | _StatusObject | ||
| _TechnicalObject | I_MaintOrderOperTechObj | _TechnicalObject | ||
| _TechObjIsEquipOrFuncnlLoc | I_MaintOrderOperTechObj | _TechObjIsEquipOrFuncnlLoc | ||
| _WorkCenter | I_MaintOrderOperTechObj | _WorkCenter | ||
| _MaintOrderOperObjectListLink | I_MaintOrderOperTechObj | _MaintOrderOperObjectListLink | ||
| _OperationHasLongText | I_MaintOrderOperTechObj | _OperationHasLongText | ||
| _Supplier | I_MaintOrderOperTechObj | _Supplier | ||
| _PersonResponsible | I_MaintOrderOperTechObj | _PersonResponsible | ||
| _StatusObjectActiveStatus | I_MaintOrderOperTechObj | _StatusObjectActiveStatus | ||
| _OverallStatus | I_MaintOrderOperTechObj | _OverallStatus | ||
| _MaintenanceOrder | I_MaintOrderOperTechObj | _MaintenanceOrder | ||
| _DurationUnitOfMeasure | I_MaintOrderOperTechObj | _DurationUnitOfMeasure | ||
| _MaintOperationExecStageCode | I_MaintOrderOperTechObj | _MaintOperationExecStageCode | ||
| _EAMProcessPhase | I_MaintOrderOperTechObj | _EAMProcessPhase | ||
| _EAMProcessSubPhase | I_MaintOrderOperTechObj | _EAMProcessSubPhase |
@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":""
}
}*/
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