P_USERADDRESS002

CDS View

Adresse für alle Benutzer inc. BP

P_USERADDRESS002 is a CDS View in S/4HANA. Adresse für alle Benutzer inc. BP. It contains 4 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 4 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_ChangeDocUser view from BASIC Vor- und Nachname Benutzer
I_RSAU_UGROUP view left_outer Cross Client User Group Assignments
I_RSAU_USER_VH view inner Value Help for User in F4204(A)
SAIS_APP_STAT_GET_ALL view left_outer SAIS: Application Start Statistic - Simple
SAIS_APP_STAT_GET_INTV view left_outer SAIS: Application Start Statistic - Simple Intervals
SAIS_GAF_USER_LIST_X1 view_entity left_outer Audit Filter - User with filter (Helper)
SGBT_NTE_CDS_USERDETAILS view from CDS View für die Benutzerdetails
SUIM_AGR_WITH_TCD view left_outer SUIM - Get (assigned) roles with tcode

Fields (4)

KeyField CDS FieldsUsed in Views
class class 1
idadtype idadtype 1
NAME_TEXTC bname_tx,full_name 5
smtp_addr mail,smtp_addr 2 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PUSADDR002'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Adresse für alle Benutzer inc. BP'
define view P_UserAddress002
  as select from           P_UserAddress
{
  key mandt,
  key bname,
      _adrp.name_first,
      _adrp.name_last,
      _adrp.name_text as NAME_TEXTC,
      _adcp.tel_extens,
      kostl,
      _adcp.building,
      _adcp.roomnumber,
      _adcp.department,
      _adcp.ih_mail   as INHOUSE_ML,
      _adrc.name1,
      _adrc.city1,
      _adrc.post_code1,
      _adrp.mc_namefir,
      _adrp.mc_namelas,
      _adrc.mc_name1,
      _adrc.mc_city1,
      idadtype,
      _but000.partner as partner,
      _adr6.smtp_addr,
      class // Do not export usergroup!

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_USERADDRESS",
"ADCP",
"ADR6",
"ADRC",
"ADRP",
"BUT000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More