I_BusPartEmailAddressTP_2

DDL: I_BUSPARTEMAILADDRESSTP_2 SQL: IBUPAEMAILADTP2 Type: view_entity TRANSACTIONAL

Transactional View For I_BusPartEmailAddress

I_BusPartEmailAddressTP_2 is a Transactional CDS View that provides data about "Transactional View For I_BusPartEmailAddress" in SAP S/4HANA. It reads from 1 data source (I_BPEmailAddress) and exposes 29 fields with key fields BusinessPartner, AddressNumber, OrdinalNumber, Person. It has 1 association to related views.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_BPEmailAddress I_BPEmailAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP_2 _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Transactional View For I_BusPartEmailAddress view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY AddressNumber AddressID
KEY OrdinalNumber OrdinalNumber
KEY Person Person
OrdinalNumberForEdit OrdinalNumber
IsDefaultEmailAddress IsDefaultEmailAddress
EmailAddress EmailAddress
IsHomeEmailAddress IsHomeEmailAddress
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
datsendasValidityStartDate
datsendasValidityEndDate
DataControllerSet _BusinessPartner DataControllerSet
DataController1 _BusinessPartner DataController1
DataController2 _BusinessPartner DataController2
DataController3 _BusinessPartner DataController3
DataController4 _BusinessPartner DataController4
DataController5 _BusinessPartner DataController5
DataController6 _BusinessPartner DataController6
DataController7 _BusinessPartner DataController7
DataController8 _BusinessPartner DataController8
DataController9 _BusinessPartner DataController9
DataController10 _BusinessPartner DataController10
_BPProtectedAddress _BPProtectedAddress
_BusinessPartner _BusinessPartner
_BusinessPartnerAddress _BusinessPartnerAddress
AuthorizationGroup _BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted
_AuthorizationGroup _BusinessPartner _AuthorizationGroup 
//@AbapCatalog.sqlViewName: 'IBUPAEMAILADTP2'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
//@ClientHandling.algorithm : #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Transactional View For I_BusPartEmailAddress'
define view entity I_BusPartEmailAddressTP_2
  as select from I_BPEmailAddress
  association        to parent I_BusinessPartnerAddressTP_2 as _BusinessPartnerAddress on  $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
                                                                                       and $projection.AddressNumber   = _BusinessPartnerAddress.AddressNumber
//                                                                                       and $projection.BPDrftUUID   = _BusinessPartnerAddress.BPDrftUUID

//                                                                                       and $projection.BPAddressDrftUUID   = _BusinessPartnerAddress.BPAddressDrftUUID

  association [1..1] to I_BusinessPartnerTP_2               as _BusinessPartner        on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                                       and $projection.BPDrftUUID   = _BusinessPartner.BPDrftUUID

{ 
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPAddressDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPEmailAddrDraftUUID,

  key BusinessPartner,
  key AddressID as AddressNumber,
  key OrdinalNumber,
  key Person,
      @ObjectModel.editableFieldFor: 'OrdinalNumber'
      OrdinalNumber as OrdinalNumberForEdit,      
      IsDefaultEmailAddress,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      EmailAddress,
      IsHomeEmailAddress,      
//      CommNumberIsNotUsed,

      ValidityStartDateTime,
      ValidityEndDateTime,
      @Semantics.businessDate.from: true
      case when ValidityStartDateTime != ''
      then cast ( (substring(ValidityStartDateTime,1,8) ) as abap.dats )
      else cast ( '00010101' as abap.dats )
      end                                                           as ValidityStartDate,
      @Semantics.businessDate.to: true
      case when ValidityEndDateTime != ''
      then cast ( (substring(ValidityEndDateTime,1,8) ) as abap.dats )
      else cast ( '99991231' as abap.dats )
      end                                                           as ValidityEndDate,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet              as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1                as DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2                as DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3                as DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4                as DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5                as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6                as DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7                as DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8                as DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9                as DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10               as DataController10,
      /* Associations */
      _BPProtectedAddress,
      _BusinessPartner,
      _BusinessPartnerAddress,
      
       _BusinessPartner.AuthorizationGroup,
       _BusinessPartner.IsBusinessPurposeCompleted,
//      _BPDataControllerUsage

       
       _BusinessPartner._AuthorizationGroup as _AuthorizationGroup
}

Learn More