A_BPIntlAddressVersion

DDL: A_BPINTLADDRESSVERSION SQL: ABPINTLADDRVERS Type: view COMPOSITE
50 Fields 2 Data Sources 1 Associations

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)

SourceAliasJoin Type
I_Address_2 I_Address_2 inner
I_BusPartAddress I_BusPartAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_BusinessPartnerAddress _BusinessPartnerAddress $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressID = _BusinessPartnerAddress.AddressID

Annotations (15)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusPartAddress BusinessPartner Issuing Authority
KEY AddressID I_BusPartAddress AddressID Ship-to address
KEY AddressRepresentationCode I_Address_2 AddressRepresentationCode Address Version
AddresseeFullName I_Address_2 AddresseeFullName Full Name
AddressIDByExternalSystem I_BusPartAddress AddressIDByExternalSystem External number
AddressPersonID I_Address_2 AddressPersonID Person Number
AddressSearchTerm1 I_Address_2 AddressSearchTerm1 Search Term 1
AddressSearchTerm2 I_Address_2 AddressSearchTerm2 Search Term 2
AddressTimeZone I_Address_2 AddressTimeZone Time Zone
CareOfName I_Address_2 CareOfName c/o
CityName I_Address_2 CityName Name
CityNumber I_Address_2 CityNumber City Code
CompanyPostalCode I_Address_2 CompanyPostalCode Company Post Cd
Country I_Address_2 Country Venue: Ctry/Reg
DeliveryServiceNumber I_Address_2 DeliveryServiceNumber Delivery Service No.
DeliveryServiceTypeCode I_Address_2 DeliveryServiceTypeCode Delvry Serv Type
DistrictName I_Address_2 DistrictName District
FormOfAddress I_Address_2 FormOfAddress Title Key
HouseNumber I_Address_2 HouseNumber House Number
HouseNumberSupplementText I_Address_2 HouseNumberSupplementText Supplement
Language I_Address_2 CorrespondenceLanguage Language
OrganizationName1 I_Address_2 OrganizationName1 Name
OrganizationName2 I_Address_2 OrganizationName2 Name 2
OrganizationName3 I_Address_2 OrganizationName3 Name 3
OrganizationName4 I_Address_2 OrganizationName4 Name 4
PersonFamilyName I_Address_2 PersonFamilyName
PersonGivenName I_Address_2 PersonGivenName
POBox I_Address_2 POBox PO Box
POBoxDeviatingCityName I_Address_2 POBoxDeviatingCityName PO Box City
POBoxDeviatingCountry I_Address_2 POBoxDeviatingCountry PO Box C/R
POBoxDeviatingRegion I_Address_2 POBoxDeviatingRegion PO Region
POBoxIsWithoutNumber I_Address_2 POBoxIsWithoutNumber PO Box w/o No.
POBoxLobbyName I_Address_2 POBoxLobbyName PO Box Lobby
POBoxPostalCode I_Address_2 POBoxPostalCode PO Box Postal Code
PostalCode I_Address_2 PostalCode Postal Code
PrfrdCommMediumType I_Address_2 PrfrdCommMediumType Comm. Method
Region I_Address_2 Region Venue Region
SecondaryRegion I_Address_2 SecondaryRegion County code
SecondaryRegionName I_Address_2 SecondaryRegionName County
StreetName I_Address_2 StreetName Text
StreetPrefixName1 I_Address_2 StreetPrefixName1 Street 2
StreetPrefixName2 I_Address_2 StreetPrefixName2 Street 3
StreetSuffixName1 I_Address_2 StreetSuffixName1 Street 4
StreetSuffixName2 I_Address_2 StreetSuffixName2 Street 5
TaxJurisdiction I_Address_2 TaxJurisdiction Tax Jurisdiction
TertiaryRegion I_Address_2 TertiaryRegion Township code
TertiaryRegionName I_Address_2 TertiaryRegionName Township
TransportZone I_Address_2 TransportZone Transport Zone
VillageName I_Address_2 VillageName Different City
_BusinessPartnerAddress _BusinessPartnerAddress

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_BPIntlAddressVersion.
-- 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: ABPINTLADDRVERS

CREATE VIEW A_BPIntlAddressVersion AS
SELECT
  I_BusPartAddress.BusinessPartner AS BusinessPartner,
  I_BusPartAddress.AddressID AS AddressID,
  I_Address_2.AddressRepresentationCode AS AddressRepresentationCode,
  I_Address_2.AddresseeFullName AS AddresseeFullName,
  I_BusPartAddress.AddressIDByExternalSystem AS AddressIDByExternalSystem,
  I_Address_2.AddressPersonID AS AddressPersonID,
  I_Address_2.AddressSearchTerm1 AS AddressSearchTerm1,
  I_Address_2.AddressSearchTerm2 AS AddressSearchTerm2,
  I_Address_2.AddressTimeZone AS AddressTimeZone,
  I_Address_2.CareOfName AS CareOfName,
  I_Address_2.CityName AS CityName,
  I_Address_2.CityNumber AS CityNumber,
  I_Address_2.CompanyPostalCode AS CompanyPostalCode,
  I_Address_2.Country AS Country,
  I_Address_2.DeliveryServiceNumber AS DeliveryServiceNumber,
  I_Address_2.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  I_Address_2.DistrictName AS DistrictName,
  I_Address_2.FormOfAddress AS FormOfAddress,
  I_Address_2.HouseNumber AS HouseNumber,
  I_Address_2.HouseNumberSupplementText AS HouseNumberSupplementText,
  I_Address_2.CorrespondenceLanguage AS Language,
  I_Address_2.OrganizationName1 AS OrganizationName1,
  I_Address_2.OrganizationName2 AS OrganizationName2,
  I_Address_2.OrganizationName3 AS OrganizationName3,
  I_Address_2.OrganizationName4 AS OrganizationName4,
  I_Address_2.PersonFamilyName AS PersonFamilyName,
  I_Address_2.PersonGivenName AS PersonGivenName,
  I_Address_2.POBox AS POBox,
  I_Address_2.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  I_Address_2.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  I_Address_2.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  I_Address_2.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  I_Address_2.POBoxLobbyName AS POBoxLobbyName,
  I_Address_2.POBoxPostalCode AS POBoxPostalCode,
  I_Address_2.PostalCode AS PostalCode,
  I_Address_2.PrfrdCommMediumType AS PrfrdCommMediumType,
  I_Address_2.Region AS Region,
  I_Address_2.SecondaryRegion AS SecondaryRegion,
  I_Address_2.SecondaryRegionName AS SecondaryRegionName,
  I_Address_2.StreetName AS StreetName,
  I_Address_2.StreetPrefixName1 AS StreetPrefixName1,
  I_Address_2.StreetPrefixName2 AS StreetPrefixName2,
  I_Address_2.StreetSuffixName1 AS StreetSuffixName1,
  I_Address_2.StreetSuffixName2 AS StreetSuffixName2,
  I_Address_2.TaxJurisdiction AS TaxJurisdiction,
  I_Address_2.TertiaryRegion AS TertiaryRegion,
  I_Address_2.TertiaryRegionName AS TertiaryRegionName,
  I_Address_2.TransportZone AS TransportZone,
  I_Address_2.VillageName AS VillageName
FROM I_BusPartAddress
INNER JOIN I_Address_2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_BusinessPartnerAddress AS _BusinessPartnerAddress ON BusinessPartner = _BusinessPartnerAddress.BusinessPartner AND AddressID = _BusinessPartnerAddress.AddressID  -- association [1..1]
;

Learn More