I_BPCustSlsTextProcessChanges

Q: Which tables does I_BPCustSlsTextProcessChanges use?

I_BPCustSlsTextProcessChanges reads from 2 data source(s): I_BPCustomerSalesTextProcess, I_BPCustSalesTextGeneralProc.

Q: How many fields does I_BPCustSlsTextProcessChanges have?

I_BPCustSlsTextProcessChanges has 51 fields. Key fields: MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ApplicationTextObjectType.

DDL: I_BPCUSTSLSTEXTPROCESSCHANGES Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

BP Customer Sales Desc Changes

I_BPCustSlsTextProcessChanges is a Transactional CDS View that provides data about "BP Customer Sales Desc Changes" in SAP S/4HANA. It reads from 2 data sources (I_BPCustomerSalesTextProcess, I_BPCustSalesTextGeneralProc) and exposes 51 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ApplicationTextObjectType. It has 2 associations to related views. Part of development package MDC_CUST_STAGING_BO.

Data Sources (2)

Source	Alias	Join Type
I_BPCustomerSalesTextProcess	_Current	from
I_BPCustSalesTextGeneralProc	_Current	union_all

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_BPCustSalesTextGeneralProc	_CustomerSalesTextGeneral	$projection.MasterDataChangeProcess = _CustomerSalesTextGeneral.MasterDataChangeProcess and $projection.MDChgProcessStep = _CustomerSalesTextGeneral.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _CustomerSalesTextGeneral.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _CustomerSalesTextGeneral.MDChgProcessSrceObject and $projection.SalesOrganization = _CustomerSalesTextGeneral.SalesOrganization and $projection.DistributionChannel = _CustomerSalesTextGeneral.DistributionChannel and $projection.Division = _CustomerSalesTextGeneral.Division and $projection.ApplicationTextObjectType = _CustomerSalesTextGeneral.ApplicationTextObjectType and $projection.TextObjectKey = _CustomerSalesTextGeneral.TextObjectKey and $projection.LongTextID = _CustomerSalesTextGeneral.LongTextID and $projection.Language = _CustomerSalesTextGeneral.Language
[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	#NOT_REQUIRED	view
EndUserText.label	BP Customer Sales Desc Changes	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#TRANSACTIONAL	view

Fields (51)

Key	Field	Source Table	Source Field
KEY	MasterDataChangeProcess	I_BPCustSalesTextGeneralProc	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCustSalesTextGeneralProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCustSalesTextGeneralProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCustSalesTextGeneralProc	MDChgProcessSrceObject
KEY	ApplicationTextObjectType	I_BPCustSalesTextGeneralProc	ApplicationTextObjectType
KEY	TextObjectKey	I_BPCustSalesTextGeneralProc	TextObjectKey
KEY	LongTextID	I_BPCustSalesTextGeneralProc	LongTextID
KEY	Language	I_BPCustSalesTextGeneralProc	Language
KEY	SalesOrganization	I_BPCustSalesTextGeneralProc	SalesOrganization
KEY	DistributionChannel	I_BPCustSalesTextGeneralProc	DistributionChannel
KEY	Division	I_BPCustSalesTextGeneralProc	Division
KEY	MDChgProcessModelTableName	_ModelTable	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelTable	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPCustSalesTextGeneralProc	MDChgProcessSourceModified
	LanguageasMDChgProcessRecordObjectText
	_Customer		_Customer
	MasterDataChangeProcess
KEY	MDChgProcessStep	I_BPCustSalesTextGeneralProc	MDChgProcessStep
KEY	MDChgProcessSrceSystem	I_BPCustSalesTextGeneralProc	MDChgProcessSrceSystem
KEY	MDChgProcessSrceObject	I_BPCustSalesTextGeneralProc	MDChgProcessSrceObject
KEY	ApplicationTextObjectType	I_BPCustSalesTextGeneralProc	ApplicationTextObjectType
KEY	TextObjectKey	I_BPCustSalesTextGeneralProc	TextObjectKey
KEY	LongTextID	I_BPCustSalesTextGeneralProc	LongTextID
KEY	Language	I_BPCustSalesTextGeneralProc	Language
KEY	SalesOrganization	I_BPCustSalesTextGeneralProc	SalesOrganization
KEY	DistributionChannel	I_BPCustSalesTextGeneralProc	DistributionChannel
KEY	Division	I_BPCustSalesTextGeneralProc	Division
KEY	MDChgProcessModelTableName	_ModelField	MDChgProcessModelTableName
KEY	MDChangeProcessModelFieldName	_ModelField	MDChangeProcessModelFieldName
KEY	char1000asMDChgProcessRecordObjectID
	MDChangeProcModelTableDesc	_ModelField	MDChangeProcModelTableDesc
	MDChangeProcessModelFieldDesc	_ModelField	MDChangeProcessModelFieldDesc
	MDChgProcModelNodeExternalName
	MDChgProcModTableExternalName
	MDChgProcModFieldExternalName
	MDChgProcCurrentAttributeValue
	MDChgProcPrevAttributeValue
	MDChgProcessAttributeIsChanged
	MDChgProcessSourceModified	I_BPCustSalesTextGeneralProc	MDChgProcessSourceModified
	LanguageasMDChgProcessRecordObjectText
	_Customer		_Customer
	_CustomerSalesTextGeneral		_CustomerSalesTextGeneral

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'BP Customer Sales Desc Changes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustSlsTextProcessChanges
  as select from           I_BPCustomerSalesTextProcess as _Current
    left outer to one join I_MDChangeProcessModelTable  as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'KNVV_STXL'
                                                                       and _ModelTable.MDChgProcessSrceObjectTypeCode = '147'


  association [0..1] to I_BPCustSalesTextGeneralProc as _CustomerSalesTextGeneral on  $projection.MasterDataChangeProcess   = _CustomerSalesTextGeneral.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep          = _CustomerSalesTextGeneral.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem    = _CustomerSalesTextGeneral.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject    = _CustomerSalesTextGeneral.MDChgProcessSrceObject
  //                                                                       and $projection.BPAssignmentID  = _CustomerSales. BPAssignmentID

                                                                                  and $projection.SalesOrganization         = _CustomerSalesTextGeneral.SalesOrganization
                                                                                  and $projection.DistributionChannel       = _CustomerSalesTextGeneral.DistributionChannel
                                                                                  and $projection.Division                  = _CustomerSalesTextGeneral.Division
                                                                                  and $projection.ApplicationTextObjectType = _CustomerSalesTextGeneral.ApplicationTextObjectType
                                                                                  and $projection.TextObjectKey             = _CustomerSalesTextGeneral.TextObjectKey
                                                                                  and $projection.LongTextID                = _CustomerSalesTextGeneral.LongTextID
                                                                                  and $projection.Language                  = _CustomerSalesTextGeneral.Language

  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.ApplicationTextObjectType,
  key _Current.TextObjectKey,
  key _Current.LongTextID,
  key _Current.Language,
  key _Current.SalesOrganization,
  key _Current.DistributionChannel,
  key _Current.Division,
  key _ModelTable.MDChgProcessModelTableName,
  key cast ( '' as fieldname )                              as MDChangeProcessModelFieldName,

  key cast( concat( concat( concat( concat( concat(
            concat( _Current.MDChgProcessSrceSystem,
            concat( '%%', _Current.MDChgProcessSrceObject )),
            concat( '%%', _Current.BPAssignmentID )),
            concat( '%%', _Current.ApplicationTextObjectType )),
            concat( '%%', _Current.TextObjectKey )),
            concat( '%%', _Current.LongTextID )),
            concat( '%%', _Current.Language ))
        as abap.char(1000) )                                as MDChgProcessRecordObjectID,
      _ModelTable.MDChangeProcModelTableDesc,
      cast ('' as as4text  )                                as MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BusPartCustomerSalesText' as fieldname )    as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BPCustomerSalesTextProcessTP' 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,
      concat( concat(
      concat( ' ', _Current.TextObjectKey ),
      concat( ' ', _Current.LongTextID )),
      concat( ' ', _Current.Language ))                     as MDChgProcessRecordObjectText,

      _Customer,
      _CustomerSalesTextGeneral
}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

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


association [0..1] to I_BPCustSalesTextGeneralProc as _CustomerSalesTextGeneral on  $projection.MasterDataChangeProcess   = _CustomerSalesTextGeneral.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep          = _CustomerSalesTextGeneral.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem    = _CustomerSalesTextGeneral.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject    = _CustomerSalesTextGeneral.MDChgProcessSrceObject
//                                                                       and $projection.BPAssignmentID  = _CustomerSales. BPAssignmentID

                                                                                and $projection.SalesOrganization         = _CustomerSalesTextGeneral.SalesOrganization
                                                                                and $projection.DistributionChannel       = _CustomerSalesTextGeneral.DistributionChannel
                                                                                and $projection.Division                  = _CustomerSalesTextGeneral.Division
                                                                                and $projection.ApplicationTextObjectType = _CustomerSalesTextGeneral.ApplicationTextObjectType
                                                                                and $projection.TextObjectKey             = _CustomerSalesTextGeneral.TextObjectKey
                                                                                and $projection.LongTextID                = _CustomerSalesTextGeneral.LongTextID
                                                                                and $projection.Language                  = _CustomerSalesTextGeneral.Language

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.ApplicationTextObjectType,
  key _Current.TextObjectKey,
  key _Current.LongTextID,
  key _Current.Language,
  key _Current.SalesOrganization,
  key _Current.DistributionChannel,
  key _Current.Division,
  key _ModelField.MDChgProcessModelTableName,
  key _ModelField.MDChangeProcessModelFieldName,
  key cast( concat( concat( concat( concat( concat(
            concat( _Current.MDChgProcessSrceSystem,
            concat( '%%', _Current.MDChgProcessSrceObject )),
            concat( '%%', _Current.BPAssignmentID )),
            concat( '%%', _Current.ApplicationTextObjectType )),
            concat( '%%', _Current.TextObjectKey )),
            concat( '%%', _Current.LongTextID )),
            concat( '%%', _Current.Language ))
        as abap.char(1000) )                                as MDChgProcessRecordObjectID,
      _ModelField.MDChangeProcModelTableDesc,
      _ModelField.MDChangeProcessModelFieldDesc,
      cast( 'BusPartCustomerSalesText' as fieldname )    as MDChgProcModelNodeExternalName,
      cast( 'I_BPCustomerSalesTextProcessTP' 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,
      concat( concat(
      concat( ' ', _Current.TextObjectKey ),
      concat( ' ', _Current.LongTextID )),
      concat( ' ', _Current.Language ))                     as MDChgProcessRecordObjectText,
      
      _Customer,
      _CustomerSalesTextGeneral
}
where
  _Current.MDChgProcessSourceModified = 'X'

Depth:

I_BPCustSlsTextProcessChanges view_entity

I_BPCustomerSalesTextProcess view_entity
I_BPCustSalesTextGeneralProc view_entity

C_BPCustSlsTextProcessChanges view_entity
I_BPCustProcessChangesUnion view_entity