C_OverdueMaintenanceOrderQ

DDL: C_OVERDUEMAINTENANCEORDERQ SQL: COVDMAINTORDQ Type: view CONSUMPTION Package: ODATA_EAM_ORD_MON

Overdue Maintenance Orders

C_OverdueMaintenanceOrderQ is a Consumption CDS View that provides data about "Overdue Maintenance Orders" in SAP S/4HANA. It reads from 1 data source (I_OverdueMaintenanceOrderC) and exposes 28 fields with key field MaintenanceOrder. Part of development package ODATA_EAM_ORD_MON.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_OverdueMaintenanceOrderC I_OverdueMaintenanceOrderC from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName COVDMAINTORDQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Overdue Maintenance Orders view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
MaintenanceOrderDesc MaintenanceOrderDesc
MaintenancePlannerGroup MaintenancePlannerGroup
MaintenanceRevision MaintenanceRevision
MaintenancePlanningPlant MaintenancePlanningPlant
MaintenancePlant MaintenancePlant
MaintenanceOrderType MaintenanceOrderType
MaintenanceOrderTypeName MaintenanceOrderTypeName
MaintPriority MaintPriority
MaintPriorityDesc MaintPriorityDesc
MaintPriorityColorCode MaintPriorityColorCode
MaintenanceActivityType MaintenanceActivityType
MaintenanceActivityTypeName MaintenanceActivityTypeName
MainWorkCenter MainWorkCenter
MainWorkCenterPlant MainWorkCenterPlant
MainWorkCenterText MainWorkCenterText
MaintenanceWorkCenter MaintenanceWorkCenter
MaintenanceWorkCenterPlant MaintenanceWorkCenterPlant
MaintenanceWorkCenterText MaintenanceWorkCenterText
ReferenceDate ReferenceDate
OverdueDays OverdueDays
ForDCLnoneedtoexposeEquipment
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
ControllingArea ControllingArea
ResponsibleCostCenter ResponsibleCostCenter
ForDCLnoneedtoexpose_Equipment
_LocationAccountAssignment _LocationAccountAssignment
_Order _Order 
@VDM.viewType: #CONSUMPTION

@AbapCatalog.sqlViewName: 'COVDMAINTORDQ'
@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
}

@Metadata.allowExtensions: true

define view C_OverdueMaintenanceOrderQ
  as select from I_OverdueMaintenanceOrderC( P_Date: $session.system_date )
{
      //I_OverdueMaintenanceOrderC

  key MaintenanceOrder,
  
      MaintenanceOrderDesc,
      
      MaintenancePlannerGroup,
      
      MaintenanceRevision,
      
      MaintenancePlanningPlant,
      
      MaintenancePlant,
      
      MaintenanceOrderType,
      MaintenanceOrderTypeName,
      
      MaintPriority,
      MaintPriorityDesc,
      MaintPriorityColorCode,          
      MaintenanceActivityType,
      MaintenanceActivityTypeName,
      
      MainWorkCenter,
      MainWorkCenterPlant,
      MainWorkCenterText,
      
      MaintenanceWorkCenter,
      MaintenanceWorkCenterPlant,
      MaintenanceWorkCenterText,
      
      ReferenceDate,
      
      OverdueDays,
      
      -- For DCL (no need to expose):
      @Consumption.hidden: true
      Equipment,
      @Consumption.hidden: true
      MaintObjectLocAcctAssgmtNmbr,
      @Consumption.hidden: true
      ControllingArea,
      @Consumption.hidden: true
      ResponsibleCostCenter,
      
      -- For DCL (no need to expose):
      _Equipment,
      _LocationAccountAssignment,
      _Order
}
where
  ReferenceDate < $session.system_date

Learn More