SAP ABAP Table VCRMD_SOC_POST (Change Document Structure; Generated by RSSCD000)

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	INTTAB	Structure
Structure	VCRMD_SOC_POST	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Social Media Post
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	UUID	☐	CRMT_SOC_DATA_UUID	SYSUUID	RAW	16	0	UUID of Social Media Post
4	EXTERNAL_UUID	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
5	INTERNAL_ID	☐	CRMT_SOC_POST_INTERNAL_ID	CRM_SOC_POST_INTERNAL_ID	CHAR	12	0	Internal ID of Social Media Post
6	CONTENT	☐	CRMT_SOC_DATA_CONTENT	STRING	STRG	0	0	Content of Social Media Post
7	TYPE	☐	CRMT_SOC_DATA_TYPE	CRM_SOC_DATA_TYPE	CHAR	1	0	Social Media Post Type
8	CHANNEL_ID	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code	SMI_CHNLDEF
9	CREATED_BY_UUID	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
10	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
11	MAIN_CATEGORY	☐	CRMT_SOC_MAIN_CATEGORY	CHAR10	CHAR	10	0	Assigned Main Category
12	SENTIMENT	☐	CRMT_SOC_DATA_SENTIMENT	CRM_SOC_DATA_SENTIMENT	CHAR	2	0	Sentiment of Social Media Post	*
13	PARENT_EXTERNAL_UUID	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
14	ROOT_EXTERNAL_UUID	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
15	SOCIAL_ACC_CODE	☐	CRMT_SOC_ACC_CODE	CHAR4	CHAR	4	0	ID of Social Media User Account
16	CREATION_DATE_TIME	☐	CRMT_SOC_DATA_CREATED	COM_TSTMP	DEC	15	0	Creation Date and Time of Social Media Post
17	PROCESSOR	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
18	REPLIED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
19	LANGUAGE	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
20	CREATED_BY_NAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
21	CONTENT_UC	☐	CRMT_SOC_DATA_CONTENT_UC	CHAR255	CHAR	255	0	Social data content upper case
22	CREATED_BY_NAME_UC	☐	CRMT_SOC_CREATED_BY_NAME_UC	CHAR255	CHAR	255	0	Created by name upper case
23	RECEIVER_USER_ACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
24	RECEIVER_USER_ID	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
25	RECEIVER_USER_ACCOUNT_UC	☐	CRMT_SOC_USER_ACCOUNT_UC	CHAR100	CHAR	100	0	Upper case of social user account
26	.INCLUDE	☐				0	0	Structures for generating change document update programs
27	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

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

History

Last changed by/on	SAP	20140117
SAP Release Created in