SMI_USR_ACCOUNT - User Account
User Account information is stored in SAP table SMI_USR_ACCOUNT.
It is part of development package BS_SOMI_DATA_MODELS in software component CA-EPT-SMI. This development package consists of objects that can be grouped under "Datta Models for Social Media Intelligence".
It is part of development package BS_SOMI_DATA_MODELS in software component CA-EPT-SMI. This development package consists of objects that can be grouped under "Datta Models for Social Media Intelligence".
Fields for table SMI_USR_ACCOUNT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | * |
| DATAPROVIDERNAME | Data Provider Name | X | SMI_DATAPROVIDERNAME | CHAR | 20 | SMI_USR_PROFILE |
| USERIDINDATAPROVIDER | Social Media User ID in Data Provider | X | SMI_USERIDINDATAPROVIDER | CHAR | 160 | SMI_USR_PROFILE |
| USERIDSIGNATURE | Signature | SMI_USERIDSIG | CHAR | 1024 | ||
| SIGNATURETIMESTAMP_UTC | User Acct Signature Timestamp (UTC) | SMI_SIGNATURETIME | DEC | 11 | ||
| SOCIALMEDIACHANNEL | Social Media Channel Code | SMI_SOCIALMEDIACHANNEL | CHAR | 8 | ||
| ISUSERREGISTERED | Is the User Registered | SMI_ISUSERREGISTERED | CHAR | 2 | ||
| USERREGSTRDTIMESTAMP_UTC | User Registered Timestamp (UTC) | SMI_USERREGISTEREDTIME | DEC | 11 | ||
| ISUSERACCOUNTVERIFIED | Is User Account Verified | SMI_ACCOUNTVERIFIED | CHAR | 2 | ||
| USERACCNTVERIFIEDTIMESTAMP_UTC | User Acct Verified Timestamp (UTC) | SMI_USERACCOUNTVERIFIEDTIME | DEC | 11 | ||
| ISUSERACCNTACTIVE | Is User Account Active | SMI_ACCOUNTACTIVE | CHAR | 2 | ||
| ISUSERACCNTLOCKEDOUT | Is User Account Locked | SMI_ACCOUNTLOCKED | CHAR | 2 | ||
| INFLUENCERRANK | Influencer Rank | SMI_USER_INFLUENCERRANK | NUMC | 8 | ||
| LASTLOGINLOCATION_COUNTRYCODE | Country/Region Key | LAND1 | CHAR | 6 | * | |
| LASTLOGINLOCATION_STATE | State Name | SMI_STATE | CHAR | 100 | ||
| LASTLOGINLOCATION_CITY | Location | SMI_LOCATIONNAME | CHAR | 100 | ||
| LASTLOGINLOCATION_LATITUDE | User Latitude Measure | SMI_USER_LATITUDEMEASURE | D16D | 8 | ||
| LASTLOGINLOCATION_LONGITUDE | User Longitude Measure | SMI_USER_LONGITUDEMEASURE | D16D | 8 | ||
| OLDESTDATAUPDATEDTIMESTAMP_UTC | Oldest Update Timestamp (UTC) | SMI_OLDESTUPDATETIME | DEC | 11 | ||
| ACCOUNTCREATEDTIMESTAMP_UTC | User Account Created Timestamp (UTC) | SMI_ACCOUNTCREATEDTIME | DEC | 11 | ||
| REGISTRATIONSOURCE | User Registration Source | SMI_REGISTRATIONSOURCE | CHAR | 120 | ||
| .INCLUDE | SMI_S_USR_ACCOUNT_CI | 0 | ||||
| DUMMY_USR_ACCOUNT | Dummy Description | CHAR | 2 |