Which tables does I_BPContactPersonWebsiteURLGov use?

I_BPContactPersonWebsiteURLGov reads from 8 data source(s): but052, but052, I_BPCntctPersnWebsiteURLProc, I_BPCntctPersnWebsiteURLProc, but000, but000, adr12, adr12.

I_BPContactPersonWebsiteURLGov

Q: How many fields does I_BPContactPersonWebsiteURLGov have?

I_BPContactPersonWebsiteURLGov has 57 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber.

DDL: I_BPCONTACTPERSONWEBSITEURLGOV Type: view_entity TRANSACTIONAL

Base Union WplcAddr Websites

I_BPContactPersonWebsiteURLGov is a Transactional CDS View that provides data about "Base Union WplcAddr Websites" in SAP S/4HANA. It reads from 8 data sources and exposes 57 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_BPCntctPersnWebsiteURLProc	BPContactPersonWebsite	from
I_BPCntctPersnWebsiteURLProc	BPContactPersonWebsite	union_all
but000	BusinessPartner2	inner
but000	BusinessPartner2	inner
adr12	Website	inner
adr12	Website	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 Websites	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 (57)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BPCntctPersnWebsiteURLProc	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCntctPersnWebsiteURLProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCntctPersnWebsiteURLProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCntctPersnWebsiteURLProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BPCntctPersnWebsiteURLProc	AddressNumber
KEY	OrdinalNumber	I_BPCntctPersnWebsiteURLProc	OrdinalNumber
KEY	BPRelshpCatIsInFwdDirection
	IsDefaultURLAddress	I_BPCntctPersnWebsiteURLProc	IsDefaultURLAddress
	CommNumberIsNotUsed	I_BPCntctPersnWebsiteURLProc	CommNumberIsNotUsed
	UniformResourceIdentifierType	I_BPCntctPersnWebsiteURLProc	UniformResourceIdentifierType
	SearchURLAddress	I_BPCntctPersnWebsiteURLProc	SearchURLAddress
	URLFieldLength	I_BPCntctPersnWebsiteURLProc	URLFieldLength
	WebsiteURL	I_BPCntctPersnWebsiteURLProc	WebsiteURL
	_RelationshipGov		_RelationshipGov
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCntctPersnWebsiteURLProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCntctPersnWebsiteURLProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCntctPersnWebsiteURLProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BPCntctPersnWebsiteURLProc	AddressNumber
KEY	OrdinalNumber	I_BPCntctPersnWebsiteURLProc	OrdinalNumber
KEY	BPRelshpCatIsInFwdDirection
	IsDefaultURLAddress	I_BPCntctPersnWebsiteURLProc	IsDefaultURLAddress
	CommNumberIsNotUsed	I_BPCntctPersnWebsiteURLProc	CommNumberIsNotUsed
	UniformResourceIdentifierType	I_BPCntctPersnWebsiteURLProc	UniformResourceIdentifierType
	SearchURLAddress	I_BPCntctPersnWebsiteURLProc	SearchURLAddress
	URLFieldLength	I_BPCntctPersnWebsiteURLProc	URLFieldLength
	WebsiteURL	I_BPCntctPersnWebsiteURLProc	WebsiteURL
	_RelationshipGov		_RelationshipGov
KEY	MDChgProcessStep
KEY	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject
KEY	AddressNumber	but052	addrnumber
KEY	OrdinalNumber	adr12	consnumber
KEY	BPRelshpCatIsInFwdDirection
	IsDefaultURLAddress	adr12	flgdefault
	CommNumberIsNotUsed	adr12	flg_nouse
	UniformResourceIdentifierType	adr12	uri_type
	SearchURLAddress	adr12	uri_srch
	MasterDataIsCurrent
	URLFieldLength	adr12	uri_length
	WebsiteURL	adr12	uri_addr
	_RelationshipGov		_RelationshipGov
KEY	MDChgProcessStep
KEY	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject
KEY	AddressNumber	but052	addrnumber
KEY	OrdinalNumber	adr12	consnumber
KEY	BPRelshpCatIsInFwdDirection
	IsDefaultURLAddress	adr12	flgdefault
	CommNumberIsNotUsed	adr12	flg_nouse
	UniformResourceIdentifierType	adr12	uri_type
	SearchURLAddress	adr12	uri_srch
	MasterDataIsCurrent
	URLFieldLength	adr12	uri_length
	WebsiteURL	adr12	uri_addr
	_RelationshipGov		_RelationshipGov
	_BPContactPersonAddress		_BPContactPersonAddress

@EndUserText.label: 'Base Union WplcAddr Websites'
@AccessControl.authorizationCheck: #CHECK
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.viewEnhancementCategory: [#NONE]
@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_BPContactPersonWebsiteURLGov
  as select from I_BPCntctPersnWebsiteURLProc as BPContactPersonWebsite
  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 BPContactPersonWebsite.MasterDataChangeProcess,
  key BPContactPersonWebsite.MDChgProcessStep,
  key BPContactPersonWebsite.MDChgProcessSrceSystem,
  key BPContactPersonWebsite.MDChgProcessSrceObject,
  key BPContactPersonWebsite.AddressNumber,
  key BPContactPersonWebsite.OrdinalNumber,
  key cast( 'X' as boolean ) as BPRelshpCatIsInFwdDirection,
      BPContactPersonWebsite.IsDefaultURLAddress,
      BPContactPersonWebsite.CommNumberIsNotUsed,
      BPContactPersonWebsite.UniformResourceIdentifierType,
      BPContactPersonWebsite.SearchURLAddress,
      cast(
      case when BPContactPersonWebsite.MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
              BPContactPersonWebsite.MDChgProcessStep = '0001' and  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
         else ' '
      end as abap_boolean preserving type
      )                           as MasterDataIsCurrent,
      BPContactPersonWebsite.URLFieldLength,
      BPContactPersonWebsite.WebsiteURL,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}
where
  BPContactPersonWebsite.MDChgProcessSourceModified <> 'D'

union all select from I_BPCntctPersnWebsiteURLProc as BPContactPersonWebsite
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 BPContactPersonWebsite.MasterDataChangeProcess,
  key BPContactPersonWebsite.MDChgProcessStep,
  key BPContactPersonWebsite.MDChgProcessSrceSystem,
  key BPContactPersonWebsite.MDChgProcessSrceObject,
  key BPContactPersonWebsite.AddressNumber,
  key BPContactPersonWebsite.OrdinalNumber,
  key cast( ' ' as boolean ) as BPRelshpCatIsInFwdDirection,
      BPContactPersonWebsite.IsDefaultURLAddress,
      BPContactPersonWebsite.CommNumberIsNotUsed,
      BPContactPersonWebsite.UniformResourceIdentifierType,
      BPContactPersonWebsite.SearchURLAddress,
      cast(
      case when BPContactPersonWebsite.MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
              BPContactPersonWebsite.MDChgProcessStep = '0001' and  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
         else ' '
      end as abap_boolean preserving type
      )                           as MasterDataIsCurrent,
      BPContactPersonWebsite.URLFieldLength,
      BPContactPersonWebsite.WebsiteURL,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}
where
  BPContactPersonWebsite.MDChgProcessSourceModified <> 'D'

union all select from but052 as BPContactPerson
  inner join          but000 as BusinessPartner2 on BusinessPartner2.partner = BPContactPerson.partner2
  inner join          adr12  as Website          on  Website.addrnumber = BPContactPerson.addrnumber
                                                 and Website.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 Website.consnumber                                                                                                                         as OrdinalNumber,
  key cast( 'X' as boolean )                                                                                                                as BPRelshpCatIsInFwdDirection,
      Website.flgdefault                                                                                                                         as IsDefaultURLAddress,
      Website.flg_nouse                                                                                                                          as CommNumberIsNotUsed,
      Website.uri_type                                                                                                                           as UniformResourceIdentifierType,
      Website.uri_srch                                                                                                                           as SearchURLAddress,
      cast( 'X' as abap_boolean preserving type )                                                                                                as MasterDataIsCurrent,
      Website.uri_length                                                                                                                         as URLFieldLength,
      Website.uri_addr                                                                                                                           as WebsiteURL,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}

union all select from but052 as BPContactPerson
  inner join          but000 as BusinessPartner2 on BusinessPartner2.partner = BPContactPerson.partner2
  inner join          adr12  as Website          on  Website.addrnumber = BPContactPerson.addrnumber
                                                 and Website.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 Website.consnumber                                                                                                                         as OrdinalNumber,
  key cast( ' ' as boolean )                                                                                                                as BPRelshpCatIsInFwdDirection,
      Website.flgdefault                                                                                                                         as IsDefaultURLAddress,
      Website.flg_nouse                                                                                                                          as CommNumberIsNotUsed,
      Website.uri_type                                                                                                                           as UniformResourceIdentifierType,
      Website.uri_srch                                                                                                                           as SearchURLAddress,
      cast( 'X' as abap_boolean preserving type )                                                                                                as MasterDataIsCurrent,
      Website.uri_length                                                                                                                         as URLFieldLength,
      Website.uri_addr                                                                                                                           as WebsiteURL,
      /* Associations */
      _RelationshipGov,
      _BPContactPersonAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCNTCTPERSNWEBSITEURLPROC",
"I_MASTERDATACHANGEPROCESS",
"ADR12",
"BUT000",
"BUT052"
],
"ASSOCIATED":
[
"I_BPCONTACTPERSONADDRESSGOV",
"I_BUSPARTRELATIONSHIPGOV"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BPContactPersonWebsiteURLGov view_entity

I_BPCntctPersnWebsiteURLProc view_entity
adr12
adr12
but000
but000
but052
but052
I_BPCntctPersnWebsiteURLProc view_entity

I_BPCntctPersnWebsiteURLGovTP view_entity