P_CustomerBPDeliveryAddr

DDL: P_CUSTOMERBPDELIVERYADDR Type: view_entity COMPOSITE

P_CustomerBPDeliveryAddr is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CustomerToBusinessPartner) and exposes 10 fields with key fields Customer, BPAddressUsage, BPAddrEndDate, BPAddressID, BPAddressOperation. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerToBusinessPartner CustomerToBusinessPartner from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_Address_2 _BPAddress $projection.BPAddressID = _BPAddress.AddressID

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustomerToBusinessPartner Customer
KEY BPAddressUsage AddressUsage AddressUsage
KEY BPAddrEndDate AddressUsage ValidityEndDate
KEY BPAddressID AddressUsage AddressNumber
KEY BPAddressOperation AddrTypeAssignment BPAddrDeterminationTransaction
BPAddressStartDate AddressUsage ValidityStartDate
BPAddressDefault AddressUsage StandardUsage
BusinessPartner BusinessPartner BusinessPartner
PersonNumber BusinessPartner PersonNumber
_BPAddress _BPAddress 
@AccessControl.authorizationCheck: #NOT_ALLOWED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #B



define view entity P_CustomerBPDeliveryAddr as select from I_CustomerToBusinessPartner as CustomerToBusinessPartner
left outer to one join I_BusinessPartner as BusinessPartner 
on BusinessPartner.BusinessPartnerUUID = CustomerToBusinessPartner.BusinessPartnerUUID 
left outer to many join I_Businesspartneraddressusage as AddressUsage 
on BusinessPartner.BusinessPartner = AddressUsage.BusinessPartner
left outer to many join I_BPAddrTypeAssignment as AddrTypeAssignment
on AddressUsage.AddressUsage  = AddrTypeAssignment.AddressType


association [1..*] to I_Address_2 as _BPAddress
  on $projection.BPAddressID = _BPAddress.AddressID
  {
  
  
  key CustomerToBusinessPartner.Customer,
  key AddressUsage.AddressUsage                           as BPAddressUsage,
  key AddressUsage.ValidityEndDate                        as BPAddrEndDate,
  key AddressUsage.AddressNumber                          as BPAddressID,
  key AddrTypeAssignment.BPAddrDeterminationTransaction   as BPAddressOperation,
  AddressUsage.ValidityStartDate                          as BPAddressStartDate,
  AddressUsage.StandardUsage                              as BPAddressDefault,
  BusinessPartner.BusinessPartner,
  BusinessPartner.PersonNumber,
 
                                        _BPAddress
  
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPADDRTYPEASSIGNMENT",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERADDRESSUSAGE",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More