I_MAINTENANCEJOBANDWORKITEM

CDS View

Maintenance Job and Work Items

I_MAINTENANCEJOBANDWORKITEM is a CDS View in S/4HANA. Maintenance Job and Work Items. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MalfunctionReportInvlmnts view from CONSUMPTION Malfunction Report User Involvements
I_MaintJobAndWorkItemForUser view from COMPOSITE Current Users Maintenance Jobs and Work Items

Fields (4)

KeyField CDS FieldsUsed in Views
KEY MaintenanceJobInternalID MaintenanceJobInternalID 1
KEY ObjectType ObjectType 1
KEY StatusObject StatusObject 1
PersonResponsible PersonResponsible 1 
@EndUserText.label: 'Maintenance Job and Work Items'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMTJOBWKITM'

@ObjectModel: {
   usageType.serviceQuality: #D,
   usageType.sizeCategory: #XL,
   usageType.dataClass: #TRANSACTIONAL
}

@AccessControl.privilegedAssociations:  [ '_ObjectOverallStatus' ]

define view I_MaintenanceJobAndWorkItem
  as select from P_MaintenanceJobAndWorkItem
  association [0..1] to I_EAMObjectOverallStatus as _ObjectOverallStatus on  P_MaintenanceJobAndWorkItem.StatusObject           = _ObjectOverallStatus.StatusObject
                                                                         and _ObjectOverallStatus.EAMOverallObjectStatusProfile = 'MAINTJOB'
  association [0..1] to I_StatusObjectStatus     as _JobInProcessStatus  on  _JobInProcessStatus.StatusObject = $projection.StatusObject
                                                                         and _JobInProcessStatus.StatusCode   = 'I0809'
  association [0..1] to I_StatusObjectStatus     as _JobFinishedStatus   on  _JobFinishedStatus.StatusObject = $projection.StatusObject
                                                                         and _JobFinishedStatus.StatusCode   = 'I0820'


  --association [0..1] to I_WorkforcePerson        as _PersonResponsible   on  $projection.PersonResponsible = _PersonResponsible.PersonExternalID 
{
  key MaintenanceJobInternalID,
  key StatusObject,
  key ObjectType,
  
      -- User status with number
      _ObjectUserStatusWithNumber.StatusCode,
  
      -- Not exposed in OData services --
      @Consumption.hidden: true
      PersonResponsible,

      -- For DCL:
      @Consumption.hidden: true
      MaintenanceNotification,
      @Consumption.hidden: true
      MaintenanceOrder,

      _JobInProcessStatus,
      _JobFinishedStatus,
      _ObjectOverallStatus,

      -- For DCL:
      _MaintenanceNotification,
      _MaintenanceOrder,
      --_PersonResponsible, 
      _WorkAgreement,
      _ObjectUserStatusWithNumber
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EAMOBJECTUSRSTATUSWITHNUMBER",
"P_MAINTENANCEJOBANDWORKITEM"
],
"ASSOCIATED":
[
"I_EAMOBJECTOVERALLSTATUS",
"I_EAMOBJECTUSRSTATUSWITHNUMBER",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDER",
"I_PERSONWORKAGREEMENT_1",
"I_STATUSOBJECTSTATUS"
],
"BASE":
[
"P_MAINTENANCEJOBANDWORKITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More