C_CommMethVHTemp

DDL: C_COMMMETHVHTEMP SQL: CCOMMMETHVH Type: view CONSUMPTION

C_CommMethVHTemp is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (tsac) and exposes 2 fields with key field CommunicationMediumType.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
tsac tsac from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCOMMMETHVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey CommunicationMediumType view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CommunicationMediumType tsac comm_type
_Text _Text 
@AbapCatalog.sqlViewName: 'CCOMMMETHVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'CommunicationMediumType'
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER

define view C_CommMethVHTemp as select from tsac
  association[0..*] to C_CommMethTextVhTemp as _Text on $projection.CommunicationMediumType = _Text.CommunicationMediumType
{
    @ObjectModel.text.association: '_Text'
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH
    key tsac.comm_type as CommunicationMediumType,
    _Text   
}
where comm_type = 'INT' or 
      comm_type = 'LET' or 
      comm_type = 'PRT' or 
      comm_type = 'TEL'

Learn More