I_BPIndepEmailAddressProcess

DDL: I_BPINDEPEMAILADDRESSPROCESS Type: view_entity Package: MDC_BUPA_GOV_BO

Base View for BUT_ADR6_IN_PRC

I_BPIndepEmailAddressProcess is a CDS View that provides data about "Base View for BUT_ADR6_IN_PRC" in SAP S/4HANA. It reads from 1 data source (but_adr6_in_prc) and exposes 16 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, OrdinalNumber. It has 1 association to related views. Part of development package MDC_BUPA_GOV_BO.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
but_adr6_in_prc but_adr6_in_prc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerProcess _BusinessPartner but_adr6_in_prc.process_id = _BusinessPartner.MasterDataChangeProcess and but_adr6_in_prc.process_step_no = _BusinessPartner.MDChgProcessStep and but_adr6_in_prc.source_system = _BusinessPartner.MDChgProcessSrceSystem and but_adr6_in_prc.source_id = _BusinessPartner.MDChgProcessSrceObject

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Base View for BUT_ADR6_IN_PRC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess process_id
KEY MDChgProcessStep process_step_no
KEY MDChgProcessSrceSystem source_system
KEY MDChgProcessSrceObject source_id
KEY OrdinalNumber consnumber
AddrCommunicationValidFromDate date_from
AddressNumber addrnumber
EmailAddress smtp_addr
IsDefaultEmailAddress flgdefault
CommNumberIsNotUsed flg_nouse
IsHomeEmailAddress home_flag
SearchEmailAddress smtp_srch
MDChgProcSrceLastChgdDateTime source_recency
MDChgProcessSourceModified source_modified
MDChgProcessSourceModifBinary source_modification_blip
_BusinessPartner _BusinessPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Base View for BUT_ADR6_IN_PRC'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPIndepEmailAddressProcess
  as select from but_adr6_in_prc
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner on  but_adr6_in_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                     and but_adr6_in_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                     and but_adr6_in_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                     and but_adr6_in_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key consnumber               as OrdinalNumber,
      date_from                as AddrCommunicationValidFromDate,
      addrnumber               as AddressNumber,
      smtp_addr                as EmailAddress,
      flgdefault               as IsDefaultEmailAddress,
      flg_nouse                as CommNumberIsNotUsed,
      home_flag                as IsHomeEmailAddress,
      smtp_srch                as SearchEmailAddress,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,

      _BusinessPartner
}

Learn More