A_BPContactToAddress
Contact Person Address
A_BPContactToAddress is a Basic CDS View that provides data about "Contact Person Address" in SAP S/4HANA. It reads from 1 data source (I_BpContactToAddress) and exposes 63 fields with key fields RelationshipNumber, BusinessPartnerCompany, BusinessPartnerPerson, ValidityEndDate, AddressID. It has 8 associations to related views. Part of development package ODATA_MASTER_DATA_BP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BpContactToAddress | I_BpContactToAddress | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | A_BusinessPartner | _BusinessPartnerCompany | $projection.BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner |
| [1..1] | A_BusinessPartner | _BusinessPartnerPerson | $projection.BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner |
| [1..1] | A_BusinessPartnerAddress | _AddressDetails | $projection.BusinessPartnerCompany = _AddressDetails.BusinessPartner and $projection.AddressID = _AddressDetails.AddressID |
| [0..*] | A_BPContactPersonTelNmbr | _BPRelshpCntctPersnTelNumber | $projection.RelationshipNumber = _BPRelshpCntctPersnTelNumber.RelationshipNumber and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnTelNumber.BusinessPartnerCompany and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnTelNumber.BusinessPartnerPerson and $projection.ValidityEndDate = _BPRelshpCntctPersnTelNumber.ValidityEndDate and $projection.AddressID = _BPRelshpCntctPersnTelNumber.AddressID |
| [0..*] | A_BPContactPersonMblNmbr | _BPRelshpCntctPersnMblNumber | $projection.RelationshipNumber = _BPRelshpCntctPersnMblNumber.RelationshipNumber and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnMblNumber.BusinessPartnerPerson and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnMblNumber.BusinessPartnerCompany and $projection.ValidityEndDate = _BPRelshpCntctPersnMblNumber.ValidityEndDate and $projection.AddressID = _BPRelshpCntctPersnMblNumber.AddressID |
| [0..*] | A_BPContactPersonFaxNmbr | _BPRelshpCntctPersnFaxNumber | $projection.RelationshipNumber = _BPRelshpCntctPersnFaxNumber.RelationshipNumber and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnFaxNumber.BusinessPartnerPerson and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnFaxNumber.BusinessPartnerCompany and $projection.ValidityEndDate = _BPRelshpCntctPersnFaxNumber.ValidityEndDate and $projection.AddressID = _BPRelshpCntctPersnFaxNumber.AddressID |
| [0..*] | A_BPContactPersonEmlAddr | _BPRelshpCntctPersnEmailAddr | $projection.RelationshipNumber = _BPRelshpCntctPersnEmailAddr.RelationshipNumber and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnEmailAddr.BusinessPartnerPerson and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnEmailAddr.BusinessPartnerCompany and $projection.ValidityEndDate = _BPRelshpCntctPersnEmailAddr.ValidityEndDate and $projection.AddressID = _BPRelshpCntctPersnEmailAddr.AddressID |
| [0..*] | A_BPContactPersonWbsteURL | _BPRelshpCntctPersnWbsteURL | $projection.RelationshipNumber = _BPRelshpCntctPersnWbsteURL.RelationshipNumber and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnWbsteURL.BusinessPartnerPerson and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnWbsteURL.BusinessPartnerCompany and $projection.ValidityEndDate = _BPRelshpCntctPersnWbsteURL.ValidityEndDate and $projection.AddressID = _BPRelshpCntctPersnWbsteURL.AddressID |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ABPCONTACTADDR | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| EndUserText.label | Contact Person Address | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view |
Fields (63)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | RelationshipNumber | RelationshipNumber | ||
| KEY | BusinessPartnerCompany | BusinessPartnerCompany | ||
| KEY | BusinessPartnerPerson | BusinessPartnerPerson | ||
| KEY | ValidityEndDate | ValidityEndDate | ||
| KEY | AddressID | AddressID | ||
| AddressNumber | _AddressDetails | AddressID | ||
| AdditionalStreetPrefixName | _AddressDetails | AdditionalStreetPrefixName | ||
| AdditionalStreetSuffixName | _AddressDetails | AdditionalStreetSuffixName | ||
| AddressTimeZone | _AddressDetails | AddressTimeZone | ||
| CareOfName | _AddressDetails | CareOfName | ||
| CityCode | _AddressDetails | CityCode | ||
| CityName | _AddressDetails | CityName | ||
| CompanyPostalCode | _AddressDetails | CompanyPostalCode | ||
| Country | _AddressDetails | Country | ||
| County | _AddressDetails | County | ||
| DeliveryServiceNumber | _AddressDetails | DeliveryServiceNumber | ||
| DeliveryServiceTypeCode | _AddressDetails | DeliveryServiceTypeCode | ||
| District | _AddressDetails | District | ||
| FormOfAddress | _AddressDetails | FormOfAddress | ||
| FullName | _AddressDetails | FullName | ||
| HomeCityName | _AddressDetails | HomeCityName | ||
| HouseNumber | _AddressDetails | HouseNumber | ||
| HouseNumberSupplementText | _AddressDetails | HouseNumberSupplementText | ||
| Language | _AddressDetails | Language | ||
| POBox | _AddressDetails | POBox | ||
| POBoxDeviatingCityName | _AddressDetails | POBoxDeviatingCityName | ||
| POBoxDeviatingCountry | _AddressDetails | POBoxDeviatingCountry | ||
| POBoxDeviatingRegion | _AddressDetails | POBoxDeviatingRegion | ||
| POBoxIsWithoutNumber | _AddressDetails | POBoxIsWithoutNumber | ||
| POBoxLobbyName | _AddressDetails | POBoxLobbyName | ||
| POBoxPostalCode | _AddressDetails | POBoxPostalCode | ||
| Person | _AddressDetails | Person | ||
| PostalCode | _AddressDetails | PostalCode | ||
| PrfrdCommMediumType | _AddressDetails | PrfrdCommMediumType | ||
| Region | _AddressDetails | Region | ||
| StreetName | _AddressDetails | StreetName | ||
| StreetPrefixName | _AddressDetails | StreetPrefixName | ||
| StreetSuffixName | _AddressDetails | StreetSuffixName | ||
| TaxJurisdiction | _AddressDetails | TaxJurisdiction | ||
| TransportZone | _AddressDetails | TransportZone | ||
| _PhoneNumber | _AddressDetails | _PhoneNumber | ||
| _MobilePhoneNumber | _AddressDetails | _MobilePhoneNumber | ||
| _FaxNumber | _AddressDetails | _FaxNumber | ||
| _EmailAddress | _AddressDetails | _EmailAddress | ||
| _URLAddress | _AddressDetails | _URLAddress | ||
| AddressRepresentationCode | AddressRepresentationCode | |||
| ContactPersonBuilding | Building | |||
| ContactPersonPrfrdCommMedium | PrfrdCommMediumType | |||
| ContactRelationshipDepartment | ContactRelationshipDepartment | |||
| ContactRelationshipFunction | ContactRelationshipFunction | |||
| CorrespondenceShortName | CorrespondenceShortName | |||
| Floor | Floor | |||
| InhouseMail | InhouseMail | |||
| IsDefaultAddress | IsDefaultAddress | |||
| RoomNumber | RoomNumber | |||
| PersonNumber | PersonNumber | |||
| _BPRelshpCntctPersnTelNumber | _BPRelshpCntctPersnTelNumber | |||
| _BPRelshpCntctPersnMblNumber | _BPRelshpCntctPersnMblNumber | |||
| _BPRelshpCntctPersnFaxNumber | _BPRelshpCntctPersnFaxNumber | |||
| _BPRelshpCntctPersnEmailAddr | _BPRelshpCntctPersnEmailAddr | |||
| _BPRelshpCntctPersnWbsteURL | _BPRelshpCntctPersnWbsteURL | |||
| _BusinessPartnerCompany | _BusinessPartnerCompany | |||
| _BusinessPartnerPerson | _BusinessPartnerPerson |
@AbapCatalog.sqlViewName: 'ABPCONTACTADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Contact Person Address'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view A_BPContactToAddress as select from I_BpContactToAddress
association [1..1] to A_BusinessPartner as _BusinessPartnerCompany on $projection.BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner
association [1..1] to A_BusinessPartner as _BusinessPartnerPerson on $projection.BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner
association [1..1] to A_BusinessPartnerAddress as _AddressDetails on $projection.BusinessPartnerCompany = _AddressDetails.BusinessPartner
and $projection.AddressID = _AddressDetails.AddressID
association [0..*] to A_BPContactPersonTelNmbr as _BPRelshpCntctPersnTelNumber on $projection.RelationshipNumber = _BPRelshpCntctPersnTelNumber.RelationshipNumber
and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnTelNumber.BusinessPartnerCompany
and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnTelNumber.BusinessPartnerPerson
and $projection.ValidityEndDate = _BPRelshpCntctPersnTelNumber.ValidityEndDate
and $projection.AddressID = _BPRelshpCntctPersnTelNumber.AddressID
association [0..*] to A_BPContactPersonMblNmbr as _BPRelshpCntctPersnMblNumber on $projection.RelationshipNumber = _BPRelshpCntctPersnMblNumber.RelationshipNumber
and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnMblNumber.BusinessPartnerPerson
and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnMblNumber.BusinessPartnerCompany
and $projection.ValidityEndDate = _BPRelshpCntctPersnMblNumber.ValidityEndDate
and $projection.AddressID = _BPRelshpCntctPersnMblNumber.AddressID
association [0..*] to A_BPContactPersonFaxNmbr as _BPRelshpCntctPersnFaxNumber on $projection.RelationshipNumber = _BPRelshpCntctPersnFaxNumber.RelationshipNumber
and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnFaxNumber.BusinessPartnerPerson
and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnFaxNumber.BusinessPartnerCompany
and $projection.ValidityEndDate = _BPRelshpCntctPersnFaxNumber.ValidityEndDate
and $projection.AddressID = _BPRelshpCntctPersnFaxNumber.AddressID
association [0..*] to A_BPContactPersonEmlAddr as _BPRelshpCntctPersnEmailAddr on $projection.RelationshipNumber = _BPRelshpCntctPersnEmailAddr.RelationshipNumber
and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnEmailAddr.BusinessPartnerPerson
and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnEmailAddr.BusinessPartnerCompany
and $projection.ValidityEndDate = _BPRelshpCntctPersnEmailAddr.ValidityEndDate
and $projection.AddressID = _BPRelshpCntctPersnEmailAddr.AddressID
association [0..*] to A_BPContactPersonWbsteURL as _BPRelshpCntctPersnWbsteURL on $projection.RelationshipNumber = _BPRelshpCntctPersnWbsteURL.RelationshipNumber
and $projection.BusinessPartnerPerson = _BPRelshpCntctPersnWbsteURL.BusinessPartnerPerson
and $projection.BusinessPartnerCompany = _BPRelshpCntctPersnWbsteURL.BusinessPartnerCompany
and $projection.ValidityEndDate = _BPRelshpCntctPersnWbsteURL.ValidityEndDate
and $projection.AddressID = _BPRelshpCntctPersnWbsteURL.AddressID
{
key RelationshipNumber,
key BusinessPartnerCompany,
key BusinessPartnerPerson,
key ValidityEndDate,
key AddressID,
@ObjectModel.readOnly: true
_AddressDetails.AddressID as AddressNumber,
@ObjectModel.readOnly: true
_AddressDetails.AdditionalStreetPrefixName,
@ObjectModel.readOnly: true
_AddressDetails.AdditionalStreetSuffixName,
@ObjectModel.readOnly: true
_AddressDetails.AddressTimeZone,
@ObjectModel.readOnly: true
_AddressDetails.CareOfName,
@ObjectModel.readOnly: true
_AddressDetails.CityCode,
@ObjectModel.readOnly: true
_AddressDetails.CityName,
@ObjectModel.readOnly: true
_AddressDetails.CompanyPostalCode,
@ObjectModel.readOnly: true
_AddressDetails.Country,
@ObjectModel.readOnly: true
_AddressDetails.County,
@ObjectModel.readOnly: true
_AddressDetails.DeliveryServiceNumber,
@ObjectModel.readOnly: true
_AddressDetails.DeliveryServiceTypeCode,
@ObjectModel.readOnly: true
_AddressDetails.District,
@ObjectModel.readOnly: true
_AddressDetails.FormOfAddress,
@ObjectModel.readOnly: true
_AddressDetails.FullName,
@ObjectModel.readOnly: true
_AddressDetails.HomeCityName,
@ObjectModel.readOnly: true
_AddressDetails.HouseNumber,
@ObjectModel.readOnly: true
_AddressDetails.HouseNumberSupplementText,
@ObjectModel.readOnly: true
_AddressDetails.Language,
@ObjectModel.readOnly: true
_AddressDetails.POBox,
@ObjectModel.readOnly: true
_AddressDetails.POBoxDeviatingCityName,
@ObjectModel.readOnly: true
_AddressDetails.POBoxDeviatingCountry,
@ObjectModel.readOnly: true
_AddressDetails.POBoxDeviatingRegion,
@ObjectModel.readOnly: true
_AddressDetails.POBoxIsWithoutNumber,
@ObjectModel.readOnly: true
_AddressDetails.POBoxLobbyName,
@ObjectModel.readOnly: true
_AddressDetails.POBoxPostalCode,
@ObjectModel.readOnly: true
_AddressDetails.Person,
@ObjectModel.readOnly: true
_AddressDetails.PostalCode,
@ObjectModel.readOnly: true
_AddressDetails.PrfrdCommMediumType,
@ObjectModel.readOnly: true
_AddressDetails.Region,
@ObjectModel.readOnly: true
_AddressDetails.StreetName,
@ObjectModel.readOnly: true
_AddressDetails.StreetPrefixName,
@ObjectModel.readOnly: true
_AddressDetails.StreetSuffixName,
@ObjectModel.readOnly: true
_AddressDetails.TaxJurisdiction,
@ObjectModel.readOnly: true
_AddressDetails.TransportZone,
@ObjectModel.readOnly: true
_AddressDetails._PhoneNumber,
@ObjectModel.readOnly: true
_AddressDetails._MobilePhoneNumber,
@ObjectModel.readOnly: true
_AddressDetails._FaxNumber,
@ObjectModel.readOnly: true
_AddressDetails._EmailAddress,
@ObjectModel.readOnly: true
_AddressDetails._URLAddress,
@ObjectModel.readOnly: true
AddressRepresentationCode,
Building as ContactPersonBuilding,
PrfrdCommMediumType as ContactPersonPrfrdCommMedium,
ContactRelationshipDepartment,
ContactRelationshipFunction,
CorrespondenceShortName,
Floor,
InhouseMail,
IsDefaultAddress,
RoomNumber,
@ObjectModel.readOnly: true
@Feature: 'API_BP_CNTCT_PERSN_ADDR'
PersonNumber,
@Feature: 'API_BP_CNTCT_PERSN_ADDR'
_BPRelshpCntctPersnTelNumber,
@Feature: 'API_BP_CNTCT_PERSN_ADDR'
_BPRelshpCntctPersnMblNumber,
@Feature: 'API_BP_CNTCT_PERSN_ADDR'
_BPRelshpCntctPersnFaxNumber,
@Feature: 'API_BP_CNTCT_PERSN_ADDR'
_BPRelshpCntctPersnEmailAddr,
@Feature: 'API_BP_CNTCT_PERSN_ADDR'
_BPRelshpCntctPersnWbsteURL,
_BusinessPartnerCompany,
_BusinessPartnerPerson
}
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