SAP ABAP Table CRMT_SMI_USER_SEARCH (Social Media User Search)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-DAT (Application Component) CRM Specific Business Partner Data
     ⤷ CRM_BUPA_BOL (Package) Interaction Layer for Business Partner (From 5.1)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_SMI_USER_SEARCH	Table Relationship Diagram
Short Description	Social Media User Search

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code	SMI_CHNLDEF
2	SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
3	SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
4	SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
5	SOCIALUSERNAME_UC	☐	SMI_SOCIALUSERNAME_UC	SMI_USERNAME_UC	CHAR	255	0	Social Media User Name in Upper Case
6	SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
7	SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_SMI_USER_SEARCH	SOCIALMEDIACHANNEL	SMI_CHNLDEF	SOCIALMEDIACHANNEL

History

Last changed by/on	SAP	20130604
SAP Release Created in	713