I_BPScrOrgAddrProcessChanges

Q: Which tables does I_BPScrOrgAddrProcessChanges use?

I_BPScrOrgAddrProcessChanges reads from 2 data source(s): I_BusPartScriptedOrgAddrProc, I_BusPartScriptedOrgAddrProc.

Q: How many fields does I_BPScrOrgAddrProcessChanges have?

I_BPScrOrgAddrProcessChanges has 43 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber.

DDL: I_BPSCRORGADDRPROCESSCHANGES SQL: IBPSCRORGADDRCHG Type: view TRANSACTIONAL

BP Org Address Version Process Changes

I_BPScrOrgAddrProcessChanges is a Transactional CDS View that provides data about "BP Org Address Version Process Changes" in SAP S/4HANA. It reads from 2 data sources (I_BusPartScriptedOrgAddrProc, I_BusPartScriptedOrgAddrProc) and exposes 43 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 4 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_BusPartScriptedOrgAddrProc	_Current	from
I_BusPartScriptedOrgAddrProc	_Current	union_all

Associations (4)

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`
[1..1]	I_BusinessPartnerAddressProc	_Address	`$projection.MasterDataChangeProcess = _Address.MasterDataChangeProcess and $projection.MDChgProcessStep = _Address.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Address.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Address.MDChgProcessSrceObject and $projection.AddressNumber = _Address.AddressNumber`
[0..1]	I_AddressRepresentationText	_AddressRepresentationText	`$projection.AddressRepresentationCode = _AddressRepresentationText.AddressRepresentationCode and _AddressRepresentationText.Language = $session.system_language`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	IBPSCRORGADDRCHG	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	BP Org Address Version Process Changes	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view
VDM.viewType	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (43)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BusPartScriptedOrgAddrProc	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BusPartScriptedOrgAddrProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BusPartScriptedOrgAddrProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BusPartScriptedOrgAddrProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BusPartScriptedOrgAddrProc	AddressNumber
KEY	AddressRepresentationCode	I_BusPartScriptedOrgAddrProc	AddressRepresentationCode
KEY	MDChgProcessModelTableName	_ModelTable	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelTable	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BusPartScriptedOrgAddrProc	MDChgProcessSourceModified
	_BusinessPartner		_BusinessPartner
	_BPProtectedAddress		_BPProtectedAddress
	_Address		_Address
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BusPartScriptedOrgAddrProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BusPartScriptedOrgAddrProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BusPartScriptedOrgAddrProc	MDChgProcessSrceObject
KEY	AddressNumber	I_BusPartScriptedOrgAddrProc	AddressNumber
KEY	AddressRepresentationCode	I_BusPartScriptedOrgAddrProc	AddressRepresentationCode
KEY	MDChgProcessModelTableName	_ModelField	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName	_ModelField	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelField	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc	_ModelField	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BusPartScriptedOrgAddrProc	MDChgProcessSourceModified
	_BusinessPartner		_BusinessPartner
	_BPProtectedAddress		_BPProtectedAddress
	_Address		_Address
	_AddressRepresentationText		_AddressRepresentationText

@AbapCatalog.sqlViewName: 'IBPSCRORGADDRCHG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BP Org Address Version Process Changes'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_BPScrOrgAddrProcessChanges
  as select from           I_BusPartScriptedOrgAddrProc as _Current
    left outer to one join I_MDChangeProcessModelTable  as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'ADRC'
                                                                       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
  association [1..1] to I_BusinessPartnerAddressProc  as _Address                   on  $projection.MasterDataChangeProcess = _Address.MasterDataChangeProcess
                                                                                    and $projection.MDChgProcessStep        = _Address.MDChgProcessStep
                                                                                    and $projection.MDChgProcessSrceSystem  = _Address.MDChgProcessSrceSystem
                                                                                    and $projection.MDChgProcessSrceObject  = _Address.MDChgProcessSrceObject
                                                                                    and $projection.AddressNumber           = _Address.AddressNumber
  association [0..1] to I_AddressRepresentationText   as _AddressRepresentationText on  $projection.AddressRepresentationCode = _AddressRepresentationText.AddressRepresentationCode
                                                                                    and _AddressRepresentationText.Language   = $session.system_language
{
  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.AddressNumber,
  key _Current.AddressRepresentationCode,
  key _ModelTable.MDChgProcessModelTableName,
  key cast ( '' as fieldname )                                                      as MDChangeProcessModelFieldName,
  key cast( concat(
              concat(
                concat(_Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject)),
              concat( '%%', _Current.AddressNumber)),
            concat( '%%', _Current.AddressRepresentationCode)) as abap.char(1000) ) as MDChgProcessRecordObjectID,
      _ModelTable.MDChangeProcModelTableDesc,
      cast ('' as as4text )                                                         as MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusinessPartnerAddressScrOrg' as fieldname )                           as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BusPartScriptedOrgAddrProcTP' 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,
      concat_with_space(
        concat(
          concat_with_space(
            concat_with_space(
              concat_with_space(
                concat_with_space(_Address.StreetName,_Address.HouseNumber,1)
             ,_Address.PostalCode,1)
           ,_Address.CityName,1)
          ,_Address.Country,1),
        ','),
        concat_with_space( _AddressRepresentationText.AddressRepresentationDesc, concat( '(', concat( _Current.AddressRepresentationCode, ')' ) ), 1 )
      ,1)                                                                           as MDChgProcessRecordObjectText,
      _BusinessPartner,
      _BPProtectedAddress,
      _Address,
      _AddressRepresentationText

}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

union all select from     I_BusPartScriptedOrgAddrProc as _Current
  left outer to many join I_MDChangeProcessModelField  as _ModelField on  (
      _ModelField.MDChgProcessModelTableName                                                                         = 'ADRC'
      or _ModelField.MDChgProcessModelTableName                                                                      = 'BUT020'
    )
                                                                      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
association [1..1] to I_BusinessPartnerAddressProc  as _Address                   on  $projection.MasterDataChangeProcess = _Address.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _Address.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _Address.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _Address.MDChgProcessSrceObject
                                                                                  and $projection.AddressNumber           = _Address.AddressNumber
association [0..1] to I_AddressRepresentationText   as _AddressRepresentationText on  $projection.AddressRepresentationCode = _AddressRepresentationText.AddressRepresentationCode
                                                                                  and _AddressRepresentationText.Language   = $session.system_language
{
      //I_BusinessPartnerProcess

  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.AddressNumber,
  key _Current.AddressRepresentationCode,
  key _ModelField.MDChgProcessModelTableName,
  key _ModelField.MDChangeProcessModelFieldName,
  key cast( concat(
              concat(
                concat(_Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject)),
              concat( '%%', _Current.AddressNumber)),
            concat( '%%', _Current.AddressRepresentationCode)) as abap.char(1000) ) as MDChgProcessRecordObjectID,
      _ModelField.MDChangeProcModelTableDesc,
      _ModelField.MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusinessPartnerAddressScrOrg' as fieldname )                           as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BusPartScriptedOrgAddrProcTP' 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,
      concat_with_space(
        concat(
          concat_with_space(
            concat_with_space(
              concat_with_space(
                concat_with_space(_Address.StreetName,_Address.HouseNumber,1)
             ,_Address.PostalCode,1)
           ,_Address.CityName,1)
          ,_Address.Country,1),
        ','),
        concat_with_space( _AddressRepresentationText.AddressRepresentationDesc, concat( '(', concat( _Current.AddressRepresentationCode, ')' ) ), 1 )
      ,1)                                                                           as MDChgProcessRecordObjectText,
      _BusinessPartner,
      _BPProtectedAddress,
      _Address,
      _AddressRepresentationText
}
where
  _Current.MDChgProcessSourceModified = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSREPRESENTATIONTEXT",
"I_BUSINESSPARTNERADDRESSPROC",
"I_BUSPARTSCRIPTEDORGADDRPROC",
"I_MDCHANGEPROCESSMODELFIELD",
"I_MDCHANGEPROCESSMODELTABLE"
],
"ASSOCIATED":
[
"I_ADDRESSREPRESENTATIONTEXT",
"I_BUSINESSPARTNERADDRESSPROC",
"I_BUSINESSPARTNERPROCESS",
"I_BUSPARTPROTECTEDADDRESSPROC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BPScrOrgAddrProcessChanges view

I_BusPartScriptedOrgAddrProc view_entity
I_BusPartScriptedOrgAddrProc view_entity

C_BPScrOrgAddrProcessChanges view
I_BPProcessChangesUnion view