1. Home
  2. Resources
  3. SAP Tables
  4. CRMD_PARTNER - Partners

SAP Table CRMD_PARTNER

Partners

CRMD_PARTNER (Partners) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CRMD_PARTNER to other SAP tables.

Source: CRMD_PARTNER (Partners)

CRMD_PARTNER table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
PARTNER_GUID GUID for an Individual Partner CRMT_PARTNER_GUID RAW 16 0
GUID GUID of a CRM Order Object CRMT_OBJECT_GUID RAW 16 0
COMPRESSED Partner has Dependent, Compressed Records CRMT_PARTNER_COMPRESSED CHAR 1 0
NULL Incorrect
X True
ATTRIBUTES Partner has Dependent Attributes CRMT_PARTNER_ATTRIBUTES CHAR 1 0
NULL Incorrect
X True
KIND_OF_ENTRY Source of a partner in a transaction CRMT_PARTNER_KIND_OF_ENTRY CHAR 1 0
NULL Unknown
A Automatic Determination
B Selected
C Entered Manually
CUST_ATTR_DB Flag: Customizable Attributes Available for Partner COMT_PARTNER_CUST_ATTRIBUTES CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
CUST_REL_DB Partner Relationship Available COMT_PARTNER_CUST_RELATION CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PARTNER_FCT Partner func. CRMT_PARTNER_FCT CHAR 8 0
PARTNER_NO Partner Number CRMT_PARTNER_NO CHAR 32 0
DISPLAY_TYPE Object Type, for Which Partner Number is to be Shown CRMT_PARTNER_DISPLAY_TYPE CHAR 2 0
NULL Business Partner GUID
BP Business Partner Number
CP Central Person
US System User (User Name)
O Org. Unit
HT Hierarchy Tree
HG Hierarchy Tree GUID
T Team
EX External Partner
HN Hierarchy Node (of a Business Partner Hierarchy)
NG Hierarchy Node GUID
NO_TYPE Partner Number Type (e.g. GUID, Pers. No., ...), Internal CRMT_PARTNER_NO_TYPE CHAR 2 0
NULL Business Partner GUID
BP Business Partner Number
CP Central Person
US System User (User Name)
O Org. Unit
HT Hierarchy Tree
HG Hierarchy Tree GUID
T Team
EX External Partner
HN Hierarchy Node (of a Business Partner Hierarchy)
NG Hierarchy Node GUID
MAINPARTNER Main Partner (For Ambiguous Partner Functions) CRMT_PARTNER_MAIN CHAR 1 0
NULL Incorrect
X True
RELATION_PARTNER Business Partner GUID BU_PARTNER_GUID RAW 16 0
ADDR_NR Address number AD_ADDRNUM CHAR 10 0
ADDR_NP Person number AD_PERSNUM CHAR 10 0
ADDR_TYPE Address type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPE CHAR 1 0
1 Organization, Company
2 Private address
3 Contact person (in company)
ADDR_ORIGIN Origin of a Partner Address CRMT_ADDR_ORIGIN_MD CHAR 1 0
STD_BP_ADDRESS Standard Business Partner Address (Depending on Addr.Type) CRMT_PARTNER_STD_BP_ADDRESS CHAR 1 0
X Yes
NULL No
ADDR_OPERATION Transaction for BP Address Determination BU_OPERATION CHAR 6 0
CALENDAR Maintain Calendar for the Partner? CRMT_PARTNER_CALENDAR CHAR 1 0
NULL Incorrect
X True
DISABLED No INBOX Selection for the Partner CRMT_PARTNER_DISABLED CHAR 1 0
NULL Incorrect
X True
ERROR_FLAG Checkbox XFELD CHAR 1 0
X Yes
NULL No
PARTNER_SRC_SYS Logical System from Which Partner Originates COMT_PARTNER_SRC_SYS CHAR 10 0