USER_ADDRP

9 Fields 3 CDS Views

Generated Table for View

USER_ADDRP is an SAP database table in S/4HANA. Generated Table for View. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MasterDataChangeProcessUser view left_outer BASIC Master Data Change Process User
I_MDImportUser view left_outer BASIC Users of Import
V_Mmim_Ddl_Om_Or_Grmail view inner Output Management GR Mail

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bname XUBNAME User
KEY persnumber AD_PERSNUM Person Number
KEY date_from AD_DATE_FR From
KEY nation AD_NATION Address Version
name_first AD_NAMEFIR First Name
name_last AD_NAMELAS Last Name
name_text AD_NAMTEXT Full Name
identity_guid SUID_GUID Identity GUID

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USER_ADDRP (
    MANDT,          -- Client [MANDT]
    BNAME,          -- User [XUBNAME]
    PERSNUMBER,     -- Person Number [AD_PERSNUM]
    DATE_FROM,      -- From [AD_DATE_FR]
    NATION,         -- Address Version [AD_NATION]
    NAME_FIRST,     -- First Name [AD_NAMEFIR]
    NAME_LAST,      -- Last Name [AD_NAMELAS]
    NAME_TEXT,      -- Full Name [AD_NAMTEXT]
    IDENTITY_GUID,  -- Identity GUID [SUID_GUID]
    PRIMARY KEY (MANDT, BNAME, PERSNUMBER, DATE_FROM, NATION)
);

Learn More