P_BPLATESTDEFAULTADDRESS_2

CDS View

Business Partner Latest Default Address

P_BPLATESTDEFAULTADDRESS_2 is a CDS View in S/4HANA. Business Partner Latest Default Address. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPLatestDefaultAddress_2 view from COMPOSITE Business Partner Latest Default Address

Fields (1)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1 
@AbapCatalog.sqlViewName: 'PBPLTSTDFLTADDR2'
@EndUserText.label: 'Business Partner Latest Default Address'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true 

define view P_BPLatestDefaultAddress_2 as select distinct from I_Businesspartneraddressusage  as Businesspartneraddressusage 
                                left outer join P_BPCurrentDefaultAddress_2   as Current    on Businesspartneraddressusage.BusinessPartner = Current.BusinessPartner 
                                left outer join P_BPNextDefaultAddress_2      as Next       on Businesspartneraddressusage.BusinessPartner = Next.BusinessPartner 
                                left outer join P_BPPreviousDefaultAddress_2  as Previous   on Businesspartneraddressusage.BusinessPartner = Previous.BusinessPartner 
                                
 association [1..1] to  I_Businesspartneraddressusage  as _Latest on   $projection.BusinessPartner     = _Latest.BusinessPartner  
                                                                  and  $projection.ValidityEndDateTime = _Latest.ValidityEndDate 
                                                                  and  _Latest.AddressUsage =   'XXDEFAULT'                                                                                     
  
{
  
  key Businesspartneraddressusage.BusinessPartner,
  
  key Businesspartneraddressusage.AddressUsage,
  
      coalesce(Current.ValidityEndDateTime, coalesce(Next.ValidityEndDateTime, Previous.ValidityEndDateTime )) as ValidityEndDateTime,
  
      _Latest
  
}

where Businesspartneraddressusage.AddressUsage = 'XXDEFAULT'



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERADDRESSUSAGE",
"P_BPCURRENTDEFAULTADDRESS_2",
"P_BPNEXTDEFAULTADDRESS_2",
"P_BPPREVIOUSDEFAULTADDRESS_2"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERADDRESSUSAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More