C_BPAddressValueHelp

DDL: C_BPADDRESSVALUEHELP SQL: CBPADDRESSVH Type: view CONSUMPTION Package: VDM_MD_BP

Value Help view for list of addresses of a BP

C_BPAddressValueHelp is a Consumption CDS View that provides data about "Value Help view for list of addresses of a BP" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerAddress) and exposes 9 fields with key field AddressNumber. It has 1 association to related views. It is exposed through 1 OData service (ICL_INSURCLMPAYMENT). Part of development package VDM_MD_BP.

1 data source(s) Exposed by 1 service(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerAddress I_BusinessPartnerAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CBPADDRESSVH view
EndUserText.label Value Help view for list of addresses of a BP view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey AddressNumber view
Search.searchable true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

OData Services (1)

ServiceBindingVersionContractRelease
ICL_INSURCLMPAYMENT ICL_UI_INSURCLMPAYMENT_O2 V2 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AddressNumber AddressNumber
BusinessPartner BusinessPartner
HouseNumber HouseNumber
StreetName StreetName
CityName CityName
Country Country
PostalCode PostalCode
_BusinessPartner _BusinessPartner
_BPProtectedAddress _BPProtectedAddress 
@AbapCatalog.sqlViewName: 'CBPADDRESSVH'
@EndUserText.label: 'Value Help view for list of addresses of a BP'

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'AddressNumber'
@Search.searchable: true
@VDM.viewType: #CONSUMPTION

@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations:  [ '_BPProtectedAddress' ]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view C_BPAddressValueHelp 
  as select from I_BusinessPartnerAddress
   association [1..1] to I_BusinessPartner          as _BusinessPartner          on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
{
    @Consumption.filter.hidden: true
    @Search.defaultSearchElement: true
    @ObjectModel.text.element: 'CompleteAddress'
    key AddressNumber,
    @Consumption.filter.hidden: true
    BusinessPartner,
    @Consumption.filter.hidden: true
    @Search.defaultSearchElement: true
    HouseNumber,
    @Consumption.filter.hidden: true
    @Search.defaultSearchElement: true
    StreetName,
    @Consumption.filter.hidden: true
    @Search.defaultSearchElement: true
    CityName,
    @Consumption.filter.hidden: true
    @Search.defaultSearchElement: true
    Country,
    @Consumption.filter.hidden: true
    @Search.defaultSearchElement: true
    PostalCode,
    @Consumption.filter.hidden: true
    @EndUserText.label: 'Address'
    case
      when HouseNumber = '' and StreetName = '' and CityName = ''
        then concat_with_space(Country,PostalCode,1)
      when HouseNumber = '' and StreetName = ''
        then concat_with_space(concat(CityName, ','), concat_with_space(Country,PostalCode,1), 1)
      else
        concat_with_space(concat(concat_with_space(concat_with_space(concat_with_space(HouseNumber,StreetName,1),',',1),CityName,1),','),concat_with_space(Country,PostalCode,1),1) 
    end
    as CompleteAddress,
    _BusinessPartner,
      _BPProtectedAddress
         
}

Learn More