SMI_USR_IDENTITY

Transparent Table Application Table
45 Fields 12 CDS Views

User Identity

SMI_USR_IDENTITY is an SAP database table in S/4HANA. User Identity. It contains 45 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 (45)

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
dummy_usr_identity 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 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]
    DUMMY_USR_IDENTITY,      -- abap.char
    PRIMARY KEY (CLIENT, DATAPROVIDERNAME, USERIDINDATAPROVIDER, COUNTER)
);

Learn More