The CDBD_SERVICE_I table in SAP ERP or S/4HANA stores Business transaction item – service data. There are total 35 fields in CDBD_SERVICE_I table. The Business 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 CDBD_SERVICE_I table. It is in CRM Order: CDB Objects for General Sales Order Processing (CDB_ORDER) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CDBD_SERVICE_I Table Fields
Following is the list of fields that are available in SAP CDBD_SERVICE_I table. The primary key fields of Business transaction item – service table in SAP are CLIENT (Client), GUID (GUID of a CRM Order Object), SERVICE_I_GUID (Own guid for SERVICE_I table).
| 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_GUID | Own guid for SERVICE_I table | CDBT_SERVICE_I_GUID | RAW (16) | |
| ORDERADM_I_GUID | Order Item Guid | CDBT_ORDERADM_I_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) | |
| TR_USER | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_ID | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_STATUS | Undefined range (can be used for patch levels) | CHAR4 | CHAR (4) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| DELETED | Single-Character Flag | CHAR1 | CHAR (1) | |
| TR_ROOTID | Character field, length 32 | CHAR32 | CHAR (32) |
