I_OVERDUEMAINTENANCEORDERC

CDS View

Overdue Maintenance Orders

I_OVERDUEMAINTENANCEORDERC is a CDS View in S/4HANA. Overdue Maintenance Orders. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_OverdueMaintenanceOrderQ view from CONSUMPTION Overdue Maintenance Orders 
@VDM.viewType: #COMPOSITE

@AbapCatalog.sqlViewName: 'IOVDMAINTORDC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Overdue Maintenance Orders'

@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}

@ObjectModel.usageType: {
  serviceQuality: #D,
  sizeCategory:   #L,
  dataClass:      #MIXED
}

define view I_OverdueMaintenanceOrderC
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_Date : sydate
  as select from P_OverdueMaintenanceOrderC( P_Date : $parameters.P_Date )
{
  key MaintenanceOrder,

      MaintenanceOrderDesc,

      MaintenancePlannerGroup,

      MaintenanceRevision,

      MaintenancePlanningPlant,

      MaintenancePlant,

      MaintenanceOrderType,
      MaintenanceOrderTypeName,

      MaintPriority,
      MaintPriorityDesc,
      MaintPriorityColorCode,

      MaintenanceActivityType,
      MaintenanceActivityTypeName,

      MainWorkCenter,
      MainWorkCenterPlant,
      MainWorkCenterText,

      MaintenanceWorkCenter,
      MaintenanceWorkCenterPlant,
      MaintenanceWorkCenterText,

      ReferenceDate,
      OverdueDays,

      -- For DCL:
      Equipment,
      MaintObjectLocAcctAssgmtNmbr,
      ResponsibleCostCenter,
      ControllingArea,

      -- For DCL:
      _Equipment,
      _LocationAccountAssignment,
      _Order
}
where
     MaintenanceProcessingPhase = '2' and (
     _StatusObjectStatus [1: StatusCode = 'I0009'].StatusIsInactive is null   -- CNF was never set
  or _StatusObjectStatus [1: StatusCode = 'I0009'].StatusIsInactive = 'X'   ) -- CNF was set, but not anymore
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSOBJECTSTATUS",
"P_OVERDUEMAINTENANCEORDERC"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_LOGISTICSORDER"
],
"BASE":
[
"P_OVERDUEMAINTENANCEORDERC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More