C_MaintOrderTP
Maintenance Order with Draft
C_MaintOrderTP is a Consumption CDS View that provides data about "Maintenance Order with Draft" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderTP) and exposes 79 fields with key field MaintenanceOrder. It has 8 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintOrderTP | _MaintOrderTP | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | C_MaintOrderOperationTP | _MaintOrderOperationTP | $projection.MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder |
| [0..1] | I_MaintOrderPlantDefaults | _PlanningPlantDefaults | $projection.MaintenancePlanningPlant = _PlanningPlantDefaults.Plant |
| [0..*] | C_MaintenanceJobWorkItem | _MaintenanceJobWorkItem | $projection.MaintenanceOrder = _MaintenanceJobWorkItem.MaintenanceOrder |
| [0..*] | I_GenericPriorityText | _PriorityText | _PriorityText.GenericPriorityType = $projection.MaintPriorityType and _PriorityText.PriorityCode = $projection.MaintPriority |
| [0..1] | I_WorkCenter | _WorkCenter | $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode |
| [0..*] | I_WorkCenterText | _WorkCenterText | $projection.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode |
| [0..*] | I_OrderTypeText | _OrderTypeText | _OrderTypeText.OrderType = $projection.MaintenanceOrderType |
| [0..1] | I_PMContactCardUser | _PMContactCardUser | _PMContactCardUser.UserID = $projection.CreatedByUser |
Annotations (22)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CMAINTORDTP | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Maintenance Order with Draft | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.representativeKey | MaintenanceOrder | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.transactionalProcessingDelegated | true | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.draftEnabled | true | view | |
| Search.searchable | true | view | |
| UI.headerInfo.description.value | MaintenanceOrderDesc | view | |
| UI.headerInfo.description.type | #STANDARD | view | |
| UI.headerInfo.title.value | MaintenanceOrder | view | |
| UI.headerInfo.title.type | #STANDARD | view | |
| UI.headerInfo.typeName | Maintenance Order | view | |
| UI.headerInfo.typeNamePlural | Maintenance Orders | view |
Fields (79)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | I_MaintOrderTP | MaintenanceOrder | |
| MaintenanceOrderForEdit | I_MaintOrderTP | MaintenanceOrderForEdit | ||
| TechnicalObject | I_MaintOrderTP | TechnicalObject | ||
| TechObjIsEquipOrFuncnlLoc | I_MaintOrderTP | TechObjIsEquipOrFuncnlLoc | ||
| MaintPriorityType | I_MaintOrderTP | MaintPriorityType | ||
| MaintPriority | I_MaintOrderTP | MaintPriority | Priority | |
| MaintenanceProcessingPhase | I_MaintOrderTP | MaintenanceProcessingPhase | ||
| MaintObjectLocAcctAssgmtNmbr | I_MaintOrderTP | MaintObjectLocAcctAssgmtNmbr | ||
| MaintenanceNotification | I_MaintOrderTP | MaintenanceNotification | ||
| Equipment | I_MaintOrderTP | Equipment | ||
| FunctionalLocation | I_MaintOrderTP | FunctionalLocation | ||
| MaintenanceItem | I_MaintOrderTP | MaintenanceItem | ||
| Assembly | I_MaintOrderTP | Assembly | ||
| SerialNumber | I_MaintOrderTP | SerialNumber | ||
| MaintenancePlanningPlant | I_MaintOrderTP | MaintenancePlanningPlant | ||
| MaintenancePlannerGroup | I_MaintOrderTP | MaintenancePlannerGroup | ||
| OperationSystemCondition | I_MaintOrderTP | OperationSystemCondition | ||
| MaintenanceRevision | I_MaintOrderTP | MaintenanceRevision | ||
| MaintenancePlan | I_MaintOrderTP | MaintenancePlan | ||
| MaintOrderRoutingNumber | I_MaintOrderTP | MaintOrderRoutingNumber | ||
| MaintenanceOrderType | I_MaintOrderTP | MaintenanceOrderType | ||
| MaintenanceOrderCategory | I_MaintOrderTP | MaintenanceOrderCategory | ||
| MaintenanceOrderDesc | I_MaintOrderTP | MaintenanceOrderDesc | ||
| MaintOrdBasicStartDate | I_MaintOrderTP | MaintOrdBasicStartDate | ||
| MaintOrdBasicEndDate | I_MaintOrderTP | MaintOrdBasicEndDate | ||
| ScheduledBasicStartDate | I_MaintOrderTP | ScheduledBasicStartDate | Schedule Start Date | |
| ScheduledBasicEndDate | I_MaintOrderTP | ScheduledBasicEndDate | Schedule End Date | |
| LatestAcceptableCompletionDate | I_MaintOrderTP | LatestAcceptableCompletionDate | ||
| MaintenanceOrderInternalID | I_MaintOrderTP | MaintenanceOrderInternalID | ||
| AuthorizationGroup | I_MaintOrderTP | AuthorizationGroup | ||
| MaintenancePlant | I_MaintOrderTP | MaintenancePlant | ||
| ControllingArea | I_MaintOrderTP | ControllingArea | ||
| MaintenanceActivityType | I_MaintOrderTP | MaintenanceActivityType | ||
| ResponsibleCostCenter | I_MaintOrderTP | ResponsibleCostCenter | ||
| MaintOrderSourceApplication | I_MaintOrderTP | MaintOrderSourceApplication | ||
| MaintOrdPersonResponsible | I_MaintOrderTP | MaintOrdPersonResponsible | ||
| MaintOrdProcessPhaseCode | I_MaintOrderTP | MaintOrdProcessPhaseCode | Phase | |
| EAMProcessPhaseCodeDesc | Phase | |||
| MaintOrdProcessSubPhaseCode | I_MaintOrderTP | MaintOrdProcessSubPhaseCode | Subphase | |
| EAMProcessSubPhaseCodeDesc | Subphase | |||
| WorkCenter | _WorkCenter | WorkCenter | ||
| AssetManufacturerName | ||||
| TechnicalObjectDescription | ||||
| CreatedByUser | I_MaintOrderTP | CreatedByUser | Created By | |
| FullName | _PMContactCardUser | FullName | ||
| CreationDate | I_MaintOrderTP | CreationDate | Created On | |
| _PlanningPlantDefaults | _PlanningPlantDefaults | |||
| _Equipment | I_MaintOrderTP | _Equipment | ||
| _LocationAccountAssignment | I_MaintOrderTP | _LocationAccountAssignment | ||
| _MaintenanceNotification | I_MaintOrderTP | _MaintenanceNotification | ||
| _MaintenanceOrderPhase | I_MaintOrderTP | _MaintenanceOrderPhase | ||
| _MaintenancePlan | I_MaintOrderTP | _MaintenancePlan | ||
| _MaintenancePriority | I_MaintOrderTP | _MaintenancePriority | ||
| _MaintenancePriorityType | I_MaintOrderTP | _MaintenancePriorityType | ||
| _MaintOrderOperationTP | _MaintOrderOperationTP | |||
| _Order | I_MaintOrderTP | _Order | ||
| _OperationSystemCondition | I_MaintOrderTP | _OperationSystemCondition | ||
| _TechnicalObject | I_MaintOrderTP | _TechnicalObject | ||
| _TechObjIsEquipOrFuncnlLoc | I_MaintOrderTP | _TechObjIsEquipOrFuncnlLoc | ||
| _MaintenanceActivityType | I_MaintOrderTP | _MaintenanceActivityType | ||
| _Assembly | I_MaintOrderTP | _Assembly | ||
| _MaintenanceOrderCategory | I_MaintOrderTP | _MaintenanceOrderCategory | ||
| _MaintenanceOrderType | I_MaintOrderTP | _MaintenanceOrderType | ||
| _MaintenancePlannerGroup | I_MaintOrderTP | _MaintenancePlannerGroup | ||
| _MaintenancePlanningPlant | I_MaintOrderTP | _MaintenancePlanningPlant | ||
| _MaintenanceRevision | I_MaintOrderTP | _MaintenanceRevision | ||
| _StatusObject | I_MaintOrderTP | _StatusObject | ||
| _StatusObjectStatus | I_MaintOrderTP | _StatusObjectStatus | ||
| _MaintOrdPersonResponsible | I_MaintOrderTP | _MaintOrdPersonResponsible | ||
| WorkCenterInternalID | I_MaintOrderTP | WorkCenterInternalID | ||
| WorkCenterTypeCode | I_MaintOrderTP | WorkCenterTypeCode | ||
| _WorkCenter | _WorkCenter | |||
| _WorkCenterText | _WorkCenterText | |||
| _PriorityText | _PriorityText | |||
| _PMContactCardUser | _PMContactCardUser | |||
| _OrderTypeText | _OrderTypeText | |||
| _EAMProcessPhase | I_MaintOrderTP | _EAMProcessPhase | ||
| _EAMProcessSubPhase | I_MaintOrderTP | _EAMProcessSubPhase | ||
| _MaintenanceJobWorkItem | _MaintenanceJobWorkItem |
@AbapCatalog.sqlViewName: 'CMAINTORDTP'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Maintenance Order with Draft'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel: {
representativeKey: 'MaintenanceOrder',
semanticKey: ['MaintenanceOrder'],
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
transactionalProcessingDelegated: true,
compositionRoot:true,
draftEnabled: true
}
@Search.searchable: true
@UI: {
headerInfo: {
description: {
value: 'MaintenanceOrderDesc',
type: #STANDARD
},
title: {
value: 'MaintenanceOrder',
type: #STANDARD
},
typeName: 'Maintenance Order',
typeNamePlural: 'Maintenance Orders'
}
}
define view C_MaintOrderTP
as select from I_MaintOrderTP as _MaintOrderTP
association [0..*] to C_MaintOrderOperationTP as _MaintOrderOperationTP on $projection.MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder
association [0..1] to I_MaintOrderPlantDefaults as _PlanningPlantDefaults on $projection.MaintenancePlanningPlant = _PlanningPlantDefaults.Plant
association [0..*] to C_MaintenanceJobWorkItem as _MaintenanceJobWorkItem on $projection.MaintenanceOrder = _MaintenanceJobWorkItem.MaintenanceOrder
association [0..*] to I_GenericPriorityText as _PriorityText on _PriorityText.GenericPriorityType = $projection.MaintPriorityType
and _PriorityText.PriorityCode = $projection.MaintPriority
association [0..1] to I_WorkCenter as _WorkCenter on $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
and $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode
association [0..*] to I_WorkCenterText as _WorkCenterText on $projection.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID
and $projection.WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode
association [0..*] to I_OrderTypeText as _OrderTypeText on _OrderTypeText.OrderType = $projection.MaintenanceOrderType
// association [1] to C_TechObjQuickVw as _TechnicalObjectQuickVw on $projection.TechObjIsEquipOrFuncnlLoc = _TechnicalObjectQuickVw.TechObjIsEquipOrFuncnlLoc
// and $projection.TechnicalObject = _TechnicalObjectQuickVw.TechnicalObject
association [0..1] to I_PMContactCardUser as _PMContactCardUser on _PMContactCardUser.UserID = $projection.CreatedByUser
{
@Consumption.semanticObject: 'MaintenanceOrder'
key _MaintOrderTP.MaintenanceOrder,
@UI.hidden: true
_MaintOrderTP.MaintenanceOrderForEdit,
@Consumption.semanticObject: 'MaintenanceObject'
_MaintOrderTP.TechnicalObject,
_MaintOrderTP.TechObjIsEquipOrFuncnlLoc,
@UI.hidden: true
_MaintOrderTP.MaintPriorityType,
@ObjectModel.text.association: '_PriorityText'
@EndUserText.label: 'Priority'
@UI.textArrangement: #TEXT_ONLY
@ObjectModel.readOnly: true
_MaintOrderTP.MaintPriority,
@UI.hidden: true
_MaintOrderTP.MaintenanceProcessingPhase,
@UI.hidden: true
_MaintOrderTP.MaintObjectLocAcctAssgmtNmbr,
@Consumption.semanticObject: 'MaintenanceNotification'
_MaintOrderTP.MaintenanceNotification,
_MaintOrderTP.Equipment,
_MaintOrderTP.FunctionalLocation,
_MaintOrderTP.MaintenanceItem,
//--[ GENERATED:012:GFBfhxvv7jY4hYOuhNduX0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaterialStdVH',
element: 'Material' }
}]
// ]--GENERATED
_MaintOrderTP.Assembly,
_MaintOrderTP.SerialNumber,
_MaintOrderTP.MaintenancePlanningPlant,
//--[ GENERATED:012:GFBfhxvv7jY4hYOuhNduX0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintPlnrGrpStdVH',
element: 'MaintenancePlannerGroup' },
additionalBinding: [{ localElement: 'MaintenancePlanningPlant',
element: 'MaintenancePlanningPlant' }]
}]
// ]--GENERATED
_MaintOrderTP.MaintenancePlannerGroup,
_MaintOrderTP.OperationSystemCondition,
//--[ GENERATED:012:GFBfhxvv7jY4hYOuhNduX0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintenanceRevisionStdVH',
element: 'MaintenanceRevision' },
additionalBinding: [{ localElement: 'MaintenancePlanningPlant',
element: 'MaintenancePlanningPlant' }]
}]
// ]--GENERATED
_MaintOrderTP.MaintenanceRevision,
_MaintOrderTP.MaintenancePlan,
@UI.hidden: true
_MaintOrderTP.MaintOrderRoutingNumber,
@ObjectModel.readOnly: true
@ObjectModel.text.association: '_OrderTypeText'
_MaintOrderTP.MaintenanceOrderType,
@UI.hidden: true
_MaintOrderTP.MaintenanceOrderCategory,
@Search.defaultSearchElement: true
_MaintOrderTP.MaintenanceOrderDesc,
_MaintOrderTP.MaintOrdBasicStartDate,
_MaintOrderTP.MaintOrdBasicEndDate,
@EndUserText.label: 'Schedule Start Date'
_MaintOrderTP.ScheduledBasicStartDate,
@EndUserText.label: 'Schedule End Date'
_MaintOrderTP.ScheduledBasicEndDate,
_MaintOrderTP.LatestAcceptableCompletionDate,
@UI.hidden: true
_MaintOrderTP.MaintenanceOrderInternalID,
_MaintOrderTP.AuthorizationGroup,
_MaintOrderTP.MaintenancePlant,
_MaintOrderTP.ControllingArea,
//--[ GENERATED:012:GFBfhxvv7jY4hYOuhNduX0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_MaintActyTypeStdVH',
element: 'MaintenanceActivityType' }
}]
// ]--GENERATED
_MaintOrderTP.MaintenanceActivityType,
_MaintOrderTP.ResponsibleCostCenter,
@UI.hidden: true
_MaintOrderTP.MaintOrderSourceApplication,
//--[ GENERATED:012:GFBfhxvv7jY4hYOuhNduX0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PersWrkAgrmtSrchHelp',
element: 'PersonWorkAgreement' }
}]
// ]--GENERATED
@Consumption.hidden: true
_MaintOrderTP.MaintOrdPersonResponsible,
@EndUserText.label: 'Phase'
@UI: {
textArrangement: #TEXT_ONLY
}
// @ObjectModel.foreignKey.association: '_EAMProcessPhase'
@ObjectModel.text.element: ['EAMProcessPhaseCodeDesc']
_MaintOrderTP.MaintOrdProcessPhaseCode,
@ObjectModel.readOnly: true
@EndUserText.label: 'Phase'
_MaintOrderTP._EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc as EAMProcessPhaseCodeDesc,
@EndUserText.label: 'Subphase'
@UI: {
textArrangement: #TEXT_ONLY
}
// @ObjectModel.foreignKey.association: '_EAMProcessSubphase'
@ObjectModel.text.element: ['EAMProcessSubphaseCodeDesc']
_MaintOrderTP.MaintOrdProcessSubPhaseCode,
@ObjectModel.readOnly: true
@EndUserText.label: 'Subphase'
_MaintOrderTP._EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc as EAMProcessSubPhaseCodeDesc,
@ObjectModel.text.association: '_WorkCenterText'
@ObjectModel.readOnly: true
_WorkCenter.WorkCenter,
// @ObjectModel.readOnly: true
// _TechnicalObjectQuickVw.AssetManufacturerName,
// @ObjectModel.readOnly: true
// _TechnicalObjectQuickVw.TechnicalObjectDescription,
@ObjectModel.readOnly: true
@ObjectModel.virtualElement: true
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_MALFUNC_TECHOBJDET_EXIT'
cast( '' as herst ) as AssetManufacturerName,
@ObjectModel.readOnly: true
@ObjectModel.virtualElement: true
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_MALFUNC_TECHOBJDET_EXIT'
cast( '' as eams_tec_obj_des ) as TechnicalObjectDescription,
@EndUserText.label: 'Created By'
@ObjectModel.foreignKey.association: '_PMContactCardUser'
// case when _PMContactCardUser.FullName is not null and _PMContactCardUser.FullName != '' then _PMContactCardUser.FullName
// when _PMContactCardUser.UserID is not null and _PMContactCardUser.UserID != '' then _PMContactCardUser.UserID
// else _MaintOrderTP.CreatedByUser end as CreatedByUser,
_MaintOrderTP.CreatedByUser,
@ObjectModel.readOnly: true
_PMContactCardUser.FullName,
@EndUserText.label: 'Created On'
_MaintOrderTP.CreationDate,
/* Associations */
_PlanningPlantDefaults,
_MaintOrderTP._Equipment,
_MaintOrderTP._LocationAccountAssignment,
_MaintOrderTP._MaintenanceNotification,
_MaintOrderTP._MaintenanceOrderPhase,
_MaintOrderTP._MaintenancePlan,
_MaintOrderTP._MaintenancePriority,
_MaintOrderTP._MaintenancePriorityType,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_MaintOrderOperationTP,
_MaintOrderTP._Order,
_MaintOrderTP._OperationSystemCondition,
@ObjectModel.filter.transformedBy: 'CL_EAM_TECHOBJ_FILTER_EXIT'
_MaintOrderTP._TechnicalObject,
_MaintOrderTP._TechObjIsEquipOrFuncnlLoc,
_MaintOrderTP._MaintenanceActivityType,
_MaintOrderTP._Assembly,
_MaintOrderTP._MaintenanceOrderCategory,
_MaintOrderTP._MaintenanceOrderType,
_MaintOrderTP._MaintenancePlannerGroup,
_MaintOrderTP._MaintenancePlanningPlant,
_MaintOrderTP._MaintenanceRevision,
_MaintOrderTP._StatusObject,
_MaintOrderTP._StatusObjectStatus,
_MaintOrderTP._MaintOrdPersonResponsible,
_MaintOrderTP.WorkCenterInternalID,
_MaintOrderTP.WorkCenterTypeCode,
_WorkCenter,
_WorkCenterText,
_PriorityText,
_PMContactCardUser,
_OrderTypeText,
// _WorkCenterText,
// _MaintOrderTP.EAMProcessPhaseCodeDesc,
_MaintOrderTP._EAMProcessPhase,
_MaintOrderTP._EAMProcessSubPhase,
_MaintenanceJobWorkItem
}
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