CIC_CustomerAddress

DDL: CIC_CUSTOMERADDRESS Type: view_entity
39 Fields 2 Data Sources 1 Associations

Proj. View on Customer Address

CIC_CustomerAddress is a CDS View that provides data about "Proj. View on Customer Address" in SAP S/4HANA. It reads from 2 data sources (adrc, CIC_CustBPAddress) and exposes 39 fields with key fields BusinessPartner, AddressNumber. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
adrc Address inner
CIC_CustBPAddress CustomerAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] CIC_IANATimeZone _IANAZone $projection.AddressTimeZone = _IANAZone.tzone and _IANAZone.flagsapdefault = 'X'

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Proj. View on Customer Address view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner CIC_CustBPAddress BusinessPartner Issuing Authority
KEY AddressNumber CIC_CustBPAddress AddressNumber Src Address No
ValidityStartDate CIC_CustBPAddress ValidityStartDate Validity Start Date
ValidityEndDate CIC_CustBPAddress ValidityEndDate ValidTo
AddressTimeZone CIC_CustBPAddress AddressTimeZone Time Zone
IANATimeZone _IANAZone ianatzone IANA time zone
Country CIC_CustBPAddress Country Venue: Ctry/Reg
Region CIC_CustBPAddress Region Venue Region
PostalCode CIC_CustBPAddress PostalCode Postal Code
CityName CIC_CustBPAddress CityName Name
CityCode CIC_CustBPAddress CityCode IATA: City
Street
StreetName CIC_CustBPAddress StreetName Text
HouseNumber CIC_CustBPAddress HouseNumber House Number
Building CIC_CustBPAddress Building Building code
Floor CIC_CustBPAddress Floor Floor
RoomNumber CIC_CustBPAddress RoomNumber Room Number
Person CIC_CustBPAddress Person Person/ Farm/ Field
CareOfName CIC_CustBPAddress CareOfName c/o
DistrictName adrc city2 District
BPCityDistrictCode adrc cityp_code District Code
AdditionalCityName CIC_CustBPAddress AdditionalCityName Different City
BusinessPartnerName1 CIC_CustBPAddress BusinessPartnerName1 Name
BusinessPartnerName2 CIC_CustBPAddress BusinessPartnerName2 Name 2
BusinessPartnerName3 CIC_CustBPAddress BusinessPartnerName3 Name 3
BusinessPartnerName4 CIC_CustBPAddress BusinessPartnerName4 Name 4
AddressIsPersonAddress
longitude
latitude
altitude
_OrganizationAddress CIC_CustBPAddress _OrganizationAddress
GivenName
PersonMiddleName
FamilyName
AcademicTitle
SecondaryRegion adrc county_code County code
SecondaryRegionName adrc county Wyoming County
TertiaryRegion adrc township_code Township code
TertiaryRegionName adrc township Township

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 CIC_CustomerAddress.
-- 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 CIC_CustomerAddress AS
SELECT
  CustomerAddress.BusinessPartner AS BusinessPartner,
  CustomerAddress.AddressNumber AS AddressNumber,
  CustomerAddress.ValidityStartDate AS ValidityStartDate,
  CustomerAddress.ValidityEndDate AS ValidityEndDate,
  CustomerAddress.AddressTimeZone AS AddressTimeZone,
  _IANAZone.ianatzone AS IANATimeZone,
  CustomerAddress.Country AS Country,
  CustomerAddress.Region AS Region,
  CustomerAddress.PostalCode AS PostalCode,
  CustomerAddress.CityName AS CityName,
  CustomerAddress.CityCode AS CityCode,
  CustomerAddress._PersonName.Street AS Street,
  CustomerAddress.StreetName AS StreetName,
  CustomerAddress.HouseNumber AS HouseNumber,
  CustomerAddress.Building AS Building,
  CustomerAddress.Floor AS Floor,
  CustomerAddress.RoomNumber AS RoomNumber,
  CustomerAddress.Person AS Person,
  CustomerAddress.CareOfName AS CareOfName,
  Address.city2 AS DistrictName,
  Address.cityp_code AS BPCityDistrictCode,
  CustomerAddress.AdditionalCityName AS AdditionalCityName,
  CustomerAddress.BusinessPartnerName1 AS BusinessPartnerName1,
  CustomerAddress.BusinessPartnerName2 AS BusinessPartnerName2,
  CustomerAddress.BusinessPartnerName3 AS BusinessPartnerName3,
  CustomerAddress.BusinessPartnerName4 AS BusinessPartnerName4,
  CustomerAddress._OrganizationAddress.AddressIsPersonAddress AS AddressIsPersonAddress,
  CustomerAddress._GeoLocation.longitude AS longitude,
  CustomerAddress._GeoLocation.latitude AS latitude,
  CustomerAddress._GeoLocation.altitude AS altitude,
  CustomerAddress._OrganizationAddress AS _OrganizationAddress,
  CustomerAddress._PersonName.GivenName AS GivenName,
  CustomerAddress._PersonName.PersonMiddleName AS PersonMiddleName,
  CustomerAddress._PersonName.FamilyName AS FamilyName,
  CustomerAddress._PersonName.AcademicTitle AS AcademicTitle,
  Address.county_code AS SecondaryRegion,
  Address.county AS SecondaryRegionName,
  Address.township_code AS TertiaryRegion,
  Address.township AS TertiaryRegionName
FROM CIC_CustBPAddress AS CustomerAddress
INNER JOIN adrc AS Address ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CIC_IANATimeZone AS _IANAZone ON AddressTimeZone = _IANAZone.tzone AND _IANAZone.flagsapdefault = 'X'  -- association [1..1]
;

Learn More