I_BPCustTextGeneralProcChgs

DDL: I_BPCUSTTEXTGENERALPROCCHGS Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

BP Customer Desc Data Process Changes

I_BPCustTextGeneralProcChgs is a Transactional CDS View that provides data about "BP Customer Desc Data Process Changes" in SAP S/4HANA. It reads from 2 data sources (I_BPCustomerTextGeneralProcess, I_BPCustomerTextGeneralProcess) and exposes 43 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ApplicationTextObjectType. It has 1 association to related views. Part of development package MDC_CUST_STAGING_BO.

2 data source(s) 43 fields

Data Sources (2)

SourceAliasJoin Type
I_BPCustomerTextGeneralProcess _Current from
I_BPCustomerTextGeneralProcess _Current union_all

Associations (1)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Desc Data Process 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 (43)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_BPCustomerTextGeneralProcess MasterDataChangeProcess
KEY MDChgProcessStep I_BPCustomerTextGeneralProcess MDChgProcessStep
KEY MDChgProcessSrceSystem I_BPCustomerTextGeneralProcess MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BPCustomerTextGeneralProcess MDChgProcessSrceObject
KEY ApplicationTextObjectType I_BPCustomerTextGeneralProcess ApplicationTextObjectType
KEY TextObjectKey I_BPCustomerTextGeneralProcess TextObjectKey
KEY LongTextID I_BPCustomerTextGeneralProcess LongTextID
KEY Language I_BPCustomerTextGeneralProcess Language
KEY MDChgProcessModelTableName _ModelTable MDChgProcessModelTableName
KEY MDChangeProcessModelFieldName
KEY char1000asMDChgProcessRecordObjectID
MDChangeProcModelTableDesc _ModelTable MDChangeProcModelTableDesc
MDChangeProcessModelFieldDesc
MDChgProcModelNodeExternalName
MDChgProcModTableExternalName
MDChgProcModFieldExternalName
MDChgProcCurrentAttributeValue
MDChgProcPrevAttributeValue
MDChgProcessAttributeIsChanged
MDChgProcessSourceModified I_BPCustomerTextGeneralProcess MDChgProcessSourceModified
LanguageasMDChgProcessRecordObjectText
MasterDataChangeProcess
KEY MDChgProcessStep I_BPCustomerTextGeneralProcess MDChgProcessStep
KEY MDChgProcessSrceSystem I_BPCustomerTextGeneralProcess MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BPCustomerTextGeneralProcess MDChgProcessSrceObject
KEY ApplicationTextObjectType I_BPCustomerTextGeneralProcess ApplicationTextObjectType
KEY TextObjectKey I_BPCustomerTextGeneralProcess TextObjectKey
KEY LongTextID I_BPCustomerTextGeneralProcess LongTextID
KEY Language I_BPCustomerTextGeneralProcess 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_BPCustomerTextGeneralProcess MDChgProcessSourceModified
LanguageasMDChgProcessRecordObjectText
_Customer _Customer 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Desc Data Process Changes'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustTextGeneralProcChgs 
 as select from           I_BPCustomerTextGeneralProcess as _Current
    left outer to one join I_MDChangeProcessModelTable    as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'KNA1_STXH'
                                                                         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.ApplicationTextObjectType,
  key _Current.TextObjectKey,
  key _Current.LongTextID,
  key _Current.Language,
  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( 'BusPartCustomerTextGeneral' as fieldname ) as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BPCustomerTextGeneralProcTP' 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
}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

union all select from     I_BPCustomerTextGeneralProcess as _Current
  left outer to many join I_MDChangeProcessModelField    as _ModelField on  _ModelField.MDChgProcessModelTableName     = 'KNA1_STXH'
                                                                        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.ApplicationTextObjectType,
  key _Current.TextObjectKey,
  key _Current.LongTextID,
  key _Current.Language,
  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( 'BusPartCustomerTextGeneral' as fieldname ) as MDChgProcModelNodeExternalName,
      cast( 'I_BPCustomerTextGeneralProcTP' 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
}
where
  _Current.MDChgProcessSourceModified = 'X'

Learn More