SAP SMI_USR_IDENTITY table - User Identity details in SAP


SAP SMI_USR_IDENTITY table summary

Object Name: SMI_USR_IDENTITY
Dictionary Type: Transparent table
Description: User Identity


Field list for SMI_USR_IDENTITY table on an S/4 SAP system

Details
SMI_USR_IDENTITY-CLIENT table field - Client

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

SMI_USR_IDENTITY-DATAPROVIDERNAME table field - Data Provider Name

Description: Data Provider Name
Field Name: DATAPROVIDERNAME
Data Element: SMI_DATAPROVIDERNAME
Data Type: CHAR
length (Dec): 10(0)
Check table: SMI_USR_PROFILE
Conversion Routine:
Domain Name: SMI_DATAPROVIDERNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATAPROVIDERNAME

SMI_USR_IDENTITY-USERIDINDATAPROVIDER table field - Social Media User ID in Data Provider

Description: Social Media User ID in Data Provider
Field Name: USERIDINDATAPROVIDER
Data Element: SMI_USERIDINDATAPROVIDER
Data Type: CHAR
length (Dec): 80(0)
Check table: SMI_USR_PROFILE
Conversion Routine:
Domain Name: SMI_USERIDINDATAPROVIDER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERIDINDATAPROVIDER

SMI_USR_IDENTITY-COUNTER table field - Counter

Description: Counter
Field Name: COUNTER
Data Element: SMI_COUNTER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTER

SMI_USR_IDENTITY-SOCIALMEDIACHANNEL table field - Social Media Channel Code

Description: Social Media Channel Code
Field Name: SOCIALMEDIACHANNEL
Data Element: SMI_SOCIALMEDIACHANNEL
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: SMI_UNIQUE_ID
MemoryID:
AppClass:
SHLP: SMI_SOCIALMEDIACHANNEL
SHLP Field: SOCIALMEDIACHANNEL
ConvExit:

See all SAP tables containing field SOCIALMEDIACHANNEL

SMI_USR_IDENTITY-SOCIALUSER table field - Social Media User ID

Description: Social Media User ID
Field Name: SOCIALUSER
Data Element: SMI_SOCIALUSER
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_USER
MemoryID:
AppClass:
SHLP: SMI_SOCIALUSER
SHLP Field: SOCIALUSER
ConvExit:

See all SAP tables containing field SOCIALUSER

SMI_USR_IDENTITY-ISLOGINIDENTITY table field - Login Identity

Description: Login Identity
Field Name: ISLOGINIDENTITY
Data Element: SMI_ISLOGINIDENTITY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOC_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISLOGINIDENTITY

SMI_USR_IDENTITY-NICKNAME table field - Nickname

Description: Nickname
Field Name: NICKNAME
Data Element: SMI_NICKNAME
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: SMI_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NICKNAME

SMI_USR_IDENTITY-ISALLOWEDFORLOGIN table field - Login Allowed

Description: Login Allowed
Field Name: ISALLOWEDFORLOGIN
Data Element: SMI_ISALLOWEDFORLOGIN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOC_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISALLOWEDFORLOGIN

SMI_USR_IDENTITY-ISEXPIREDSESSION table field - Session Expired

Description: Session Expired
Field Name: ISEXPIREDSESSION
Data Element: SMI_ISEXPIREDSESSION
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOC_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISEXPIREDSESSION

SMI_USR_IDENTITY-LASTLOGINTIMESTAMP_UTC table field - Last Login Timestamp

Description: Last Login Timestamp
Field Name: LASTLOGINTIMESTAMP_UTC
Data Element: SMI_LASTLOGINTIMESTAMP
Data Type: DEC
length (Dec): 21(7)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTLOGINTIMESTAMP_UTC

SMI_USR_IDENTITY-PHOTOURL table field - Social User Profile Image URL

Description: Social User Profile Image URL
Field Name: PHOTOURL
Data Element: SMI_SOCIALUSERIMAGEURL
Data Type: CHAR
length (Dec): 512(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOCIALUSERIMAGEURL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHOTOURL

SMI_USR_IDENTITY-THUMBNAILURL table field - Thumbnail URL

Description: Thumbnail URL
Field Name: THUMBNAILURL
Data Element: SMI_THUMBNAILURL
Data Type: CHAR
length (Dec): 512(0)
Check table:
Conversion Routine:
Domain Name: SMI_URL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field THUMBNAILURL

SMI_USR_IDENTITY-FIRSTNAME table field - First Name

Description: First Name
Field Name: FIRSTNAME
Data Element: SMI_FNAME
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: SMI_USERNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTNAME

SMI_USR_IDENTITY-LASTNAME table field - Last Name

Description: Last Name
Field Name: LASTNAME
Data Element: SMI_LNAME
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: SMI_USERNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTNAME

SMI_USR_IDENTITY-GENDER table field - Gender

Description: Gender
Field Name: GENDER
Data Element: SMI_GENDERCODE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SMI_GENDERCODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GENDER

SMI_USR_IDENTITY-AGE table field - Social Media User Age

Description: Social Media User Age
Field Name: AGE
Data Element: SMI_AGE
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: SMI_AGE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AGE

SMI_USR_IDENTITY-BIRTHDAY table field - Birth Day

Description: Birth Day
Field Name: BIRTHDAY
Data Element: SMI_BIRTHDAY
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: SMI_DAY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIRTHDAY

SMI_USR_IDENTITY-BIRTHMONTH table field - Birth Month

Description: Birth Month
Field Name: BIRTHMONTH
Data Element: SMI_BIRTHMONTH
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: SMI_MONTH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIRTHMONTH

SMI_USR_IDENTITY-BIRTHYEAR table field - Birth Year

Description: Birth Year
Field Name: BIRTHYEAR
Data Element: SMI_BIRTHYEAR
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: SMI_YEAR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIRTHYEAR

SMI_USR_IDENTITY-EMAIL table field - E-mail

Description: E-mail
Field Name: EMAIL
Data Element: SMI_EMAIL
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: SMI_EMAIL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMAIL

SMI_USR_IDENTITY-COUNTRYCODE table field - Country/Region Key

Description: Country/Region Key
Field Name: COUNTRYCODE
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRYCODE

SMI_USR_IDENTITY-STATE table field - State Name

Description: State Name
Field Name: STATE
Data Element: SMI_STATE
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_STATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATE

SMI_USR_IDENTITY-CITY table field - Location

Description: Location
Field Name: CITY
Data Element: SMI_LOCATIONNAME
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_LOCATIONNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITY

SMI_USR_IDENTITY-ZIP table field - Zip Code

Description: Zip Code
Field Name: ZIP
Data Element: SMI_ZIP
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SMI_ZIP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZIP

SMI_USR_IDENTITY-PROFILEURL table field - Link to User Profile in a Social Media Channel

Description: Link to User Profile in a Social Media Channel
Field Name: PROFILEURL
Data Element: SMI_SOCIALUSERPROFILELINK
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOCIALUSERPROFILELINK
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROFILEURL

SMI_USR_IDENTITY-PROXIEDEMAIL table field - Proxy E-mail

Description: Proxy E-mail
Field Name: PROXIEDEMAIL
Data Element: SMI_PROXYEMAIL
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: SMI_EMAIL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROXIEDEMAIL

SMI_USR_IDENTITY-ADDRESS table field - Social Media User Address

Description: Social Media User Address
Field Name: ADDRESS
Data Element: SMI_ADDRESS
Data Type: STRG
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name: SMI_ADDRESS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS

SMI_USR_IDENTITY-LANGUAGES table field - Languages Known

Description: Languages Known
Field Name: LANGUAGES
Data Element: SMI_LANG
Data Type: STRG
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name: SMI_LANG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LANGUAGES

SMI_USR_IDENTITY-PROFESSIONALHEADLINE table field - Professional Headline

Description: Professional Headline
Field Name: PROFESSIONALHEADLINE
Data Element: SMI_PROFESSIONALHEADLINE
Data Type: STRG
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name: SMI_PROFESSIONALHEADLINE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROFESSIONALHEADLINE

SMI_USR_IDENTITY-BIO table field - Social Media User Bio

Description: Social Media User Bio
Field Name: BIO
Data Element: SMI_BIO
Data Type: STRG
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name: SMI_BIO
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIO

SMI_USR_IDENTITY-INDUSTRY table field - Industry Name

Description: Industry Name
Field Name: INDUSTRY
Data Element: SMI_INDUSTRY
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: SMI_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDUSTRY

SMI_USR_IDENTITY-SPECIALITIES table field - Professional Strengths

Description: Professional Strengths
Field Name: SPECIALITIES
Data Element: SMI_SPECIALITIES
Data Type: STRG
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name: SMI_SPECIALITIES
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPECIALITIES

SMI_USR_IDENTITY-RELIGION table field - Religion

Description: Religion
Field Name: RELIGION
Data Element: SMI_RELIGION
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_RELIGION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELIGION

SMI_USR_IDENTITY-POLITICALVIEW table field - Political View

Description: Political View
Field Name: POLITICALVIEW
Data Element: SMI_POLITICALVIEW
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_POLITICALVIEW
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POLITICALVIEW

SMI_USR_IDENTITY-INTERESTEDIN table field - Interests

Description: Interests
Field Name: INTERESTEDIN
Data Element: SMI_INTERESTEDIN
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: SMI_INTERESTEDIN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INTERESTEDIN

SMI_USR_IDENTITY-RELATIONSHIPSTATUS table field - Relationship Status

Description: Relationship Status
Field Name: RELATIONSHIPSTATUS
Data Element: SMI_RELATIONSHIPSTATUS
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_RELATIONSHIPSTATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RELATIONSHIPSTATUS

SMI_USR_IDENTITY-HOMETOWN table field - Hometown

Description: Hometown
Field Name: HOMETOWN
Data Element: SMI_HOMETOWN
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_LOCATIONNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOMETOWN

SMI_USR_IDENTITY-FOLLOWERSCOUNT table field - Number of Followers

Description: Number of Followers
Field Name: FOLLOWERSCOUNT
Data Element: SMI_FOLLOWERSCOUNT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SMI_COUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FOLLOWERSCOUNT

SMI_USR_IDENTITY-FOLLOWINGCOUNT table field - Following Count

Description: Following Count
Field Name: FOLLOWINGCOUNT
Data Element: SMI_FOLLOWINGCOUNT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SMI_COUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FOLLOWINGCOUNT

SMI_USR_IDENTITY-USERNAME table field - Social Media User Name

Description: Social Media User Name
Field Name: USERNAME
Data Element: SMI_SOCIALUSERNAME
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: SMI_USERNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

SMI_USR_IDENTITY-LOCALE table field - Language Code

Description: Language Code
Field Name: LOCALE
Data Element: SMI_LOCALE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: SMI_LOCALE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCALE

SMI_USR_IDENTITY-ISVERIFIED table field - Is Account Verified

Description: Is Account Verified
Field Name: ISVERIFIED
Data Element: SMI_ISVERIFIED
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOC_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISVERIFIED

SMI_USR_IDENTITY-USERTIMEZONE table field - Time Zone

Description: Time Zone
Field Name: USERTIMEZONE
Data Element: SMI_TIMEZONE
Data Type: CHAR
length (Dec): 6(0)
Check table: *
Conversion Routine:
Domain Name: TZNZONE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERTIMEZONE

SMI_USR_IDENTITY-DUMMY_USR_IDENTITY table field - Dummy Description

Description: Dummy Description
Field Name: DUMMY_USR_IDENTITY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUMMY_USR_IDENTITY


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table