SAP ABAP Table CRMD_SOC_POST (Social Media Post)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-SMC (Application Component) Social Media Cockpit in Interaction Center
     ⤷ CRM_SOC (Package) CRM Social Media

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_SOC_POST	Table Relationship Diagram
Short Description	Social Media Post

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	UUID	☑	CRMT_SOC_DATA_UUID	SYSUUID	RAW	16	0	UUID of Social Media Post
3	EXTERNAL_UUID	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
4	INTERNAL_ID	☐	CRMT_SOC_POST_INTERNAL_ID	CRM_SOC_POST_INTERNAL_ID	CHAR	12	0	Internal ID of Social Media Post
5	CONTENT	☐	CRMT_SOC_DATA_CONTENT	STRING	STRG	0	0	Content of Social Media Post
6	TYPE	☐	CRMT_SOC_DATA_TYPE	CRM_SOC_DATA_TYPE	CHAR	1	0	Social Media Post Type
7	CHANNEL_ID	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code	SMI_CHNLDEF
8	CREATED_BY_UUID	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
9	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
10	MAIN_CATEGORY	☐	CRMT_SOC_MAIN_CATEGORY	CHAR10	CHAR	10	0	Assigned Main Category
11	SENTIMENT	☐	CRMT_SOC_DATA_SENTIMENT	CRM_SOC_DATA_SENTIMENT	CHAR	2	0	Sentiment of Social Media Post	*
12	PARENT_EXTERNAL_UUID	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
13	ROOT_EXTERNAL_UUID	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
14	SOCIAL_ACC_CODE	☐	CRMT_SOC_ACC_CODE	CHAR4	CHAR	4	0	ID of Social Media User Account
15	CREATION_DATE_TIME	☐	CRMT_SOC_DATA_CREATED	COM_TSTMP	DEC	15	0	Creation Date and Time of Social Media Post
16	PROCESSOR	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
17	REPLIED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
18	LANGUAGE	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
19	CREATED_BY_NAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
20	CONTENT_UC	☐	CRMT_SOC_DATA_CONTENT_UC	CHAR255	CHAR	255	0	Social data content upper case
21	CREATED_BY_NAME_UC	☐	CRMT_SOC_CREATED_BY_NAME_UC	CHAR255	CHAR	255	0	Created by name upper case
22	RECEIVER_USER_ACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
23	RECEIVER_USER_ID	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
24	RECEIVER_USER_ACCOUNT_UC	☐	CRMT_SOC_USER_ACCOUNT_UC	CHAR100	CHAR	100	0	Upper case of social user account

Foreign Keys

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

History

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