C_MaintOrderTP

DDL: C_MAINTORDERTP SQL: CMAINTORDTP Type: view CONSUMPTION

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)

SourceAliasJoin Type
I_MaintOrderTP _MaintOrderTP from

Associations (8)

CardinalityTargetAliasCondition
[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)

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

KeyFieldSource TableSource FieldDescription
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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EAMPROCESSPHASE",
"I_EAMPROCESSPHASETEXT",
"I_EAMPROCESSSUBPHASE",
"I_EAMPROCESSSUBPHASETEXT",
"I_MAINTORDERTP",
"I_PMCONTACTCARDUSER",
"I_WORKCENTER"
],
"ASSOCIATED":
[
"C_MAINTENANCEJOBWORKITEM",
"C_MAINTORDEROPERATIONTP",
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_EQUIPMENT",
"I_GENERICPRIORITYTEXT",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_LOGISTICSORDER",
"I_MAINTENANCEACTIVITYTYPE",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDERPHASE",
"I_MAINTENANCEPLANBASIC",
"I_MAINTENANCEPLANNERGROUP",
"I_MAINTENANCEREVISION",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDERPLANTDEFAULTS",
"I_MATERIAL",
"I_ORDERCATEGORY",
"I_ORDERTYPE",
"I_ORDERTYPETEXT",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_PMCONTACTCARDUSER",
"I_PMNOTIFICATIONPRIORITY",
"I_PMNOTIFICATIONPRIORITYTYPE",
"I_STATUSOBJECT",
"I_STATUSOBJECTSTATUS",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_WORKCENTER",
"I_WORKCENTERTEXT"
],
"BASE":
[
"I_MAINTORDERTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/