SMI_USR_IDENTITY

Transparent Table Application Table
44 Fields 12 CDS Views

User Identity

SMI_USR_IDENTITY is an SAP database table in S/4HANA. User Identity. It contains 44 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
I_Somi_Usr_Certification view inner BASIC Certification Information of User From Data Provider
I_Somi_Usr_Custom view inner BASIC Custom Information for user from Data Provider
I_Somi_Usr_Education view inner BASIC Education Information for User provided from Data Provider
I_Somi_Usr_Favorite view inner BASIC Favorites of user provided by Data Provider
I_Somi_Usr_Identity view from BASIC Idenitity of user provided by Data Provider
I_Somi_Usr_Likes view inner BASIC User Like Information from Data Provider
I_Somi_Usr_Patent view inner BASIC Patent Information of user from Data Provider
I_Somi_Usr_Phone view inner BASIC Phone Information of User Information from Data Provider
I_Somi_Usr_Profile view inner BASIC Profile Information of User from Data Provider
I_Somi_Usr_Publications view inner BASIC Publication Information of User from Data Provider
I_Somi_Usr_Skill view inner BASIC Skill of user from Data Provider
I_Somi_Usr_Workexp view inner BASIC Work Experience of User Information from Data Provider

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY dataprovidername smi_dataprovidername Data Provider Name
KEY useridindataprovider smi_useridindataprovider User ID DataPrvdr
KEY counter smi_counter Counter
socialmediachannel smi_socialmediachannel Channel Code
socialuser smi_socialuser Social User ID
isloginidentity smi_isloginidentity ISLOGINIDENTITY
nickname smi_nickname Nickname
isallowedforlogin smi_isallowedforlogin AllowedForLogin
isexpiredsession smi_isexpiredsession ISEXPIREDSESSION
lastlogintimestamp_utc smi_lastlogintimestamp Last Login Time
photourl smi_socialuserimageurl Image URL
thumbnailurl smi_thumbnailurl Thmbnl URL
firstname smi_fname First Name
lastname smi_lname Last Name
gender smi_gendercode Gender
age smi_age Age
birthday smi_birthday Birth Day
birthmonth smi_birthmonth Birth Month
birthyear smi_birthyear Birth Year
email smi_email E-mail
countrycode land1 Country/Reg.
state smi_state State Name
city smi_locationname Location
zip smi_zip Zip Code
profileurl smi_socialuserprofilelink Profile Link
proxiedemail smi_proxyemail Proxy Email
address smi_address Address
languages smi_lang Language
professionalheadline smi_professionalheadline Prof Headline
bio smi_bio User Bio
industry smi_industry Industry Name
specialities smi_specialities Prof Strnt
religion smi_religion Religion
politicalview smi_politicalview Political View
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
locale smi_locale Locale
isverified smi_isverified User Verfieid
usertimezone smi_timezone Time Zone

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 Identity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SMI_USR_IDENTITY (
    CLIENT,                  -- Client [mandt]
    DATAPROVIDERNAME,        -- Data Provider Name [smi_dataprovidername]
    USERIDINDATAPROVIDER,    -- User ID DataPrvdr [smi_useridindataprovider]
    COUNTER,                 -- Counter [smi_counter]
    SOCIALMEDIACHANNEL,      -- Channel Code [smi_socialmediachannel]
    SOCIALUSER,              -- Social User ID [smi_socialuser]
    ISLOGINIDENTITY,         -- ISLOGINIDENTITY [smi_isloginidentity]
    NICKNAME,                -- Nickname [smi_nickname]
    ISALLOWEDFORLOGIN,       -- AllowedForLogin [smi_isallowedforlogin]
    ISEXPIREDSESSION,        -- ISEXPIREDSESSION [smi_isexpiredsession]
    LASTLOGINTIMESTAMP_UTC,  -- Last Login Time [smi_lastlogintimestamp]
    PHOTOURL,                -- Image URL [smi_socialuserimageurl]
    THUMBNAILURL,            -- Thmbnl URL [smi_thumbnailurl]
    FIRSTNAME,               -- First Name [smi_fname]
    LASTNAME,                -- Last Name [smi_lname]
    GENDER,                  -- Gender [smi_gendercode]
    AGE,                     -- Age [smi_age]
    BIRTHDAY,                -- Birth Day [smi_birthday]
    BIRTHMONTH,              -- Birth Month [smi_birthmonth]
    BIRTHYEAR,               -- Birth Year [smi_birthyear]
    EMAIL,                   -- E-mail [smi_email]
    COUNTRYCODE,             -- Country/Reg. [land1]
    STATE,                   -- State Name [smi_state]
    CITY,                    -- Location [smi_locationname]
    ZIP,                     -- Zip Code [smi_zip]
    PROFILEURL,              -- Profile Link [smi_socialuserprofilelink]
    PROXIEDEMAIL,            -- Proxy Email [smi_proxyemail]
    ADDRESS,                 -- Address [smi_address]
    LANGUAGES,               -- Language [smi_lang]
    PROFESSIONALHEADLINE,    -- Prof Headline [smi_professionalheadline]
    BIO,                     -- User Bio [smi_bio]
    INDUSTRY,                -- Industry Name [smi_industry]
    SPECIALITIES,            -- Prof Strnt [smi_specialities]
    RELIGION,                -- Religion [smi_religion]
    POLITICALVIEW,           -- Political View [smi_politicalview]
    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]
    LOCALE,                  -- Locale [smi_locale]
    ISVERIFIED,              -- User Verfieid [smi_isverified]
    USERTIMEZONE,            -- Time Zone [smi_timezone]
    PRIMARY KEY (CLIENT, DATAPROVIDERNAME, USERIDINDATAPROVIDER, COUNTER)
);

Learn More