I_CAContractPartnerAddress

DDL: I_CACONTRACTPARTNERADDRESS Type: view_entity COMPOSITE Package: FKK_BUPA

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.

2 data source(s) 16 fields

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
KEY BusinessPartner BusinessPartner
HouseNumber HouseNumber
StreetName StreetName
CityName CityName
Country Country
PostalCode PostalCode
AddressLine3
KEY BusinessPartner BusinessPartner
HouseNumber _AddressDefaultRepresentation HouseNumber
StreetName _AddressDefaultRepresentation StreetName
CityName _AddressDefaultRepresentation CityName
Country _AddressDefaultRepresentation Country
PostalCode _AddressDefaultRepresentation PostalCode
AddressLine3
_BusinessPartner _BusinessPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Address of a Contract Partner'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
  usageType:{
    serviceQuality: #C,
    sizeCategory: #S,
    dataClass: #MASTER
  },
  representativeKey: 'AddressNumber'
}

@VDM.viewType: #COMPOSITE
define view entity I_CAContractPartnerAddress
  as select from I_BusinessPartnerAddress
{
      @ObjectModel.text.element: [ 'CAContractPartnerAddressText' ]
      @UI.textArrangement: #TEXT_FIRST
  key AddressNumber,
      @UI.hidden: true
      @ObjectModel.foreignKey.association: '_BusinessPartner'
  key BusinessPartner,
      @UI.hidden: true
      HouseNumber,
      @UI.hidden: true
      StreetName,
      @UI.hidden: true
      CityName,
      @UI.hidden: true
      Country,
      @UI.hidden: true
      PostalCode,

      @UI.hidden: true
      cast( concat_with_space(StreetName,
                  HouseNumber, 1) as adress_gfn_kk preserving type )                                                        as AddressLine1,

      @UI.hidden: true
      cast( concat_with_space(PostalCode,
                CityName, 1) as city_gfn_kk preserving type )                                                               as AddressLine2,

      @UI.hidden: true
      cast(_Address._Country._Text[1: Language=$session.system_language].CountryName    as country_gfn_kk preserving type ) as AddressLine3,


      @Consumption.filter.hidden: true
      @Semantics.text: true
      cast(concat_with_space(
        concat_with_space(
          concat(concat_with_space(StreetName,HouseNumber, 1),','),
          concat(concat_with_space(PostalCode,CityName, 1),','),
          1),
        _Address._Country._Text[1: Language=$session.system_language].CountryName,
        1
      ) as address_text_gfn_kk)                                                                                             as CAContractPartnerAddressText,

      _BusinessPartner
}
where
  AddressNumber is not initial
union all select from I_BPCurrentDefaultAddress as _DefaultAddress
{
  key cast('' as ad_addrnum)                                                                                                                     as AddressNumber,
  key BusinessPartner,
      _AddressDefaultRepresentation.HouseNumber,
      _AddressDefaultRepresentation.StreetName,
      _AddressDefaultRepresentation.CityName,
      _AddressDefaultRepresentation.Country,
      _AddressDefaultRepresentation.PostalCode,

      cast( concat_with_space(_AddressDefaultRepresentation.StreetName,
            _AddressDefaultRepresentation.HouseNumber, 1) as adress_gfn_kk preserving type )                                                     as AddressLine1,

      cast( concat_with_space(_AddressDefaultRepresentation.PostalCode,
                _AddressDefaultRepresentation.CityName, 1) as city_gfn_kk preserving type )                                                      as AddressLine2,

      cast(_AddressDefaultRepresentation._Country._Text[1: Language=$session.system_language].CountryName    as country_gfn_kk preserving type ) as AddressLine3,

      cast(concat_with_space(
        concat_with_space(
          concat(concat_with_space(_AddressDefaultRepresentation.StreetName,_AddressDefaultRepresentation.HouseNumber, 1),','),
          concat(concat_with_space(_AddressDefaultRepresentation.PostalCode,_AddressDefaultRepresentation.CityName, 1),','),
          1),
        _AddressDefaultRepresentation._Country._Text[1: Language=$session.system_language].CountryName,
        1
      ) as address_text_gfn_kk)                                                                                                                  as CAContractPartnerAddressText,

      _BusinessPartner
}

Learn More