C_MaintPriorityWithPhaseVH

DDL: C_MAINTPRIORITYWITHPHASEVH SQL: CPMPRIOPHAVH Type: view CONSUMPTION

Priority with phase

C_MaintPriorityWithPhaseVH is a Consumption CDS View that provides data about "Priority with phase" in SAP S/4HANA. It reads from 2 data sources (C_MaintPriorityTypeWithPhaseVH, I_GenericPriority) and exposes 5 fields with key fields MaintPriorityType, MaintPriority. It has 1 association to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
C_MaintPriorityTypeWithPhaseVH C_MaintPriorityTypeWithPhaseVH inner
I_GenericPriority I_GenericPriority from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_MaintPriorityTypeWithPhaseVH _MaintPriorityType $projection.MaintPriorityType = _MaintPriorityType.MaintPriorityType

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CPMPRIOPHAVH view
EndUserText.label Priority with phase view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey MaintPriority view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
Consumption.ranked true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MaintPriorityType I_GenericPriority GenericPriorityType Priority Type
KEY MaintPriority I_GenericPriority PriorityCode
MaintPriorityTypeDesc _MaintPriorityType MaintPriorityTypeDesc Priority Type Text
_MaintPriorityType _MaintPriorityType
_GenericPriorityText I_GenericPriority _GenericPriorityText 
@AbapCatalog.sqlViewName: 'CPMPRIOPHAVH'
@EndUserText.label: 'Priority with phase'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@VDM.viewType:#CONSUMPTION 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED  
 
@ClientHandling.algorithm: #SESSION_VARIABLE   
@Metadata.ignorePropagatedAnnotations:true


@ObjectModel.usageType:{
    serviceQuality: #C,    
    sizeCategory: #S,
    dataClass: #CUSTOMIZING
}
@ObjectModel.representativeKey: 'MaintPriority'
@ObjectModel.dataCategory: #VALUE_HELP
@UI: {presentationVariant: [{ sortOrder: [{ by: 'MaintPriorityType', direction:  #ASC }] }] }

@Search.searchable: true
@Consumption.ranked: true

define view C_MaintPriorityWithPhaseVH as select from I_GenericPriority 
inner join C_MaintPriorityTypeWithPhaseVH on I_GenericPriority.GenericPriorityType = C_MaintPriorityTypeWithPhaseVH.MaintPriorityType
association [0..1] to C_MaintPriorityTypeWithPhaseVH as _MaintPriorityType on $projection.MaintPriorityType = _MaintPriorityType.MaintPriorityType
{
    
    @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }    
    @ObjectModel.foreignKey.association: '_MaintPriorityType'
    @EndUserText.label: 'Priority Type'
    @EndUserText.quickInfo: 'Priority Type' 
    key I_GenericPriority.GenericPriorityType as MaintPriorityType, 
    
    @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }  
    @ObjectModel.text.association: '_GenericPriorityText'
    @UI.textArrangement: #TEXT_FIRST
    key I_GenericPriority.PriorityCode as MaintPriority,
    
    @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 } 
    @EndUserText.label: 'Priority Type Text'
    @EndUserText.quickInfo: 'Priority Type Text'
    _MaintPriorityType.MaintPriorityTypeDesc as MaintPriorityTypeDesc,
    
    // Propagate association  

    _MaintPriorityType, 
    I_GenericPriority._GenericPriorityText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_MAINTPRIORITYTYPEWITHPHASEVH",
"I_GENERICPRIORITY"
],
"ASSOCIATED":
[
"C_MAINTPRIORITYTYPEWITHPHASEVH",
"I_GENERICPRIORITYTEXT"
],
"BASE":
[
"I_GENERICPRIORITY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More