I_BusinessPartnerAddressDsp

DDL: I_BUSINESSPARTNERADDRESSDSP Type: view_entity BASIC

Business Partner Address Display

I_BusinessPartnerAddressDsp is a Basic CDS View that provides data about "Business Partner Address Display" in SAP S/4HANA. It reads from 2 data sources (I_Address, but021_fs) and exposes 11 fields with key fields BusinessPartner, ValidityEndDate, AddressUsage, AddressNumber.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_Address BPAddressActive inner
but021_fs but021_fs from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Partner Address Display view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner but021_fs partner
KEY ValidityEndDate but021_fs valid_to
KEY AddressUsage but021_fs adr_kind
KEY AddressNumber but021_fs addrnumber
ValidityStartDate but021_fs valid_from
StandardUsage but021_fs xdfadu
ValidFrom but021_fs valid_from
CityDisplayName I_Address CityName
PostalCodeForDisplay I_Address PostalCode
StreetDisplayName I_Address StreetName
CountryForDisplay I_Address Country 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business Partner Address Display'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_BusinessPartnerAddressDsp as select from but021_fs 
inner join I_Address as BPAddressActive on but021_fs.addrnumber = BPAddressActive.AddressID
{
    key but021_fs.partner   as BusinessPartner,
    key but021_fs.valid_to  as ValidityEndDate, 
    key but021_fs.adr_kind  as AddressUsage, 
    key but021_fs.addrnumber as AddressNumber, 
    but021_fs.valid_from    as ValidityStartDate, 
    but021_fs.xdfadu as StandardUsage,
    but021_fs.valid_from as ValidFrom,
    BPAddressActive.CityName as CityDisplayName,
    BPAddressActive.PostalCode as PostalCodeForDisplay,
    BPAddressActive.StreetName as StreetDisplayName,
    BPAddressActive.Country  as CountryForDisplay   
} where but021_fs.valid_to >= tstmp_current_utctimestamp()
    and but021_fs.valid_from <= tstmp_current_utctimestamp()
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"BUT021_FS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More