SGBT_NTE_CDS_USERDETAILS

DDL: SGBT_NTE_CDS_USERDETAILS SQL: V_NTE_CDS_USERD Type: view Package: S_GBT_NTE

CDS View für die Benutzerdetails

SGBT_NTE_CDS_USERDETAILS is a CDS View that provides data about "CDS View für die Benutzerdetails" in SAP S/4HANA. It reads from 1 data source (P_UserAddress002) and exposes 5 fields with key field UserId. Part of development package S_GBT_NTE.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_UserAddress002 P_UserAddress002 from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName V_NTE_CDS_USERD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View für die Benutzerdetails view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UserId bname
FirstName name_first
LastName name_last
Name NAME_TEXTC
smtp_addr smtp_addr 
@AbapCatalog.sqlViewName: 'V_NTE_CDS_USERD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View für die Benutzerdetails'

define view SGBT_NTE_CDS_USERDETAILS as select from P_UserAddress002 {
  key bname as UserId,
  @Semantics:  { name.additionalName: true }
  name_first as FirstName,
  @Semantics:  { name.familyName: true }
  name_last as LastName,
  @Semantics:  { name.fullName: true }
  NAME_TEXTC as Name,
  @Semantics: { 
      eMail: {
        address: true, 
        type: [ #WORK ] 
      } 
  }
  smtp_addr
}

Learn More