I_BPFaxTextProcChanges

Q: Which tables does I_BPFaxTextProcChanges use?

I_BPFaxTextProcChanges reads from 2 data source(s): I_BPFaxNumberTextProc, I_BPFaxNumberTextProc.

Q: How many fields does I_BPFaxTextProcChanges have?

I_BPFaxTextProcChanges has 45 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber.

DDL: I_BPFAXTEXTPROCCHANGES Type: view_entity Package: MDC_BUPA_GOV_BO

Addr-Dependent Fax Text Changes

I_BPFaxTextProcChanges is a CDS View that provides data about "Addr-Dependent Fax Text Changes" in SAP S/4HANA. It reads from 2 data sources (I_BPFaxNumberTextProc, I_BPFaxNumberTextProc) and exposes 45 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 3 associations to related views. Part of development package MDC_BUPA_GOV_BO.

Data Sources (2)

Source	Alias	Join Type
I_BPFaxNumberTextProc	_Current	from
I_BPFaxNumberTextProc	_Current	union_all

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_BusinessPartnerProcess	_BusinessPartner	`$projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject`
[0..1]	I_BusPartProtectedAddressProc	_BPProtectedAddress	`_Current.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess and _Current.MDChgProcessStep = _BPProtectedAddress.MDChgProcessStep and _Current.MDChgProcessSrceSystem = _BPProtectedAddress.MDChgProcessSrceSystem and _Current.MDChgProcessSrceObject = _BPProtectedAddress.MDChgProcessSrceObject and _Current.AddressNumber = _BPProtectedAddress.AddressNumber`
[1..1]	I_BPFaxNumberProcess	_Fax	`$projection.MasterDataChangeProcess = _Fax.MasterDataChangeProcess and $projection.MDChgProcessStep = _Fax.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Fax.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Fax.MDChgProcessSrceObject and $projection.AddressNumber = _Fax.AddressNumber and $projection.OrdinalNumber = _Fax.OrdinalNumber`

Annotations (6)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Addr-Dependent Fax Text Changes	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (45)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BPFaxNumberTextProc	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPFaxNumberTextProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPFaxNumberTextProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPFaxNumberTextProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BPFaxNumberTextProc	AddressNumber
KEY	OrdinalNumber	I_BPFaxNumberTextProc	OrdinalNumber
KEY	Language	I_BPFaxNumberTextProc	Language
KEY	MDChgProcessModelTableName	_ModelTable	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelTable	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPFaxNumberTextProc	MDChgProcessSourceModified
	MDChgProcessRecordObjectText	I_BPFaxNumberTextProc	CommunicationRemarkText
	_BusinessPartner		_BusinessPartner
	_BPProtectedAddress		_BPProtectedAddress
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPFaxNumberTextProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPFaxNumberTextProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPFaxNumberTextProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BPFaxNumberTextProc	AddressNumber
KEY	OrdinalNumber	I_BPFaxNumberTextProc	OrdinalNumber
KEY	Language	I_BPFaxNumberTextProc	Language
KEY	MDChgProcessModelTableName	_ModelField	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName	_ModelField	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelField	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc	_ModelField	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPFaxNumberTextProc	MDChgProcessSourceModified
	MDChgProcessRecordObjectText	I_BPFaxNumberTextProc	CommunicationRemarkText
	_BusinessPartner		_BusinessPartner
	_BPProtectedAddress		_BPProtectedAddress
	_Fax		_Fax

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Addr-Dependent Fax Text Changes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPFaxTextProcChanges 
as select from I_BPFaxNumberTextProc                    as _Current
     left outer to one join I_MDChangeProcessModelTable as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'ADR3T'
                                                                       and _ModelTable.MDChgProcessSrceObjectTypeCode = '147'

  association [1..1] to I_BusinessPartnerProcess      as _BusinessPartner    on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject

  association [0..1] to I_BusPartProtectedAddressProc as _BPProtectedAddress on  _Current.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess
                                                                             and _Current.MDChgProcessStep        = _BPProtectedAddress.MDChgProcessStep
                                                                             and _Current.MDChgProcessSrceSystem  = _BPProtectedAddress.MDChgProcessSrceSystem
                                                                             and _Current.MDChgProcessSrceObject  = _BPProtectedAddress.MDChgProcessSrceObject
                                                                             and _Current.AddressNumber           = _BPProtectedAddress.AddressNumber

  association [1..1] to I_BPFaxNumberProcess          as _Fax                on  $projection.MasterDataChangeProcess = _Fax.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _Fax.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _Fax.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _Fax.MDChgProcessSrceObject
                                                                             and $projection.AddressNumber           = _Fax.AddressNumber
                                                                             and $projection.OrdinalNumber           = _Fax.OrdinalNumber
{
  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.AddressNumber,
  key _Current.OrdinalNumber,
  key _Current.Language,
  key _ModelTable.MDChgProcessModelTableName,
  key cast ( '' as fieldname )                         as MDChangeProcessModelFieldName,
  key cast( concat(concat(concat(
            concat(_Current.MDChgProcessSrceSystem,
            concat( '%%', _Current.MDChgProcessSrceObject)),
            concat( '%%', _Current.AddressNumber)),
            concat( '%%', _Current.OrdinalNumber)),
            concat( '%%', _Current.Language))
        as abap.char(1000) )                            as MDChgProcessRecordObjectID,
      _ModelTable.MDChangeProcModelTableDesc,
      cast ('' as as4text )                             as MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BPProcFaxNumberText' as fieldname )        as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BPFaxNumberTextProcTP' as fieldname )    as MDChgProcModTableExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as fieldname )                           as MDChgProcModFieldExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                    as MDChgProcCurrentAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                    as MDChgProcPrevAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_BUPAPROCTP2_CALC_EXIT'
      cast( '' as boolean )                             as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,
      _Current.CommunicationRemarkText                  as MDChgProcessRecordObjectText,
        /* Associations */
      _BusinessPartner,
      _BPProtectedAddress,
      _Fax
}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

union all select from I_BPFaxNumberTextProc           as _Current
  left outer to many join I_MDChangeProcessModelField as _ModelField on _ModelField.MDChgProcessModelTableName = 'ADR3T'
                                                                     and _ModelField.MDChgProcessSrceObjectTypeCode = '147'

  association [1..1] to I_BusinessPartnerProcess      as _BusinessPartner    on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject

  association [0..1] to I_BusPartProtectedAddressProc as _BPProtectedAddress on  _Current.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess
                                                                             and _Current.MDChgProcessStep        = _BPProtectedAddress.MDChgProcessStep
                                                                             and _Current.MDChgProcessSrceSystem  = _BPProtectedAddress.MDChgProcessSrceSystem
                                                                             and _Current.MDChgProcessSrceObject  = _BPProtectedAddress.MDChgProcessSrceObject
                                                                             and _Current.AddressNumber           = _BPProtectedAddress.AddressNumber

  association [1..1] to I_BPFaxNumberProcess          as _Fax                on  $projection.MasterDataChangeProcess = _Fax.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _Fax.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _Fax.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _Fax.MDChgProcessSrceObject
                                                                             and $projection.AddressNumber           = _Fax.AddressNumber
                                                                             and $projection.OrdinalNumber           = _Fax.OrdinalNumber
{

  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.AddressNumber,
  key _Current.OrdinalNumber,
  key _Current.Language,
  key _ModelField.MDChgProcessModelTableName,
  key _ModelField.MDChangeProcessModelFieldName,
  key cast( concat(concat(concat(
            concat(_Current.MDChgProcessSrceSystem,
            concat( '%%', _Current.MDChgProcessSrceObject)),
            concat( '%%', _Current.AddressNumber)),
            concat( '%%', _Current.OrdinalNumber)),
            concat( '%%', _Current.Language))
        as abap.char(1000) )                          as MDChgProcessRecordObjectID,
      _ModelField.MDChangeProcModelTableDesc,
      _ModelField.MDChangeProcessModelFieldDesc,
      cast( 'BPProcFaxNumberText' as fieldname )          as MDChgProcModelNodeExternalName,
      cast( 'I_BPFaxNumberTextProcTP' as fieldname )      as MDChgProcModTableExternalName,
      cast( '' as fieldname )                         as MDChgProcModFieldExternalName,
      cast( '' as abap.char( 260 ) )                  as MDChgProcCurrentAttributeValue,
      cast( '' as abap.char( 260 ) )                  as MDChgProcPrevAttributeValue,
      cast( '' as boolean )                           as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,
      _Current.CommunicationRemarkText                as MDChgProcessRecordObjectText,
        /* Associations */
      _BusinessPartner,
      _BPProtectedAddress,
      _Fax
}
where
  _Current.MDChgProcessSourceModified = 'X'

Depth:

I_BPFaxTextProcChanges view_entity

I_BPFaxNumberTextProc view_entity
I_BPFaxNumberTextProc view_entity

C_BPFaxTextProcChanges view_entity