In this post, I will try and describe everything you need to know about the SAP crmd_service_i table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_SERVICE_I what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_SERVICE_I....Right lets get started!
Object Name: CRMD_SERVICE_I
Dictionary Type: Transparent table
Description: Transaction Item - Service
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| SERVICE_I_INT | DUMMY | CHAR | 1(0) | Dummy function in length 1 | DUMMY | SAP | CRM | |||||
| DISPO_FLG | CRMT_SRV_DISPO_FLG | CHAR | 1(0) | Relevant for Resource Planning | FLAG | CRM | ||||||
| CONFIRM_RELEVANT | CRMT_CONFIRM_RELEVANT | CHAR | 1(0) | Relevant for Confirmation | CRM_BOOLEAN | CRM | ||||||
| INSPEC_RELEVANT | CRMT_INSPECTION_RELEVANT | CHAR | 1(0) | Relevant for Inspection | CRM_BOOLEAN | CRM | ||||||
| SRV_CONF_TIME | CRMT_SRV_CONF_DURATION | QUAN | 7(2) | Confirmed Duration | DAUER_5_2 | CRM | ||||||
| SRV_CONF_TUNIT | CRMT_SRV_CONF_TIME_UNIT | UNIT | 3(0) | T006 | Time Unit for Confirmed Duration | MEINS | H_T006_TIME_SRV | MSEHI | CRM | |||
| ASSIGNMENT_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| SERVICE_TYPE | CRMT_SERVICE_TYPE | CHAR | 4(0) | * | Service Type | CRMT_SERVICE_TYPE | CRM | |||||
| VALUATION_TYPE | CRMT_VALUATION_TYPE | CHAR | 6(0) | * | Valuation Type | CRMT_VALUATION_TYPE | CRM | |||||
| SRV_ESCAL | CRMT_SRV_ESCAL | CHAR | 10(0) | CRMD_ESCAL | Response Profile | CRM_SRV_ESCAL | CRM | |||||
| SRV_SERWI | CRMT_SRV_SERWI | CHAR | 10(0) | CRMD_SERWI | Service Profile | CRM_SRV_SERWI | CRM | |||||
| SRV_RULE_ID | SC_RULEID | CHAR | 25(0) | Internal Identification of Rules of Periodic Appointments | TEXT25 | CRM | ||||||
| WARRANTY | COMT_PRODUCT_GUID | RAW | 16(0) | Internal Unique ID of Product | SYSUUID | CRM | ||||||
| WARRANTY_ID | CRMT_WTY_PRODUCT_ID | CHAR | 40(0) | Warranty ID | COM_PRODUCT_ID | CRM_WTY_SHTEXT | PRODUCT_ID | CRM |