C_Arberp_Address

DDL: C_ARBERP_ADDRESS SQL: CARB_ADDRESS Type: view CONSUMPTION
25 Fields 5 Data Sources 2 Associations

CDS View for Addresses

C_Arberp_Address is a Consumption CDS View that provides data about "CDS View for Addresses" in SAP S/4HANA. It reads from 5 data sources (I_AddressPhoneNumber_2, I_AddressFaxNumber_2, t005k, t005k, I_Address_2) and exposes 25 fields with key field AddressID. It has 2 associations to related views.

Data Sources (5)

SourceAliasJoin Type
I_AddressPhoneNumber_2 _TMP_DefaultPhoneNumber left_outer
I_AddressFaxNumber_2 _WORKARROUND_DefaultFaxNumber left_outer
t005k _WORKARROUND_FaxDialCode left_outer
t005k _WORKARROUND_PhoneDialCode left_outer
I_Address_2 I_Address from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_RegionText _RegionText _RegionText.Region = I_Address.Region and _RegionText.Country = I_Address.Country
[0..*] I_CountryText _CountryText _CountryText.Country = I_Address.Country

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CARB_ADDRESS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label CDS View for Addresses view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_Address_2 AddressID Ship-to address
FullName I_Address_2 AddresseeFullName Full Name
CareOfName I_Address_2 CareOfName c/o
CityName I_Address_2 CityName Name
PostalCode I_Address_2 PostalCode Postal Code
StreetName I_Address_2 StreetName Text
HouseNumber I_Address_2 HouseNumber House Number
HouseNumberSupplementText I_Address_2 HouseNumberSupplementText Supplement
Building I_Address_2 Building Building code
Floor I_Address_2 Floor Floor
Country I_Address_2 Country Venue: Ctry/Reg
CorrespondenceLanguage I_Address_2 CorrespondenceLanguage Language
CountryNameasCountryName
LanguageasLanguage
Region I_Address_2 Region Venue Region
RegionNameasRegionName
LanguageasTranslationLanguage
InternationalPhoneNumber _CurrentDfltLandlinePhoneNmbr InternationalPhoneNumber Telephone no.
DestinationLocationCountry _CurrentDfltLandlinePhoneNmbr PhoneNumberCountry Venue: Ctry/Reg
CountryDialingCode t005k telefto Tel. to
InternationalFaxNumber _CurrentDfltFaxNumber InternationalFaxNumber Fax Number
FaxCountry _CurrentDfltFaxNumber FaxNumberCountry Country/Region
FaxCountryDialingCode t005k telefto Tel. to
EmailAddress _CurrentDfltEmailAddress EmailAddress E-Mail Address
RoomNumber I_Address_2 RoomNumber Room Number

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 C_Arberp_Address.
-- 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: CARB_ADDRESS

CREATE VIEW C_Arberp_Address AS
SELECT
  I_Address.AddressID AS AddressID,
  I_Address.AddresseeFullName AS FullName,
  I_Address.CareOfName AS CareOfName,
  I_Address.CityName AS CityName,
  I_Address.PostalCode AS PostalCode,
  I_Address.StreetName AS StreetName,
  I_Address.HouseNumber AS HouseNumber,
  I_Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  I_Address.Building AS Building,
  I_Address.Floor AS Floor,
  I_Address.Country AS Country,
  I_Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  coalesce (_CountryText[1: Language = CorrespondenceLanguage].CountryName, _CountryText[1: Language = 'E'].CountryName) as CountryName AS CountryNameasCountryName,
  coalesce (_CountryText[1: Language = CorrespondenceLanguage].Language, _CountryText[1: Language = 'E'].Language) as Language AS LanguageasLanguage,
  I_Address.Region AS Region,
  coalesce (_RegionText[1: Language = CorrespondenceLanguage].RegionName, _RegionText[1: Language = 'E'].RegionName) as RegionName AS RegionNameasRegionName,
  coalesce (_RegionText[1: Language = CorrespondenceLanguage].Language, _RegionText[1: Language = 'E'].Language) as TranslationLanguage AS LanguageasTranslationLanguage,
  _CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS InternationalPhoneNumber,
  _CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry AS DestinationLocationCountry,
  _WORKARROUND_PhoneDialCode.telefto AS CountryDialingCode,
  _CurrentDfltFaxNumber.InternationalFaxNumber AS InternationalFaxNumber,
  _CurrentDfltFaxNumber.FaxNumberCountry AS FaxCountry,
  _WORKARROUND_FaxDialCode.telefto AS FaxCountryDialingCode,
  _CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  I_Address.RoomNumber AS RoomNumber
FROM I_Address_2 AS I_Address
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _TMP_DefaultPhoneNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005k AS _WORKARROUND_PhoneDialCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _WORKARROUND_DefaultFaxNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005k AS _WORKARROUND_FaxDialCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RegionText AS _RegionText ON _RegionText.Region = I_Address.Region AND _RegionText.Country = I_Address.Country  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = I_Address.Country  -- association [0..*]
;

Learn More