The CRMD_SOC_POST table in SAP ERP or S/4HANA stores Social Media Post data. There are total 24 fields in CRMD_SOC_POST table. The Social Media Post table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMD_SOC_POST table. It is in CRM Social Media (CRM_SOC) ABAP package and is part of the Social Media Cockpit in Interaction Center (CRM-IC-SMC) module.
SAP CRMD_SOC_POST Table Fields
Following is the list of fields that are available in SAP CRMD_SOC_POST table. The primary key fields of the table are CLIENT (Client), UUID (UUID of Social Media Post).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| UUID | UUID of Social Media Post | CRMT_SOC_DATA_UUID | RAW (16) | |
| EXTERNAL_UUID | Social Media Data ID String | SMI_SOCIALPOST | CHAR (50) | |
| INTERNAL_ID | Internal ID of Social Media Post | CRMT_SOC_POST_INTERNAL_ID | CHAR (12) | |
| CONTENT | Content of Social Media Post | CRMT_SOC_DATA_CONTENT | STRG () | |
| TYPE | Social Media Post Type | CRMT_SOC_DATA_TYPE | CHAR (1) | |
| CHANNEL_ID | Social Media Channel Code | SMI_SOCIALMEDIACHANNEL | SMI_CHNLDEF | CHAR (4) |
| CREATED_BY_UUID | Social Media User ID | SMI_SOCIALUSER | CHAR (50) | |
| STATUS | Object Status | CRM_J_STATUS | CHAR (5) | |
| MAIN_CATEGORY | Assigned Main Category | CRMT_SOC_MAIN_CATEGORY | CHAR (10) | |
| SENTIMENT | Sentiment of Social Media Post | CRMT_SOC_DATA_SENTIMENT | CHAR (2) | |
| PARENT_EXTERNAL_UUID | Social Media Data ID String | SMI_SOCIALPOST | CHAR (50) | |
| ROOT_EXTERNAL_UUID | Social Media Data ID String | SMI_SOCIALPOST | CHAR (50) | |
| SOCIAL_ACC_CODE | ID of Social Media User Account | CRMT_SOC_ACC_CODE | CHAR (4) | |
| CREATION_DATE_TIME | Creation Date and Time of Social Media Post | CRMT_SOC_DATA_CREATED | DEC (15) | |
| PROCESSOR | User Name in User Master Record | XUBNAME | CHAR (12) | |
| REPLIED_BY | User Name in User Master Record | XUBNAME | CHAR (12) | |
| LANGUAGE | 2-Character SAP Language Code | LAISO | CHAR (2) | |
| CREATED_BY_NAME | Social Media User Name | SMI_SOCIALUSERNAME | CHAR (255) | |
| CONTENT_UC | Social data content upper case | CRMT_SOC_DATA_CONTENT_UC | CHAR (255) | |
| CREATED_BY_NAME_UC | Created by name upper case | CRMT_SOC_CREATED_BY_NAME_UC | CHAR (255) | |
| RECEIVER_USER_ACCOUNT | Social Media User Account | SMI_SOCIALUSERACCOUNT | CHAR (100) | |
| RECEIVER_USER_ID | Social Media User ID | SMI_SOCIALUSER | CHAR (50) | |
| RECEIVER_USER_ACCOUNT_UC | Upper case of social user account | CRMT_SOC_USER_ACCOUNT_UC | CHAR (100) |
