I_MAINTORDERTP

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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":""
}
}*/