P_Cfd_User_Name

DDL: P_CFD_USER SQL: P_CFD_USER Type: view

wrapper view for usr21

P_Cfd_User_Name is a CDS View that provides data about "wrapper view for usr21" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 1 field with key field name.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
usr21 usr21 from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_CFD_USER view
ClientDependent false view
EndUserText.label wrapper view for usr21 view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY name bname 
@AbapCatalog.sqlViewName: 'P_CFD_USER'
@ClientDependent: false
@EndUserText.label: 'wrapper view for usr21'
@AccessControl.authorizationCheck: #NOT_ALLOWED
// official IAM view I_User is not available in our system :(

define view P_Cfd_User_Name 
  as select from usr21 {
    key bname as name,
    case techdesc
      when '' then bname
      else techdesc
    end as description
} where mandt = $session.client 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR21"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More