view_Kna1_name_p

DDL: CDS_KNA1_NAME_P SQL: CDS_KNA1_NAME_P Type: view

Display Name of Customer

view_Kna1_name_p is a CDS View that provides data about "Display Name of Customer" in SAP S/4HANA. It reads from 1 data source (kna1). It has 1 association to related views.

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
kna1 customer from

Parameters (1)

NameTypeDefault
p_language spras

Associations (1)

CardinalityTargetAliasCondition
[0..*] t005t country_names $projection.customer_land1 = country_names.land1

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CDS_KNA1_NAME_P view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Display Name of Customer view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view 
@AbapCatalog.sqlViewName:'CDS_KNA1_NAME_P'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Display Name of Customer'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view view_Kna1_name_p  with parameters p_language : spras
 as
 select from kna1 as customer
   association [0..*] to t005t as country_names on $projection.customer_land1 = country_names.land1
 { 
     key customer.kunnr as customer_account,
     customer.land1 as customer_land1,
     customer.begru as customer_begru,
     
     cast( concat_with_space( customer.name1, concat_with_space( customer.pstlz, concat_with_space( customer.ort01, coalesce( country_names[1: spras = $parameters.p_language].landx, country_names[1: spras = 'E'].landx), 1 ), 1), 1) as abap.char( 100 )) as customer_display_name
 
  }

Learn More