What is I_BusinessPartnerAddress in SAP S/4HANA?

I_BusinessPartnerAddress is a basic CDS view in SAP S/4HANA. Core view for Business Partner Address It contains 62 fields.

Which tables does I_BusinessPartnerAddress read from?

I_BusinessPartnerAddress reads data from: but020.

What VDM layer is I_BusinessPartnerAddress?

I_BusinessPartnerAddress is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_BusinessPartnerAddress

DDL: I_BUSINESSPARTNERADDRESS SQL: IBPADDRESS Type: view BASIC Package: VDM_MD_BP_BASE

62 Fields 1 Data Sources 3 Associations

Core view for Business Partner Address

I_BusinessPartnerAddress is a Basic CDS View that provides data about "Core view for Business Partner Address" in SAP S/4HANA. It reads from 1 data source (but020) and exposes 62 fields with key fields BusinessPartner, AddressNumber. It has 3 associations to related views. Part of development package VDM_MD_BP_BASE.

Data Sources (1)

Source	Alias	Join Type
but020	BusinessPartnerAddress	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_Address	_Address	`$projection.AddressNumber = _Address.AddressID`
[1..1]	I_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[0..1]	I_BPProtectedAddress	_BPProtectedAddress	`$projection.BusinessPartner = _BPProtectedAddress.BusinessPartner and $projection.AddressNumber = _BPProtectedAddress.AddressID`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	IBPADDRESS	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.viewType	#BASIC	view
EndUserText.label	Core view for Business Partner Address	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (62)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner	but020	partner	With Partner
KEY	AddressNumber	but020	addrnumber	Address Number
	ValidityStartDate	but020	addr_valid_from	Valid From
	ValidityEndDate	but020	addr_valid_to	Valid To
	BusinessPartnerAddressUUID	but020	address_guid	UUID
	BPTargetAddressID	but020	move_addr	Move Target
	BPAddressMoveDateTime	but020	addr_move_date	Date of Move
	CareOfName	_Address	CareOfName	c/o
	FormOfAddress	_Address	FormOfAddress	Title Key
	FullName	_Address	FullName	Name
	HouseNumber	_Address	HouseNumber	House Number
	StreetName	_Address	StreetName	Text
	HouseNumberSupplementText	_Address	HouseNumberSupplementText	Supplement
	District	_Address	District	District Court
	PostalCode	_Address	PostalCode	Postal Code
	CityName	_Address	CityName	Name
	Country	_Address	Country	Venue: Ctry/Reg
	Region	_Address	Region	Venue Region
	AddressTimeZone	_Address	AddressTimeZone	Time Zone
	TaxJurisdiction	_Address	TaxJurisdiction	Tax Jurisdiction
	TransportZone	_Address	TransportZone	Transport Zone
	CompanyPostalCode	_Address	CompanyPostalCode	Company Post Cd
	DeliveryServiceNumber	_Address	DeliveryServiceNumber	Delivery Service No.
	POBox	_Address	POBox	PO Box
	POBoxIsWithoutNumber	_Address	POBoxIsWithoutNumber	PO Box w/o No.
	POBoxPostalCode	_Address	POBoxPostalCode	PO Box Postal Code
	POBoxLobbyName	_Address	POBoxLobbyName	PO Box Lobby
	POBoxDeviatingCityName	_Address	POBoxDeviatingCityName	PO Box City
	POBoxDeviatingRegion	_Address	POBoxDeviatingRegion	PO Region
	POBoxDeviatingCountry	_Address	POBoxDeviatingCountry	PO Box C/R
	CorrespondenceLanguage	_Address	CorrespondenceLanguage	Language
	PrfrdCommMediumType	_Address	PrfrdCommMediumType	Comm. Method
	StreetPrefixName	_Address	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	_Address	AdditionalStreetPrefixName	Street 3
	StreetSuffixName	_Address	StreetSuffixName	Street 4
	AdditionalStreetSuffixName	_Address	AdditionalStreetSuffixName	Street 5
	HomeCityName	_Address	HomeCityName	Different City
	DeliveryServiceTypeCode	_Address	DeliveryServiceTypeCode	Delvry Serv Type
	AddressStreetUnusable	_Address	AddressStreetUnusable
	AddressPostBoxUnusable	_Address	AddressPostBoxUnusable
	Building	_Address	Building	Building code
	Floor	_Address	Floor	Floor
	RoomNumber	_Address	RoomNumber	Room Number
	County	_Address	County	Wyoming County
	CountyCode	_Address	CountyCode	County code
	TownshipCode	_Address	TownshipCode
	TownshipName	_Address	TownshipName
	CityFileTestStatus	_Address	CityFileTestStatus	Check Status
	PhoneNumber
	PhoneNumberCountry
	PhoneNumberExtension
	FaxNumber
	FaxCountry
	FaxNumberExtension
	MobilePhoneNumber
	MobilePhoneCountry
	EmailAddress
	URLFieldLength
	WebsiteURL
	_Address		_Address
	_BusinessPartner		_BusinessPartner
	_BPProtectedAddress		_BPProtectedAddress

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_BusinessPartnerAddress.
-- 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: IBPADDRESS

CREATE VIEW I_BusinessPartnerAddress AS
SELECT
  BusinessPartnerAddress.partner AS BusinessPartner,
  BusinessPartnerAddress.addrnumber AS AddressNumber,
  BusinessPartnerAddress.addr_valid_from AS ValidityStartDate,
  BusinessPartnerAddress.addr_valid_to AS ValidityEndDate,
  BusinessPartnerAddress.address_guid AS BusinessPartnerAddressUUID,
  BusinessPartnerAddress.move_addr AS BPTargetAddressID,
  BusinessPartnerAddress.addr_move_date AS BPAddressMoveDateTime,
  _Address.CareOfName AS CareOfName,
  _Address.FormOfAddress AS FormOfAddress,
  _Address.FullName AS FullName,
  _Address.HouseNumber AS HouseNumber,
  _Address.StreetName AS StreetName,
  _Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _Address.District AS District,
  _Address.PostalCode AS PostalCode,
  _Address.CityName AS CityName,
  _Address.Country AS Country,
  _Address.Region AS Region,
  _Address.AddressTimeZone AS AddressTimeZone,
  _Address.TaxJurisdiction AS TaxJurisdiction,
  _Address.TransportZone AS TransportZone,
  _Address.CompanyPostalCode AS CompanyPostalCode,
  _Address.DeliveryServiceNumber AS DeliveryServiceNumber,
  _Address.POBox AS POBox,
  _Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.POBoxLobbyName AS POBoxLobbyName,
  _Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _Address.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _Address.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  _Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  _Address.StreetPrefixName AS StreetPrefixName,
  _Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _Address.StreetSuffixName AS StreetSuffixName,
  _Address.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _Address.HomeCityName AS HomeCityName,
  _Address.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _Address.AddressStreetUnusable AS AddressStreetUnusable,
  _Address.AddressPostBoxUnusable AS AddressPostBoxUnusable,
  _Address.Building AS Building,
  _Address.Floor AS Floor,
  _Address.RoomNumber AS RoomNumber,
  _Address.County AS County,
  _Address.CountyCode AS CountyCode,
  _Address.TownshipCode AS TownshipCode,
  _Address.TownshipName AS TownshipName,
  _Address.CityFileTestStatus AS CityFileTestStatus,
  coalesce(_Address._DefaultCorporatePhoneNumber.PhoneNumber, _Address._DefaultPrivatePhoneNumber.PhoneNumber) AS PhoneNumber,
  coalesce(_Address._DefaultCorporatePhoneNumber.DestinationLocationCountry, _Address._DefaultPrivatePhoneNumber.DestinationLocationCountry) AS PhoneNumberCountry,
  coalesce(_Address._DefaultCorporatePhoneNumber.PhoneNumberExtension, _Address._DefaultPrivatePhoneNumber.PhoneNumberExtension) AS PhoneNumberExtension,
  coalesce(_Address._DefaultCorpFaxNumber.FaxNumber, _Address._DefaultPrivateFaxNumber.FaxNumber) AS FaxNumber,
  coalesce(_Address._DefaultCorpFaxNumber.FaxCountry, _Address._DefaultPrivateFaxNumber.FaxCountry) AS FaxCountry,
  coalesce(_Address._DefaultCorpFaxNumber.FaxNumberExtension, _Address._DefaultPrivateFaxNumber.FaxNumberExtension) AS FaxNumberExtension,
  coalesce(_Address._DefaultCorpMobilePhoneNumber.PhoneNumber, _Address._DefaultPvtMobilePhoneNumber.PhoneNumber) AS MobilePhoneNumber,
  coalesce(_Address._DefaultCorpMobilePhoneNumber.DestinationLocationCountry, _Address._DefaultPvtMobilePhoneNumber.DestinationLocationCountry) AS MobilePhoneCountry,
  coalesce(_Address._DefaultCorpEmailAddress.EmailAddress, _Address._DefaultPvtEmailAddress.EmailAddress) AS EmailAddress,
  coalesce(_Address._DefaultCorpURLAddress.URLFieldLength, _Address._DefaultPvtURLAddress.URLFieldLength) AS URLFieldLength,
  _Address._DefaultURLAddress.WebsiteURL AS WebsiteURL
FROM but020 AS BusinessPartnerAddress
LEFT OUTER JOIN I_Address AS _Address ON AddressNumber = _Address.AddressID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPProtectedAddress AS _BPProtectedAddress ON BusinessPartner = _BPProtectedAddress.BusinessPartner AND AddressNumber = _BPProtectedAddress.AddressID  -- association [0..1]
;

Depth:

I_BusinessPartnerAddress view

but020