In this post, I will try and describe everything you need to know about the SAP crmd_partner 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_PARTNER 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_PARTNER....Right lets get started!
Object Name: CRMD_PARTNER
Dictionary Type: Transparent table
Description: Partners
| 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 | |||||
| PARTNER_GUID | CRMT_PARTNER_GUID | RAW | 16(0) | GUID for an Individual Partner | SYSUUID | |||||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
| COMPRESSED | CRMT_PARTNER_COMPRESSED | CHAR | 1(0) | Partner has Dependent, Compressed Records | CRM_BOOLEAN | |||||||
| ATTRIBUTES | CRMT_PARTNER_ATTRIBUTES | CHAR | 1(0) | Partner has Dependent Attributes | CRM_BOOLEAN | |||||||
| KIND_OF_ENTRY | CRMT_PARTNER_KIND_OF_ENTRY | CHAR | 1(0) | Source of a partner in a transaction | CRM_PARTNER_KIND_OF_ENTRY | |||||||
| CUST_ATTR_DB | COMT_PARTNER_CUST_ATTRIBUTES | CHAR | 1(0) | Flag: Customizable Attributes Available for Partner | FLAG | |||||||
| CUST_REL_DB | COMT_PARTNER_CUST_RELATION | CHAR | 1(0) | Partner Relationship Available | FLAG | |||||||
| PARTNER_FCT | CRMT_PARTNER_FCT | CHAR | 8(0) | Partner func. | COM_PARTNER_FCT | |||||||
| PARTNER_NO | CRMT_PARTNER_NO | CHAR | 32(0) | Partner Number | CRM_PARTNER_NO | |||||||
| DISPLAY_TYPE | CRMT_PARTNER_DISPLAY_TYPE | CHAR | 2(0) | Object Type, for Which Partner Number is to be Shown | COMT_PARTNER_NO_TYPE | |||||||
| NO_TYPE | CRMT_PARTNER_NO_TYPE | CHAR | 2(0) | Partner Number Type (e.g. GUID, Pers. No., ...), Internal | COMT_PARTNER_NO_TYPE | |||||||
| MAINPARTNER | CRMT_PARTNER_MAIN | CHAR | 1(0) | Main Partner (For Ambiguous Partner Functions) | CRM_BOOLEAN | |||||||
| RELATION_PARTNER | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | |||||||
| ADDR_NR | AD_ADDRNUM | CHAR | 10(0) | * | Address number | AD_ADDRNUM | ADR | |||||
| ADDR_NP | AD_PERSNUM | CHAR | 10(0) | * | Person number | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | |||
| ADDR_TYPE | AD_ADRTYPE | CHAR | 1(0) | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | |||||||
| ADDR_ORIGIN | CRMT_ADDR_ORIGIN_MD | CHAR | 1(0) | Origin of a Partner Address | CRM_ADDR_ORIGIN_MD | |||||||
| STD_BP_ADDRESS | CRMT_PARTNER_STD_BP_ADDRESS | CHAR | 1(0) | Standard Business Partner Address (Depending on Addr.Type) | XFELD | |||||||
| ADDR_OPERATION | BU_OPERATION | CHAR | 6(0) | * | Transaction for BP Address Determination | BU_OPERATION | ||||||
| CALENDAR | CRMT_PARTNER_CALENDAR | CHAR | 1(0) | Maintain Calendar for the Partner? | CRM_BOOLEAN | |||||||
| DISABLED | CRMT_PARTNER_DISABLED | CHAR | 1(0) | No INBOX Selection for the Partner | CRM_BOOLEAN | |||||||
| ERROR_FLAG | XFELD | CHAR | 1(0) | Checkbox | XFELD | FB | ||||||
| PARTNER_SRC_SYS | COMT_PARTNER_SRC_SYS | CHAR | 10(0) | * | Logical System from Which Partner Originates | LOGSYS |