I_BPIndepPhoneTextProcChanges

DDL: I_BPINDEPPHONETEXTPROCCHANGES Type: view_entity Package: MDC_BUPA_GOV_BO

BP Address-Indep Phone Number Text Chngs

I_BPIndepPhoneTextProcChanges is a CDS View that provides data about "BP Address-Indep Phone Number Text Chngs" in SAP S/4HANA. It reads from 2 data sources (I_BPIndepPhoneNumberTextProc, I_BPIndepPhoneNumberTextProc) and exposes 41 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, OrdinalNumber. It has 2 associations to related views. Part of development package MDC_BUPA_GOV_BO.

2 data source(s) 41 fields

Data Sources (2)

SourceAliasJoin Type
I_BPIndepPhoneNumberTextProc _Current from
I_BPIndepPhoneNumberTextProc _Current union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerProcess _BusinessPartner $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartner.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartner.MDChgProcessSrceObject
[1..1] I_BPIndepTelephoneNumberProc _Telephone $projection.MasterDataChangeProcess = _Telephone.MasterDataChangeProcess and $projection.MDChgProcessStep = _Telephone.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Telephone.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Telephone.MDChgProcessSrceObject and $projection.OrdinalNumber = _Telephone.OrdinalNumber

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Address-Indep Phone Number Text Chngs view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_BPIndepPhoneNumberTextProc MasterDataChangeProcess
KEY MDChgProcessStep I_BPIndepPhoneNumberTextProc MDChgProcessStep
KEY MDChgProcessSrceSystem I_BPIndepPhoneNumberTextProc MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BPIndepPhoneNumberTextProc MDChgProcessSrceObject
KEY OrdinalNumber I_BPIndepPhoneNumberTextProc OrdinalNumber
KEY Language I_BPIndepPhoneNumberTextProc Language
KEY MDChgProcessModelTableName _ModelTable MDChgProcessModelTableName
KEY MDChangeProcessModelFieldName
KEY char1000asMDChgProcessRecordObjectID
MDChangeProcModelTableDesc _ModelTable MDChangeProcModelTableDesc
MDChangeProcessModelFieldDesc
MDChgProcModelNodeExternalName
MDChgProcModTableExternalName
MDChgProcModFieldExternalName
MDChgProcCurrentAttributeValue
MDChgProcPrevAttributeValue
MDChgProcessAttributeIsChanged
MDChgProcessSourceModified I_BPIndepPhoneNumberTextProc MDChgProcessSourceModified
MDChgProcessRecordObjectText I_BPIndepPhoneNumberTextProc CommunicationRemarkText
_BusinessPartner _BusinessPartner
MasterDataChangeProcess
KEY MDChgProcessStep I_BPIndepPhoneNumberTextProc MDChgProcessStep
KEY MDChgProcessSrceSystem I_BPIndepPhoneNumberTextProc MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BPIndepPhoneNumberTextProc MDChgProcessSrceObject
KEY OrdinalNumber I_BPIndepPhoneNumberTextProc OrdinalNumber
KEY Language I_BPIndepPhoneNumberTextProc 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_BPIndepPhoneNumberTextProc MDChgProcessSourceModified
MDChgProcessRecordObjectText I_BPIndepPhoneNumberTextProc CommunicationRemarkText
_BusinessPartner _BusinessPartner
_Telephone _Telephone 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Address-Indep Phone Number Text Chngs'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPIndepPhoneTextProcChanges
as select from          I_BPIndepPhoneNumberTextProc    as _Current
     left outer to one join I_MDChangeProcessModelTable as _ModelTable on  _ModelTable.MDChgProcessModelTableName     = 'ADR2T_IN'
                                                                       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 [1..1] to I_BPIndepTelephoneNumberProc  as _Telephone          on  $projection.MasterDataChangeProcess = _Telephone.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _Telephone.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _Telephone.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _Telephone.MDChgProcessSrceObject
                                                                             and $projection.OrdinalNumber           = _Telephone.OrdinalNumber
{
  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.OrdinalNumber,
  key _Current.Language,
  key _ModelTable.MDChgProcessModelTableName,
  key cast ( '' as fieldname )                              as MDChangeProcessModelFieldName,
  key cast( concat(concat(
            concat(_Current.MDChgProcessSrceSystem, 
            concat( '%%', _Current.MDChgProcessSrceObject)),
            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( 'BPProcIndepPhoneNumberText' as fieldname )      as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BPIndepPhoneNumberTextProcTP' 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,
      _Telephone
}
where
     _Current.MDChgProcessSourceModified = 'I'
  or _Current.MDChgProcessSourceModified = 'D'

union all select from     I_BPIndepPhoneNumberTextProc as _Current
  left outer to many join I_MDChangeProcessModelField as _ModelField on _ModelField.MDChgProcessModelTableName = 'ADR2T_IN'
                                                                     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 [1..1] to I_BPIndepTelephoneNumberProc  as _Telephone          on  $projection.MasterDataChangeProcess = _Telephone.MasterDataChangeProcess
                                                                             and $projection.MDChgProcessStep        = _Telephone.MDChgProcessStep
                                                                             and $projection.MDChgProcessSrceSystem  = _Telephone.MDChgProcessSrceSystem
                                                                             and $projection.MDChgProcessSrceObject  = _Telephone.MDChgProcessSrceObject
                                                                             and $projection.OrdinalNumber           = _Telephone.OrdinalNumber
{

  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.OrdinalNumber,
  key _Current.Language,
  key _ModelField.MDChgProcessModelTableName,
  key _ModelField.MDChangeProcessModelFieldName,
  key cast( concat(concat(
            concat(_Current.MDChgProcessSrceSystem, 
            concat( '%%', _Current.MDChgProcessSrceObject)),
            concat( '%%', _Current.OrdinalNumber)),
            concat( '%%', _Current.Language)) as abap.char(1000) ) as MDChgProcessRecordObjectID,
      _ModelField.MDChangeProcModelTableDesc,
      _ModelField.MDChangeProcessModelFieldDesc,
      cast( 'BPProcIndepPhoneNumberText' as fieldname )     as MDChgProcModelNodeExternalName,
      cast( 'I_BPIndepPhoneNumberTextProcTP' 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,
      _Telephone
}
where
  _Current.MDChgProcessSourceModified = 'X'

Learn More