SAP Social Media Intelligence Foundation Tables
Are you looking for the right table related to SAP Social Media Intelligence Foundation Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Social Media Intelligence Foundation (CA-EPT-SMI) module.
Top 10 tables in Social Media Intelligence Foundation
| Table | Description |
|---|---|
| SMI_COUNTRYCNFG | Table to map Social Data country name with country code |
| SMI_DP_SITES | Site Details for Data Providers |
| SMI_ASRCHTERM | Search Terms with Associations |
| SMI_CHNLDEF_T | Social Media Channel Description |
| SMI_RTREVALMDE_T | Social Data Retreival Mode Description |
| SMI_GRPASSIGN | Social Media Group Assignment |
| SMI_CNSNTSOCLUSR | Consent Of Social User |
| SMI_PARAMS | Social Intelligence Parameters |
| SMI_DPDEF_T | Data Providers Description |
| SMI_DP_WHT_BLK | Configuration for linking Gigya and Whitelist Blacklist |
List of tables in Social Media Intelligence Foundation
| Table | Description |
|---|---|
| SMI_COUNTRYCNFG | Table to map Social Data country name with country code |
| SMI_DP_SITES | Site Details for Data Providers |
| SMI_ASRCHTERM | Search Terms with Associations |
| SMI_CHNLDEF_T | Social Media Channel Description |
| SMI_RTREVALMDE_T | Social Data Retreival Mode Description |
| SMI_GRPASSIGN | Social Media Group Assignment |
| SMI_CNSNTSOCLUSR | Consent Of Social User |
| SMI_PARAMS | Social Intelligence Parameters |
| SMI_DPDEF_T | Data Providers Description |
| SMI_DP_WHT_BLK | Configuration for linking Gigya and Whitelist Blacklist |
| SMI_CHNLSRCH | Social Media Channel Search |
| SMI_CHNLDEF_EXT | Social Media Channel Extension |
| SMI_DPCHNL | Permitted Channels for Data Provider |
| SMI_ROLE_SGASSGN | Role Search Group Assignment |
| SMI_RTREVALMDE | Social Data Retrieval Mode |
| SMI_ETYPES_E_ENT | List of Entitys to be excluded by Sententiment Assignment |
| SMI_SOCIAL_RNTM | Table to Store Temporary Runtime Data |
| SMI_ASRCHTERM_T | Search Term Association Description |
| SMI_LSTUPDTD_DTL | Gigya Last Updated Details |
| SMI_IMPLIEDCNSNT | Implied Consent |
| SMI_CHNLRSLT_T | Social Media Channel Result Details |
| SMI_CHNLSRCH_T | Social Media Channel Search Details |
| SMI_CHNLDEF | Social Media Channel Definition |
| SMI_SOCIALGRP | Social Media Group |
| SMI_SOCIALUSERS | Specific Social User Definition |
| SMI_CHNLRSLT | Social Media Channel Search Result |
| SMI_CONSENTCNFG | Configuration for Social Consent Management |
| SMI_OBJTYPID | Object Type Definition |
| SMI_ENTITY_TYPET | Entity Type Texts |
| SMI_RUNTIME_INFO | Key - Value Pairs to store Runtime Info |
| SMI_ENTITY_TYPES | List of Entity Types for Sentiment Analysis |
| SMI_DPDEF | Data Providers Definition |
| SMI_OBJTYPID_T | Object Type Description |
| SMI_SOCIALGRP_T | Social Media Group Details |
| SMI_USR_IDENTITY | User Identity |
| SMI_USERGRP | User Group Definition |
| SMI_USERGRP_T | Social User Group Description |
| SMI_SRCHTERM | Search Term Definition |
| SMI_SRCHTRM_SETG | Search Term Settings |
| SMI_USR_PHONE | User Phone Information |
| SMI_USR_ACCOUNT | User Account |
| SMI_SRCHGRP | Search Group |
| SOCIALDATA | Social Data Definition |
| SMI_SRCHFLTR | Search Filter Definition |
| SOCIALUSERINFO | Social User Info Definition |
| SMI_USRLIKE_POST | Posts liked by users |
| SMI_SRCHGRP_T | Search Group Description |
| SMI_USR_SGASSGN | User to Search Group Assignment |
| SMI_UG_SGASSGN | User Group to Search Group Assignment |
| SMI_USR_PATENT | User Patent Details |
| SMI_USR_PROFILE | User Profile |
| SMI_USER_RNTM | Userinfo Runtime Calculation |
| SMI_USR_LIKE | User Likes |
| SMI_USR_WORKEXP | Work Experience Table |
| SMI_SRCTRM_OBJTY | Object Type and Search Term Mapping |
| SMI_USR_SKILL | User Skill details |
| SMI_USR_CRTFCT | Certificate Table |
| SMI_SRCHTRM_LANG | Search Term Language |
| SMI_VOICE_CUST | Assignment of Sentiment to an Entity on Post Level |
| SMI_VOCLANG | Permitted Languages |
| SMI_USR_CUSTOM | Custom Data Table |
| SMI_SRCHQRY | Search Query Definition |
| SMI_USR_PBLCTN | Publication Table |
| SMI_USR_FAVORITE | User Favorites Information |
| SMI_USR_EDCTN | Education Table |
| SMI_USR_WHT_BLCK | Whitelisted and Blacklisted users |
| SMI_USR_UGASSGN | User to User Group Assignment |