C_BPEmailAddress

DDL: C_BPEMAILADDRESS SQL: CBPEMAILADDR Type: view CONSUMPTION

Business Partner Email Consumption View

C_BPEmailAddress is a Consumption CDS View that provides data about "Business Partner Email Consumption View" in SAP S/4HANA. It reads from 1 data source (I_BPEmailAddressTP) and exposes 11 fields with key fields BusinessPartner, AddressID, OrdinalNumber. It has 4 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_BPEmailAddressTP BPEmailAddress from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerAddress _BusinessPartnerAddress $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressID = _BusinessPartnerAddress.AddressNumber
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartnerSupplier _BusinessPartnerSupplier $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBPEMAILADDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Business Partner Email Consumption View view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPEmailAddressTP BusinessPartner
KEY AddressID I_BPEmailAddressTP AddressID
KEY OrdinalNumber I_BPEmailAddressTP OrdinalNumber
IsDefaultEmailAddress I_BPEmailAddressTP IsDefaultEmailAddress
EmailAddress I_BPEmailAddressTP EmailAddress
IsHomeEmailAddress I_BPEmailAddressTP IsHomeEmailAddress
AddressCommunicationRemarkText I_BPEmailAddressTP AddressCommunicationRemarkText
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartnerSupplier _BusinessPartnerSupplier
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'CBPEMAILADDR'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Business Partner Email Consumption View'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: ['BusinessPartner','AddressID','Person','OrdinalNumber','IsDefaultEmailAddress'],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@VDM.viewType: #CONSUMPTION

define view C_BPEmailAddress
  as select from I_BPEmailAddressTP as BPEmailAddress

  association [1..1] to C_BusinessPartnerAddress  as _BusinessPartnerAddress  on  $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
                                                                              and $projection.AddressID       = _BusinessPartnerAddress.AddressNumber

  association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

  association [1..1] to C_BusinessPartnerSupplier as _BusinessPartnerSupplier on  $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner

  association [1..1] to C_BusinessPartner         as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

{
  key BPEmailAddress.BusinessPartner,
  key BPEmailAddress.AddressID,
  key BPEmailAddress.OrdinalNumber,
  //@ObjectModel.readOnly: true

      BPEmailAddress.IsDefaultEmailAddress,
      BPEmailAddress.EmailAddress,
      @ObjectModel.readOnly: true
      BPEmailAddress.IsHomeEmailAddress,
      BPEmailAddress.AddressCommunicationRemarkText,
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _BusinessPartnerAddress,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartnerSupplier,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartner
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPEMAILADDRESSTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERADDRESS",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More