SAP Table CRMD_PARTNER stores Partnersdata

  

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!


SAP CRMD_PARTNER dictionary attributes

Object Name: CRMD_PARTNER
Dictionary Type: Transparent table
Description: Partners


CRMD_PARTNER field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTEST
PARTNER_GUIDCRMT_PARTNER_GUIDRAW16(0) GUID for an Individual PartnerSYSUUID
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
COMPRESSEDCRMT_PARTNER_COMPRESSEDCHAR1(0) Partner has Dependent, Compressed RecordsCRM_BOOLEAN
ATTRIBUTESCRMT_PARTNER_ATTRIBUTESCHAR1(0) Partner has Dependent AttributesCRM_BOOLEAN
KIND_OF_ENTRYCRMT_PARTNER_KIND_OF_ENTRYCHAR1(0) Source of a partner in a transactionCRM_PARTNER_KIND_OF_ENTRY
CUST_ATTR_DBCOMT_PARTNER_CUST_ATTRIBUTESCHAR1(0) Flag: Customizable Attributes Available for PartnerFLAG
CUST_REL_DBCOMT_PARTNER_CUST_RELATIONCHAR1(0) Partner Relationship AvailableFLAG
PARTNER_FCTCRMT_PARTNER_FCTCHAR8(0) Partner func.COM_PARTNER_FCT
PARTNER_NOCRMT_PARTNER_NOCHAR32(0) Partner NumberCRM_PARTNER_NO
DISPLAY_TYPECRMT_PARTNER_DISPLAY_TYPECHAR2(0) Object Type, for Which Partner Number is to be ShownCOMT_PARTNER_NO_TYPE
NO_TYPECRMT_PARTNER_NO_TYPECHAR2(0) Partner Number Type (e.g. GUID, Pers. No., ...), InternalCOMT_PARTNER_NO_TYPE
MAINPARTNERCRMT_PARTNER_MAINCHAR1(0) Main Partner (For Ambiguous Partner Functions)CRM_BOOLEAN
RELATION_PARTNERBU_PARTNER_GUIDRAW16(0) Business Partner GUIDSYSUUID
ADDR_NRAD_ADDRNUMCHAR10(0) *Address numberAD_ADDRNUMADR
ADDR_NPAD_PERSNUMCHAR10(0) *Person numberAD_PERSNUMCDTADDRESSPERSNUMBER
ADDR_TYPEAD_ADRTYPECHAR1(0) Address type (1=Organization, 2=Person, 3=Contact person)AD_ADRTYPE
ADDR_ORIGINCRMT_ADDR_ORIGIN_MDCHAR1(0) Origin of a Partner AddressCRM_ADDR_ORIGIN_MD
STD_BP_ADDRESSCRMT_PARTNER_STD_BP_ADDRESSCHAR1(0) Standard Business Partner Address (Depending on Addr.Type)XFELD
ADDR_OPERATIONBU_OPERATIONCHAR6(0) *Transaction for BP Address DeterminationBU_OPERATION
CALENDARCRMT_PARTNER_CALENDARCHAR1(0) Maintain Calendar for the Partner?CRM_BOOLEAN
DISABLEDCRMT_PARTNER_DISABLEDCHAR1(0) No INBOX Selection for the PartnerCRM_BOOLEAN
ERROR_FLAGXFELDCHAR1(0) CheckboxXFELDFB
PARTNER_SRC_SYSCOMT_PARTNER_SRC_SYSCHAR10(0) *Logical System from Which Partner OriginatesLOGSYS