SMI_USR_PROFILE

Transparent Table Application Table
39 Fields 1 CDS Views

User Profile

SMI_USR_PROFILE is an SAP database table in S/4HANA. User Profile. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Somi_Usr_Profile view from BASIC Profile Information of User from Data Provider

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY dataprovidername SMI_DATAPROVIDERNAME Data Provider Name
KEY useridindataprovider SMI_USERIDINDATAPROVIDER User ID DataPrvdr
firstname SMI_FNAME First Name
lastname SMI_LNAME Last Name
nickname SMI_NICKNAME Nickname
photourl SMI_SOCIALUSERIMAGEURL Image URL
profileurl SMI_SOCIALUSERPROFILELINK Profile Link
age SMI_AGE Age
gender SMI_GENDERCODE Gender
birthday SMI_BIRTHDAY Birth Day
birthmonth SMI_BIRTHMONTH Birth Month
birthyear SMI_BIRTHYEAR Birth Year
country LAND1 Country/Reg.
state SMI_STATE State Name
city SMI_LOCATIONNAME Location
address SMI_ADDRESS Address
bio SMI_BIO User Bio
thumbnailurl SMI_THUMBNAILURL Thmbnl URL
zip SMI_ZIP Zip Code
proxyemail SMI_PROXYEMAIL Proxy Email
language SMI_LANG Language
honors SMI_HONORS Honors
professionalheadline SMI_PROFESSIONALHEADLINE Prof Headline
industry SMI_INDUSTRY Industry Name
specialities SMI_SPECIALITIES Prof Strnt
religion SMI_RELIGION Religion
interestedin SMI_INTERESTEDIN Interests
relationshipstatus SMI_RELATIONSHIPSTATUS Relship Status
hometown SMI_HOMETOWN Hometown
followerscount SMI_FOLLOWERSCOUNT Followers
followingcount SMI_FOLLOWINGCOUNT Following Count
username SMI_SOCIALUSERNAME Social User Name
name SMI_SOCIALUSERNAME Social User Name
locale SMI_LOCALE Locale
isverified SMI_ISVERIFIED User Verfieid
usertimezone SMI_TIMEZONE Time Zone
educationlevel SMI_EDUCATIONLEVEL Edu
dummy_usr_profile abap.char

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.

-- User Profile
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SMI_USR_PROFILE (
    CLIENT,                -- Client [MANDT]
    DATAPROVIDERNAME,      -- Data Provider Name [SMI_DATAPROVIDERNAME]
    USERIDINDATAPROVIDER,  -- User ID DataPrvdr [SMI_USERIDINDATAPROVIDER]
    FIRSTNAME,             -- First Name [SMI_FNAME]
    LASTNAME,              -- Last Name [SMI_LNAME]
    NICKNAME,              -- Nickname [SMI_NICKNAME]
    PHOTOURL,              -- Image URL [SMI_SOCIALUSERIMAGEURL]
    PROFILEURL,            -- Profile Link [SMI_SOCIALUSERPROFILELINK]
    AGE,                   -- Age [SMI_AGE]
    GENDER,                -- Gender [SMI_GENDERCODE]
    BIRTHDAY,              -- Birth Day [SMI_BIRTHDAY]
    BIRTHMONTH,            -- Birth Month [SMI_BIRTHMONTH]
    BIRTHYEAR,             -- Birth Year [SMI_BIRTHYEAR]
    COUNTRY,               -- Country/Reg. [LAND1]
    STATE,                 -- State Name [SMI_STATE]
    CITY,                  -- Location [SMI_LOCATIONNAME]
    ADDRESS,               -- Address [SMI_ADDRESS]
    BIO,                   -- User Bio [SMI_BIO]
    THUMBNAILURL,          -- Thmbnl URL [SMI_THUMBNAILURL]
    ZIP,                   -- Zip Code [SMI_ZIP]
    PROXYEMAIL,            -- Proxy Email [SMI_PROXYEMAIL]
    LANGUAGE,              -- Language [SMI_LANG]
    HONORS,                -- Honors [SMI_HONORS]
    PROFESSIONALHEADLINE,  -- Prof Headline [SMI_PROFESSIONALHEADLINE]
    INDUSTRY,              -- Industry Name [SMI_INDUSTRY]
    SPECIALITIES,          -- Prof Strnt [SMI_SPECIALITIES]
    RELIGION,              -- Religion [SMI_RELIGION]
    INTERESTEDIN,          -- Interests [SMI_INTERESTEDIN]
    RELATIONSHIPSTATUS,    -- Relship Status [SMI_RELATIONSHIPSTATUS]
    HOMETOWN,              -- Hometown [SMI_HOMETOWN]
    FOLLOWERSCOUNT,        -- Followers [SMI_FOLLOWERSCOUNT]
    FOLLOWINGCOUNT,        -- Following Count [SMI_FOLLOWINGCOUNT]
    USERNAME,              -- Social User Name [SMI_SOCIALUSERNAME]
    NAME,                  -- Social User Name [SMI_SOCIALUSERNAME]
    LOCALE,                -- Locale [SMI_LOCALE]
    ISVERIFIED,            -- User Verfieid [SMI_ISVERIFIED]
    USERTIMEZONE,          -- Time Zone [SMI_TIMEZONE]
    EDUCATIONLEVEL,        -- Edu [SMI_EDUCATIONLEVEL]
    DUMMY_USR_PROFILE,     -- abap.char
    PRIMARY KEY (CLIENT, DATAPROVIDERNAME, USERIDINDATAPROVIDER)
);

Learn More