I_MAINTORDERHISTTECHOBJ

CDS View

Maintenance Order History w/ Techn. Obj.

I_MAINTORDERHISTTECHOBJ is a CDS View in S/4HANA. Maintenance Order History w/ Techn. Obj.. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaintOrderTechObjCube view union_all COMPOSITE Maintenance Order With Tech Object - Cube 
@EndUserText.label: 'Maintenance Order History w/ Techn. Obj.'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IMNTORDHISTECOBJ'

@ObjectModel.representativeKey: 'MaintenanceOrder'
@ObjectModel.semanticKey:  [ 'MaintenanceOrder' ]

@ObjectModel.compositionRoot: true

@ObjectModel: {
    createEnabled: false,
    updateEnabled: false,
    deleteEnabled: false
}

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

// #BASIC View which also incorporates I_TechnicalObject (used for generating BOPF infrastructure)


define view I_MaintOrderHistTechObj
  as select from I_MaintenanceOrderHistory
  association [0..*] to I_MaintOrderOperTechObj     as _MaintenanceOrderOperation on  $projection.MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder
  association [0..1] to I_TechnicalObject           as _TechnicalObject           on  _TechnicalObject.TechnicalObject           = $projection.TechnicalObject
                                                                                  and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
  association [0..1] to I_TechObjIsEquipOrFuncnlLoc as _TechObjIsEquipOrFuncnlLoc on  _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc
{

      @ObjectModel.text.element:  [ 'MaintenanceOrderDesc' ]
  key I_MaintenanceOrderHistory.MaintenanceOrder,

      @ObjectModel.foreignKey.association: '_TechnicalObject'
      case when I_MaintenanceOrderHistory.Equipment != '' then
                  cast( I_MaintenanceOrderHistory.Equipment as eams_tec_obj )
           when I_MaintenanceOrderHistory.Equipment = '' and
                I_MaintenanceOrderHistory._LocationAccountAssignment.FunctionalLocation != '' then
                  cast(  I_MaintenanceOrderHistory._LocationAccountAssignment.FunctionalLocation as eams_tec_obj )
           else cast('' as eams_tec_obj ) end                     as TechnicalObject,

      @ObjectModel.foreignKey.association: '_TechObjIsEquipOrFuncnlLoc'
      case when I_MaintenanceOrderHistory.Equipment != '' then
                  cast ( 'EAMS_EQUI' as eams_tec_obj_type_value)
           when I_MaintenanceOrderHistory.Equipment = '' and
                I_MaintenanceOrderHistory._LocationAccountAssignment.FunctionalLocation != '' then
                  cast ( 'EAMS_FL' as eams_tec_obj_type_value)
           else cast('' as eams_tec_obj_type_value ) end          as TechObjIsEquipOrFuncnlLoc,

      /* Fields */
      I_MaintenanceOrderHistory.CreatedByUser,
      I_MaintenanceOrderHistory.CreationDate,
      I_MaintenanceOrderHistory.LastChangedByUser,
      I_MaintenanceOrderHistory.LastChangeDate,
      I_MaintenanceOrderHistory.IsMarkedForDeletion,
      I_MaintenanceOrderHistory.MaintPriorityType,
      I_MaintenanceOrderHistory.MaintPriority,
      I_MaintenanceOrderHistory.MaintenanceProcessingPhase,
      I_MaintenanceOrderHistory.MaintObjectLocAcctAssgmtNmbr,
      I_MaintenanceOrderHistory.MaintenanceNotification,
      I_MaintenanceOrderHistory.LeadingOrder,
      I_MaintenanceOrderHistory.Equipment,
      I_MaintenanceOrderHistory.MaintenanceItem,
      I_MaintenanceOrderHistory.Assembly,
      I_MaintenanceOrderHistory.SerialNumber,
      I_MaintenanceOrderHistory.MaintenancePlanningPlant,
      I_MaintenanceOrderHistory.MaintenancePlannerGroup,
      I_MaintenanceOrderHistory.MaintenanceRevision,
      I_MaintenanceOrderHistory.MaintenancePlan,
      //TODO: AUFPL is missing in HIKO

      //ZI_MaintenanceOrderHistory.MaintOrderRoutingNumber,

      I_MaintenanceOrderHistory.MaintenanceOrderType,
      I_MaintenanceOrderHistory.MaintenanceOrderCategory,
      I_MaintenanceOrderHistory.MaintenanceOrderDesc,
      I_MaintenanceOrderHistory.MaintOrdBasicStartDate,
      I_MaintenanceOrderHistory.MaintOrdBasicEndDate,
      I_MaintenanceOrderHistory.ActualStartDate,
      I_MaintenanceOrderHistory.ConfirmedEndDate,
      I_MaintenanceOrderHistory.MaintenanceOrderInternalID,
      I_MaintenanceOrderHistory.BillOfOperationsType,
      I_MaintenanceOrderHistory.BillOfOperations,
      I_MaintenanceOrderHistory.BillOfOperationsVariant,
      I_MaintenanceOrderHistory.WorkCenterInternalID,
      I_MaintenanceOrderHistory.WorkCenterTypeCode,
      I_MaintenanceOrderHistory.Plant,
      I_MaintenanceOrderHistory._MainWorkCenter.WorkCenter                             as MaintOrdMainWorkCenter,
      I_MaintenanceOrderHistory._MainWorkCenter.Plant                                  as MaintOrdMainWorkCenterPlant,      
//      I_MaintenanceOrderHistory.MainWorkCenter,

//      I_MaintenanceOrderHistory.MainWorkCenterPlant,

      I_MaintenanceOrderHistory.BusinessArea,
      _MaintenancePartner[1: PartnerFunction = 'VW'].Partner      as MaintOrdPersonResponsible,
      //_MaintenancePartner[1: PartnerFunction = 'VW'].PartnerName  as MaintOrdPersonResponsibleName,


      I_MaintenanceOrderHistory.MaintOrderReferenceDate,
      I_MaintenanceOrderHistory.MaintenanceOrderPlanningCode,
      I_MaintenanceOrderHistory.OperationSystemCondition,
      //TODO: ADPSP is missing in HIKO

      //I_MaintenanceOrderHistory.ReferenceElement,

      I_MaintenanceOrderHistory.MaintenanceActivityType,

      /* Fields required by DCL (authorization) */
      I_MaintenanceOrderHistory.ControllingArea,
      //TODO: KOSTV is missing in HIKO

      //I_MaintenanceOrderHistory.ResponsibleCostCenter,

      I_MaintenanceOrderHistory.AuthorizationGroup,
      I_MaintenanceOrderHistory.MaintenancePlant,

      /* Associations */
      I_MaintenanceOrderHistory._Equipment,
      I_MaintenanceOrderHistory._LocationAccountAssignment,
      I_MaintenanceOrderHistory._MaintenanceNotification,
      I_MaintenanceOrderHistory._MaintenanceOrderCategory,
      I_MaintenanceOrderHistory._MaintenanceOrderType,
      I_MaintenanceOrderHistory._MaintenanceOrderComponent,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _MaintenanceOrderOperation,
      I_MaintenanceOrderHistory._MaintenanceOrderPhase,
      I_MaintenanceOrderHistory._MaintenancePlan,
      I_MaintenanceOrderHistory._MaintenancePriority,
      I_MaintenanceOrderHistory._MaintenancePriorityType,
      //TODO: AUFK and AFKO don't contain data for historical orders

      //I_MaintenanceOrderHistory._Order,

      I_MaintenanceOrderHistory._StatusObject,
      _TechnicalObject,
      _TechObjIsEquipOrFuncnlLoc,
      _Plant,
      _MainWorkCenter,
      _BillOfOperationsType,
      _BillOfOperationsGroup,
      //_WorkCenter,

      I_MaintenanceOrderHistory._BusinessArea,
      I_MaintenanceOrderHistory._StatusObjectStatus,
      I_MaintenanceOrderHistory._MaintenancePlannerGroup,
      I_MaintenanceOrderHistory._MaintenancePlanningPlant,
      I_MaintenanceOrderHistory._MaintenanceActivityType,
      I_MaintenanceOrderHistory._Assembly,
      I_MaintenanceOrderHistory._OperationSystemCondition,
      I_MaintenanceOrderHistory._MaintenanceItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEORDERHISTORY",
"I_PLANTMAINTENANCEPARTNER",
"I_WORKCENTER"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE",
"I_BUSINESSAREA",
"I_EQUIPMENT",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEACTIVITYTYPE",
"I_MAINTENANCEITEM",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDERCOMPONENT_2",
"I_MAINTENANCEORDERPHASE",
"I_MAINTENANCEPLANBASIC",
"I_MAINTENANCEPLANNERGROUP",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDEROPERTECHOBJ",
"I_MATERIAL",
"I_ORDERCATEGORY",
"I_ORDERTYPE",
"I_PLANT",
"I_PMNOTIFICATIONPRIORITY",
"I_PMNOTIFICATIONPRIORITYTYPE",
"I_STATUSOBJECT",
"I_STATUSOBJECTSTATUS",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_WORKCENTER"
],
"BASE":
[
"I_MAINTENANCEORDERHISTORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More