What is C_BusinessPartnerContact in SAP S/4HANA?

C_BusinessPartnerContact is a consumption CDS view in SAP S/4HANA. Consumption BusinessPartner Contact It contains 48 fields.

Which tables does C_BusinessPartnerContact read from?

C_BusinessPartnerContact reads data from: I_BusinessPartnerContactTP.

What VDM layer is C_BusinessPartnerContact?

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

C_BusinessPartnerContact

DDL: C_BUSINESSPARTNERCONTACT SQL: CBUPACONTACT Type: view CONSUMPTION

48 Fields 1 Data Sources 9 Associations

Consumption BusinessPartner Contact

C_BusinessPartnerContact is a Consumption CDS View that provides data about "Consumption BusinessPartner Contact" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerContactTP) and exposes 48 fields with key fields BusinessPartner, BusinessPartnerPerson, RelationshipNumber, ValidityEndDate. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BusinessPartnerContactTP	BusinessPartnerContact	from

Associations (9)

Cardinality	Target	Alias	Condition
[1..1]	C_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[1..1]	C_BusinessPartnerSupplier	_BusinessPartnerSupplier	`$projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner`
[1..1]	C_BusinessPartnerCustomer	_BusinessPartnerCustomer	`$projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner`
[0..*]	C_TitleTextVHTemp	_TitleText	`$projection.FormOfAddress = _TitleText.FormOfAddress`
[0..*]	C_TelCountryTextVHTemp	_PhoneNumberCountryText	`$projection.PhoneNumberCountry = _PhoneNumberCountryText.Country`
[0..*]	C_TelCountryTextVHTemp	_MobilePhoneCountryText	`$projection.PhoneNumberCountry = _MobilePhoneCountryText.Country`
[0..*]	C_TelCountryTextVHTemp	_FaxCountryText	`$projection.PhoneNumberCountry = _FaxCountryText.Country`
[0..*]	C_BPContactAddress	_BPContactAddress	`$projection.BusinessPartner = _BPContactAddress.BusinessPartner1 and $projection.BusinessPartnerPerson = _BPContactAddress.BusinessPartner2 and $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate`
[0..*]	C_BPLanguageTextValueHelp	_BPLanguageText	`$projection.CorrespondenceLanguage = _BPLanguageText.LanguageCode`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	CBUPACONTACT	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Consumption BusinessPartner Contact	view
Metadata.allowExtensions	true	view
ObjectModel.type	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
UI.headerInfo.typeName	Contact	view
UI.headerInfo.typeNamePlural	Contacts	view
UI.headerInfo.title.label	Contact Person Name	view
UI.headerInfo.title.value	FullName	view
VDM.viewType	#CONSUMPTION	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner	I_BusinessPartnerContactTP	BusinessPartner	Issuing Authority
KEY	BusinessPartnerPerson	I_BusinessPartnerContactTP	BusinessPartnerPerson	Busn. Partner
KEY	RelationshipNumber	I_BusinessPartnerContactTP	RelationshipNumber	BP Rel. Number
KEY	ValidityEndDate	I_BusinessPartnerContactTP	ValidityEndDate	ValidTo
	BusinessPartnerForEdit	I_BusinessPartnerContactTP	BusinessPartnerForEdit	Busn. Partner
	BusinessPartnerPersonForEdit	I_BusinessPartnerContactTP	BusinessPartnerPersonForEdit	Busn. Partner
	RelationshipNumberForEdit	I_BusinessPartnerContactTP	RelationshipNumberForEdit	BP Rel. Number
	ValidityEndDateForEdit	I_BusinessPartnerContactTP	ValidityEndDateForEdit	Valid To
	PersonUUID	I_BusinessPartnerContactTP	PersonUUID	BP GUID
	FormOfAddress	I_BusinessPartnerContactTP	FormOfAddress	Title Key
	FirstName	I_BusinessPartnerContactTP	FirstName	First Name
	LastName	I_BusinessPartnerContactTP	LastName	Last Name
	BirthDate	I_BusinessPartnerContactTP	BirthDate	Date of Birth
	CorrespondenceLanguage	I_BusinessPartnerContactTP	CorrespondenceLanguage	Language
	ValidityStartDate	I_BusinessPartnerContactTP	ValidityStartDate	Validity Start Date
	PhoneNumberCountry	I_BusinessPartnerContactTP	PhoneNumberCountry
	PhoneNumber	I_BusinessPartnerContactTP	PhoneNumber	Telephone no.
	PhoneNumberExtension	I_BusinessPartnerContactTP	PhoneNumberExtension	Extension
	MobilePhoneCountry	I_BusinessPartnerContactTP	MobilePhoneCountry	Country/Region
	MobilePhoneNumber	I_BusinessPartnerContactTP	MobilePhoneNumber	Telephone
	FaxCountry	I_BusinessPartnerContactTP	FaxCountry	Country/Region
	FaxNumber	I_BusinessPartnerContactTP	FaxNumber	Fax Number
	FaxNumberExtension	I_BusinessPartnerContactTP	FaxNumberExtension	Extension
	EmailAddress	I_BusinessPartnerContactTP	EmailAddress	E-Mail Address
	ContactPersonFunction	I_BusinessPartnerContactTP	ContactPersonFunction	Function
	ContactPersonDepartment	I_BusinessPartnerContactTP	ContactPersonDepartment	Department
	Building	I_BusinessPartnerContactTP	Building	Building code
	Floor	I_BusinessPartnerContactTP	Floor	Floor
	RoomNumber	I_BusinessPartnerContactTP	RoomNumber	Room Number
	FullName	I_BusinessPartnerContactTP	FullName	Name
	BusinessPartnerCategory	I_BusinessPartnerContactTP	BusinessPartnerCategory	Partner Cat.
	ContactPersonVIPType	I_BusinessPartnerContactTP	ContactPersonVIPType	VIP
	ContactPersonAuthorityType	I_BusinessPartnerContactTP	ContactPersonAuthorityType	Authority
	ContactPersonRemarkText	I_BusinessPartnerContactTP	ContactPersonRemarkText	Note
	_BusinessPartnerSupplier		_BusinessPartnerSupplier
	_BusinessPartnerCustomer		_BusinessPartnerCustomer
	_BusinessPartner		_BusinessPartner
	_CntctPersnFuncValueHelp		_CntctPersnFuncValueHelp
	_CntctPersnDeptValueHelp		_CntctPersnDeptValueHelp
	_ContactPersonFunction		_ContactPersonFunction
	_TitleText		_TitleText
	_PhoneNumberCountryText		_PhoneNumberCountryText
	_MobilePhoneCountryText		_MobilePhoneCountryText
	_BPLanguageText		_BPLanguageText
	_FaxCountryText		_FaxCountryText
	_BPContactAddress		_BPContactAddress
	_BusinessPartnerCompany		_BusinessPartnerCompany
	_BusinessPartnerPerson		_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_BusinessPartnerContact.
-- 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: CBUPACONTACT

CREATE VIEW C_BusinessPartnerContact AS
SELECT
  BusinessPartnerContact.BusinessPartner AS BusinessPartner,
  BusinessPartnerContact.BusinessPartnerPerson AS BusinessPartnerPerson,
  BusinessPartnerContact.RelationshipNumber AS RelationshipNumber,
  BusinessPartnerContact.ValidityEndDate AS ValidityEndDate,
  BusinessPartnerContact.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerContact.BusinessPartnerPersonForEdit AS BusinessPartnerPersonForEdit,
  BusinessPartnerContact.RelationshipNumberForEdit AS RelationshipNumberForEdit,
  BusinessPartnerContact.ValidityEndDateForEdit AS ValidityEndDateForEdit,
  BusinessPartnerContact.PersonUUID AS PersonUUID,
  BusinessPartnerContact.FormOfAddress AS FormOfAddress,
  BusinessPartnerContact.FirstName AS FirstName,
  BusinessPartnerContact.LastName AS LastName,
  BusinessPartnerContact.BirthDate AS BirthDate,
  BusinessPartnerContact.CorrespondenceLanguage AS CorrespondenceLanguage,
  BusinessPartnerContact.ValidityStartDate AS ValidityStartDate,
  BusinessPartnerContact.PhoneNumberCountry AS PhoneNumberCountry,
  BusinessPartnerContact.PhoneNumber AS PhoneNumber,
  BusinessPartnerContact.PhoneNumberExtension AS PhoneNumberExtension,
  BusinessPartnerContact.MobilePhoneCountry AS MobilePhoneCountry,
  BusinessPartnerContact.MobilePhoneNumber AS MobilePhoneNumber,
  BusinessPartnerContact.FaxCountry AS FaxCountry,
  BusinessPartnerContact.FaxNumber AS FaxNumber,
  BusinessPartnerContact.FaxNumberExtension AS FaxNumberExtension,
  BusinessPartnerContact.EmailAddress AS EmailAddress,
  BusinessPartnerContact.ContactPersonFunction AS ContactPersonFunction,
  BusinessPartnerContact.ContactPersonDepartment AS ContactPersonDepartment,
  BusinessPartnerContact.Building AS Building,
  BusinessPartnerContact.Floor AS Floor,
  BusinessPartnerContact.RoomNumber AS RoomNumber,
  BusinessPartnerContact.FullName AS FullName,
  BusinessPartnerContact.BusinessPartnerCategory AS BusinessPartnerCategory,
  BusinessPartnerContact.ContactPersonVIPType AS ContactPersonVIPType,
  BusinessPartnerContact.ContactPersonAuthorityType AS ContactPersonAuthorityType,
  BusinessPartnerContact.ContactPersonRemarkText AS ContactPersonRemarkText
FROM I_BusinessPartnerContactTP AS BusinessPartnerContact
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON BusinessPartner = _BusinessPartnerSupplier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_TitleTextVHTemp AS _TitleText ON FormOfAddress = _TitleText.FormOfAddress  -- association [0..*]
LEFT OUTER JOIN C_TelCountryTextVHTemp AS _PhoneNumberCountryText ON PhoneNumberCountry = _PhoneNumberCountryText.Country  -- association [0..*]
LEFT OUTER JOIN C_TelCountryTextVHTemp AS _MobilePhoneCountryText ON PhoneNumberCountry = _MobilePhoneCountryText.Country  -- association [0..*]
LEFT OUTER JOIN C_TelCountryTextVHTemp AS _FaxCountryText ON PhoneNumberCountry = _FaxCountryText.Country  -- association [0..*]
LEFT OUTER JOIN C_BPContactAddress AS _BPContactAddress ON BusinessPartner = _BPContactAddress.BusinessPartner1 AND BusinessPartnerPerson = _BPContactAddress.BusinessPartner2 AND RelationshipNumber = _BPContactAddress.RelationshipNumber AND ValidityEndDate = _BPContactAddress.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN C_BPLanguageTextValueHelp AS _BPLanguageText ON CorrespondenceLanguage = _BPLanguageText.LanguageCode  -- association [0..*]
;

Depth:

C_BusinessPartnerContact view

I_BusinessPartnerContactTP view