The CRMD_SERVICE_I table in SAP ERP or S/4HANA stores Transaction Item – Service data. There are total 27 fields in CRMD_SERVICE_I table. The Transaction Item – Service 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_SERVICE_I table. It is in CRM Service Order Item Data (CRM_SERVICE_I) ABAP package and is part of the Service Order (CRM-BTX-SVO) module.
SAP CRMD_SERVICE_I Table Fields
Following is the list of fields that are available in SAP CRMD_SERVICE_I 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) | |
| SERVICE_I_INT | Dummy function in length 1 | DUMMY | CHAR (1) | |
| DISPO_FLG | Relevant for Resource Planning | CRMT_SRV_DISPO_FLG | CHAR (1) | |
| CONFIRM_RELEVANT | Relevant for Confirmation | CRMT_CONFIRM_RELEVANT | CHAR (1) | |
| INSPEC_RELEVANT | Relevant for Inspection | CRMT_INSPECTION_RELEVANT | CHAR (1) | |
| SRV_CONF_TIME | Confirmed Duration | CRMT_SRV_CONF_DURATION | QUAN (7) | |
| SRV_CONF_TUNIT | Time Unit for Confirmed Duration | CRMT_SRV_CONF_TIME_UNIT | T006 | UNIT (3) |
| ASSIGNMENT_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| OVERTIME_CAT | Overtime Category | CATS_OVERTIME_CATEGORY | * | CHAR (4) |
| SERVICE_TYPE | Service Type | CRMT_SERVICE_TYPE | CRMC_SRV_TYPE | CHAR (4) |
| VALUATION_TYPE | Valuation Type | CRMT_VALUATION_TYPE | CRMC_VAL_TYPE | CHAR (6) |
| SRV_ESCAL | Response Profile | CRMT_SRV_ESCAL | CRMD_ESCAL | CHAR (10) |
| SRV_SERWI | Service Profile | CRMT_SRV_SERWI | CRMD_SERWI | CHAR (10) |
| SRV_RULE_ID | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR (25) | |
| SRCL_SERVICE_PROFILE | Processing Times: Service Profile | CRMT_SRCL_SRVPRF | * | CHAR (10) |
| SRCL_RESPONSE_PROFILE | Processing Time: Response Profile | CRMT_SRCL_RSPRF | * | CHAR (10) |
| SRV_ESCAL_CHANGED | Single-Character Flag | CHAR1 | CHAR (1) | |
| SRV_SERWI_CHANGED | Single-Character Flag | CHAR1 | CHAR (1) | |
| WARRANTY | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW (16) | |
| WARRANTY_ID | Master warranty number | MGANR | * | CHAR (20) |
| CMPL_ITM_IS_COMPLETE | Complaint Complete | CRMS4_COMP_COMPLETE | CHAR (1) | |
| CMPL_ITM_IS_ENT | Complaint Entitled | CRMS4_COMP_ENT | CHAR (1) | |
| CMPL_ITM_IS_ACC | Complaint Accepted | CRMS4_COMP_ACC | CHAR (1) | |
| CMPL_ITM_IS_FOC | Complaint Free Of Charge | CRMS4_COMP_FOC | CHAR (1) | |
| CMPL_ITM_IS_GOW | Complaint Goodwill | CRMS4_COMP_GOW | CHAR (1) | |
| SERVICE_I_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) |
