I_BPCNTCTPERSNEMAILADDRESSPROC

CDS View

Core BP Workplace Email Address Process

I_BPCNTCTPERSNEMAILADDRESSPROC is a CDS View in S/4HANA. Core BP Workplace Email Address Process. It contains 14 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 14 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPCntctPersnEmailAddrGov view_entity from TRANSACTIONAL Base Union WplcAddr Email
I_BPCntctPersnEmailAddrGov view_entity union_all TRANSACTIONAL Base Union WplcAddr Email
I_BPCntctPersnEmailAddrProcTP view_entity from TRANSACTIONAL BP Workplace Email Addr Process Data - TP
I_BPCntctPersnEmlAddrProcChgs view_entity from TRANSACTIONAL BP Contact Person Workplace Address Email Process Changes
I_BPCntctPersnEmlAddrProcChgs view_entity union_all TRANSACTIONAL BP Contact Person Workplace Address Email Process Changes

Fields (14)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 2
KEY MasterDataChangeProcess MasterDataChangeProcess 2
KEY MDChgProcessSrceObject MDChgProcessSrceObject 2
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 2
KEY MDChgProcessStep MDChgProcessStep 2
KEY OrdinalNumber OrdinalNumber 2
_BPRelProcess _BPRelProcess 1
_WorkplaceAddress _WorkplaceAddress 1
CommNumberIsNotUsed CommNumberIsNotUsed 1
EmailAddress EmailAddress 1
IsDefaultEmailAddress IsDefaultEmailAddress 1
IsHomeEmailAddress IsHomeEmailAddress 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
ValidityEndDateTime ValidityEndDateTime 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Core BP Workplace Email Address Process'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API 
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity I_BPCntctPersnEmailAddressProc
  as select from bur_adr6_prc
  association [1..1] to I_BPContactPersonAddressProc as _WorkplaceAddress on  bur_adr6_prc.process_id        = _WorkplaceAddress.MasterDataChangeProcess
                                                                          and bur_adr6_prc.process_step_no   = _WorkplaceAddress.MDChgProcessStep
                                                                          and bur_adr6_prc.source_system     = _WorkplaceAddress.MDChgProcessSrceSystem
                                                                          and bur_adr6_prc.source_id         = _WorkplaceAddress.MDChgProcessSrceObject
                                                                          and bur_adr6_prc.source_addrnumber = _WorkplaceAddress.AddressNumber
  association [1..1] to I_BusPartRelationshipProcess as _BPRelProcess     on  bur_adr6_prc.process_id      = _BPRelProcess.MasterDataChangeProcess
                                                                          and bur_adr6_prc.process_step_no = _BPRelProcess.MDChgProcessStep
                                                                          and bur_adr6_prc.source_system   = _BPRelProcess.MDChgProcessSrceSystem
                                                                          and bur_adr6_prc.source_id       = _BPRelProcess.MDChgProcessSrceObject
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key source_addrnumber        as AddressNumber,
  key consnumber               as OrdinalNumber,
      date_from                as AddrCommunicationValidFromDate,
      valid_to                 as ValidityEndDateTime,
      flgdefault               as IsDefaultEmailAddress,
      smtp_addr                as EmailAddress,
      home_flag                as IsHomeEmailAddress,
      flg_nouse                as CommNumberIsNotUsed,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,

      _WorkplaceAddress,
      _BPRelProcess
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BUR_ADR6_PRC"
],
"ASSOCIATED":
[
"I_BPCONTACTPERSONADDRESSPROC",
"I_BUSPARTRELATIONSHIPPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More