What is C_Customer360ExternalContact in SAP S/4HANA?

C_Customer360ExternalContact is a consumption CDS view in SAP S/4HANA. Customer 360 External Contact It contains 27 fields.

Which tables does C_Customer360ExternalContact read from?

C_Customer360ExternalContact reads data from: I_CustomerContact.

What VDM layer is C_Customer360ExternalContact?

C_Customer360ExternalContact is classified as a Consumption view optimized for specific business scenarios and reporting.

C_Customer360ExternalContact

DDL: C_CUSTOMER360EXTERNALCONTACT Type: view_entity CONSUMPTION

27 Fields 1 Data Sources

Customer 360 External Contact

C_Customer360ExternalContact is a Consumption CDS View that provides data about "Customer 360 External Contact" in SAP S/4HANA. It reads from 1 data source (I_CustomerContact) and exposes 27 fields with key fields Customer, BusinessPartnerCompany, BusinessPartnerPerson, ContactPerson.

Data Sources (1)

Source	Alias	Join Type
I_CustomerContact	CustomerContact	from

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Customer 360 External Contact	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view

Fields (27)

Key	Field	Source Table	Source Field	Description
KEY	Customer	_Customer	Customer	Sold-to Party
KEY	BusinessPartnerCompany	I_CustomerContact	BusinessPartnerCompany	Busn. Partner
KEY	BusinessPartnerPerson	I_CustomerContact	BusinessPartnerPerson	Busn. Partner
KEY	ContactPerson	I_CustomerContact	CustomerContact
	FirstName	I_CustomerContact	FirstName	First Name
	LastName	I_CustomerContact	LastName	Last Name
	BusinessPartnerFullName
	IsStandardRelationship	I_CustomerContact	IsStandardRelationship	Standard
	PartnerFunctionName
	InternationalPhoneNumber	I_CustomerContact	InternationalPhoneNumber	Telephone no.
	EmailAddress	I_CustomerContact	EmailAddress	E-Mail Address
	InternationalMobilePhoneNumber	I_CustomerContact	InternationalMobilePhoneNumber
	AuthorizationGroup	_Customer	AuthorizationGroup	AuthorizGroup
	CustomerAccountGroup	_Customer	CustomerAccountGroup	Account group
	DataControllerSet	_Customer	DataControllerSet	Data Ctrlr. Set
	DataController1	_Customer	DataController1	Data Controller
	DataController2	_Customer	DataController2	Data Controller
	DataController3	_Customer	DataController3	Data Controller
	DataController4	_Customer	DataController4	Data Controller
	DataController5	_Customer	DataController5	Data Controller
	DataController6	_Customer	DataController6	Data Controller
	DataController7	_Customer	DataController7	Data Controller
	DataController8	_Customer	DataController8	Data Controller
	DataController9	_Customer	DataController9	Data Controller
	DataController10	_Customer	DataController10	Data Controller
	_BusinessPartnerCompany	I_CustomerContact	_BusinessPartnerCompany
	_BusinessPartnerPerson	I_CustomerContact	_BusinessPartnerPerson

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 C_Customer360ExternalContact.
-- 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.

CREATE VIEW C_Customer360ExternalContact AS
SELECT
  _Customer.Customer AS Customer,
  CustomerContact.BusinessPartnerCompany AS BusinessPartnerCompany,
  CustomerContact.BusinessPartnerPerson AS BusinessPartnerPerson,
  CustomerContact.CustomerContact AS ContactPerson,
  CustomerContact.FirstName AS FirstName,
  CustomerContact.LastName AS LastName,
  concat_with_space(CustomerContact.FirstName, CustomerContact.LastName, 1) AS BusinessPartnerFullName,
  CustomerContact.IsStandardRelationship AS IsStandardRelationship,
  CustomerContact._ContactPersonFunction._Text[1: Language=$session.system_language ].ContactPersonFunctionName AS PartnerFunctionName,
  CustomerContact.InternationalPhoneNumber AS InternationalPhoneNumber,
  CustomerContact.EmailAddress AS EmailAddress,
  CustomerContact.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.DataControllerSet AS DataControllerSet,
  _Customer.DataController1 AS DataController1,
  _Customer.DataController2 AS DataController2,
  _Customer.DataController3 AS DataController3,
  _Customer.DataController4 AS DataController4,
  _Customer.DataController5 AS DataController5,
  _Customer.DataController6 AS DataController6,
  _Customer.DataController7 AS DataController7,
  _Customer.DataController8 AS DataController8,
  _Customer.DataController9 AS DataController9,
  _Customer.DataController10 AS DataController10,
  CustomerContact._BusinessPartnerCompany AS _BusinessPartnerCompany,
  CustomerContact._BusinessPartnerPerson AS _BusinessPartnerPerson
FROM I_CustomerContact AS CustomerContact
;

Depth:

C_Customer360ExternalContact view_entity

I_CustomerContact view