Which tables does view_lfa1_name_p use?

view_lfa1_name_p reads from 1 data source(s): lfa1.

view_lfa1_name_p

DDL: CDS_LFA1_NAME_P SQL: CDS_LFA1_NAME_P Type: view

Display Name of Supplier

view_lfa1_name_p is a CDS View that provides data about "Display Name of Supplier" in SAP S/4HANA. It reads from 1 data source (lfa1) and exposes 2 fields. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
lfa1	vendor	from

Parameters (1)

Name	Type	Default
p_language	spras

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	t005t	country_names	`$projection.vendor_land1 = country_names.land1`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CDS_LFA1_NAME_P	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Display Name of Supplier	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

Fields (2)

Key	Field	Source Table	Source Field	Description
	vendor_land1	lfa1	land1
	vendor_begru	lfa1	begru

@AbapCatalog.sqlViewName:'CDS_LFA1_NAME_P'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Display Name of Supplier'
@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_lfa1_name_p  with parameters p_language : spras
 as
 select from lfa1 as vendor
   association [0..*] to t005t as country_names on $projection.vendor_land1 = country_names.land1
 { 
     key vendor.lifnr as vendor_account,
     vendor.land1 as vendor_land1,
     vendor.begru as vendor_begru,
     
     cast( concat_with_space( vendor.name1, concat_with_space( vendor.pstlz, concat_with_space( vendor.ort01, coalesce( country_names[1: spras = $parameters.p_language].landx, country_names[1: spras = 'E'].landx), 1 ), 1), 1) as abap.char( 100 )) as vendor_display_name
         
  }
          
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LFA1",
"T005T"
],
"ASSOCIATED":
[
"T005T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

view_lfa1_name_p view

lfa1