VFCLM_BAM_DDL_USERFULLNAME

DDL: FCLM_BAM_USERNAME SQL: VFCLMUSERNMVW Type: view

User full name view

VFCLM_BAM_DDL_USERFULLNAME is a CDS View that provides data about "User full name view" in SAP S/4HANA. It reads from 3 data sources (adrp, usr02, usr21) and exposes 4 fields.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
adrp adrp left_outer
usr02 usr02 from
usr21 usr21 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMUSERNMVW view
EndUserText.label User full name view view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (4)

KeyFieldSource TableSource FieldDescription
bname usr02 bname
name_first adrp name_first
name_last adrp name_last
name_text adrp name_text 
@AbapCatalog.sqlViewName: 'VFCLMUSERNMVW'
@EndUserText.label: 'User full name view'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
define view VFCLM_BAM_DDL_USERFULLNAME 
as select from usr02 inner join usr21 on usr02.bname = usr21.bname left outer join adrp on adrp.persnumber = usr21.persnumber {
  usr02.bname,
  adrp.name_first,
  adrp.name_last,
  adrp.name_text
  
} 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRP",
"USR02",
"USR21"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More