P_Competitor

DDL: P_COMPETITOR SQL: P_Cmpetitor Type: view BASIC

P_Competitor is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 2 fields with key field CompetitorID.

Data Sources (1)

SourceAliasJoin Type
kna1 kna1 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName P_Cmpetitor view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.representativeKey CompetitorID view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CompetitorID kunnr
CustomerName name1
@AbapCatalog.sqlViewName: 'P_Cmpetitor'
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Vaule help for competitor'

@Search.searchable: true
@ObjectModel.representativeKey: 'CompetitorID'
define view P_Competitor as select from kna1

{
  @ObjectModel.text.element:  [ 'CustomerName' ]   
  key kunnr as CompetitorID,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #HIGH  
  @Semantics.text: true
  name1 as CustomerName
}