I_MAINTORDERTP
Maintenance Order w/ Technical Object
I_MAINTORDERTP is a CDS View in S/4HANA. Maintenance Order w/ Technical Object. It contains 69 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MaintOrderForAction | view | from | CONSUMPTION | Maintenance Order Operation for Action |
| C_MaintOrderTP | view | from | CONSUMPTION | Maintenance Order with Draft |
| C_ObjPgMaintOrder | view | from | CONSUMPTION | Maintenance Order |
Fields (69)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | 2 |
| _Assembly | _Assembly | 1 | |
| _EAMProcessPhase | _EAMProcessPhase | 1 | |
| _EAMProcessSubPhase | _EAMProcessSubPhase | 1 | |
| _Equipment | _Equipment | 1 | |
| _LocationAccountAssignment | _LocationAccountAssignment | 1 | |
| _MaintenanceActivityType | _MaintenanceActivityType | 1 | |
| _MaintenanceNotification | _MaintenanceNotification | 1 | |
| _MaintenanceOrderCategory | _MaintenanceOrderCategory | 1 | |
| _MaintenanceOrderPhase | _MaintenanceOrderPhase | 1 | |
| _MaintenanceOrderType | _MaintenanceOrderType | 1 | |
| _MaintenancePlan | _MaintenancePlan | 1 | |
| _MaintenancePlannerGroup | _MaintenancePlannerGroup | 1 | |
| _MaintenancePlanningPlant | _MaintenancePlanningPlant | 1 | |
| _MaintenancePriority | _MaintenancePriority | 1 | |
| _MaintenancePriorityType | _MaintenancePriorityType | 1 | |
| _MaintenanceRevision | _MaintenanceRevision | 1 | |
| _MaintOrdPersonResponsible | _MaintOrdPersonResponsible | 1 | |
| _OperationSystemCondition | _OperationSystemCondition | 1 | |
| _Order | _Order | 1 | |
| _StatusObject | _StatusObject | 1 | |
| _StatusObjectStatus | _StatusObjectStatus | 1 | |
| _TechnicalObject | _TechnicalObject | 1 | |
| _TechObjIsEquipOrFuncnlLoc | _TechObjIsEquipOrFuncnlLoc | 1 | |
| Assembly | Assembly | 1 | |
| AuthorizationGroup | AuthorizationGroup | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| Equipment | Equipment | 1 | |
| FunctionalLocation | FunctionalLocation | 1 | |
| LatestAcceptableCompletionDate | LatestAcceptableCompletionDate | 2 | |
| MaintenanceActivityType | MaintenanceActivityType | 1 | |
| MaintenanceItem | MaintenanceItem | 2 | |
| MaintenanceNotification | MaintenanceNotification | 2 | |
| MaintenanceOrderCategory | MaintenanceOrderCategory | 1 | |
| MaintenanceOrderDesc | MaintenanceOrderDesc | 2 | |
| MaintenanceOrderForEdit | MaintenanceOrderForEdit | 1 | |
| MaintenanceOrderInternalID | MaintenanceOrderInternalID | 2 | |
| MaintenanceOrderType | MaintenanceOrderType | 2 | |
| MaintenancePlan | MaintenancePlan | 2 | |
| MaintenancePlannerGroup | MaintenancePlannerGroup | 1 | |
| MaintenancePlanningPlant | MaintenancePlanningPlant | 1 | |
| MaintenancePlant | MaintenancePlant | 1 | |
| MaintenanceProcessingPhase | MaintenanceProcessingPhase | 2 | |
| MaintenanceRevision | MaintenanceRevision | 1 | |
| MaintObjectLocAcctAssgmtNmbr | MaintObjectLocAcctAssgmtNmbr | 1 | |
| MaintOrdBasicEndDate | MaintOrdBasicEndDate | 1 | |
| MaintOrdBasicStartDate | MaintOrdBasicStartDate | 1 | |
| MaintOrderProcessingContext | MaintOrderProcessingContext | 1 | |
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | 1 | |
| MaintOrderSourceApplication | MaintOrderSourceApplication | 1 | |
| MaintOrdPersonResponsible | MaintOrdPersonResponsible | 1 | |
| MaintOrdProcessPhaseCode | MaintOrdProcessPhaseCode | 1 | |
| MaintOrdProcessSubPhaseCode | MaintOrdProcessSubPhaseCode | 1 | |
| MaintPriority | MaintPriority | 1 | |
| MaintPriorityType | MaintPriorityType | 1 | |
| OperationSystemCondition | OperationSystemCondition | 1 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 1 | |
| ScheduledBasicEndDate | ScheduledBasicEndDate | 1 | |
| ScheduledBasicStartDate | ScheduledBasicStartDate | 1 | |
| SerialNumber | SerialNumber | 1 | |
| TaskListGroup | TaskListGroup | 1 | |
| TaskListGroupCounter | TaskListGroupCounter | 1 | |
| TaskListType | TaskListType | 1 | |
| TechnicalObject | TechnicalObject | 1 | |
| TechObjIsEquipOrFuncnlLoc | TechObjIsEquipOrFuncnlLoc | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 1 |
@AbapCatalog.sqlViewName: 'IMAINTORDERTP'
@EndUserText.label: 'Maintenance Order w/ Technical Object'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.sapObjectNodeType.name: 'MaintenanceOrder'
@ObjectModel.compositionRoot:true
@ObjectModel.transactionalProcessingEnabled:true
@ObjectModel.draftEnabled:true
@ObjectModel.writeDraftPersistence:'MAINTORDER_D'
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey: [ 'MaintenanceOrder' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.entityChangeStateId: 'LastChangeDateTime'
define view I_MaintOrderTP
as select from I_MaintOrderTechObj
association [0..*] to I_MaintOrderOperationTP as _MaintOrderOperationTP on $projection.MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder
association [0..1] to E_MaintenanceOrder as _MaintenanceOrderExtension on $projection.MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder
association [0..1] to I_FunctionalLocationLabel as _FunctionalLocationLabel on _FunctionalLocationLabel.FunctionalLocation = $projection.FunctionalLocation
{
key I_MaintOrderTechObj.MaintenanceOrder,
I_MaintOrderTechObj.MaintenanceOrder as MaintenanceOrderForEdit,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_TechnicalObjectStdVH',
element: 'TechnicalObject' },
additionalBinding: [{ localElement: 'TechObjIsEquipOrFuncnlLoc',
element: 'TechObjIsEquipOrFuncnlLoc' }]
}]
// ]--GENERATED
I_MaintOrderTechObj.TechnicalObject,
I_MaintOrderTechObj.TechObjIsEquipOrFuncnlLoc,
I_MaintOrderTechObj.MaintPriorityType,
I_MaintOrderTechObj.MaintPriority,
I_MaintOrderTechObj.MaintenanceProcessingPhase,
I_MaintOrderTechObj.MaintObjectLocAcctAssgmtNmbr,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintNotifStdVH',
element: 'MaintenanceNotification' }
}]
// ]--GENERATED
I_MaintOrderTechObj.MaintenanceNotification,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_EquipmentStdVH',
element: 'Equipment' }
}]
// ]--GENERATED
I_MaintOrderTechObj.Equipment,
I_MaintOrderTechObj.FunctionalLocation,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenanceItemStdVH',
element: 'MaintenanceItem' }
}]
// ]--GENERATED
I_MaintOrderTechObj.MaintenanceItem,
cast('' as wapos) as MaintenancePlanItemIntID,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
// ]--GENERATED
I_MaintOrderTechObj.Assembly,
I_MaintOrderTechObj.SerialNumber,
I_MaintOrderTechObj.MaintenancePlanningPlant,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintPlnrGrpStdVH',
element: 'MaintenancePlannerGroup' },
additionalBinding: [{ localElement: 'MaintenancePlanningPlant',
element: 'MaintenancePlanningPlant' }]
}]
// ]--GENERATED
I_MaintOrderTechObj.MaintenancePlannerGroup,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenanceRevisionStdVH',
element: 'MaintenanceRevision' },
additionalBinding: [{ localElement: 'MaintenancePlanningPlant',
element: 'MaintenancePlanningPlant' }]
}]
// ]--GENERATED
I_MaintOrderTechObj.MaintenanceRevision,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenancePlanStdVH',
element: 'MaintenancePlan' }
}]
// ]--GENERATED
I_MaintOrderTechObj.MaintenancePlan,
I_MaintOrderTechObj.MaintOrderRoutingNumber,
I_MaintOrderTechObj.MaintenanceOrderType,
I_MaintOrderTechObj.MaintenanceOrderCategory,
I_MaintOrderTechObj.MaintenanceOrderDesc,
BasicSchedulingType,
OrdIsNotSchedldAutomatically,
I_MaintOrderTechObj.MaintOrdBasicStartDate,
@ObjectModel.readOnly: true
I_MaintOrderTechObj.MaintOrdBasicStartTime,
I_MaintOrderTechObj.MaintOrdBasicEndDate,
@ObjectModel.readOnly: true
I_MaintOrderTechObj.MaintOrdBasicEndTime,
// IME: 2002 LACD
I_MaintOrderTechObj.LatestAcceptableCompletionDate,
// IME: 2002 LACD
ScheduledBasicStartDate,
ScheduledBasicStartTime,
ScheduledBasicEndDate,
ScheduledBasicEndTime,
I_MaintOrderTechObj.MaintenanceOrderInternalID,
I_MaintOrderTechObj.WorkCenterInternalID,
I_MaintOrderTechObj.WorkCenterTypeCode,
I_MaintOrderTechObj.BusinessArea,
I_MaintOrderTechObj.MaintOrdMainWorkCenter,
I_MaintOrderTechObj.MaintOrdMainWorkCenterPlant,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PersWrkAgrmtSrchHelp',
element: 'PersonWorkAgreement' }
}]
// ]--GENERATED
I_MaintOrderTechObj.MaintOrdPersonResponsible as MaintOrdPersonResponsible,
// cast( I_MaintOrderTechObj.MaintOrdPersonResponsible as eams_person_responsible ) as MaintOrdPersonResponsible,
I_MaintOrderTechObj.MaintOrderReferenceDate,
I_MaintOrderTechObj.MaintOrderReferenceTime,
I_MaintOrderTechObj.MaintenanceOrderPlanningCode,
I_MaintOrderTechObj.OperationSystemCondition,
I_MaintOrderTechObj.ReferenceElement,
//--[ GENERATED:012:GFBfhxvv7kY4nKFWHa7fa0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintActyTypeStdVH',
element: 'MaintenanceActivityType' }
}]
// ]--GENERATED
I_MaintOrderTechObj.MaintenanceActivityType,
I_MaintOrderTechObj.ControllingArea,
I_MaintOrderTechObj.CompanyCode,
I_MaintOrderTechObj.ResponsibleCostCenter,
ControllingObjectClass,
ProfitCenter,
WBSElementInternalID,
ProjectInternalID,
OrderProcessingGroup,
-- not in use. only kept because it is a field in shipped draft table.
cast( '' as iautg ) as AuthorizationGroup,
I_MaintOrderTechObj.MaintenancePlant,
I_MaintOrderTechObj.CreatedByUser,
cast( case when _StatusObjectStatus[ StatusCode = 'I3350' ].StatusObject is not null then 'F2023' else '' end as pm_source_appl) as MaintOrderSourceApplication,
I_MaintOrderTechObj.CreationDate,
I_MaintOrderTechObj.CreationTime,
@ObjectModel.readOnly: true
-- see JIRA RAPBSP-65 - Presently, BOPF expects this to be timestampl (Long!)
I_MaintOrderTechObj.LastChangeDateTime,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
I_MaintOrderTechObj.OrderHasLongText,
@ObjectModel.readOnly: true
MaintOrderIsFinallyConfirmed,
@ObjectModel.readOnly: true
_MaintOrderHasOpenMainWork.MaintOrdHasOpenMainWork,
@ObjectModel.readOnly
I_MaintOrderTechObj.TaskListGroup,
@ObjectModel.readOnly
I_MaintOrderTechObj.TaskListType,
@ObjectModel.readOnly
I_MaintOrderTechObj.TaskListGroupCounter,
I_MaintOrderTechObj.Currency,
@ObjectModel.readOnly
MaintOrdProcessPhaseCode,
@ObjectModel.readOnly
MaintOrdProcessSubPhaseCode,
@ObjectModel.readOnly
_WrkPmtMaintOrderRelevance.WorkPermitRelevance,
MaintOrderProcessingContext,
I_MaintOrderTechObj.Material,
I_MaintOrderTechObj._Assembly,
I_MaintOrderTechObj._BusinessArea,
I_MaintOrderTechObj._ControllingArea,
I_MaintOrderTechObj._CompanyCode,
_ControllingObjectClass,
_ProfitCenter,
_BasicSchedulingType,
_OrderProcessingGroup,
_WBSElement,
_Project,
I_MaintOrderTechObj._Equipment,
I_MaintOrderTechObj._LocationAccountAssignment,
I_MaintOrderTechObj._MaintenanceActivityType,
I_MaintOrderTechObj._MaintenanceNotification,
I_MaintOrderTechObj._MaintenanceOrderCategory,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_MaintOrderOperationTP,
I_MaintOrderTechObj._MaintenanceOrderPhase,
I_MaintOrderTechObj._MaintenanceOrderType,
I_MaintOrderTechObj._MaintenancePlan,
I_MaintOrderTechObj._MaintenanceItem,
I_MaintOrderTechObj._OrderItem,
I_MaintOrderTechObj._MaintenanceTaskList,
I_MaintOrderTechObj._MaintenancePlannerGroup,
I_MaintOrderTechObj._MaintenancePlanningPlant,
I_MaintOrderTechObj._MaintenancePriority,
I_MaintOrderTechObj._MaintenancePriorityType,
I_MaintOrderTechObj._MainWorkCenter,
I_MaintOrderTechObj._MaintOrdMainWorkCenter,
I_MaintOrderTechObj._MaintOrdMainWorkCenterPlant,
I_MaintOrderTechObj._OperationSystemCondition,
I_MaintOrderTechObj._Order,
I_MaintOrderTechObj._OrderHasLongText,
I_MaintOrderTechObj._FunctionalLocation,
I_MaintOrderTechObj._ResponsibleCostCenter,
I_MaintOrderTechObj._StatusObject,
I_MaintOrderTechObj._StatusObjectStatus,
I_MaintOrderTechObj._TechnicalObject,
I_MaintOrderTechObj._TechObjIsEquipOrFuncnlLoc,
I_MaintOrderTechObj._MaintOrdPlngDegreeCode,
I_MaintOrderTechObj._MaintenanceRevision,
I_MaintOrderTechObj._MaintOrderTypeControlParam,
I_MaintOrderTechObj._CreatedByUser,
I_MaintOrderTechObj._MaintOrderIsFinallyConfirmed,
I_MaintOrderTechObj._MaintOrdPersonResponsible,
I_MaintOrderTechObj._StatusObjectActiveStatus,
I_MaintOrderTechObj._MaintOrderHasOpenMainWork,
I_MaintOrderTechObj._MaintenancePlanPlant,
I_MaintOrderTechObj._EAMProcessPhase,
I_MaintOrderTechObj._EAMProcessSubPhase,
I_MaintOrderTechObj._WrkPmtMaintOrderRelevance,
_FunctionalLocationLabel.FunctionalLocationLabelName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCTIONALLOCATIONLABEL",
"I_MAINTORDERHASOPENMAINWORK",
"I_MAINTORDERTECHOBJ",
"I_STATUSOBJECTSTATUS",
"I_WRKPMTMAINTORDERRELEVANCE"
],
"ASSOCIATED":
[
"E_MAINTENANCEORDER",
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_EQUIPMENT",
"I_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCATIONLABEL",
"I_INDICATOR",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_LOGISTICSORDER",
"I_MAINTENANCEACTIVITYTYPE",
"I_MAINTENANCEITEM",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDERPHASE",
"I_MAINTENANCEPLANBASIC",
"I_MAINTENANCEPLANNERGROUP",
"I_MAINTENANCEPLANPLANT",
"I_MAINTENANCEREVISION",
"I_MAINTENANCETASKLIST",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDERHASOPENMAINWORK",
"I_MAINTORDEROPERATIONTP",
"I_MAINTORDERTYPECONTROLPARAM",
"I_MAINTORDPLNGDEGREECODE",
"I_MATERIAL",
"I_ORDERCATEGORY",
"I_ORDERITEM",
"I_ORDERPROCESSINGGROUP",
"I_ORDERTYPE",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_PMNOTIFICATIONPRIORITY",
"I_PMNOTIFICATIONPRIORITYTYPE",
"I_PROFITCENTER",
"I_PROJECTBYINTERNALKEY",
"I_SCHEDULINGTYPE",
"I_STATUSOBJECT",
"I_STATUSOBJECTACTIVESTATUS",
"I_STATUSOBJECTSTATUS",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_USER",
"I_WBSELEMENTBYINTERNALKEY",
"I_WORKCENTER",
"I_WORKCENTERBYSEMANTICKEY",
"I_WRKPMTMAINTORDERRELEVANCE"
],
"BASE":
[
"I_MAINTORDERTECHOBJ"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/