Which tables does A_BPContactToAddress use?

A_BPContactToAddress reads from 1 data source(s): I_BpContactToAddress.

A_BPContactToAddress

Q: How many fields does A_BPContactToAddress have?

A_BPContactToAddress has 57 fields. Key fields: RelationshipNumber, BusinessPartnerCompany, BusinessPartnerPerson, ValidityEndDate, AddressID.

DDL: A_BPCONTACTTOADDRESS SQL: ABPCONTACTADDR Type: view BASIC

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 57 fields with key fields RelationshipNumber, BusinessPartnerCompany, BusinessPartnerPerson, ValidityEndDate, AddressID. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BpContactToAddress	I_BpContactToAddress	from

Associations (3)

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`

Annotations (14)

Name	Value	Level
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
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

Fields (57)

Key	Field	Source Table	Source Field
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
	_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

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

{
  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,
      _AddressDetails._PhoneNumber,
      _AddressDetails._MobilePhoneNumber,
      _AddressDetails._FaxNumber,
      _AddressDetails._EmailAddress,
      _AddressDetails._URLAddress,
      @ObjectModel.readOnly: true
      AddressRepresentationCode,
      Building as ContactPersonBuilding,
      PrfrdCommMediumType as ContactPersonPrfrdCommMedium,
      ContactRelationshipDepartment,
      ContactRelationshipFunction,      
      CorrespondenceShortName,
      Floor,   
      InhouseMail,      
      IsDefaultAddress,    
      RoomNumber,     
      _BusinessPartnerCompany,
      _BusinessPartnerPerson
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_BUSINESSPARTNERADDRESS",
"I_BPCONTACTTOADDRESS"
],
"ASSOCIATED":
[
"A_ADDRESSEMAILADDRESS",
"A_ADDRESSFAXNUMBER",
"A_ADDRESSHOMEPAGEURL",
"A_ADDRESSPHONENUMBER",
"A_BUSINESSPARTNER",
"A_BUSINESSPARTNERADDRESS"
],
"BASE":
[
"A_BUSINESSPARTNERADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

A_BPContactToAddress view

I_BpContactToAddress view