I_CustomerContacts

Customer Contacts | view: IMDCUSTCNTCTS | ATTR | Extraction: Not supported | Component: Business Partners
Tables used: ADCPADR3ADR6BUT000BUT052BUT000BUT051ADR2ADR2BUT050
Column Name Description
Customer FK Business Partner Number
CustomerContact FK Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsStandardRelationship Standard Relationship Show values
Column Name Description Domain name
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Function of partner
  • Client
  • Function of partner
  • I_CUSTOMERCONTACTS.MANDT == TB912.CLIENT
  • I_CUSTOMERCONTACTS.CONTACTPERSONFUNCTION == TB912.PAFKT
Business Partner Number
  • Business Partner Number
  • Client
  • I_CUSTOMERCONTACTS.CUSTOMER == BUT000.PARTNER
  • I_CUSTOMERCONTACTS.MANDT == BUT000.CLIENT
Business Partner Number
  • Client
  • Business Partner Number
  • I_CUSTOMERCONTACTS.MANDT == BUT000.CLIENT
  • I_CUSTOMERCONTACTS.CUSTOMERCONTACT == BUT000.PARTNER