C_BusinessPartnerContact
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 | Field |
|---|---|---|---|
| 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 | |
| KEY | BusinessPartnerPerson | I_BusinessPartnerContactTP | BusinessPartnerPerson | |
| KEY | RelationshipNumber | I_BusinessPartnerContactTP | RelationshipNumber | |
| KEY | ValidityEndDate | I_BusinessPartnerContactTP | ValidityEndDate | |
| BusinessPartnerForEdit | I_BusinessPartnerContactTP | BusinessPartnerForEdit | ||
| BusinessPartnerPersonForEdit | I_BusinessPartnerContactTP | BusinessPartnerPersonForEdit | ||
| RelationshipNumberForEdit | I_BusinessPartnerContactTP | RelationshipNumberForEdit | ||
| ValidityEndDateForEdit | I_BusinessPartnerContactTP | ValidityEndDateForEdit | ||
| PersonUUID | I_BusinessPartnerContactTP | PersonUUID | ||
| FormOfAddress | I_BusinessPartnerContactTP | FormOfAddress | ||
| FirstName | I_BusinessPartnerContactTP | FirstName | ||
| LastName | I_BusinessPartnerContactTP | LastName | ||
| BirthDate | I_BusinessPartnerContactTP | BirthDate | ||
| CorrespondenceLanguage | I_BusinessPartnerContactTP | CorrespondenceLanguage | ||
| ValidityStartDate | I_BusinessPartnerContactTP | ValidityStartDate | ||
| PhoneNumberCountry | I_BusinessPartnerContactTP | PhoneNumberCountry | ||
| PhoneNumber | I_BusinessPartnerContactTP | PhoneNumber | ||
| PhoneNumberExtension | I_BusinessPartnerContactTP | PhoneNumberExtension | ||
| MobilePhoneCountry | I_BusinessPartnerContactTP | MobilePhoneCountry | ||
| MobilePhoneNumber | I_BusinessPartnerContactTP | MobilePhoneNumber | ||
| FaxCountry | I_BusinessPartnerContactTP | FaxCountry | ||
| FaxNumber | I_BusinessPartnerContactTP | FaxNumber | ||
| FaxNumberExtension | I_BusinessPartnerContactTP | FaxNumberExtension | ||
| EmailAddress | I_BusinessPartnerContactTP | EmailAddress | ||
| ContactPersonFunction | I_BusinessPartnerContactTP | ContactPersonFunction | ||
| ContactPersonDepartment | I_BusinessPartnerContactTP | ContactPersonDepartment | ||
| Building | I_BusinessPartnerContactTP | Building | ||
| Floor | I_BusinessPartnerContactTP | Floor | ||
| RoomNumber | I_BusinessPartnerContactTP | RoomNumber | ||
| FullName | I_BusinessPartnerContactTP | FullName | ||
| BusinessPartnerCategory | I_BusinessPartnerContactTP | BusinessPartnerCategory | ||
| ContactPersonVIPType | I_BusinessPartnerContactTP | ContactPersonVIPType | ||
| ContactPersonAuthorityType | I_BusinessPartnerContactTP | ContactPersonAuthorityType | ||
| ContactPersonRemarkText | I_BusinessPartnerContactTP | ContactPersonRemarkText | ||
| _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 |
@AbapCatalog.sqlViewName: 'CBUPACONTACT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Consumption BusinessPartner Contact'
@Metadata.allowExtensions: true
@ObjectModel.type: #CONSUMPTION
@ObjectModel: {
semanticKey: ['BusinessPartner', 'BusinessPartnerPersonForEdit', 'RelationshipNumber'],
createEnabled,
updateEnabled,
deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@UI.headerInfo:{
typeName: 'Contact',
typeNamePlural: 'Contacts',
title: { label:'Contact Person Name', value: 'FullName' }
}
@VDM.viewType: #CONSUMPTION
define view C_BusinessPartnerContact
as select from I_BusinessPartnerContactTP as BusinessPartnerContact
association [1..1] to C_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to C_BusinessPartnerSupplier as _BusinessPartnerSupplier on $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
association [0..*] to C_TitleTextVHTemp as _TitleText on $projection.FormOfAddress = _TitleText.FormOfAddress
association [0..*] to C_TelCountryTextVHTemp as _PhoneNumberCountryText on $projection.PhoneNumberCountry = _PhoneNumberCountryText.Country
association [0..*] to C_TelCountryTextVHTemp as _MobilePhoneCountryText on $projection.PhoneNumberCountry = _MobilePhoneCountryText.Country
association [0..*] to C_TelCountryTextVHTemp as _FaxCountryText on $projection.PhoneNumberCountry = _FaxCountryText.Country
association [0..*] to C_BPContactAddress as _BPContactAddress on $projection.BusinessPartner = _BPContactAddress.BusinessPartner1
and $projection.BusinessPartnerPerson = _BPContactAddress.BusinessPartner2
and $projection.RelationshipNumber = _BPContactAddress.RelationshipNumber
and $projection.ValidityEndDate = _BPContactAddress.ValidityEndDate
association [0..*] to C_BPLanguageTextValueHelp as _BPLanguageText on $projection.CorrespondenceLanguage = _BPLanguageText.LanguageCode
// association [0..1] to I_BusPartRelshpCategoryVH as _BPRoleCategoryText on $projection.RelationshipCategory = _BPRoleCategoryText.RelationshipCategory
// and $projection.BPRelshpCatIsInFwdDirection = _BPRoleCategoryText.BPRelshpCatIsInFwdDirection
{
key BusinessPartnerContact.BusinessPartner,
key BusinessPartnerContact.BusinessPartnerPerson,
key BusinessPartnerContact.RelationshipNumber,
key BusinessPartnerContact.ValidityEndDate,
BusinessPartnerContact.BusinessPartnerForEdit,
BusinessPartnerContact.BusinessPartnerPersonForEdit,
BusinessPartnerContact.RelationshipNumberForEdit,
BusinessPartnerContact.ValidityEndDateForEdit, // Internal Incident: 2280164720
// @ObjectModel.readOnly: true
// @ObjectModel.text.element: ['BusPartRelshpCatDescription']
// BusinessPartnerContact.RelationshipCategory,
// BusinessPartnerContact.BPRelshpCatIsInFwdDirection,
BusinessPartnerContact.PersonUUID,
@ObjectModel.text.association: '_TitleText'
BusinessPartnerContact.FormOfAddress,
BusinessPartnerContact.FirstName,
BusinessPartnerContact.LastName,
BusinessPartnerContact.BirthDate,
@ObjectModel.text.association: '_BPLanguageText'
//@ObjectModel.readOnly: true
BusinessPartnerContact.CorrespondenceLanguage,
BusinessPartnerContact.ValidityStartDate,
@ObjectModel.text.association: '_PhoneNumberCountryText'
BusinessPartnerContact.PhoneNumberCountry,
BusinessPartnerContact.PhoneNumber,
BusinessPartnerContact.PhoneNumberExtension,
@ObjectModel.text.association: '_MobilePhoneCountryText'
BusinessPartnerContact.MobilePhoneCountry,
BusinessPartnerContact.MobilePhoneNumber,
@ObjectModel.text.association: '_FaxCountryText'
BusinessPartnerContact.FaxCountry,
BusinessPartnerContact.FaxNumber,
BusinessPartnerContact.FaxNumberExtension,
BusinessPartnerContact.EmailAddress,
@UI.textArrangement: #TEXT_FIRST
BusinessPartnerContact.ContactPersonFunction,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@UI.textArrangement: #TEXT_FIRST
BusinessPartnerContact.ContactPersonDepartment,
BusinessPartnerContact.Building,
BusinessPartnerContact.Floor,
BusinessPartnerContact.RoomNumber,
@ObjectModel.readOnly: true
BusinessPartnerContact.FullName,
BusinessPartnerContact.BusinessPartnerCategory,
BusinessPartnerContact.ContactPersonVIPType,
BusinessPartnerContact.ContactPersonAuthorityType,
BusinessPartnerContact.ContactPersonRemarkText,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
_BusinessPartnerSupplier,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
_BusinessPartnerCustomer,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
_BusinessPartner,
// @ObjectModel.readOnly: true
// _BPRoleCategoryText.BusPartRelshpCatDescription,
_CntctPersnFuncValueHelp,
_CntctPersnDeptValueHelp,
_ContactPersonFunction,
_TitleText,
_PhoneNumberCountryText,
_MobilePhoneCountryText,
_BPLanguageText,
_FaxCountryText,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_BPContactAddress,
// _BPRoleCategoryText,
/* Associations */
@Consumption.filter.hidden:true
_BusinessPartnerCompany,
@Consumption.filter.hidden:true
_BusinessPartnerPerson
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERCONTACTTP"
],
"ASSOCIATED":
[
"C_BPCONTACTADDRESS",
"C_BPLANGUAGETEXTVALUEHELP",
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSUPPLIER",
"C_TELCOUNTRYTEXTVHTEMP",
"C_TITLETEXTVHTEMP",
"I_BUSINESSPARTNER",
"I_CONTACTPERSONDEPARTMENT",
"I_CONTACTPERSONFUNCTION"
],
"BASE":
[
"I_BUSINESSPARTNERCONTACTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA