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. 10 CDS views read from this table.

CDS Views using this table (10)

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_F4 view_entity inner GAF Value Help for Users
SAIS_GAF_USER_LIST_X1 view_entity left_outer Audit Filter - User with filter (Helper)
SAIS_USER_F4 view_entity inner BC-SEC Value Help for Users
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 AddressType,idadtype 4
NAME_TEXTC bname_tx,full_name,FullName 8
smtp_addr EMail,mail,smtp_addr 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Adresse für alle Benutzer inc. BP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_USERADDRESS002 (
    CLASS,
    IDADTYPE,
    NAME_TEXTC,
    SMTP_ADDR
);