I_CustomerContact

DDL: I_CUSTOMERCONTACT SQL: ICUSTCONTACT Type: view COMPOSITE Package: VDM_MD_COMMON
34 Fields 1 Data Sources

CustomerContact

I_CustomerContact is a Composite CDS View that provides data about "CustomerContact" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerContact) and exposes 34 fields with key field CustomerContact. Part of development package VDM_MD_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerContact _BP from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTCONTACT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label CustomerContact view
ObjectModel.representativeKey CustomerContact view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CustomerContact _Link CustomerContact
RelationshipNumber I_BusinessPartnerContact RelationshipNumber BP Rel. Number
BusinessPartnerCompany I_BusinessPartnerContact BusinessPartnerCompany Busn. Partner
BusinessPartnerPerson I_BusinessPartnerContact BusinessPartnerPerson Busn. Partner
FirstName I_BusinessPartnerContact FirstName First Name
LastName I_BusinessPartnerContact LastName Last Name
BusinessPartnerName I_BusinessPartnerContact BusinessPartnerName Extracted Customer Name
ContactPersonDepartment I_BusinessPartnerContact ContactPersonDepartment Department
ContactPersonFunction I_BusinessPartnerContact ContactPersonFunction Function
InternationalPhoneNumber I_BusinessPartnerContact InternationalPhoneNumber Telephone no.
PhoneNumberCountry I_BusinessPartnerContact PhoneNumberCountry
PhoneNumber I_BusinessPartnerContact PhoneNumber Telephone no.
PhoneNumberExtension I_BusinessPartnerContact PhoneNumberExtension Extension
InternationalMobilePhoneNumber I_BusinessPartnerContact InternationalMobilePhoneNumber
MobilePhoneCountry I_BusinessPartnerContact MobilePhoneCountry Country/Region
MobilePhoneNumber I_BusinessPartnerContact MobilePhoneNumber Telephone
MobilePhoneNumberExtension I_BusinessPartnerContact MobilePhoneNumberExtension
InternationalFaxNumber I_BusinessPartnerContact InternationalFaxNumber Fax Number
FaxCountry I_BusinessPartnerContact FaxCountry Country/Region
FaxNumber I_BusinessPartnerContact FaxNumber Fax Number
FaxNumberExtension I_BusinessPartnerContact FaxNumberExtension Extension
EmailAddress I_BusinessPartnerContact EmailAddress E-Mail Address
AuthorizationGroup I_BusinessPartnerContact AuthorizationGroup AuthorizGroup
PartnerUUID I_BusinessPartnerContact PartnerUUID
PersonUUID I_BusinessPartnerContact PersonUUID BP GUID
IsStandardRelationship I_BusinessPartnerContact IsStandardRelationship Standard
AddressID I_BusinessPartnerContact AddressID Ship-to address
ValidityStartDate I_BusinessPartnerContact ValidityStartDate Validity Start Date
ValidityEndDate I_BusinessPartnerContact ValidityEndDate ValidTo
_BusinessPartnerCompany I_BusinessPartnerContact _BusinessPartnerCompany
_BusinessPartnerPerson I_BusinessPartnerContact _BusinessPartnerPerson
_ContactPersonDepartment I_BusinessPartnerContact _ContactPersonDepartment
_ContactPersonFunction I_BusinessPartnerContact _ContactPersonFunction
_StandardAddress I_BusinessPartnerContact _StandardAddress

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CustomerContact.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICUSTCONTACT

CREATE VIEW I_CustomerContact AS
SELECT
  _Link.CustomerContact AS CustomerContact,
  _BP.RelationshipNumber AS RelationshipNumber,
  _BP.BusinessPartnerCompany AS BusinessPartnerCompany,
  _BP.BusinessPartnerPerson AS BusinessPartnerPerson,
  _BP.FirstName AS FirstName,
  _BP.LastName AS LastName,
  _BP.BusinessPartnerName AS BusinessPartnerName,
  _BP.ContactPersonDepartment AS ContactPersonDepartment,
  _BP.ContactPersonFunction AS ContactPersonFunction,
  _BP.InternationalPhoneNumber AS InternationalPhoneNumber,
  _BP.PhoneNumberCountry AS PhoneNumberCountry,
  _BP.PhoneNumber AS PhoneNumber,
  _BP.PhoneNumberExtension AS PhoneNumberExtension,
  _BP.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  _BP.MobilePhoneCountry AS MobilePhoneCountry,
  _BP.MobilePhoneNumber AS MobilePhoneNumber,
  _BP.MobilePhoneNumberExtension AS MobilePhoneNumberExtension,
  _BP.InternationalFaxNumber AS InternationalFaxNumber,
  _BP.FaxCountry AS FaxCountry,
  _BP.FaxNumber AS FaxNumber,
  _BP.FaxNumberExtension AS FaxNumberExtension,
  _BP.EmailAddress AS EmailAddress,
  _BP.AuthorizationGroup AS AuthorizationGroup,
  _BP.PartnerUUID AS PartnerUUID,
  _BP.PersonUUID AS PersonUUID,
  _BP.IsStandardRelationship AS IsStandardRelationship,
  _BP.AddressID AS AddressID,
  _BP.ValidityStartDate AS ValidityStartDate,
  _BP.ValidityEndDate AS ValidityEndDate,
  _BP._BusinessPartnerCompany AS _BusinessPartnerCompany,
  _BP._BusinessPartnerPerson AS _BusinessPartnerPerson,
  _BP._ContactPersonDepartment AS _ContactPersonDepartment,
  _BP._ContactPersonFunction AS _ContactPersonFunction,
  _BP._StandardAddress AS _StandardAddress
FROM I_BusinessPartnerContact AS _BP
;

Learn More