SOCIALUSERINFO SAP (Social User Info Definition) Table details

Dictionary Type: Table
Description: Social User Info Definition




ABAP Code to SELECT data from SOCIALUSERINFO
Related tables to SOCIALUSERINFO
Access table SOCIALUSERINFO




Table field list including key, data, relationships and ABAP select examples

SOCIALUSERINFO is a standard SAP Table which is used to store Social User Info Definition data and is available within R/3 SAP systems depending on the version and release level.

The SOCIALUSERINFO table consists of various fields, each holding specific information or linking keys about Social User Info Definition data available in SAP. These include SOCIALMEDIACHANNEL (Social Media Channel Code), SOCIALUSER (Social Media User ID), SOCIALUSERPROFILELINK (Link to User Profile in a Social Media Channel), SOCIALUSERACCOUNT (Social Media User Account).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SOCIALUSERINFO table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
SOCIALMEDIACHANNELSocial Media Channel Code SMI_SOCIALMEDIACHANNELCHAR4SMI_CHNLDEFSMI_UNIQUE_IDSMI_SOCIALMEDIACHANNEL
SOCIALUSERSocial Media User ID SMI_SOCIALUSERCHAR50SMI_USERSMI_SOCIALUSER
SOCIALUSERPROFILELINKLink to User Profile in a Social Media Channel SMI_SOCIALUSERPROFILELINKCHAR255SMI_SOCIALUSERPROFILELINK
SOCIALUSERACCOUNTSocial Media User Account SMI_SOCIALUSERACCOUNTCHAR100SMI_SOCIALUSERACCOUNT
GENDERCODEGender SMI_GENDERCODECHAR1SMI_GENDERCODE
NUMBEROFSOCIALUSERCONTACTSCount of User Contacts in Social Media SMI_NUMBEROFSOCIALUSERCONTACTSINT410SMI_COUNT
SOCIALUSERINFLUENCESCOREVALUEInfluence Score SMI_SOCLUSRINFLUENCESCOREVALUECHAR20SMI_SOCLUSRINFLUENCESCOREVALUE
CREATIONDATETIMEPost Creation Timestamp SMI_CREATIONDATETIMECHAR50SMI_DATETIME
LOCATIONNAMELocation SMI_LOCATIONNAMECHAR50SMI_LOCATIONNAME
COUNTRYNAMECountry SMI_COUNTRYNAMECHAR50SMI_COUNTRYNAME
SOCIALUSERNAMESocial Media User Name SMI_SOCIALUSERNAMECHAR255SMI_USERNAME
SOCIALUSEREMAILADDRESSSocial Media User E-mail Address SMI_SOCIALUSEREMAILADDRESSCHAR255SMI_SOCIALUSEREMAILADDRESS
SOCIALUSERNAME_UCSocial Media User Name in Upper Case SMI_SOCIALUSERNAME_UCCHAR255SMI_USERNAME_UC
CREATEDATCreation Date and Time in UTC Time Stamp (yyyymmddhhmmss) SMI_CREATEDATDEC15TSTPSBCOS_TSTMP
ISUSERIDSURROGATEIs Social Media User ID Surrogate SMI_ISUSERIDSURROGATECHAR1SMI_SOC_STATUS
SOCIALUSERIMAGELINKSocial User Profile Image URL SMI_SOCIALUSERIMAGEURLCHAR512SMI_SOCIALUSERIMAGEURL

Key field Non-key field



How do I retrieve data from SAP table SOCIALUSERINFO using ABAP code

The following ABAP code Example will allow you to do a basic selection on SOCIALUSERINFO to SELECT all data from the table
DATA: WA_SOCIALUSERINFO TYPE SOCIALUSERINFO.

SELECT SINGLE *
FROM SOCIALUSERINFO
INTO CORRESPONDING FIELDS OF WA_SOCIALUSERINFO
WHERE...

How to access SAP table SOCIALUSERINFO

Within an ECC or HANA version of SAP you can also view further information about SOCIALUSERINFO and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!