SAP table UDM_CCT_ATTR (Customer Contact)

SAP table UDM_CCT_ATTR has 2 primary key fields being MANDT,CCT_GUID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
CCT_GUID Customer Contact Key CHAR 32 0 BDM_CCT_GUID
CUSTOMER Business Partner Number CHAR 10 0 BU_PARTNER
COLL_SEGMENT Collection Segment CHAR 10 0 UDM_COLL_SGMT UDM_COLL_SEGMENT
CCT_ID Contact ID NUMC 6 0 BDM_CCT_ID
COLL_SPECIALIST Collection Specialist CHAR 12 0 BDM_COLL_SPECIALIST
CONTACT_KEY Contact Person Key CHAR 10 0 BDM_CONTACT_KEY
CCT_NAME Name of Contact Person at Business Partner CHAR 40 0 UDM_CONTACT_NAME
CCT_EMAIL Email Address of Contact Person at Business Partner CHAR 128 0 UDM_CONTACT_EMAIL
CCT_PHONE Telephone Number of Contact Person at Business Partner CHAR 30 0 UDM_CONTACT_PHONE
CCT_FAX Fax Number of Contact Person at Business Partner CHAR 30 0 UDM_CONTACT_FAX
CCT_FAXC Country/Region of Fax Number CHAR 3 0 UDM_CONTACT_FAXC
CCT_DIRECTION Contact Direction CHAR 1 0 BDM_CCT_DIRECTION
I Inbound
O Outbound
CCT_TYPE Contact Type CHAR 3 0 UDM_CONTACTTYPE
CCT_RESULT Result of Customer Contact CHAR 3 0 UDM_CCT_RESULT_ID
XREACHED Customer Reached CHAR 1 0 BDM_XREACHED
CCT_TIME Time of Customer Contact DEC 15 0 UDM_CONTACT_TIME
CCT_DURATION Duration of Customer Contact NUMC 3 0 BDM_CCT_DURATION
CREATED_BY Created By CHAR 12 0 UDM_CREATED_BY
CREATED_AT Created On DEC 15 0 UDM_CREATED_ON
CHANGED_BY Last Changed By CHAR 12 0 UDM_CHANGED_BY
CHANGED_AT Last Changed On DEC 15 0 UDM_CHANGE_ON
WORKITEM_ID Key of Worklist Item RAW 16 0 UDM_WORKLIST_ITEM_GUID
CCT_ATTCH_COUNT Number of Linked Attachments NUMC 4 0 BDM_ATTCH_COUNT

UDM_CCT_ATTR foreign key relationships

Table Field Check Table Check Field
0 UDM_CCT_ATTR COLL_SEGMENT UDM_COLL_SGMT Collection Segment MANDT
0 UDM_CCT_ATTR COLL_SEGMENT UDM_COLL_SGMT Collection Segment COLL_SEGMENT