I_CUSTOMERCONTACT

CDS View

CustomerContact

I_CUSTOMERCONTACT is a CDS View in S/4HANA. CustomerContact. It contains 26 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 26 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_Customer360_Contactop view from CONSUMPTION Customer 360 Contact OP
C_Customer360ExternalContact view_entity from CONSUMPTION Customer 360 External Contact
C_CustomerContact_F2200 view from CONSUMPTION
C_Custprojcustomercontact view inner CONSUMPTION Customer contact details for Customer Projects
C_SalesDocumentContactPerson view inner CONSUMPTION Sales Doc w. Cust-Expd Price Cntct Persn
I_CollectionsCustomerContactVH view from COMPOSITE Collections Customer Contact VH
I_CustomerContactOP view from COMPOSITE View for Contacts for Customer Object Page
I_CustomerContactVH view inner COMPOSITE Customer Contact Value Help

Fields (26)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerCompany BusinessPartnerCompany 5
KEY BusinessPartnerPerson BusinessPartner2,BusinessPartnerPerson 6
KEY CustomerContact ContactPerson,CustomerContact 2
KEY RelationshipNumber RelationshipNumber 3
_ContactPersonDepartment _ContactPersonDepartment 1
BusinessPartnerName BusinessPartnerName,CustomerContact 2
ContactPersonDepartment ContactPersonDepartment 3
ContactPersonFunction ContactPersonFunction 3
EmailAddress EmailAddress 6
FaxCountry FaxCountry 1
FaxNumber FaxNumber 1
FaxNumberExtension FaxNumberExtension 1
FirstName FirstName 4
InternationalFaxNumber InternationalFaxNumber 2
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 5
InternationalPhoneNumber InternationalPhoneNumber 5
IsStandardRelationship IsStandardRelationship 1
LastName LastName 4
MobilePhoneCountry MobilePhoneCountry 1
MobilePhoneNumber MobilePhoneNumber 3
MobilePhoneNumberExtension MobilePhoneNumberExtension 1
PartnerUUID PartnerUUID 3
PersonUUID PersonUUID 1
PhoneNumber PhoneNumber 2
PhoneNumberCountry PhoneNumberCountry 1
PhoneNumberExtension PhoneNumberExtension 1 
@AbapCatalog.sqlViewName: 'ICUSTCONTACT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'CustomerContact'
@ObjectModel.representativeKey: 'CustomerContact'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view I_CustomerContact
  as select from I_BusinessPartnerContact as _BP
    join         I_BPCustomerContactLink  as _Link on  _BP.PartnerUUID = _Link.BusinessPartnerUUID
                                                   and _BP.PersonUUID  = _Link.PersonUUID
{
  key _Link.CustomerContact as CustomerContact,
      _BP.RelationshipNumber,
      _BP.BusinessPartnerCompany,
      _BP.BusinessPartnerPerson,
      _BP.FirstName,
      _BP.LastName,
      _BP.BusinessPartnerName,
      _BP.ContactPersonDepartment,
      _BP.ContactPersonFunction,
      _BP.InternationalPhoneNumber,
      _BP.PhoneNumberCountry,
      _BP.PhoneNumber,
      _BP.PhoneNumberExtension,
      _BP.InternationalMobilePhoneNumber,
      _BP.MobilePhoneCountry,
      _BP.MobilePhoneNumber,
      _BP.MobilePhoneNumberExtension,
      _BP.InternationalFaxNumber,
      _BP.FaxCountry,
      _BP.FaxNumber,
      _BP.FaxNumberExtension,
      _BP.EmailAddress,
      _BP.AuthorizationGroup,
      _BP.PartnerUUID,
      _BP.PersonUUID,
      _BP.IsStandardRelationship,
      _BP.AddressID, //required for _BP._StandardAddress association

      _BP.ValidityStartDate,
      _BP.ValidityEndDate,

      //Associations

      _BP._BusinessPartnerCompany,
      _BP._BusinessPartnerPerson,
      _BP._ContactPersonDepartment,
      _BP._ContactPersonFunction,
      _BP._StandardAddress //This will have the current default address of contact person.

                           //Consumer of the view should use this association to get the address fields

                           
}      
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERCONTACTLINK",
"I_BUSINESSPARTNERCONTACT"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_BUSINESSPARTNER",
"I_CONTACTPERSONDEPARTMENT",
"I_CONTACTPERSONFUNCTION"
],
"BASE":
[
"I_BUSINESSPARTNERCONTACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More