SAP Table UDM_CCT_ATTR

Customer Contact

UDM_CCT_ATTR (Customer Contact) 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 UDM_CCT_ATTR to other SAP tables.

Source: UDM_CCT_ATTR (Customer Contact)

UDM_CCT_ATTR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CCT_GUID Customer Contact Key BDM_CCT_GUID CHAR 32 0
CUSTOMER Business Partner Number BU_PARTNER CHAR 10 0
COLL_SEGMENT Collection Segment BDM_COLL_SEGMENT UDM_COLL_SGMT CHAR 10 0
CCT_ID Contact ID BDM_CCT_ID NUMC 6 0
COLL_SPECIALIST Collection Specialist BDM_COLL_SPECIALIST CHAR 12 0
CONTACT_KEY Contact Person Key BDM_CONTACT_KEY CHAR 10 0
CCT_NAME Name of Contact Person BDM_CONTACT_NAME CHAR 40 0
CCT_EMAIL e-mail Address of Contact Person BDM_CONTACT_EMAIL CHAR 128 0
CCT_PHONE Contact Person: Telephone Number BDM_CONTACT_PHONE CHAR 30 0
CCT_FAX Fax Number of Contact Person BDM_CONTACT_FAX CHAR 30 0
CCT_FAXC Country of Fax Number BDM_CONTACT_FAXC CHAR 3 0
CCT_DIRECTION Contact Direction BDM_CCT_DIRECTION CHAR 1 0
I Inbound
O Outbound
CCT_TYPE Contact Type BDM_CCT_TYPE CHAR 3 0
CCT_RESULT Result of Customer Contact BDM_CCT_RESULT CHAR 3 0
XREACHED Customer Reached BDM_XREACHED CHAR 1 0
X TRUE
NULL FALSE
CCT_TIME Time of Customer Contact BDM_CCT_TIME DEC 15 0
CCT_DURATION Duration of Customer Contact BDM_CCT_DURATION NUMC 3 0
CREATED_BY Created By SCMG_CREATE_USER CHAR 12 0
CREATED_AT Created On SCMG_CREATE_TIME DEC 15 0
CHANGED_BY Last Changed by SCMG_CHANGE_USER CHAR 12 0
CHANGED_AT Last Changed On SCMG_CHANGE_TIME DEC 15 0
WORKITEM_ID Key of Worklist Item UDM_WORKLIST_ITEM_GUID RAW 16 0
CCT_ATTCH_COUNT Number of Linked Attachments BDM_ATTCH_COUNT NUMC 4 0

UDM_CCT_ATTR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
UDM_CCT_ATTR COLL_SEGMENT UDM_CCT_ATTR MANDT UDM_COLL_SGMT Collection Segment MANDT
UDM_CCT_ATTR COLL_SEGMENT UDM_CCT_ATTR COLL_SEGMENT UDM_COLL_SGMT Collection Segment COLL_SEGMENT