I_BPCntctPersnWbsteURLProcChgs

DDL: I_BPCNTCTPERSNWBSTEURLPROCCHGS Type: view_entity TRANSACTIONAL

BP Contact Person Workplace Address Website Process Changes

I_BPCntctPersnWbsteURLProcChgs is a Transactional CDS View that provides data about "BP Contact Person Workplace Address Website Process Changes" in SAP S/4HANA. It reads from 4 data sources (I_BusPartRelationshipProcess, I_BusPartRelationshipProcess, I_BPCntctPersnWebsiteURLProc, I_BPCntctPersnWebsiteURLProc) and exposes 97 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 1 association to related views.

4 data source(s) 97 fields

Data Sources (4)

SourceAliasJoin Type
I_BusPartRelationshipProcess _BPRelationship inner
I_BusPartRelationshipProcess _BPRelationship inner
I_BPCntctPersnWebsiteURLProc _Current from
I_BPCntctPersnWebsiteURLProc _Current union_all

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BusPartRelshpCategoryDesc _RelationshipCategoryText $projection.RelationshipCategory = _RelationshipCategoryText.RelationshipCategory and $projection.BPRelshpCatIsInFwdDirection = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label BP Contact Person Workplace Address Website Process Changes view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (97)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_BPCntctPersnWebsiteURLProc MasterDataChangeProcess
KEY MDChgProcessStep I_BPCntctPersnWebsiteURLProc MDChgProcessStep
KEY MDChgProcessSrceSystem I_BPCntctPersnWebsiteURLProc MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BPCntctPersnWebsiteURLProc MDChgProcessSrceObject
KEY AddressNumber I_BPCntctPersnWebsiteURLProc AddressNumber
KEY OrdinalNumber I_BPCntctPersnWebsiteURLProc OrdinalNumber
KEY MDChgProcessModelTableName _ModelTable MDChgProcessModelTableName
KEY MDChangeProcessModelFieldName
KEY MDChgProcessRecordObjectID
MDChgProcessSrceBusPart1 I_BusPartRelationshipProcess MDChgProcessSrceBusPart1
MDChgProcessSrceBusPart2 I_BusPartRelationshipProcess MDChgProcessSrceBusPart2
RelationshipCategory I_BusPartRelationshipProcess RelationshipCategory
BPRelshpCatIsInFwdDirection I_BusPartRelationshipProcess BPRelshpCatIsInFwdDirection
BP1AuthorizationGroup I_BusPartRelationshipProcess BP1AuthorizationGroup
BP2AuthorizationGroup I_BusPartRelationshipProcess BP2AuthorizationGroup
BP1DataControllerSet I_BusPartRelationshipProcess BP1DataControllerSet
BP1DataController1 I_BusPartRelationshipProcess BP1DataController1
BP1DataController2 I_BusPartRelationshipProcess BP1DataController2
BP1DataController3 I_BusPartRelationshipProcess BP1DataController3
BP1DataController4 I_BusPartRelationshipProcess BP1DataController4
BP1DataController5 I_BusPartRelationshipProcess BP1DataController5
BP1DataController6 I_BusPartRelationshipProcess BP1DataController6
BP1DataController7 I_BusPartRelationshipProcess BP1DataController7
BP1DataController8 I_BusPartRelationshipProcess BP1DataController8
BP1DataController9 I_BusPartRelationshipProcess BP1DataController9
BP1DataController10 I_BusPartRelationshipProcess BP1DataController10
BP2DataControllerSet I_BusPartRelationshipProcess BP2DataControllerSet
BP2DataController1 I_BusPartRelationshipProcess BP2DataController1
BP2DataController2 I_BusPartRelationshipProcess BP2DataController2
BP2DataController3 I_BusPartRelationshipProcess BP2DataController3
BP2DataController4 I_BusPartRelationshipProcess BP2DataController4
BP2DataController5 I_BusPartRelationshipProcess BP2DataController5
BP2DataController6 I_BusPartRelationshipProcess BP2DataController6
BP2DataController7 I_BusPartRelationshipProcess BP2DataController7
BP2DataController8 I_BusPartRelationshipProcess BP2DataController8
BP2DataController9 I_BusPartRelationshipProcess BP2DataController9
BP2DataController10 I_BusPartRelationshipProcess BP2DataController10
MDChangeProcModelTableDesc _ModelTable MDChangeProcModelTableDesc
MDChangeProcessModelFieldDesc
MDChgProcModelNodeExternalName
MDChgProcModTableExternalName
MDChgProcModFieldExternalName
MDChgProcCurrentAttributeValue
MDChgProcPrevAttributeValue
MDChgProcessAttributeIsChanged
MDChgProcessSourceModified I_BPCntctPersnWebsiteURLProc MDChgProcessSourceModified
_BPRelProcess I_BPCntctPersnWebsiteURLProc _BPRelProcess
_WorkplaceAddress I_BPCntctPersnWebsiteURLProc _WorkplaceAddress
MasterDataChangeProcess
KEY MDChgProcessStep I_BPCntctPersnWebsiteURLProc MDChgProcessStep
KEY MDChgProcessSrceSystem I_BPCntctPersnWebsiteURLProc MDChgProcessSrceSystem
KEY MDChgProcessSrceObject I_BPCntctPersnWebsiteURLProc MDChgProcessSrceObject
KEY AddressNumber I_BPCntctPersnWebsiteURLProc AddressNumber
KEY OrdinalNumber I_BPCntctPersnWebsiteURLProc OrdinalNumber
KEY MDChgProcessModelTableName _ModelField MDChgProcessModelTableName
KEY MDChangeProcessModelFieldName _ModelField MDChangeProcessModelFieldName
KEY MDChgProcessRecordObjectID
MDChgProcessSrceBusPart1 I_BusPartRelationshipProcess MDChgProcessSrceBusPart1
MDChgProcessSrceBusPart2 I_BusPartRelationshipProcess MDChgProcessSrceBusPart2
RelationshipCategory I_BusPartRelationshipProcess RelationshipCategory
BPRelshpCatIsInFwdDirection I_BusPartRelationshipProcess BPRelshpCatIsInFwdDirection
BP1AuthorizationGroup I_BusPartRelationshipProcess BP1AuthorizationGroup
BP2AuthorizationGroup I_BusPartRelationshipProcess BP2AuthorizationGroup
BP1DataControllerSet I_BusPartRelationshipProcess BP1DataControllerSet
BP1DataController1 I_BusPartRelationshipProcess BP1DataController1
BP1DataController2 I_BusPartRelationshipProcess BP1DataController2
BP1DataController3 I_BusPartRelationshipProcess BP1DataController3
BP1DataController4 I_BusPartRelationshipProcess BP1DataController4
BP1DataController5 I_BusPartRelationshipProcess BP1DataController5
BP1DataController6 I_BusPartRelationshipProcess BP1DataController6
BP1DataController7 I_BusPartRelationshipProcess BP1DataController7
BP1DataController8 I_BusPartRelationshipProcess BP1DataController8
BP1DataController9 I_BusPartRelationshipProcess BP1DataController9
BP1DataController10 I_BusPartRelationshipProcess BP1DataController10
BP2DataControllerSet I_BusPartRelationshipProcess BP2DataControllerSet
BP2DataController1 I_BusPartRelationshipProcess BP2DataController1
BP2DataController2 I_BusPartRelationshipProcess BP2DataController2
BP2DataController3 I_BusPartRelationshipProcess BP2DataController3
BP2DataController4 I_BusPartRelationshipProcess BP2DataController4
BP2DataController5 I_BusPartRelationshipProcess BP2DataController5
BP2DataController6 I_BusPartRelationshipProcess BP2DataController6
BP2DataController7 I_BusPartRelationshipProcess BP2DataController7
BP2DataController8 I_BusPartRelationshipProcess BP2DataController8
BP2DataController9 I_BusPartRelationshipProcess BP2DataController9
BP2DataController10 I_BusPartRelationshipProcess BP2DataController10
MDChangeProcModelTableDesc _ModelField MDChangeProcModelTableDesc
ddtextendasMDChangeProcessModelFieldDesc
MDChgProcModelNodeExternalName
MDChgProcModTableExternalName
MDChgProcModFieldExternalName
MDChgProcCurrentAttributeValue
MDChgProcPrevAttributeValue
MDChgProcessAttributeIsChanged
MDChgProcessSourceModified I_BPCntctPersnWebsiteURLProc MDChgProcessSourceModified
_BPRelProcess I_BPCntctPersnWebsiteURLProc _BPRelProcess
_WorkplaceAddress I_BPCntctPersnWebsiteURLProc _WorkplaceAddress
_RelationshipCategoryText _RelationshipCategoryText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BP Contact Person Workplace Address Website Process Changes'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_BPCntctPersnWbsteURLProcChgs
  as select from           I_BPCntctPersnWebsiteURLProc as _Current
    left outer to one join I_MDChangeProcessModelTable  as _ModelTable     on  _ModelTable.MDChgProcessModelTableName     = 'ADR12'
                                                                           and _ModelTable.MDChgProcessSrceObjectTypeCode = '1405'
    inner join             I_BusPartRelationshipProcess as _BPRelationship on  _Current.MasterDataChangeProcess = _BPRelationship.MasterDataChangeProcess
                                                                           and _Current.MDChgProcessStep        = _BPRelationship.MDChgProcessStep
                                                                           and _Current.MDChgProcessSrceSystem  = _BPRelationship.MDChgProcessSrceSystem
                                                                           and _Current.MDChgProcessSrceObject  = _BPRelationship.MDChgProcessSrceObject
  association [0..*] to I_BusPartRelshpCategoryDesc as _RelationshipCategoryText on  $projection.RelationshipCategory        = _RelationshipCategoryText.RelationshipCategory
                                                                                 and $projection.BPRelshpCatIsInFwdDirection = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection
{

  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.AddressNumber,
  key _Current.OrdinalNumber,
  key _ModelTable.MDChgProcessModelTableName,
  key cast ( '' as fieldname )                                                                                                                                                                                                   as MDChangeProcessModelFieldName,
  key cast ( concat( concat( concat( _Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject )), concat( '%%', _Current.AddressNumber ) ), concat( '%%', _Current.OrdinalNumber ) )  as abap.char(1000) ) as MDChgProcessRecordObjectID,
      _BPRelationship.MDChgProcessSrceBusPart1,
      _BPRelationship.MDChgProcessSrceBusPart2,
      _BPRelationship.RelationshipCategory,
      @Semantics.booleanIndicator: true
      _BPRelationship.BPRelshpCatIsInFwdDirection,
      _BPRelationship.BP1AuthorizationGroup,
      _BPRelationship.BP2AuthorizationGroup,
      _BPRelationship.BP1DataControllerSet,
      _BPRelationship.BP1DataController1,
      _BPRelationship.BP1DataController2,
      _BPRelationship.BP1DataController3,
      _BPRelationship.BP1DataController4,
      _BPRelationship.BP1DataController5,
      _BPRelationship.BP1DataController6,
      _BPRelationship.BP1DataController7,
      _BPRelationship.BP1DataController8,
      _BPRelationship.BP1DataController9,
      _BPRelationship.BP1DataController10,
      _BPRelationship.BP2DataControllerSet,
      _BPRelationship.BP2DataController1,
      _BPRelationship.BP2DataController2,
      _BPRelationship.BP2DataController3,
      _BPRelationship.BP2DataController4,
      _BPRelationship.BP2DataController5,
      _BPRelationship.BP2DataController6,
      _BPRelationship.BP2DataController7,
      _BPRelationship.BP2DataController8,
      _BPRelationship.BP2DataController9,
      _BPRelationship.BP2DataController10,
      _ModelTable.MDChangeProcModelTableDesc,
      cast ('' as as4text )                                                                                                                                                                                                      as MDChangeProcessModelFieldDesc,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'BPRelCPWebsite' as fieldname )                                                                                                                                                                                      as MDChgProcModelNodeExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      cast( 'I_BPCntctPersnWebsiteURLProcTP' as fieldname )                                                                                                                                                                      as MDChgProcModTableExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as fieldname )                                                                                                                                                                                                    as MDChgProcModFieldExternalName,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                                                                                                                             as MDChgProcCurrentAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as abap.char( 260 ) )                                                                                                                                                                                             as MDChgProcPrevAttributeValue,
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'
      cast( '' as boolean )                                                                                                                                                                                                      as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,
      concat_with_space(
        concat_with_space(
          concat_with_space(
            concat_with_space( _BPRelationship.BusinessPartnerName1, _RelationshipCategoryText.BusPartRelshpCatDescription, 1 ),
            _BPRelationship.BusinessPartnerName2, 1
          ),
          concat_with_space(
            concat_with_space( _Current._WorkplaceAddress.StreetName, _Current._WorkplaceAddress.HouseNumber, 1 ),
            _Current._WorkplaceAddress.PostalCode, 1
          ),
          1
        ),
        _Current.SearchURLAddress,
        1
      )                                                                                                                                                                                                                          as MDChgProcessRecordObjectText,
      _Current._BPRelProcess,
      _Current._WorkplaceAddress,
      _RelationshipCategoryText
}

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


union all select from     I_BPCntctPersnWebsiteURLProc as _Current
  inner join              I_BusPartRelationshipProcess as _BPRelationship on  _Current.MasterDataChangeProcess = _BPRelationship.MasterDataChangeProcess
                                                                          and _Current.MDChgProcessStep        = _BPRelationship.MDChgProcessStep
                                                                          and _Current.MDChgProcessSrceSystem  = _BPRelationship.MDChgProcessSrceSystem
                                                                          and _Current.MDChgProcessSrceObject  = _BPRelationship.MDChgProcessSrceObject
  left outer to many join I_MDChangeProcessModelField  as _ModelField     on  _ModelField.MDChgProcessModelTableName     = 'ADR12'
                                                                          and _ModelField.MDChgProcessSrceObjectTypeCode = '1405'
  left outer to one join  dd03l                        as dd03l           on  dd03l.tabname   = 'ADR12'
                                                                          and dd03l.fieldname = _ModelField.MDChangeProcessModelFieldName
                                                                          and dd03l.as4local  = 'A'
                                                                          and dd03l.as4vers   = '0000'
  left outer to one join  dd04t                        as dd04t           on  dd04t.rollname   = dd03l.rollname
                                                                          and dd04t.as4local   = dd03l.as4local
                                                                          and dd04t.as4vers    = dd03l.as4vers
                                                                          and dd04t.ddlanguage = $session.system_language
association [0..*] to I_BusPartRelshpCategoryDesc as _RelationshipCategoryText on  $projection.RelationshipCategory        = _RelationshipCategoryText.RelationshipCategory
                                                                               and $projection.BPRelshpCatIsInFwdDirection = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection
{

  key _Current.MasterDataChangeProcess,
  key _Current.MDChgProcessStep,
  key _Current.MDChgProcessSrceSystem,
  key _Current.MDChgProcessSrceObject,
  key _Current.AddressNumber,
  key _Current.OrdinalNumber,
  key _ModelField.MDChgProcessModelTableName,
  key _ModelField.MDChangeProcessModelFieldName,
  key cast ( concat( concat( concat( _Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject )), concat( '%%', _Current.AddressNumber ) ), concat( '%%', _Current.OrdinalNumber ) )  as abap.char(1000) ) as MDChgProcessRecordObjectID,
      _BPRelationship.MDChgProcessSrceBusPart1,
      _BPRelationship.MDChgProcessSrceBusPart2,
      _BPRelationship.RelationshipCategory,
      _BPRelationship.BPRelshpCatIsInFwdDirection,
      _BPRelationship.BP1AuthorizationGroup,
      _BPRelationship.BP2AuthorizationGroup,
      _BPRelationship.BP1DataControllerSet,
      _BPRelationship.BP1DataController1,
      _BPRelationship.BP1DataController2,
      _BPRelationship.BP1DataController3,
      _BPRelationship.BP1DataController4,
      _BPRelationship.BP1DataController5,
      _BPRelationship.BP1DataController6,
      _BPRelationship.BP1DataController7,
      _BPRelationship.BP1DataController8,
      _BPRelationship.BP1DataController9,
      _BPRelationship.BP1DataController10,
      _BPRelationship.BP2DataControllerSet,
      _BPRelationship.BP2DataController1,
      _BPRelationship.BP2DataController2,
      _BPRelationship.BP2DataController3,
      _BPRelationship.BP2DataController4,
      _BPRelationship.BP2DataController5,
      _BPRelationship.BP2DataController6,
      _BPRelationship.BP2DataController7,
      _BPRelationship.BP2DataController8,
      _BPRelationship.BP2DataController9,
      _BPRelationship.BP2DataController10,
      _ModelField.MDChangeProcModelTableDesc,
      case
        when _ModelField.MDChangeProcessModelFieldDesc is not initial
        then _ModelField.MDChangeProcessModelFieldDesc
        else dd04t.ddtext
      end                                                                                                                                                                                                                        as MDChangeProcessModelFieldDesc,
      //      @ObjectModel.readOnly: true

      //      @ObjectModel.virtualElement: true

      cast( 'BPRelCPWebsite' as fieldname )                                                                                                                                                                                      as MDChgProcModelNodeExternalName,
      //      @ObjectModel.readOnly: true

      //      @ObjectModel.virtualElement: true

      cast( 'I_BPCntctPersnWebsiteURLProcTP' as fieldname )                                                                                                                                                                      as MDChgProcModTableExternalName,
      //      @ObjectModel.readOnly: true

      //      @ObjectModel.virtualElement: true

      //      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'

      cast( '' as fieldname )                                                                                                                                                                                                    as MDChgProcModFieldExternalName,
      //      @ObjectModel.readOnly: true

      //      @ObjectModel.virtualElement: true

      //      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'

      cast( '' as abap.char( 260 ) )                                                                                                                                                                                             as MDChgProcCurrentAttributeValue,
      //      @ObjectModel.readOnly: true

      //      @ObjectModel.virtualElement: true

      //      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'

      cast( '' as abap.char( 260 ) )                                                                                                                                                                                             as MDChgProcPrevAttributeValue,
      //      @ObjectModel.readOnly: true

      //      @ObjectModel.virtualElement: true

      //      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_REL_PROCTP_CALC_EXIT'

      cast( '' as boolean )                                                                                                                                                                                                      as MDChgProcessAttributeIsChanged,
      _Current.MDChgProcessSourceModified,
      concat_with_space(
        concat_with_space(
          concat_with_space(
            concat_with_space( _BPRelationship.BusinessPartnerName1, _RelationshipCategoryText.BusPartRelshpCatDescription, 1 ),
            _BPRelationship.BusinessPartnerName2, 1
          ),
          concat_with_space(
            concat_with_space( _Current._WorkplaceAddress.StreetName, _Current._WorkplaceAddress.HouseNumber, 1 ),
            _Current._WorkplaceAddress.PostalCode, 1
          ),
          1
        ),
        _Current.SearchURLAddress,
        1
      )                                                                                                                                                                                                                          as MDChgProcessRecordObjectText,
      _Current._BPRelProcess,
      _Current._WorkplaceAddress,
      _RelationshipCategoryText
}
where
  _Current.MDChgProcessSourceModified = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCNTCTPERSNWEBSITEURLPROC",
"I_BPCONTACTPERSONADDRESSPROC",
"I_BUSPARTRELATIONSHIPPROCESS",
"I_BUSPARTRELSHPCATEGORYDESC",
"I_MDCHANGEPROCESSMODELFIELD",
"I_MDCHANGEPROCESSMODELTABLE",
"DD03L",
"DD04T"
],
"ASSOCIATED":
[
"I_BPCONTACTPERSONADDRESSPROC",
"I_BUSPARTRELATIONSHIPPROCESS",
"I_BUSPARTRELSHPCATEGORYDESC"
],
"BASE":
[
"I_BPCNTCTPERSNWEBSITEURLPROC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More