Which tables does I_BPCntctPersnEmailAddrGov use?

I_BPCntctPersnEmailAddrGov reads from 8 data source(s): but052, but052, I_BPCntctPersnEmailAddressProc, I_BPCntctPersnEmailAddressProc, but000, but000, adr6, adr6.

I_BPCntctPersnEmailAddrGov

Q: How many fields does I_BPCntctPersnEmailAddrGov have?

I_BPCntctPersnEmailAddrGov has 53 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber.

DDL: I_BPCNTCTPERSNEMAILADDRGOV Type: view_entity TRANSACTIONAL

Base Union WplcAddr Email

I_BPCntctPersnEmailAddrGov is a Transactional CDS View that provides data about "Base Union WplcAddr Email" in SAP S/4HANA. It reads from 8 data sources and exposes 53 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 3 associations to related views.

Data Sources (8)

Source	Alias	Join Type
but052	BPContactPerson	union_all
but052	BPContactPerson	union_all
I_BPCntctPersnEmailAddressProc	BPContactPersonEmailAddress	from
I_BPCntctPersnEmailAddressProc	BPContactPersonEmailAddress	union_all
but000	BusinessPartner2	inner
but000	BusinessPartner2	inner
adr6	EmailAddress	inner
adr6	EmailAddress	inner

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_BusPartRelationshipGov	_RelationshipGov	`$projection.MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess and $projection.MDChgProcessStep = _RelationshipGov.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RelationshipGov.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RelationshipGov.MDChgProcessSrceObject`
[1..1]	I_BPContactPersonAddressGov	_BPContactPersonAddress	`$projection.MasterDataChangeProcess = _BPContactPersonAddress.MasterDataChangeProcess and $projection.MDChgProcessStep = _BPContactPersonAddress.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BPContactPersonAddress.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BPContactPersonAddress.MDChgProcessSrceObject and $projection.AddressNumber = _BPContactPersonAddress.AddressNumber`
[0..1]	I_MasterDataChangeProcess	_MasterDataChangeProcess	`$projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess`

Annotations (7)

Name	Value	Level
EndUserText.label	Base Union WplcAddr Email	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#TRANSACTIONAL	view

Fields (53)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BPCntctPersnEmailAddressProc	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCntctPersnEmailAddressProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCntctPersnEmailAddressProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCntctPersnEmailAddressProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BPCntctPersnEmailAddressProc	AddressNumber
KEY	OrdinalNumber	I_BPCntctPersnEmailAddressProc	OrdinalNumber
KEY	BPRelshpCatIsInFwdDirection
	ValidityEndDateTime	I_BPCntctPersnEmailAddressProc	ValidityEndDateTime
	IsDefaultEmailAddress	I_BPCntctPersnEmailAddressProc	IsDefaultEmailAddress
	EmailAddress	I_BPCntctPersnEmailAddressProc	EmailAddress
	IsHomeEmailAddress	I_BPCntctPersnEmailAddressProc	IsHomeEmailAddress
	CommNumberIsNotUsed	I_BPCntctPersnEmailAddressProc	CommNumberIsNotUsed
	_RelationshipGov		_RelationshipGov
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCntctPersnEmailAddressProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCntctPersnEmailAddressProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCntctPersnEmailAddressProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BPCntctPersnEmailAddressProc	AddressNumber
KEY	OrdinalNumber	I_BPCntctPersnEmailAddressProc	OrdinalNumber
KEY	BPRelshpCatIsInFwdDirection
	ValidityEndDateTime	I_BPCntctPersnEmailAddressProc	ValidityEndDateTime
	IsDefaultEmailAddress	I_BPCntctPersnEmailAddressProc	IsDefaultEmailAddress
	EmailAddress	I_BPCntctPersnEmailAddressProc	EmailAddress
	IsHomeEmailAddress	I_BPCntctPersnEmailAddressProc	IsHomeEmailAddress
	CommNumberIsNotUsed	I_BPCntctPersnEmailAddressProc	CommNumberIsNotUsed
	_RelationshipGov		_RelationshipGov
KEY	MDChgProcessStep
KEY	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject
KEY	AddressNumber	but052	addrnumber
KEY	OrdinalNumber	adr6	consnumber
KEY	BPRelshpCatIsInFwdDirection
	ValidityEndDateTime
	IsDefaultEmailAddress	adr6	flgdefault
	EmailAddress	adr6	smtp_addr
	IsHomeEmailAddress	adr6	home_flag
	CommNumberIsNotUsed	adr6	flg_nouse
	MasterDataIsCurrent
	_RelationshipGov		_RelationshipGov
KEY	MDChgProcessStep
KEY	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject
KEY	AddressNumber	but052	addrnumber
KEY	OrdinalNumber	adr6	consnumber
KEY	BPRelshpCatIsInFwdDirection
	ValidityEndDateTime
	IsDefaultEmailAddress	adr6	flgdefault
	EmailAddress	adr6	smtp_addr
	IsHomeEmailAddress	adr6	home_flag
	CommNumberIsNotUsed	adr6	flg_nouse
	MasterDataIsCurrent
	_RelationshipGov		_RelationshipGov
	_BPContactPersonAddress		_BPContactPersonAddress

@EndUserText.label: 'Base Union WplcAddr Email'
@AccessControl.authorizationCheck: #CHECK
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
define view entity I_BPCntctPersnEmailAddrGov
  as select from I_BPCntctPersnEmailAddressProc as BPContactPersonEmailAddress
  association [1..1] to I_BusPartRelationshipGov    as _RelationshipGov         on  $projection.MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _RelationshipGov.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _RelationshipGov.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _RelationshipGov.MDChgProcessSrceObject
  association [1..1] to I_BPContactPersonAddressGov as _BPContactPersonAddress  on  $projection.MasterDataChangeProcess = _BPContactPersonAddress.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _BPContactPersonAddress.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _BPContactPersonAddress.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _BPContactPersonAddress.MDChgProcessSrceObject
                                                                                and $projection.AddressNumber           = _BPContactPersonAddress.AddressNumber
  association [0..1] to I_MasterDataChangeProcess   as _MasterDataChangeProcess on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
{
  key BPContactPersonEmailAddress.MasterDataChangeProcess,
  key BPContactPersonEmailAddress.MDChgProcessStep,
  key BPContactPersonEmailAddress.MDChgProcessSrceSystem,
  key BPContactPersonEmailAddress.MDChgProcessSrceObject,
  key BPContactPersonEmailAddress.AddressNumber,
  key BPContactPersonEmailAddress.OrdinalNumber,
  key cast( 'X' as boolean ) as BPRelshpCatIsInFwdDirection,
      BPContactPersonEmailAddress.ValidityEndDateTime,
      BPContactPersonEmailAddress.IsDefaultEmailAddress,
      BPContactPersonEmailAddress.EmailAddress,
      BPContactPersonEmailAddress.IsHomeEmailAddress,
      BPContactPersonEmailAddress.CommNumberIsNotUsed,
      cast(
      case when BPContactPersonEmailAddress.MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
              BPContactPersonEmailAddress.MDChgProcessStep = '0001' and  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
         else ' '
      end as abap_boolean preserving type
      )                           as MasterDataIsCurrent,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}
where
  BPContactPersonEmailAddress.MDChgProcessSourceModified <> 'D'

union all select from I_BPCntctPersnEmailAddressProc as BPContactPersonEmailAddress
association [1..1] to I_BusPartRelationshipGov    as _RelationshipGov         on  $projection.MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess
                                                                              and $projection.MDChgProcessStep        = _RelationshipGov.MDChgProcessStep
                                                                              and $projection.MDChgProcessSrceSystem  = _RelationshipGov.MDChgProcessSrceSystem
                                                                              and $projection.MDChgProcessSrceObject  = _RelationshipGov.MDChgProcessSrceObject
association [1..1] to I_BPContactPersonAddressGov as _BPContactPersonAddress  on  $projection.MasterDataChangeProcess = _BPContactPersonAddress.MasterDataChangeProcess
                                                                              and $projection.MDChgProcessStep        = _BPContactPersonAddress.MDChgProcessStep
                                                                              and $projection.MDChgProcessSrceSystem  = _BPContactPersonAddress.MDChgProcessSrceSystem
                                                                              and $projection.MDChgProcessSrceObject  = _BPContactPersonAddress.MDChgProcessSrceObject
                                                                              and $projection.AddressNumber           = _BPContactPersonAddress.AddressNumber
association [0..1] to I_MasterDataChangeProcess   as _MasterDataChangeProcess on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
{
  key BPContactPersonEmailAddress.MasterDataChangeProcess,
  key BPContactPersonEmailAddress.MDChgProcessStep,
  key BPContactPersonEmailAddress.MDChgProcessSrceSystem,
  key BPContactPersonEmailAddress.MDChgProcessSrceObject,
  key BPContactPersonEmailAddress.AddressNumber,
  key BPContactPersonEmailAddress.OrdinalNumber,
  key cast( ' ' as boolean ) as BPRelshpCatIsInFwdDirection,
      BPContactPersonEmailAddress.ValidityEndDateTime,
      BPContactPersonEmailAddress.IsDefaultEmailAddress,
      BPContactPersonEmailAddress.EmailAddress,
      BPContactPersonEmailAddress.IsHomeEmailAddress,
      BPContactPersonEmailAddress.CommNumberIsNotUsed,
      cast(
      case when BPContactPersonEmailAddress.MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
              BPContactPersonEmailAddress.MDChgProcessStep = '0001' and  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
         else ' '
      end as abap_boolean preserving type
      )                           as MasterDataIsCurrent,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}
where
  BPContactPersonEmailAddress.MDChgProcessSourceModified <> 'D'

union all select from but052 as BPContactPerson
  inner join          but000 as BusinessPartner2 on BusinessPartner2.partner = BPContactPerson.partner2
  inner join          adr6   as EmailAddress     on  EmailAddress.addrnumber = BPContactPerson.addrnumber
                                                 and EmailAddress.persnumber = BusinessPartner2.persnumber

association [1..1] to I_BusPartRelationshipGov    as _RelationshipGov        on  $projection.MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _RelationshipGov.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _RelationshipGov.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _RelationshipGov.MDChgProcessSrceObject
association [1..1] to I_BPContactPersonAddressGov as _BPContactPersonAddress on  $projection.MasterDataChangeProcess = _BPContactPersonAddress.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _BPContactPersonAddress.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _BPContactPersonAddress.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _BPContactPersonAddress.MDChgProcessSrceObject
                                                                             and $projection.AddressNumber           = _BPContactPersonAddress.AddressNumber

{
  key '000000000000'                                                                                                                             as MasterDataChangeProcess,
  key '0000'                                                                                                                                     as MDChgProcessStep,
  key ''                                                                                                                                         as MDChgProcessSrceSystem,
  key cast( concat( BPContactPerson.partner1, concat( '$$', concat( BPContactPerson.partner2, concat( '$$', 'BUR001' ) ) ) )  as mdc_source_id ) as MDChgProcessSrceObject,
  key BPContactPerson.addrnumber                                                                                                                 as AddressNumber,
  key EmailAddress.consnumber                                                                                                                    as OrdinalNumber,
  key cast( 'X' as boolean )                                                                                                                as BPRelshpCatIsInFwdDirection,
      cast( '' as ad_valto )                                                                                                                     as ValidityEndDateTime,
      EmailAddress.flgdefault                                                                                                                    as IsDefaultEmailAddress,
      EmailAddress.smtp_addr                                                                                                                     as EmailAddress,
      EmailAddress.home_flag                                                                                                                     as IsHomeEmailAddress,
      EmailAddress.flg_nouse                                                                                                                     as CommNumberIsNotUsed,
      cast( 'X' as abap_boolean preserving type )                                                                                                as MasterDataIsCurrent,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}

union all select from but052 as BPContactPerson
  inner join          but000 as BusinessPartner2 on BusinessPartner2.partner = BPContactPerson.partner2
  inner join          adr6   as EmailAddress     on  EmailAddress.addrnumber = BPContactPerson.addrnumber
                                                 and EmailAddress.persnumber = BusinessPartner2.persnumber

association [1..1] to I_BusPartRelationshipGov    as _RelationshipGov        on  $projection.MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _RelationshipGov.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _RelationshipGov.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _RelationshipGov.MDChgProcessSrceObject
association [1..1] to I_BPContactPersonAddressGov as _BPContactPersonAddress on  $projection.MasterDataChangeProcess = _BPContactPersonAddress.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _BPContactPersonAddress.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _BPContactPersonAddress.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _BPContactPersonAddress.MDChgProcessSrceObject
                                                                             and $projection.AddressNumber           = _BPContactPersonAddress.AddressNumber

{
  key '000000000000'                                                                                                                             as MasterDataChangeProcess,
  key '0000'                                                                                                                                     as MDChgProcessStep,
  key ''                                                                                                                                         as MDChgProcessSrceSystem,
  key cast( concat( BPContactPerson.partner1, concat( '$$', concat( BPContactPerson.partner2, concat( '$$', 'BUR001' ) ) ) )  as mdc_source_id ) as MDChgProcessSrceObject,
  key BPContactPerson.addrnumber                                                                                                                 as AddressNumber,
  key EmailAddress.consnumber                                                                                                                    as OrdinalNumber,
  key cast( ' ' as boolean )                                                                                                                as BPRelshpCatIsInFwdDirection,
      cast( '' as ad_valto )                                                                                                                     as ValidityEndDateTime,
      EmailAddress.flgdefault                                                                                                                    as IsDefaultEmailAddress,
      EmailAddress.smtp_addr                                                                                                                     as EmailAddress,
      EmailAddress.home_flag                                                                                                                     as IsHomeEmailAddress,
      EmailAddress.flg_nouse                                                                                                                     as CommNumberIsNotUsed,
      cast( 'X' as abap_boolean preserving type )                                                                                                as MasterDataIsCurrent,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCNTCTPERSNEMAILADDRESSPROC",
"I_MASTERDATACHANGEPROCESS",
"ADR6",
"BUT000",
"BUT052"
],
"ASSOCIATED":
[
"I_BPCONTACTPERSONADDRESSGOV",
"I_BUSPARTRELATIONSHIPGOV"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BPCntctPersnEmailAddrGov view_entity

I_BPCntctPersnEmailAddressProc view_entity
adr6
adr6
but000
but000
but052
but052
I_BPCntctPersnEmailAddressProc view_entity

I_BPCntctPersnEmailAddrGovTP view_entity