The CRMS4D_COMP_H table in SAP ERP or S/4HANA stores Header Table for Complaints data. There are total 36 fields in CRMS4D_COMP_H table. The Header Table for Complaints 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 CRMS4D_COMP_H table. It is in Complaints Business Object (CRMS4_COMPLAINT_BO) ABAP package and is part of the S4CRM: Complaints (CRM-S4-COM) module.
SAP CRMS4D_COMP_H Table Fields
Following is the list of fields that are available in SAP CRMS4D_COMP_H table. The primary key fields of the table are CLIENT (Client), OBJTYPE_H (Business Trans. Cat.), OBJECT_ID (Transaction ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| OBJTYPE_H | Business Trans. Cat. | CRMT_SUBOBJECT_CATEGORY_DB | CRMC_SUBOB_CAT | CHAR (10) |
| OBJECT_ID | Transaction ID | CRMT_OBJECT_ID_DB | CHAR (10) | |
| HEADER_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | * | CHAR (4) |
| DESCRIPTION_H | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR (40) | |
| DESCR_LANGUAGE | Language Key of Description | CRMT_PROCESS_DESCRIPTION_LANGU | * | LANG (1) |
| CREATED_AT_H | Created At | CRMS4_CREATED_AT | DEC (15) | |
| CREATED_BY_H | User that Created the Transaction | CRMT_CREATED_BY | CHAR (12) | |
| CHANGED_AT_H | Changed At | CRMS4_CHANGED_AT | DEC (15) | |
| CHANGED_BY_H | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR (12) | |
| BTX_CLASS | CRM Business Transaction Classification | CRMT_TRANSACTION_CLASSIFICATN | CHAR (1) | |
| AUTH_SCOPE | Authorization Scope | CRM_AUTH_SCOPE | * | NUMC (6) |
| ARCHIVING_FLAG | Indicator Whether the Business Transaction Can Be Archived | CRMT_ARCHIVING_FLAG | CHAR (1) | |
| OBJECT_ID_OK | Indicator That Transaction ID Is Correct | CRMT_OBJECT_ID_OK | CHAR (1) | |
| VERIFY_DATE | Time Period of Last Archiving Attempt | CRMT_VERIFY_DATE | DEC (15) | |
| SOLD_TO_PARTY | Sold-To Party | CRMT_SOLD_TO_PART | BUT000 | CHAR (10) |
| PERSON_RESP | Employee Responsible | CRMT_PERSON_RESP | BUT000 | CHAR (10) |
| CONTACT_PERSON | Customer Contact Person | CRMT_CONTACT_PERSON | BUT000 | CHAR (10) |
| REPORTER | Reporter | CRMS4_COMP_REPORTER | * | CHAR (10) |
| PRIORITY | Activity Priority | CRMT_PRIORITY | SCPRIO | NUMC (1) |
| SRV_CUST_END | Service Request Due Date | CRMS4_SRV_CUST_END_TSTMP | DEC (15) | |
| COMPLAINT_URGENCY | Complaint Urgency | CRMS4_COMP_URGENCY | CRMS4C_COMP_URG | NUMC (2) |
| COMPLAINT_PROC_START | Complaint Start of Processing | CRMS4_COMP_PROC_START | DEC (15) | |
| COMPLAINT_PROC_END | Complaint End of Processing | CRMS4_COMP_PROC_END | DEC (15) | |
| REQ_SOLUTION | Complaint Requested Solution | CRMS4_REQ_SOLUTION | CRMS4C_REQ_SOL | CHAR (4) |
| ISSUE_CAUSED_BY | Complaint Issue Caused By | CRMS4_COMP_ISS_CAU | CRMS4C_ISS_CAU | CHAR (4) |
| COMPLAINT_IMPACT | Complaint Impact | CRMS4_COMP_IMPACT | CRMS4C_IMPACT | CHAR (4) |
| COMPLAINT_REASON | Complaint Reason | CRMS4_COMP_REASON | CRMS4C_REASON | CHAR (4) |
| PO_NUMBER_SOLD | Sold-To Party’s External Reference Number | CRMT_PO_NUMBER_SOLD | CHAR (35) | |
| STAT_LIFECYCLE | Life Cycle Status | CRMS4_STAT_LIFECYCLE | CHAR (4) | |
| STAT_ERROR | Error Status | CRMS4_STAT_ERROR | CHAR (1) | |
| STAT_OPEN | Status “Open” | CRMS4_STAT_OPEN | CHAR (1) | |
| STAT_ARCHIVABLE | Archivable | CRMS4_STAT_ARCHIVABLE | CHAR (1) | |
| STAT_ARCHIVED | Archived | CRMS4_STAT_ARCHIVED | CHAR (1) | |
| COMP_H_DUMMY_PS | Single-Character Flag | CHAR1 | CHAR (1) |
