P_BPNextDefaultAddress_2

DDL: P_BPNEXTDEFAULTADDRESS_2 SQL: PBPNEXTDFLTADDR2 Type: view COMPOSITE

XXDEFAULT Addr Valid in Nearest Future

P_BPNextDefaultAddress_2 is a Composite CDS View that provides data about "XXDEFAULT Addr Valid in Nearest Future" in SAP S/4HANA. It reads from 1 data source (I_Businesspartneraddressusage) and exposes 2 fields.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_Businesspartneraddressusage I_Businesspartneraddressusage from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBPNEXTDFLTADDR2 view
EndUserText.label XXDEFAULT Addr Valid in Nearest Future view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (2)

KeyFieldSource TableSource FieldDescription
BusinessPartner BusinessPartner
ValidityEndDateTime 
@AbapCatalog.sqlViewName: 'PBPNEXTDFLTADDR2'
@EndUserText.label: 'XXDEFAULT Addr Valid in Nearest Future'
@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_BPNextDefaultAddress_2 
  as select from I_Businesspartneraddressusage 
{
 BusinessPartner,
 min(ValidityEndDate) as ValidityEndDateTime
}

where AddressUsage   = 'XXDEFAULT' 
and   ValidityEndDate > tstmp_current_utctimestamp()

group by BusinessPartner

Learn More