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.
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 | BP Rel. Number | |
| KEY | BusinessPartnerCompany | BusinessPartnerCompany | Busn. Partner | |
| KEY | BusinessPartnerPerson | BusinessPartnerPerson | Busn. Partner | |
| KEY | ValidityEndDate | ValidityEndDate | ValidTo | |
| KEY | AddressID | AddressID | Ship-to address | |
| AddressNumber | _AddressDetails | AddressID | Ship-to address | |
| AdditionalStreetPrefixName | _AddressDetails | AdditionalStreetPrefixName | Street 3 | |
| AdditionalStreetSuffixName | _AddressDetails | AdditionalStreetSuffixName | Street 5 | |
| AddressTimeZone | _AddressDetails | AddressTimeZone | Time Zone | |
| CareOfName | _AddressDetails | CareOfName | c/o | |
| CityCode | _AddressDetails | CityCode | IATA: City | |
| CityName | _AddressDetails | CityName | Name | |
| CompanyPostalCode | _AddressDetails | CompanyPostalCode | Company Post Cd | |
| Country | _AddressDetails | Country | Venue: Ctry/Reg | |
| County | _AddressDetails | County | Wyoming County | |
| DeliveryServiceNumber | _AddressDetails | DeliveryServiceNumber | Delivery Service No. | |
| DeliveryServiceTypeCode | _AddressDetails | DeliveryServiceTypeCode | Delvry Serv Type | |
| District | _AddressDetails | District | District Court | |
| FormOfAddress | _AddressDetails | FormOfAddress | Title Key | |
| FullName | _AddressDetails | FullName | Name | |
| HomeCityName | _AddressDetails | HomeCityName | Different City | |
| HouseNumber | _AddressDetails | HouseNumber | House Number | |
| HouseNumberSupplementText | _AddressDetails | HouseNumberSupplementText | Supplement | |
| Language | _AddressDetails | Language | Report Text Language | |
| POBox | _AddressDetails | POBox | PO Box | |
| POBoxDeviatingCityName | _AddressDetails | POBoxDeviatingCityName | PO Box City | |
| POBoxDeviatingCountry | _AddressDetails | POBoxDeviatingCountry | PO Box C/R | |
| POBoxDeviatingRegion | _AddressDetails | POBoxDeviatingRegion | PO Region | |
| POBoxIsWithoutNumber | _AddressDetails | POBoxIsWithoutNumber | PO Box w/o No. | |
| POBoxLobbyName | _AddressDetails | POBoxLobbyName | PO Box Lobby | |
| POBoxPostalCode | _AddressDetails | POBoxPostalCode | PO Box Postal Code | |
| Person | _AddressDetails | Person | Person/ Farm/ Field | |
| PostalCode | _AddressDetails | PostalCode | Postal Code | |
| PrfrdCommMediumType | _AddressDetails | PrfrdCommMediumType | Comm. Method | |
| Region | _AddressDetails | Region | Venue Region | |
| StreetName | _AddressDetails | StreetName | Text | |
| StreetPrefixName | _AddressDetails | StreetPrefixName | Street 2 | |
| StreetSuffixName | _AddressDetails | StreetSuffixName | Street 4 | |
| TaxJurisdiction | _AddressDetails | TaxJurisdiction | Tax Jurisdiction | |
| TransportZone | _AddressDetails | TransportZone | Transport Zone | |
| _PhoneNumber | _AddressDetails | _PhoneNumber | ||
| _MobilePhoneNumber | _AddressDetails | _MobilePhoneNumber | ||
| _FaxNumber | _AddressDetails | _FaxNumber | ||
| _EmailAddress | _AddressDetails | _EmailAddress | ||
| _URLAddress | _AddressDetails | _URLAddress | ||
| AddressRepresentationCode | AddressRepresentationCode | Address Version | ||
| ContactPersonBuilding | Building | Building code | ||
| ContactPersonPrfrdCommMedium | PrfrdCommMediumType | Comm. Method | ||
| ContactRelationshipDepartment | ContactRelationshipDepartment | Department | ||
| ContactRelationshipFunction | ContactRelationshipFunction | Function | ||
| CorrespondenceShortName | CorrespondenceShortName | |||
| Floor | Floor | Floor | ||
| InhouseMail | InhouseMail | |||
| IsDefaultAddress | IsDefaultAddress | Stand. address | ||
| RoomNumber | RoomNumber | Room Number | ||
| PersonNumber | PersonNumber | Person Number | ||
| _BPRelshpCntctPersnTelNumber | _BPRelshpCntctPersnTelNumber | |||
| _BPRelshpCntctPersnMblNumber | _BPRelshpCntctPersnMblNumber | |||
| _BPRelshpCntctPersnFaxNumber | _BPRelshpCntctPersnFaxNumber | |||
| _BPRelshpCntctPersnEmailAddr | _BPRelshpCntctPersnEmailAddr | |||
| _BPRelshpCntctPersnWbsteURL | _BPRelshpCntctPersnWbsteURL | |||
| _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 A_BPContactToAddress.
-- 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: ABPCONTACTADDR
CREATE VIEW A_BPContactToAddress AS
SELECT
RelationshipNumber,
BusinessPartnerCompany,
BusinessPartnerPerson,
ValidityEndDate,
AddressID,
_AddressDetails.AddressID AS AddressNumber,
_AddressDetails.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
_AddressDetails.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
_AddressDetails.AddressTimeZone AS AddressTimeZone,
_AddressDetails.CareOfName AS CareOfName,
_AddressDetails.CityCode AS CityCode,
_AddressDetails.CityName AS CityName,
_AddressDetails.CompanyPostalCode AS CompanyPostalCode,
_AddressDetails.Country AS Country,
_AddressDetails.County AS County,
_AddressDetails.DeliveryServiceNumber AS DeliveryServiceNumber,
_AddressDetails.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
_AddressDetails.District AS District,
_AddressDetails.FormOfAddress AS FormOfAddress,
_AddressDetails.FullName AS FullName,
_AddressDetails.HomeCityName AS HomeCityName,
_AddressDetails.HouseNumber AS HouseNumber,
_AddressDetails.HouseNumberSupplementText AS HouseNumberSupplementText,
_AddressDetails.Language AS Language,
_AddressDetails.POBox AS POBox,
_AddressDetails.POBoxDeviatingCityName AS POBoxDeviatingCityName,
_AddressDetails.POBoxDeviatingCountry AS POBoxDeviatingCountry,
_AddressDetails.POBoxDeviatingRegion AS POBoxDeviatingRegion,
_AddressDetails.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
_AddressDetails.POBoxLobbyName AS POBoxLobbyName,
_AddressDetails.POBoxPostalCode AS POBoxPostalCode,
_AddressDetails.Person AS Person,
_AddressDetails.PostalCode AS PostalCode,
_AddressDetails.PrfrdCommMediumType AS PrfrdCommMediumType,
_AddressDetails.Region AS Region,
_AddressDetails.StreetName AS StreetName,
_AddressDetails.StreetPrefixName AS StreetPrefixName,
_AddressDetails.StreetSuffixName AS StreetSuffixName,
_AddressDetails.TaxJurisdiction AS TaxJurisdiction,
_AddressDetails.TransportZone AS TransportZone,
_AddressDetails._PhoneNumber AS _PhoneNumber,
_AddressDetails._MobilePhoneNumber AS _MobilePhoneNumber,
_AddressDetails._FaxNumber AS _FaxNumber,
_AddressDetails._EmailAddress AS _EmailAddress,
_AddressDetails._URLAddress AS _URLAddress,
AddressRepresentationCode,
Building AS ContactPersonBuilding,
PrfrdCommMediumType AS ContactPersonPrfrdCommMedium,
ContactRelationshipDepartment,
ContactRelationshipFunction,
CorrespondenceShortName,
Floor,
InhouseMail,
IsDefaultAddress,
RoomNumber,
PersonNumber
FROM I_BpContactToAddress
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartnerCompany ON BusinessPartnerCompany = _BusinessPartnerCompany.BusinessPartner -- association [1..1]
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartnerPerson ON BusinessPartnerPerson = _BusinessPartnerPerson.BusinessPartner -- association [1..1]
LEFT OUTER JOIN A_BusinessPartnerAddress AS _AddressDetails ON BusinessPartnerCompany = _AddressDetails.BusinessPartner AND AddressID = _AddressDetails.AddressID -- association [1..1]
LEFT OUTER JOIN A_BPContactPersonTelNmbr AS _BPRelshpCntctPersnTelNumber ON RelationshipNumber = _BPRelshpCntctPersnTelNumber.RelationshipNumber AND BusinessPartnerCompany = _BPRelshpCntctPersnTelNumber.BusinessPartnerCompany AND BusinessPartnerPerson = _BPRelshpCntctPersnTelNumber.BusinessPartnerPerson AND ValidityEndDate = _BPRelshpCntctPersnTelNumber.ValidityEndDate AND AddressID = _BPRelshpCntctPersnTelNumber.AddressID -- association [0..*]
LEFT OUTER JOIN A_BPContactPersonMblNmbr AS _BPRelshpCntctPersnMblNumber ON RelationshipNumber = _BPRelshpCntctPersnMblNumber.RelationshipNumber AND BusinessPartnerPerson = _BPRelshpCntctPersnMblNumber.BusinessPartnerPerson AND BusinessPartnerCompany = _BPRelshpCntctPersnMblNumber.BusinessPartnerCompany AND ValidityEndDate = _BPRelshpCntctPersnMblNumber.ValidityEndDate AND AddressID = _BPRelshpCntctPersnMblNumber.AddressID -- association [0..*]
LEFT OUTER JOIN A_BPContactPersonFaxNmbr AS _BPRelshpCntctPersnFaxNumber ON RelationshipNumber = _BPRelshpCntctPersnFaxNumber.RelationshipNumber AND BusinessPartnerPerson = _BPRelshpCntctPersnFaxNumber.BusinessPartnerPerson AND BusinessPartnerCompany = _BPRelshpCntctPersnFaxNumber.BusinessPartnerCompany AND ValidityEndDate = _BPRelshpCntctPersnFaxNumber.ValidityEndDate AND AddressID = _BPRelshpCntctPersnFaxNumber.AddressID -- association [0..*]
LEFT OUTER JOIN A_BPContactPersonEmlAddr AS _BPRelshpCntctPersnEmailAddr ON RelationshipNumber = _BPRelshpCntctPersnEmailAddr.RelationshipNumber AND BusinessPartnerPerson = _BPRelshpCntctPersnEmailAddr.BusinessPartnerPerson AND BusinessPartnerCompany = _BPRelshpCntctPersnEmailAddr.BusinessPartnerCompany AND ValidityEndDate = _BPRelshpCntctPersnEmailAddr.ValidityEndDate AND AddressID = _BPRelshpCntctPersnEmailAddr.AddressID -- association [0..*]
LEFT OUTER JOIN A_BPContactPersonWbsteURL AS _BPRelshpCntctPersnWbsteURL ON RelationshipNumber = _BPRelshpCntctPersnWbsteURL.RelationshipNumber AND BusinessPartnerPerson = _BPRelshpCntctPersnWbsteURL.BusinessPartnerPerson AND BusinessPartnerCompany = _BPRelshpCntctPersnWbsteURL.BusinessPartnerCompany AND ValidityEndDate = _BPRelshpCntctPersnWbsteURL.ValidityEndDate AND AddressID = _BPRelshpCntctPersnWbsteURL.AddressID -- association [0..*]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA