I_CUSTOMERCONTACT

CDS View
28 Fields 8 CDS Views

CustomerContact

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

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 (28)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerCompany BusinessPartnerCompany 5
KEY BusinessPartnerPerson BusinessPartner2,BusinessPartnerPerson 6
KEY CustomerContact ContactPerson,CustomerContact 2
KEY RelationshipNumber RelationshipNumber 3
_BusinessPartnerCompany _BusinessPartnerCompany 1
_BusinessPartnerPerson _BusinessPartnerPerson 1
_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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- CustomerContact
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTOMERCONTACT (
    BUSINESSPARTNERCOMPANY,
    BUSINESSPARTNERPERSON,
    CUSTOMERCONTACT,
    RELATIONSHIPNUMBER,
    _BUSINESSPARTNERCOMPANY,
    _BUSINESSPARTNERPERSON,
    _CONTACTPERSONDEPARTMENT,
    BUSINESSPARTNERNAME,
    CONTACTPERSONDEPARTMENT,
    CONTACTPERSONFUNCTION,
    EMAILADDRESS,
    FAXCOUNTRY,
    FAXNUMBER,
    FAXNUMBEREXTENSION,
    FIRSTNAME,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    ISSTANDARDRELATIONSHIP,
    LASTNAME,
    MOBILEPHONECOUNTRY,
    MOBILEPHONENUMBER,
    MOBILEPHONENUMBEREXTENSION,
    PARTNERUUID,
    PERSONUUID,
    PHONENUMBER,
    PHONENUMBERCOUNTRY,
    PHONENUMBEREXTENSION,
    PRIMARY KEY (BUSINESSPARTNERCOMPANY, BUSINESSPARTNERPERSON, CUSTOMERCONTACT, RELATIONSHIPNUMBER)
);

Learn More