The CRMD_DHR_SERVICE table in SAP ERP or S/4HANA stores Service Tickets data. There are total 17 fields in CRMD_DHR_SERVICE table. The Service Tickets 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_DHR_SERVICE table. It is in Operative Reporting in CRM (CRM_REPORT) ABAP package and is part of the Reporting Framework (CRM-BTX-ANA-RFW) module.
SAP CRMD_DHR_SERVICE Table Fields
Following is the list of fields that are available in SAP CRMD_DHR_SERVICE table. The primary key fields of the table are CLIENT (Client), GUID (GUID of a CRM Order Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| ITEMS_INVALID | Logical Variable | CRMT_BOOLEAN | CHAR (1) | |
| CHANGED_AT | Changed On (Output in User Time Zone) | CRMT_CHANGED_AT_USR | DEC (15) | |
| OBJECT_ID | Transaction ID | CRMT_OBJECT_ID | CHAR (10) | |
| PRIORITY | Activity Priority | CRMT_PRIORITY | * | NUMC (1) |
| DESCRIPTION_UC | Transaction Description (Uppercase) | CRMT_PROCESS_DESCRIPTION_UC | CHAR (40) | |
| PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | * | CHAR (4) |
| STAT_OPEN | Transaction is Still Open | CRMT_STATUS_OPEN | CHAR (1) | |
| RESP_GROUP_RFW | Responsible Group | CRMT_RESPONSIBLE_GROUP | * | CHAR (10) |
| PERSON_RESP | Employee Responsible | CRMT_PERSON_RESP | * | CHAR (10) |
| CREATED_AT | Created On (Output in User Time Zone) | CRMT_CREATED_AT_USR | DEC (15) | |
| KATALOGART_SRV | Catalog | COMT_CATALOG | * | CHAR (2) |
| CODEGRUPPE_SRV | Code Group | CRM_QCODEGRP | * | CHAR (8) |
| CODE_SRV | Code | CRM_QCODE | * | CHAR (4) |
| STATUS | Object Status | CRM_J_STATUS | CHAR (5) | |
| EEW_R_SRVO_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) |
