CRMD_SOC_POST - Social Media Post

Social Media Post information is stored in SAP table CRMD_SOC_POST.
It is part of development package CRM_SOC in software component CRM-IC-SMC. This development package consists of objects that can be grouped under "CRM Social Media".

Fields for table CRMD_SOC_POST

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
UUID	UUID of Social Media Post	X	CRMT_SOC_DATA_UUID	RAW	16
EXTERNAL_UUID	Social Media Data ID String		SMI_SOCIALPOST	CHAR	100
INTERNAL_ID	Internal ID of Social Media Post		CRMT_SOC_POST_INTERNAL_ID	CHAR	24
CONTENT	Content of Social Media Post		CRMT_SOC_DATA_CONTENT	STRG	8
TYPE	Social Media Post Type		CRMT_SOC_DATA_TYPE	CHAR	2
CHANNEL_ID	Social Media Channel Code		SMI_SOCIALMEDIACHANNEL	CHAR	8	SMI_CHNLDEF
CREATED_BY_UUID	Social Media User ID		SMI_SOCIALUSER	CHAR	100
STATUS	Object Status		CRM_J_STATUS	CHAR	10
MAIN_CATEGORY	Assigned Main Category		CRMT_SOC_MAIN_CATEGORY	CHAR	20
SENTIMENT	Sentiment of Social Media Post		CRMT_SOC_DATA_SENTIMENT	CHAR	4
PARENT_EXTERNAL_UUID	Social Media Data ID String		SMI_SOCIALPOST	CHAR	100
ROOT_EXTERNAL_UUID	Social Media Data ID String		SMI_SOCIALPOST	CHAR	100
SOCIAL_ACC_CODE	ID of Social Media User Account		CRMT_SOC_ACC_CODE	CHAR	8
CREATION_DATE_TIME	Creation Date and Time of Social Media Post		CRMT_SOC_DATA_CREATED	DEC	8
PROCESSOR	User Name in User Master Record		XUBNAME	CHAR	24
REPLIED_BY	User Name in User Master Record		XUBNAME	CHAR	24
LANGUAGE	2-Character SAP Language Code		LAISO	CHAR	4
CREATED_BY_NAME	Social Media User Name		SMI_SOCIALUSERNAME	CHAR	510
CONTENT_UC	Social data content upper case		CRMT_SOC_DATA_CONTENT_UC	CHAR	510
CREATED_BY_NAME_UC	Created by name upper case		CRMT_SOC_CREATED_BY_NAME_UC	CHAR	510
RECEIVER_USER_ACCOUNT	Social Media User Account		SMI_SOCIALUSERACCOUNT	CHAR	200
RECEIVER_USER_ID	Social Media User ID		SMI_SOCIALUSER	CHAR	100
RECEIVER_USER_ACCOUNT_UC	Upper case of social user account		CRMT_SOC_USER_ACCOUNT_UC	CHAR	200