CIC_CustomerAddress

DDL: CIC_CUSTOMERADDRESS Type: view_entity

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.

2 data source(s) 39 fields

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 #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner CIC_CustBPAddress BusinessPartner
KEY AddressNumber CIC_CustBPAddress AddressNumber
ValidityStartDate CIC_CustBPAddress ValidityStartDate
ValidityEndDate CIC_CustBPAddress ValidityEndDate
AddressTimeZone CIC_CustBPAddress AddressTimeZone
IANATimeZone _IANAZone ianatzone
Country CIC_CustBPAddress Country
Region CIC_CustBPAddress Region
PostalCode CIC_CustBPAddress PostalCode
CityName CIC_CustBPAddress CityName
CityCode CIC_CustBPAddress CityCode
Street
StreetName CIC_CustBPAddress StreetName
HouseNumber CIC_CustBPAddress HouseNumber
Building CIC_CustBPAddress Building
Floor CIC_CustBPAddress Floor
RoomNumber CIC_CustBPAddress RoomNumber
Person CIC_CustBPAddress Person
CareOfName CIC_CustBPAddress CareOfName
DistrictName adrc city2
BPCityDistrictCode adrc cityp_code
AdditionalCityName CIC_CustBPAddress AdditionalCityName
BusinessPartnerName1 CIC_CustBPAddress BusinessPartnerName1
BusinessPartnerName2 CIC_CustBPAddress BusinessPartnerName2
BusinessPartnerName3 CIC_CustBPAddress BusinessPartnerName3
BusinessPartnerName4 CIC_CustBPAddress BusinessPartnerName4
AddressIsPersonAddress
longitude
latitude
altitude
_OrganizationAddress CIC_CustBPAddress _OrganizationAddress
GivenName
PersonMiddleName
FamilyName
AcademicTitle
SecondaryRegion adrc county_code
SecondaryRegionName adrc county
TertiaryRegion adrc township_code
TertiaryRegionName adrc township 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Proj. View on Customer Address'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #MASTER
}
define view entity CIC_CustomerAddress
  as select from CIC_CustBPAddress as CustomerAddress

    inner join   adrc              as Address on  CustomerAddress.AddressNumber = Address.addrnumber
                                              and Address.nation                is initial
                                              and Address.date_from             = '00010101'
  association [1..1] to CIC_IANATimeZone as _IANAZone on  $projection.AddressTimeZone = _IANAZone.tzone
                                                      and _IANAZone.flagsapdefault    = 'X'
{
  key CustomerAddress.BusinessPartner,
  key CustomerAddress.AddressNumber,
      CustomerAddress.ValidityStartDate,
      CustomerAddress.ValidityEndDate,
      CustomerAddress.AddressTimeZone,
      _IANAZone.ianatzone   as IANATimeZone,
      CustomerAddress.Country,
      CustomerAddress.Region,
      CustomerAddress.PostalCode,
      CustomerAddress.CityName,
      CustomerAddress.CityCode,
      CustomerAddress._PersonName.Street,
      CustomerAddress.StreetName,
      CustomerAddress.HouseNumber,
      CustomerAddress.Building,
      CustomerAddress.Floor,
      CustomerAddress.RoomNumber,
      CustomerAddress.Person,
      CustomerAddress.CareOfName,
      Address.city2         as DistrictName,
      Address.cityp_code    as BPCityDistrictCode,
      CustomerAddress.AdditionalCityName,

      /* Organization Name */
      CustomerAddress.BusinessPartnerName1,
      CustomerAddress.BusinessPartnerName2,
      CustomerAddress.BusinessPartnerName3,
      CustomerAddress.BusinessPartnerName4,
      CustomerAddress._OrganizationAddress.AddressIsPersonAddress,

      /* Coordinates */
      CustomerAddress._GeoLocation.longitude,
      CustomerAddress._GeoLocation.latitude,
      CustomerAddress._GeoLocation.altitude,
      CustomerAddress._OrganizationAddress,

      /* Person Name Details */
      CustomerAddress._PersonName.GivenName,
      CustomerAddress._PersonName.PersonMiddleName,
      CustomerAddress._PersonName.FamilyName,
      CustomerAddress._PersonName.AcademicTitle,
      

      Address.county_code   as SecondaryRegion,
      Address.county        as SecondaryRegionName,
      Address.township_code as TertiaryRegion,
      Address.township      as TertiaryRegionName

      //      coalesce( _PersonName.SecondaryRegion, _OrganizationAddress.SecondaryRegion )         as SecondaryRegion,

      //      coalesce( _PersonName.SecondaryRegionName, _OrganizationAddress.SecondaryRegionName ) as SecondaryRegionName,

      //      coalesce( _PersonName.TertiaryRegion, _OrganizationAddress.TertiaryRegion )           as TertiaryRegion,

      //      coalesce( _PersonName.TertiaryRegionName, _OrganizationAddress.TertiaryRegionName )   as TertiaryRegionName



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CIC_CUSTBPADDRESS",
"CIC_GEO_COORDINATES",
"CIC_IANATIMEZONE",
"I_ADDRORGNAMEPOSTALADDRESS",
"I_PERSONADDRESS",
"ADRC"
],
"ASSOCIATED":
[
"I_ADDRORGNAMEPOSTALADDRESS"
],
"BASE":
[
"CIC_CUSTBPADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More