I_BusinessPartnerAddressTP

DDL: I_BUSINESSPARTNERADDRESSTP SQL: IBPADDRESSTP Type: view TRANSACTIONAL
72 Fields 1 Data Sources 9 Associations

Business Partner Address

I_BusinessPartnerAddressTP is a Transactional CDS View that provides data about "Business Partner Address" in SAP S/4HANA. It reads from 1 data source (I_BusPartAddress) and exposes 72 fields with key fields BusinessPartner, AddressNumber. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusPartAddress BusinessPartnerAddress from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..*] I_BusinessPartnerAddrUsageTP _BusinessPartnerAddrUsage $projection.BusinessPartner = _BusinessPartnerAddrUsage.BusinessPartner and $projection.AddressNumber = _BusinessPartnerAddrUsage.AddressNumber
[0..*] I_BPTelephoneNumberTP _BPTelephoneNumber $projection.BusinessPartner = _BPTelephoneNumber.BusinessPartner and $projection.AddressNumber = _BPTelephoneNumber.AddressID
[0..*] I_BPMobilePhoneNumberTP _BPMobilePhoneNumber $projection.BusinessPartner = _BPMobilePhoneNumber.BusinessPartner and $projection.AddressNumber = _BPMobilePhoneNumber.AddressID
[0..*] I_BPFaxNumberTP _BPFaxNumber $projection.BusinessPartner = _BPFaxNumber.BusinessPartner and $projection.AddressNumber = _BPFaxNumber.AddressID
[0..*] I_BPWebsiteURLTP _BPWebsiteURL $projection.BusinessPartner = _BPWebsiteURL.BusinessPartner and $projection.AddressNumber = _BPWebsiteURL.AddressID
[0..*] I_BPEmailAddressTP _BPEmailAddress $projection.BusinessPartner = _BPEmailAddress.BusinessPartner and $projection.AddressNumber = _BPEmailAddress.AddressID
[1..1] I_BPLatestDefaultAddress_2 _StandardAddrUsage $projection.BusinessPartner = _StandardAddrUsage.BusinessPartner
[0..1] I_CountryText _CountryText $projection.country = _CountryText.Country and _CountryText.Language = $session.system_language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDRESSTP view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Business Partner Address view
ObjectModel.writeDraftPersistence BUPA_ADRC_D view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusPartAddress BusinessPartner Issuing Authority
KEY AddressNumber I_BusPartAddress AddressID Ship-to address
BusinessPartnerForEdit I_BusPartAddress BusinessPartner Issuing Authority
AddressNumberForEdit
ValidityStartDate I_BusPartAddress ValidityStartDate Validity Start Date
ValidityEndDate I_BusPartAddress ValidityEndDate ValidTo
AddressValidityStartDate
AddressValidityEndDate
CareOfName
StreetPrefixName
AdditionalStreetPrefixName
HouseNumber
StreetName
CustomerSupplierStreetName
HouseNumberSupplementText
StreetSuffixName
AdditionalStreetSuffixName
HomeCityName
District
PostalCode
CityName
CustomerSupplierCityName
Country
Region
AddressTimeZone
TransportZone
TaxJurisdiction
TaxJurisdictionByProvider
CompanyPostalCode
DeliveryServiceTypeCode
DeliveryServiceNumber
POBox
POBoxIsWithoutNumber
POBoxPostalCode
POBoxLobbyName
POBoxDeviatingCityName
POBoxDeviatingRegion
POBoxDeviatingCountry
CorrespondenceLanguage
PrfrdCommMediumType
PhoneNumber
FaxNumber
PhoneNumberCountry
PhoneNumberExtension
FaxCountry
FaxNumberExtension
MobilePhoneNumber
MobilePhoneCountry
EmailAddress
County
TownshipName _AddressDefaultRepresentation TertiaryRegionName Township
BPTargetAddressID I_BusPartAddress BPTargetAddressID Move Target
BPAddressMoveDateTime I_BusPartAddress BPAddressMoveDateTime Date of Move
AddressMoveDate
InternationalPhoneNumber
CompleteAddress
BPTargetAddressText
BPAddressIsProtected _BPProtectedAddress BPAddressIsProtected Sensitivity
URLFieldLength
WebsiteURL
_BusinessPartner _BusinessPartner
_BusinessPartnerAddrUsage _BusinessPartnerAddrUsage
_BPTelephoneNumber _BPTelephoneNumber
_BPMobilePhoneNumber _BPMobilePhoneNumber
_BPFaxNumber _BPFaxNumber
_BPWebsiteURL _BPWebsiteURL
_BPEmailAddress _BPEmailAddress
_CountryText _CountryText
_StandardAddrUsage _StandardAddrUsage
_BPProtectedAddress _BPProtectedAddress
_AddressDefaultRepresentation _AddressDefaultRepresentation
_Address _Address

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 I_BusinessPartnerAddressTP.
-- 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: IBPADDRESSTP

CREATE VIEW I_BusinessPartnerAddressTP AS
SELECT
  BusinessPartnerAddress.BusinessPartner AS BusinessPartner,
  BusinessPartnerAddress.AddressID AS AddressNumber,
  BusinessPartnerAddress.BusinessPartner AS BusinessPartnerForEdit,
  cast(BusinessPartnerAddress.AddressID as char10) AS AddressNumberForEdit,
  BusinessPartnerAddress.ValidityStartDate AS ValidityStartDate,
  BusinessPartnerAddress.ValidityEndDate AS ValidityEndDate,
  tstmp_to_dats(BusinessPartnerAddress.ValidityStartDate,'UTC', $session.client, 'NULL') AS AddressValidityStartDate,
  tstmp_to_dats(BusinessPartnerAddress.ValidityEndDate,'UTC', $session.client, 'NULL') AS AddressValidityEndDate,
  BusinessPartnerAddress._AddressDefaultRepresentation.CareOfName AS CareOfName,
  BusinessPartnerAddress._AddressDefaultRepresentation.StreetPrefixName1 AS StreetPrefixName,
  BusinessPartnerAddress._AddressDefaultRepresentation.StreetPrefixName2 AS AdditionalStreetPrefixName,
  BusinessPartnerAddress._AddressDefaultRepresentation.HouseNumber AS HouseNumber,
  BusinessPartnerAddress._AddressDefaultRepresentation.StreetName AS StreetName,
  BusinessPartnerAddress._AddressDefaultRepresentation.StreetName AS CustomerSupplierStreetName,
  BusinessPartnerAddress._AddressDefaultRepresentation.HouseNumberSupplementText AS HouseNumberSupplementText,
  BusinessPartnerAddress._AddressDefaultRepresentation.StreetSuffixName1 AS StreetSuffixName,
  BusinessPartnerAddress._AddressDefaultRepresentation.StreetSuffixName2 AS AdditionalStreetSuffixName,
  BusinessPartnerAddress._AddressDefaultRepresentation.VillageName AS HomeCityName,
  BusinessPartnerAddress._AddressDefaultRepresentation.DistrictName AS District,
  BusinessPartnerAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  BusinessPartnerAddress._AddressDefaultRepresentation.CityName AS CityName,
  BusinessPartnerAddress._AddressDefaultRepresentation.CityName AS CustomerSupplierCityName,
  BusinessPartnerAddress._AddressDefaultRepresentation.Country AS Country,
  BusinessPartnerAddress._AddressDefaultRepresentation.Region AS Region,
  BusinessPartnerAddress._AddressDefaultRepresentation.AddressTimeZone AS AddressTimeZone,
  BusinessPartnerAddress._AddressDefaultRepresentation.TransportZone AS TransportZone,
  BusinessPartnerAddress._AddressDefaultRepresentation.TaxJurisdiction AS TaxJurisdiction,
  BusinessPartnerAddress._AddressDefaultRepresentation.TaxJurisdiction AS TaxJurisdictionByProvider,
  BusinessPartnerAddress._AddressDefaultRepresentation.CompanyPostalCode AS CompanyPostalCode,
  BusinessPartnerAddress._AddressDefaultRepresentation.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  BusinessPartnerAddress._AddressDefaultRepresentation.DeliveryServiceNumber AS DeliveryServiceNumber,
  BusinessPartnerAddress._AddressDefaultRepresentation.POBox AS POBox,
  BusinessPartnerAddress._AddressDefaultRepresentation.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  BusinessPartnerAddress._AddressDefaultRepresentation.POBoxPostalCode AS POBoxPostalCode,
  BusinessPartnerAddress._AddressDefaultRepresentation.POBoxLobbyName AS POBoxLobbyName,
  BusinessPartnerAddress._AddressDefaultRepresentation.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  BusinessPartnerAddress._AddressDefaultRepresentation.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  BusinessPartnerAddress._AddressDefaultRepresentation.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  BusinessPartnerAddress._AddressDefaultRepresentation.CorrespondenceLanguage AS CorrespondenceLanguage,
  BusinessPartnerAddress._AddressDefaultRepresentation.PrfrdCommMediumType AS PrfrdCommMediumType,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry AS PhoneNumberCountry,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber AS PhoneNumberExtension,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltFaxNumber.FaxNumberCountry AS FaxCountry,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltFaxNumber.FaxExtensionNumber AS FaxNumberExtension,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobilePhoneNumber,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltMobilePhoneNumber.PhoneNumberCountry AS MobilePhoneCountry,
  BusinessPartnerAddress._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  BusinessPartnerAddress._AddressDefaultRepresentation.SecondaryRegionName AS County,
  _AddressDefaultRepresentation.TertiaryRegionName AS TownshipName,
  BusinessPartnerAddress.BPTargetAddressID AS BPTargetAddressID,
  BusinessPartnerAddress.BPAddressMoveDateTime AS BPAddressMoveDateTime,
  tstmp_to_dats(BusinessPartnerAddress.BPAddressMoveDateTime,'UTC', $session.client, 'NULL') AS AddressMoveDate,
  _AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS InternationalPhoneNumber,
  cast( ' ' as abap.char( 177 ) ) AS CompleteAddress,
  cast( ' ' as abap.sstring( 260 ) ) AS BPTargetAddressText,
  _BPProtectedAddress.BPAddressIsProtected AS BPAddressIsProtected,
  coalesce(_Address._DefaultCorpURLAddress.URLFieldLength, _Address._DefaultPvtURLAddress.URLFieldLength) AS URLFieldLength,
  _Address._DefaultURLAddress.WebsiteURL AS WebsiteURL
FROM I_BusPartAddress AS BusinessPartnerAddress
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerAddrUsageTP AS _BusinessPartnerAddrUsage ON BusinessPartner = _BusinessPartnerAddrUsage.BusinessPartner AND AddressNumber = _BusinessPartnerAddrUsage.AddressNumber  -- association [1..*]
LEFT OUTER JOIN I_BPTelephoneNumberTP AS _BPTelephoneNumber ON BusinessPartner = _BPTelephoneNumber.BusinessPartner AND AddressNumber = _BPTelephoneNumber.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPMobilePhoneNumberTP AS _BPMobilePhoneNumber ON BusinessPartner = _BPMobilePhoneNumber.BusinessPartner AND AddressNumber = _BPMobilePhoneNumber.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPFaxNumberTP AS _BPFaxNumber ON BusinessPartner = _BPFaxNumber.BusinessPartner AND AddressNumber = _BPFaxNumber.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPWebsiteURLTP AS _BPWebsiteURL ON BusinessPartner = _BPWebsiteURL.BusinessPartner AND AddressNumber = _BPWebsiteURL.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPEmailAddressTP AS _BPEmailAddress ON BusinessPartner = _BPEmailAddress.BusinessPartner AND AddressNumber = _BPEmailAddress.AddressID  -- association [0..*]
LEFT OUTER JOIN I_BPLatestDefaultAddress_2 AS _StandardAddrUsage ON BusinessPartner = _StandardAddrUsage.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON country = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
;

Learn More