Which tables does A_BPIntlAddressVersion use?

A_BPIntlAddressVersion reads from 2 data source(s): I_Address_2, I_BusPartAddress.

How many fields does A_BPIntlAddressVersion have?

A_BPIntlAddressVersion has 50 fields. Key fields: BusinessPartner, AddressID, AddressRepresentationCode.

A_BPIntlAddressVersion

DDL: A_BPINTLADDRESSVERSION SQL: ABPINTLADDRVERS Type: view COMPOSITE

BP International Address Version

A_BPIntlAddressVersion is a Composite CDS View that provides data about "BP International Address Version" in SAP S/4HANA. It reads from 2 data sources (I_Address_2, I_BusPartAddress) and exposes 50 fields with key fields BusinessPartner, AddressID, AddressRepresentationCode. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
I_Address_2	I_Address_2	inner
I_BusPartAddress	I_BusPartAddress	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	A_BusinessPartnerAddress	_BusinessPartnerAddress	`$projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressID = _BusinessPartnerAddress.AddressID`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	ABPINTLADDRVERS	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	BP International Address Version	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#C	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 (50)

Key	Field	Source Table	Source Field
KEY	BusinessPartner	I_BusPartAddress	BusinessPartner
KEY	AddressID	I_BusPartAddress	AddressID
KEY	AddressRepresentationCode	I_Address_2	AddressRepresentationCode
	AddresseeFullName	I_Address_2	AddresseeFullName
	AddressIDByExternalSystem	I_BusPartAddress	AddressIDByExternalSystem
	AddressPersonID	I_Address_2	AddressPersonID
	AddressSearchTerm1	I_Address_2	AddressSearchTerm1
	AddressSearchTerm2	I_Address_2	AddressSearchTerm2
	AddressTimeZone	I_Address_2	AddressTimeZone
	CareOfName	I_Address_2	CareOfName
	CityName	I_Address_2	CityName
	CityNumber	I_Address_2	CityNumber
	CompanyPostalCode	I_Address_2	CompanyPostalCode
	Country	I_Address_2	Country
	DeliveryServiceNumber	I_Address_2	DeliveryServiceNumber
	DeliveryServiceTypeCode	I_Address_2	DeliveryServiceTypeCode
	DistrictName	I_Address_2	DistrictName
	FormOfAddress	I_Address_2	FormOfAddress
	HouseNumber	I_Address_2	HouseNumber
	HouseNumberSupplementText	I_Address_2	HouseNumberSupplementText
	Language	I_Address_2	CorrespondenceLanguage
	OrganizationName1	I_Address_2	OrganizationName1
	OrganizationName2	I_Address_2	OrganizationName2
	OrganizationName3	I_Address_2	OrganizationName3
	OrganizationName4	I_Address_2	OrganizationName4
	PersonFamilyName	I_Address_2	PersonFamilyName
	PersonGivenName	I_Address_2	PersonGivenName
	POBox	I_Address_2	POBox
	POBoxDeviatingCityName	I_Address_2	POBoxDeviatingCityName
	POBoxDeviatingCountry	I_Address_2	POBoxDeviatingCountry
	POBoxDeviatingRegion	I_Address_2	POBoxDeviatingRegion
	POBoxIsWithoutNumber	I_Address_2	POBoxIsWithoutNumber
	POBoxLobbyName	I_Address_2	POBoxLobbyName
	POBoxPostalCode	I_Address_2	POBoxPostalCode
	PostalCode	I_Address_2	PostalCode
	PrfrdCommMediumType	I_Address_2	PrfrdCommMediumType
	Region	I_Address_2	Region
	SecondaryRegion	I_Address_2	SecondaryRegion
	SecondaryRegionName	I_Address_2	SecondaryRegionName
	StreetName	I_Address_2	StreetName
	StreetPrefixName1	I_Address_2	StreetPrefixName1
	StreetPrefixName2	I_Address_2	StreetPrefixName2
	StreetSuffixName1	I_Address_2	StreetSuffixName1
	StreetSuffixName2	I_Address_2	StreetSuffixName2
	TaxJurisdiction	I_Address_2	TaxJurisdiction
	TertiaryRegion	I_Address_2	TertiaryRegion
	TertiaryRegionName	I_Address_2	TertiaryRegionName
	TransportZone	I_Address_2	TransportZone
	VillageName	I_Address_2	VillageName
	_BusinessPartnerAddress		_BusinessPartnerAddress

@AbapCatalog.sqlViewName: 'ABPINTLADDRVERS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'BP International Address Version'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL 
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_BPIntlAddressVersion as select from I_BusPartAddress 
inner join I_Address_2 on I_BusPartAddress.AddressID = I_Address_2.AddressID

  association [1..1] to A_BusinessPartnerAddress as _BusinessPartnerAddress on $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner 
                                                                           and $projection.AddressID = _BusinessPartnerAddress.AddressID
   
{
  key I_BusPartAddress.BusinessPartner,
  key I_BusPartAddress.AddressID, 
  key I_Address_2.AddressRepresentationCode,    
      @ObjectModel.readOnly: true   
      I_Address_2.AddresseeFullName,   
      @ObjectModel.readOnly: true   
      I_BusPartAddress.AddressIDByExternalSystem,
      @ObjectModel.readOnly: true   
      I_Address_2.AddressPersonID, 
      I_Address_2.AddressSearchTerm1,
      I_Address_2.AddressSearchTerm2,
      @ObjectModel.readOnly: true   
      I_Address_2.AddressTimeZone, 
      I_Address_2.CareOfName, 
      I_Address_2.CityName, 
      @ObjectModel.readOnly: true   
      I_Address_2.CityNumber, 
      @ObjectModel.readOnly: true   
      I_Address_2.CompanyPostalCode, 
      @ObjectModel.readOnly: true   
      I_Address_2.Country,       
      @ObjectModel.readOnly: true   
      I_Address_2.DeliveryServiceNumber, 
      @ObjectModel.readOnly: true   
      I_Address_2.DeliveryServiceTypeCode, 
      I_Address_2.DistrictName, 
      I_Address_2.FormOfAddress,          
      I_Address_2.HouseNumber, 
      I_Address_2.HouseNumberSupplementText, 
      @ObjectModel.readOnly: true   
      I_Address_2.CorrespondenceLanguage as Language,
      I_Address_2.OrganizationName1,
      I_Address_2.OrganizationName2,
      I_Address_2.OrganizationName3,
      I_Address_2.OrganizationName4,      
      I_Address_2.PersonFamilyName,
      I_Address_2.PersonGivenName,
      @ObjectModel.readOnly: true   
      I_Address_2.POBox, 
      I_Address_2.POBoxDeviatingCityName, 
      @ObjectModel.readOnly: true   
      I_Address_2.POBoxDeviatingCountry, 
      @ObjectModel.readOnly: true   
      I_Address_2.POBoxDeviatingRegion, 
      @ObjectModel.readOnly: true   
      I_Address_2.POBoxIsWithoutNumber, 
      I_Address_2.POBoxLobbyName, 
      @ObjectModel.readOnly: true   
      I_Address_2.POBoxPostalCode, 
      @ObjectModel.readOnly: true
      I_Address_2.PostalCode, 
      @ObjectModel.readOnly: true   
      I_Address_2.PrfrdCommMediumType, 
      @ObjectModel.readOnly: true   
      I_Address_2.Region, 
      @ObjectModel.readOnly: true   
      I_Address_2.SecondaryRegion,
      I_Address_2.SecondaryRegionName, 
      I_Address_2.StreetName, 
      I_Address_2.StreetPrefixName1, 
      I_Address_2.StreetPrefixName2,
      I_Address_2.StreetSuffixName1, 
      I_Address_2.StreetSuffixName2, 
      @ObjectModel.readOnly: true   
      I_Address_2.TaxJurisdiction, 
      @ObjectModel.readOnly: true   
      I_Address_2.TertiaryRegion,
      I_Address_2.TertiaryRegionName,
      @ObjectModel.readOnly: true   
      I_Address_2.TransportZone,
      I_Address_2.VillageName, 
      _BusinessPartnerAddress
}

where I_Address_2.AddressRepresentationCode is not initial

Depth:

A_BPIntlAddressVersion view

I_BusPartAddress view
I_Address_2 view_entity