C_MaintWorkRequestPriority

DDL: C_MAINTWORKREQUESTPRIORITY SQL: CPMWRKREQPRIO Type: view CONSUMPTION

Consumption View for Maintenance Work Request Priority

C_MaintWorkRequestPriority is a Consumption CDS View that provides data about "Consumption View for Maintenance Work Request Priority" in SAP S/4HANA. It reads from 1 data source (I_PMNotificationType) and exposes 6 fields with key fields NotificationType, MaintPriority.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_PMNotificationType _NotificationType from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPMWRKREQPRIO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumption View for Maintenance Work Request Priority view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY NotificationType I_PMNotificationType NotificationType
KEY MaintPriority _PMGenericPriority PriorityCode
MaintPriorityType I_PMNotificationType MaintPriorityType
MaintPriorityColorCode
MaintPriorityDesc
_PMGenericPriority _PMGenericPriority 
@AbapCatalog.sqlViewName: 'CPMWRKREQPRIO'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Consumption View for Maintenance Work Request Priority'
@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S 
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.resultSet.sizeCategory: #XS
@UI.presentationVariant: [{
  sortOrder: [{
                direction: #ASC,
                by: 'MaintPriority'
   }]
 }]
define view C_MaintWorkRequestPriority as select from I_PMNotificationType as _NotificationType

    association[0..*] to I_GenericPriority as _PMGenericPriority on _PMGenericPriority.GenericPriorityType = _NotificationType.MaintPriorityType    
                                                                                     {
                                                                                    
       key _NotificationType.NotificationType,
       
       @ObjectModel.text.element: ['MaintPriorityDesc']
       key _PMGenericPriority.PriorityCode as MaintPriority,
       
       _NotificationType.MaintPriorityType ,
       
       cast (_PMGenericPriority.GenericPriorityColorCode as maintprioritycolorcode) as MaintPriorityColorCode,
     
        @Semantics.text: true
       _PMGenericPriority._GenericPriorityText[ 1: Language = $session.system_language ].GenericPriorityDesc as MaintPriorityDesc,
      
     
       @UI.hidden: true
       _PMGenericPriority

}

Learn More