SAP ABAP Table CRMC_SOC_ACCOUNT (Social Media User Accounts)

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	CRMC_SOC_ACCOUNT	Table Relationship Diagram
Short Description	Social Media User Accounts

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	CHANNEL_ID	☑	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code	SMI_CHNLDEF
3	ACCOUNT_CODE	☑	CRMT_SOC_ACC_CODE	CHAR4	CHAR	4	0	ID of Social Media User Account
4	IS_ACTIVE	☐	CRMT_SOC_ACCOUNT_IS_ACTIVE	BOOLE	CHAR	1	0	Social Media User Account is Active
5	MAIN_CATEGORY	☐	CRMT_SOC_MAIN_CATEGORY	CHAR10	CHAR	10	0	Assigned Main Category
6	LATEST_POST_INFO	☐	SMI_LASTPROCESSEDSOCIALPOST	SMI_LASTPROCESSEDSOCIALPOST	CHAR	50	0	Last Retrieved Social Post Details
7	LATEST_MSG_INFO	☐	SMI_LASTPROCESSEDSOCIALPOST	SMI_LASTPROCESSEDSOCIALPOST	CHAR	50	0	Last Retrieved Social Post Details
8	LATEST_COMMT_INFO	☐	SMI_LASTPROCESSEDSOCIALPOST	SMI_LASTPROCESSEDSOCIALPOST	CHAR	50	0	Last Retrieved Social Post Details

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_SOC_ACCOUNT	CHANNEL_ID	SMI_CHNLDEF	SOCIALMEDIACHANNEL	KEY	1	CN

History

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