C_BPAddlCustEmailAddress

@AbapCatalog.sqlViewName: 'CBPADDCEA'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'C view for email address of mlt customer'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel: {
    semanticKey: ['BusinessPartner', 'Customer', 'AddressID', 'OrdinalNumber' ]
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@VDM.viewType: #CONSUMPTION
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view C_BPAddlCustEmailAddress as select from I_BPAddlCustEmailAddressTP as BPAddlCustEmailAddressTP

association [1..1]  to C_BusinessPartner         as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer   on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
  
association [1..1] to C_BPAdditionalCustomer as _BPAdditionalCustomer   on  $projection.BusinessPartner = _BPAdditionalCustomer.BusinessPartner
                                                                         and  $projection.Customer = _BPAdditionalCustomer.Customer

{     
      key BPAddlCustEmailAddressTP.BusinessPartner,      
      key BPAddlCustEmailAddressTP.Customer,
      key BPAddlCustEmailAddressTP.AddressID,
      key BPAddlCustEmailAddressTP.OrdinalNumber,
      @ObjectModel.readOnly: true
      BPAddlCustEmailAddressTP.IsDefaultEmailAddress, 
      BPAddlCustEmailAddressTP.EmailAddress, 
      BPAddlCustEmailAddressTP.IsHomeEmailAddress,
      @ObjectModel.readOnly: true
      BPAddlCustEmailAddressTP.AddressCommunicationRemarkText,
  
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartner,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _BPAdditionalCustomer
}