I_CAContractPartnerAddress

DDL: I_CACONTRACTPARTNERADDRESS Type: view_entity COMPOSITE Package: FKK_BUPA
16 Fields 2 Data Sources

Address of a Contract Partner

I_CAContractPartnerAddress is a Composite CDS View that provides data about "Address of a Contract Partner" in SAP S/4HANA. It reads from 2 data sources (I_BPCurrentDefaultAddress, I_BusinessPartnerAddress) and exposes 16 fields with key fields AddressNumber, BusinessPartner, BusinessPartner. Part of development package FKK_BUPA.

Data Sources (2)

SourceAliasJoin Type
I_BPCurrentDefaultAddress _DefaultAddress union_all
I_BusinessPartnerAddress I_BusinessPartnerAddress from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Address of a Contract Partner view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey AddressNumber view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AddressNumber AddressNumber Src Address No
KEY BusinessPartner BusinessPartner Issuing Authority
HouseNumber HouseNumber House Number
StreetName StreetName Text
CityName CityName Name
Country Country Venue: Ctry/Reg
PostalCode PostalCode Postal Code
AddressLine3
KEY BusinessPartner BusinessPartner Issuing Authority
HouseNumber _AddressDefaultRepresentation HouseNumber House Number
StreetName _AddressDefaultRepresentation StreetName Text
CityName _AddressDefaultRepresentation CityName Name
Country _AddressDefaultRepresentation Country Venue: Ctry/Reg
PostalCode _AddressDefaultRepresentation PostalCode Postal Code
AddressLine3
_BusinessPartner _BusinessPartner

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_CAContractPartnerAddress.
-- 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.

CREATE VIEW I_CAContractPartnerAddress AS
SELECT
  AddressNumber,
  BusinessPartner,
  HouseNumber,
  StreetName,
  CityName,
  Country,
  PostalCode,
  cast(_Address._Country._Text[1: Language=$session.system_language].CountryName as country_gfn_kk preserving type ) AS AddressLine3
FROM I_BusinessPartnerAddress
-- UNION ALL with additional select branch(es): I_BPCurrentDefaultAddress
;

Learn More