SAP SMI_USR_ACCOUNT table - User Account details in SAP

SAP SMI_USR_ACCOUNT table summary

Object Name: SMI_USR_ACCOUNT
Dictionary Type: Transparent table
Description: User Account

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

Details

SMI_USR_ACCOUNT-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_ACCOUNT-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_ACCOUNT-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_ACCOUNT-USERIDSIGNATURE table field - Signature ▼

Description: Signature
Field Name: USERIDSIGNATURE
Data Element: SMI_USERIDSIG
Data Type: CHAR
length (Dec): 512(0)
Check table:
Conversion Routine:
Domain Name: SMI_USERIDSIG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERIDSIGNATURE

SMI_USR_ACCOUNT-SIGNATURETIMESTAMP_UTC table field - User Acct Signature Timestamp (UTC) ▼

Description: User Acct Signature Timestamp (UTC)
Field Name: SIGNATURETIMESTAMP_UTC
Data Element: SMI_SIGNATURETIME
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 SIGNATURETIMESTAMP_UTC

SMI_USR_ACCOUNT-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_ACCOUNT-ISUSERREGISTERED table field - Is the User Registered ▼

Description: Is the User Registered
Field Name: ISUSERREGISTERED
Data Element: SMI_ISUSERREGISTERED
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 ISUSERREGISTERED

SMI_USR_ACCOUNT-USERREGSTRDTIMESTAMP_UTC table field - User Registered Timestamp (UTC) ▼

Description: User Registered Timestamp (UTC)
Field Name: USERREGSTRDTIMESTAMP_UTC
Data Element: SMI_USERREGISTEREDTIME
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 USERREGSTRDTIMESTAMP_UTC

SMI_USR_ACCOUNT-ISUSERACCOUNTVERIFIED table field - Is User Account Verified ▼

Description: Is User Account Verified
Field Name: ISUSERACCOUNTVERIFIED
Data Element: SMI_ACCOUNTVERIFIED
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 ISUSERACCOUNTVERIFIED

SMI_USR_ACCOUNT-USERACCNTVERIFIEDTIMESTAMP_UTC table field - User Acct Verified Timestamp (UTC) ▼

Description: User Acct Verified Timestamp (UTC)
Field Name: USERACCNTVERIFIEDTIMESTAMP_UTC
Data Element: SMI_USERACCOUNTVERIFIEDTIME
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 USERACCNTVERIFIEDTIMESTAMP_UTC

SMI_USR_ACCOUNT-ISUSERACCNTACTIVE table field - Is User Account Active ▼

Description: Is User Account Active
Field Name: ISUSERACCNTACTIVE
Data Element: SMI_ACCOUNTACTIVE
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 ISUSERACCNTACTIVE

SMI_USR_ACCOUNT-ISUSERACCNTLOCKEDOUT table field - Is User Account Locked ▼

Description: Is User Account Locked
Field Name: ISUSERACCNTLOCKEDOUT
Data Element: SMI_ACCOUNTLOCKED
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 ISUSERACCNTLOCKEDOUT

SMI_USR_ACCOUNT-INFLUENCERRANK table field - Influencer Rank ▼

Description: Influencer Rank
Field Name: INFLUENCERRANK
Data Element: SMI_USER_INFLUENCERRANK
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: SMI_USER_INFLUENCERRANK
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INFLUENCERRANK

SMI_USR_ACCOUNT-LASTLOGINLOCATION_COUNTRYCODE table field - Country/Region Key ▼

Description: Country/Region Key
Field Name: LASTLOGINLOCATION_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 LASTLOGINLOCATION_COUNTRYCODE

SMI_USR_ACCOUNT-LASTLOGINLOCATION_STATE table field - State Name ▼

Description: State Name
Field Name: LASTLOGINLOCATION_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 LASTLOGINLOCATION_STATE

SMI_USR_ACCOUNT-LASTLOGINLOCATION_CITY table field - Location ▼

Description: Location
Field Name: LASTLOGINLOCATION_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 LASTLOGINLOCATION_CITY

SMI_USR_ACCOUNT-LASTLOGINLOCATION_LATITUDE table field - User Latitude Measure ▼

Description: User Latitude Measure
Field Name: LASTLOGINLOCATION_LATITUDE
Data Element: SMI_USER_LATITUDEMEASURE
Data Type: D16D
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: SMI_MEASURE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTLOGINLOCATION_LATITUDE

SMI_USR_ACCOUNT-LASTLOGINLOCATION_LONGITUDE table field - User Longitude Measure ▼

Description: User Longitude Measure
Field Name: LASTLOGINLOCATION_LONGITUDE
Data Element: SMI_USER_LONGITUDEMEASURE
Data Type: D16D
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: SMI_MEASURE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTLOGINLOCATION_LONGITUDE

SMI_USR_ACCOUNT-OLDESTDATAUPDATEDTIMESTAMP_UTC table field - Oldest Update Timestamp (UTC) ▼

Description: Oldest Update Timestamp (UTC)
Field Name: OLDESTDATAUPDATEDTIMESTAMP_UTC
Data Element: SMI_OLDESTUPDATETIME
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 OLDESTDATAUPDATEDTIMESTAMP_UTC

SMI_USR_ACCOUNT-ACCOUNTCREATEDTIMESTAMP_UTC table field - User Account Created Timestamp (UTC) ▼

Description: User Account Created Timestamp (UTC)
Field Name: ACCOUNTCREATEDTIMESTAMP_UTC
Data Element: SMI_ACCOUNTCREATEDTIME
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 ACCOUNTCREATEDTIMESTAMP_UTC

SMI_USR_ACCOUNT-REGISTRATIONSOURCE table field - User Registration Source ▼

Description: User Registration Source
Field Name: REGISTRATIONSOURCE
Data Element: SMI_REGISTRATIONSOURCE
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: SMI_REGISTRATIONSOURCE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGISTRATIONSOURCE

SMI_USR_ACCOUNT-DUMMY_USR_ACCOUNT table field - Dummy Description ▼

Description: Dummy Description
Field Name: DUMMY_USR_ACCOUNT
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_ACCOUNT

View list of all SAP tables(S4H/ECC)

Select data from SAP table