I_BPCustDocAssgmtProcChanges

Q: Which tables does I_BPCustDocAssgmtProcChanges use?

I_BPCustDocAssgmtProcChanges reads from 2 data source(s): I_BPCustDocumentAssgmtProc, I_BPCustDocumentAssgmtProc.

Q: How many fields does I_BPCustDocAssgmtProcChanges have?

I_BPCustDocAssgmtProcChanges has 49 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DocumentInfoRecordDocType.

DDL: I_BPCUSTDOCASSGMTPROCCHANGES Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

BP Customer Document Assignment Changes

I_BPCustDocAssgmtProcChanges is a Transactional CDS View that provides data about "BP Customer Document Assignment Changes" in SAP S/4HANA. It reads from 2 data sources (I_BPCustDocumentAssgmtProc, I_BPCustDocumentAssgmtProc) and exposes 49 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DocumentInfoRecordDocType. It has 1 association to related views. Part of development package MDC_CUST_STAGING_BO.

Data Sources (2)

Source	Alias	Join Type
I_BPCustDocumentAssgmtProc	_Current	from
I_BPCustDocumentAssgmtProc	_Current	union_all

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_BPCustomerProcess	_Customer	`$projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	BP Customer Document Assignment Changes	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#TRANSACTIONAL	view

Fields (49)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BPCustDocumentAssgmtProc	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCustDocumentAssgmtProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCustDocumentAssgmtProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCustDocumentAssgmtProc	MDChgProcessSrceObject
KEY	DocumentInfoRecordDocType	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocType
KEY	DocumentInfoRecordDocNumber	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocNumber
KEY	DocumentInfoRecordDocVersion	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocVersion
KEY	DocumentInfoRecordDocPart	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocPart
KEY	LinkedSAPObject	I_BPCustDocumentAssgmtProc	LinkedSAPObject
KEY	LinkedSAPObjectKey	I_BPCustDocumentAssgmtProc	LinkedSAPObjectKey
KEY	DocObjectLinkCounter	I_BPCustDocumentAssgmtProc	DocObjectLinkCounter
KEY	MDChgProcessModelTableName	_ModelTable	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelTable	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPCustDocumentAssgmtProc	MDChgProcessSourceModified
	char260asMDChgProcessRecordObjectText
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCustDocumentAssgmtProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCustDocumentAssgmtProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCustDocumentAssgmtProc	MDChgProcessSrceObject
KEY	DocumentInfoRecordDocType	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocType
KEY	DocumentInfoRecordDocNumber	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocNumber
KEY	DocumentInfoRecordDocVersion	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocVersion
KEY	DocumentInfoRecordDocPart	I_BPCustDocumentAssgmtProc	DocumentInfoRecordDocPart
KEY	LinkedSAPObject	I_BPCustDocumentAssgmtProc	LinkedSAPObject
KEY	LinkedSAPObjectKey	I_BPCustDocumentAssgmtProc	LinkedSAPObjectKey
KEY	DocObjectLinkCounter	I_BPCustDocumentAssgmtProc	DocObjectLinkCounter
KEY	MDChgProcessModelTableName	_ModelField	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName	_ModelField	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelField	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc	_ModelField	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPCustDocumentAssgmtProc	MDChgProcessSourceModified
	char260asMDChgProcessRecordObjectText
	_Customer		_Customer

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Document Assignment Changes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustDocAssgmtProcChanges
  as select from           I_BPCustDocumentAssgmtProc  as _Current
    left outer to one join I_MDChangeProcessModelTable as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'KNA1_DARD'
                                                                      and _ModelTable.MDChgProcessSrceObjectTypeCode = '147'
  association [1..1] to I_BPCustomerProcess as _Customer on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                         and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                         and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                         and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject

{
  key  _Current.MasterDataChangeProcess,
  key  _Current.MDChgProcessStep,
  key  _Current.MDChgProcessSrceSystem,
  key  _Current.MDChgProcessSrceObject,
  key  _Current.DocumentInfoRecordDocType,
  key  _Current.DocumentInfoRecordDocNumber,
  key  _Current.DocumentInfoRecordDocVersion,
  key  _Current.DocumentInfoRecordDocPart,
  key  _Current.LinkedSAPObject,
  key  _Current.LinkedSAPObjectKey,
  key  _Current.DocObjectLinkCounter,
  key  _ModelTable.MDChgProcessModelTableName,
  key  cast ( '' as fieldname )                            as MDChangeProcessModelFieldName,
  key  cast( concat(
               concat(
                 concat( _Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject )),
               concat( '%%', _Current.BPAssignmentID )),
             concat( '%%', _Current.DocumentInfoRecordDocType ))
         as abap.char(1000) )                              as MDChgProcessRecordObjectID,
       _ModelTable.MDChangeProcModelTableDesc,
       cast ('' as as4text  )                              as MDChangeProcessModelFieldDesc,
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement: true
       cast( 'BusPartCustomerDocument' as fieldname ) as MDChgProcModelNodeExternalName,
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement: true
       cast( 'I_BPCustDocumentAssgmtProcTP' as fieldname ) as MDChgProcModTableExternalName,
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement: true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
       cast( '' as fieldname )                             as MDChgProcModFieldExternalName,
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement: true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
       cast( '' as abap.char( 260 ) )                      as MDChgProcCurrentAttributeValue,
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement: true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
       cast( '' as abap.char( 260 ) )                      as MDChgProcPrevAttributeValue,
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement: true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_CUST_PROCTP_CALC_EXIT'
       cast( '' as boolean )                               as MDChgProcessAttributeIsChanged,
       _Current.MDChgProcessSourceModified,
       cast( concat_with_space(coalesce(_Current.DocumentInfoRecordDocType,'') ,
             concat( concat( '(', _Current.DocumentInfoRecordDocType ), ')' ) , 1 )
         as abap.char( 260 ) )                             as MDChgProcessRecordObjectText,
       _Customer
}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

union all select from     I_BPCustDocumentAssgmtProc  as _Current
  left outer to many join I_MDChangeProcessModelField as _ModelField on  _ModelField.MDChgProcessModelTableName     = 'KNA1_DRAD'
                                                                     and _ModelField.MDChgProcessSrceObjectTypeCode = '147'
association [1..1] to I_BPCustomerProcess as _Customer on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                       and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                       and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                       and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject

{
  key  _Current.MasterDataChangeProcess,
  key  _Current.MDChgProcessStep,
  key  _Current.MDChgProcessSrceSystem,
  key  _Current.MDChgProcessSrceObject,
  key  _Current.DocumentInfoRecordDocType,
  key  _Current.DocumentInfoRecordDocNumber,
  key  _Current.DocumentInfoRecordDocVersion,
  key  _Current.DocumentInfoRecordDocPart,
  key  _Current.LinkedSAPObject,
  key  _Current.LinkedSAPObjectKey,
  key  _Current.DocObjectLinkCounter,
  key  _ModelField.MDChgProcessModelTableName,
  key  _ModelField.MDChangeProcessModelFieldName,
  key  cast( concat(
               concat(
                 concat( _Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject )),
               concat( '%%', _Current.BPAssignmentID )),
             concat( '%%', _Current.DocumentInfoRecordDocType ))
         as abap.char(1000) )                               as MDChgProcessRecordObjectID,
       _ModelField.MDChangeProcModelTableDesc,
       _ModelField.MDChangeProcessModelFieldDesc,
       cast( 'BusPartCustomerDocument' as fieldname ) as MDChgProcModelNodeExternalName,
       cast( 'I_BPCustDocumentAssgmtProcTP' 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,
       cast( concat_with_space(coalesce(_Current.DocumentInfoRecordDocType,'') ,
             concat( concat( '(', _Current.DocumentInfoRecordDocType ), ')' ) , 1 )
         as abap.char( 260 ) )                              as MDChgProcessRecordObjectText,
       _Customer
}
where
  _Current.MDChgProcessSourceModified = 'X'

Depth:

I_BPCustDocAssgmtProcChanges view_entity

I_BPCustDocumentAssgmtProc view_entity
I_BPCustDocumentAssgmtProc view_entity

C_BPCustDocAssgmtProcChanges view_entity
I_BPCustProcessChangesUnion view_entity