SOCIALUSERINFO - Social User Info Definition
Social User Info Definition information is stored in SAP table SOCIALUSERINFO.
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 SOCIALUSERINFO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
CLIENT | Client | X | MANDT | CLNT | 6 | * |
SOCIALMEDIACHANNEL | Social Media Channel Code | X | SMI_SOCIALMEDIACHANNEL | CHAR | 8 | SMI_CHNLDEF |
SOCIALUSER | Social Media User ID | X | SMI_SOCIALUSER | CHAR | 100 | |
GIGYAUUID | Social Media User ID in Data Provider | SMI_USERIDINDATAPROVIDER | CHAR | 160 | ||
SOCIALUSERPROFILELINK | Link to User Profile in a Social Media Channel | SMI_SOCIALUSERPROFILELINK | CHAR | 510 | ||
SOCIALUSERACCOUNT | Social Media User Account | SMI_SOCIALUSERACCOUNT | CHAR | 200 | ||
GENDERCODE | Gender | SMI_GENDERCODE | CHAR | 2 | ||
NUMBEROFSOCIALUSERCONTACTS | Count of User Contacts in Social Media | SMI_NUMBEROFSOCIALUSERCONTACTS | INT4 | 4 | ||
SOCIALUSERINFLUENCESCOREVALUE | Influence Score | SMI_SOCLUSRINFLUENCESCOREVALUE | CHAR | 40 | ||
CREATIONDATETIME | Post Creation Timestamp | SMI_CREATIONDATETIME | CHAR | 100 | ||
LOCATIONNAME | Location | SMI_LOCATIONNAME | CHAR | 100 | ||
COUNTRYNAME | Country | SMI_COUNTRYNAME | CHAR | 100 | ||
SOCIALUSERNAME | Social Media User Name | SMI_SOCIALUSERNAME | CHAR | 510 | ||
SOCIALUSEREMAILADDRESS | Social Media User E-mail Address | SMI_SOCIALUSEREMAILADDRESS | CHAR | 510 | ||
SOCIALUSERNAME_UC | Social Media User Name in Upper Case | SMI_SOCIALUSERNAME_UC | CHAR | 510 | ||
CREATEDAT | Creation Date and Time in System (UTC Timestamp) | SMI_CREATEDAT | DEC | 8 | ||
ISUSERIDSURROGATE | Is Social Media User ID Surrogate | SMI_ISUSERIDSURROGATE | CHAR | 2 | ||
SOCIALUSERIMAGELINK | Social User Profile Image URL | SMI_SOCIALUSERIMAGEURL | CHAR | 1024 | ||
SOCIALUSERTYPE | Social User Type | SMI_SOCIALUSERTYPE | CHAR | 8 | ||
ISPSEUDOUSER | Is User a Pseudo User | SMI_ISPSEUDOUSER | CHAR | 2 | ||
.INCLUDE | CI_SMI_SOCIALUSERINFO | 0 |