C_MaintNotifOutputParamDetn

DDL: C_MAINTNOTIFOUTPUTPARAMDETN SQL: CMNTNTFPRMDR Type: view CONSUMPTION Package: IPRT

Maintenance Notification OM Parameter Determination

C_MaintNotifOutputParamDetn is a Consumption CDS View that provides data about "Maintenance Notification OM Parameter Determination" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotification) and exposes 20 fields with key field MaintenanceNotification. Part of development package IPRT.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotification I_MaintenanceNotification from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMNTNTFPRMDR view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Notification OM Parameter Determination view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification
NotificationType NotificationType
MaintPriority MaintPriority
NotifProcessingPhase
WorkCenter _MainWorkCenter WorkCenter
MaintenancePlant
MaintenancePlanningPlant _PMNotifMaintenanceData MaintenancePlanningPlant
AssetLocation
AssetRoom
PlantSection
Equipment _PMNotifMaintenanceData Equipment
FunctionalLocation
Assembly _PMNotifMaintenanceData Assembly
MaintenancePlannerGroup _PMNotifMaintenanceData MaintenancePlannerGroup
TechnicalObjectCategory
TechnicalObjectType
ABCIndicator
MaintenanceObjectIsDown _PMNotifMaintenanceData MaintenanceObjectIsDown
MaintNotifProcessPhaseCode _PMNotifMaintenanceData MaintNotifProcessPhaseCode
MaintNotifProcessSubPhaseCode _PMNotifMaintenanceData MaintNotifProcessSubPhaseCode 
@AbapCatalog.sqlViewName: 'CMNTNTFPRMDR'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Maintenance Notification OM Parameter Determination'
@AbapCatalog.preserveKey: true 
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION

@ObjectModel: {
   compositionRoot: false,
   usageType: {
    serviceQuality:#C,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
   }
}

define view C_MaintNotifOutputParamDetn
  as select from I_MaintenanceNotification
{

  key MaintenanceNotification,
      NotificationType,
      MaintPriority,
      cast ( NotifProcessingPhase as eam_opd_notif_status preserving type ) as NotifProcessingPhase,
      _MainWorkCenter.WorkCenter                                            as WorkCenter,
      _PMNotifMaintenanceData._LocationAccountAssignment.MaintenancePlant   as MaintenancePlant,
      _PMNotifMaintenanceData.MaintenancePlanningPlant                      as MaintenancePlanningPlant,
      _PMNotifMaintenanceData._LocationAccountAssignment.AssetLocation      as AssetLocation,
      _PMNotifMaintenanceData._LocationAccountAssignment.AssetRoom          as AssetRoom,
      _PMNotifMaintenanceData._LocationAccountAssignment.PlantSection       as PlantSection,
      _PMNotifMaintenanceData.Equipment                                     as Equipment,
      _PMNotifMaintenanceData._LocationAccountAssignment.FunctionalLocation as FunctionalLocation,
      _PMNotifMaintenanceData.Assembly                                      as Assembly,
      _PMNotifMaintenanceData.MaintenancePlannerGroup                       as MaintenancePlannerGroup,
      _PMNotifMaintenanceData._Equipment.EquipmentCategory                  as TechnicalObjectCategory,
      _PMNotifMaintenanceData._Equipment.TechnicalObjectType                as TechnicalObjectType,
      _PMNotifMaintenanceData._LocationAccountAssignment.ABCIndicator       as ABCIndicator,
      _PMNotifMaintenanceData.MaintenanceObjectIsDown                       as MaintenanceObjectIsDown,
      _PMNotifMaintenanceData.MaintNotifProcessPhaseCode                    as MaintNotifProcessPhaseCode,
      _PMNotifMaintenanceData.MaintNotifProcessSubPhaseCode                 as MaintNotifProcessSubPhaseCode

}

Learn More