In this post, I will try and describe everything you need to know about the SAP crmd_rout_grp_us 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_ROUT_GRP_US 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_ROUT_GRP_US....Right lets get started!
Object Name: CRMD_ROUT_GRP_US
Dictionary Type: Transparent table
Description: Usage Category for Routing Group for Business Routing
| 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 | ||||
| ROUTING_GRP_GUID | CRMT_ROUTING_GROUP_GUID | RAW | 16(0) | GUID for routing group for business routing | SYSUUID | CRM | ||||||
| ROUT_GRP_USAGE | CRMT_ROUTING_GROUP_USAGE | CHAR | 2(0) | Usage Category for Routing Group for Business Routing | CRM_ROUTING_USAGE | CRM | ||||||
| ROUT_GRP_USID | CRMT_ROUTING_GROUP_USID | CHAR | 32(0) | Routing group - Usage Object for Usage Cat. for BR | CRM_ROUTING_GROUP_ID | CRM | ||||||
| USAGE_VALID_TO | CRMT_ROUT_GROUP_USAGE_VALID_TO | DATS | 8(0) | Routing group - Usage Category Valid To for BR | DATUM | CRM | ||||||
| DUMMY_FIELD | CHAR64 | CHAR | 64(0) | Character field, length 64 | CHAR64 | CRM | ||||||
| CREATED_AT | CRMT_ROUTING_GROUP_CREATED_AT | DEC | 15(0) | Created at date for routing group for business routing | BCOS_TSTMP | CRM | ||||||
| CREATED_BY | CRMT_ROUTING_GROUP_CREATED_BY | CHAR | 12(0) | Created by user for routing group for business routing | UNAME | CRM | ||||||
| CHANGED_AT | CRMT_ROUTING_GROUP_CHANGED_AT | DEC | 15(0) | Changed at date for routing group for business routing | BCOS_TSTMP | CRM | ||||||
| CHANGED_BY | CRMT_ROUTING_GROUP_CHANGED_BY | CHAR | 12(0) | Last changed by user for routing group for business routing | UNAME | CRM | ||||||
| USAGE_VALID_FROM | CRMT_ROUT_GRP_USAGE_VALID_FROM | DATS | 8(0) | Routing group - Usage Category Valid To for BR | DATUM | CRM |