In this post, I will try and describe everything you need to know about the SAP crmd_cl_om 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_CL_OM 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_CL_OM....Right lets get started!
Object Name: CRMD_CL_OM
Dictionary Type: Transparent table
Description: Table for Org. Structure to MSA
| 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 | CDB_CL_OM_GUID_ORGOBJ | RAW | 16(0) | Object GUID | SYSUUID | CRM | ||||||
| OTYPE | OTYPE | CHAR | 2(0) | * | Object Type | OTYPE | POT | PP | CRM | |||
| OBJID | REALO | CHAR | 45(0) | Extended Object ID | CHAR45 | PP | CRM | |||||
| GUID_BP | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| OBJID_PARENT | REALO | CHAR | 45(0) | Extended Object ID | CHAR45 | PP | CRM | |||||
| GUID_PARENT | CDB_CL_OM_GUID_ORGOBJ | RAW | 16(0) | Object GUID | SYSUUID | CRM | ||||||
| GUID_BP_PARENT | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| OTYPE_PARENT | OTYPE | CHAR | 2(0) | * | Object Type | OTYPE | POT | PP | CRM | |||
| UNAME | UNAME | CHAR | 12(0) | User Name | UNAME | SAP | CRM | |||||
| PERNR | PERNR_D | NUMC | 8(0) | Personnel Number | PERNR | PER | PB | CRM | ||||
| SHORT | SHORT_D | CHAR | 12(0) | Object Abbreviation | TEXT12 | PP | CRM | |||||
| STEXT | STEXT | CHAR | 40(0) | Object Name | TEXT40 | PP | CRM | |||||
| OBJID_LEAD_POS | CDB_CL_OM_OBJID_LEAD_POS | NUMC | 8(0) | * | Object ID for Executive Position | HROBJID | CRM | |||||
| GUID_LEAD_POS | CDB_CL_OM_GUID_LEAD_POS | RAW | 16(0) | GUID From Leading Position | SYSUUID | CRM |