I_BPCntctPersnMblNumberProcTP

DDL: I_BPCNTCTPERSNMBLNUMBERPROCTP Type: view_entity TRANSACTIONAL Package: MDC_BP_REL_GOV_BO

Workplace Addr Mobile Nmber Proc - TP

I_BPCntctPersnMblNumberProcTP is a Transactional CDS View that provides data about "Workplace Addr Mobile Nmber Proc - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCntctPersnMblNumberProc) and exposes 28 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 5 associations to related views. Part of development package MDC_BP_REL_GOV_BO.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCntctPersnMblNumberProc I_BPCntctPersnMblNumberProc from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_BusPartRelationshipProcessTP _BPRelProcess $projection.MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess and $projection.MDChgProcessStep = _BPRelProcess.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BPRelProcess.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BPRelProcess.MDChgProcessSrceObject
[0..1] I_BusPartTelCountryPrefix _TelCountryPrefix $projection.MobilePhoneCountry = _TelCountryPrefix.Country
[0..1] I_BPRelshpProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workplace Addr Mobile Nmber Proc - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY AddressNumber AddressNumber
KEY OrdinalNumber OrdinalNumber
AddrCommunicationValidFromDate AddrCommunicationValidFromDate
MobilePhoneCountry MobilePhoneCountry
TelephoneCountryPrefix _TelCountryPrefix TelephoneCountryPrefix
IsDefaultPhoneNumber IsDefaultPhoneNumber
CommNumberIsNotUsed CommNumberIsNotUsed
MobilePhoneNumber MobilePhoneNumber
CompleteTelephoneNumber CompleteTelephoneNumber
PhoneIsSMSEnabled PhoneIsSMSEnabled
PhoneNumberType PhoneNumberType
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
datsendasValidityStartDate
datsendasValidityEndDate
AddressLine1Text
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
_BPRelProcess _BPRelProcess
_WorkplaceAddress _WorkplaceAddress
_TelCountryPrefix _TelCountryPrefix
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workplace Addr Mobile Nmber Proc - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@Search.searchable:true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCntctPersnMblNumberProcTP
  as select from I_BPCntctPersnMblNumberProc
  association [1..1] to I_BusPartRelationshipProcessTP        as _BPRelProcess        on  $projection.MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _BPRelProcess.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _BPRelProcess.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _BPRelProcess.MDChgProcessSrceObject
  association        to parent I_BPContactPersonAddressProcTP as _WorkplaceAddress    on  $projection.MasterDataChangeProcess = _WorkplaceAddress.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _WorkplaceAddress.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _WorkplaceAddress.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _WorkplaceAddress.MDChgProcessSrceObject
                                                                                      and $projection.AddressNumber           = _WorkplaceAddress.AddressNumber
  association [0..1] to I_BusPartTelCountryPrefix             as _TelCountryPrefix    on  $projection.MobilePhoneCountry = _TelCountryPrefix.Country
  association [0..1] to I_BPRelshpProcessKPIRecordType        as _RecordType          on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH             as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..*] to I_MDChgProcRecordMessages             as _RecordMessages      on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject

{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key AddressNumber,
  key OrdinalNumber,
      AddrCommunicationValidFromDate,
      MobilePhoneCountry,
      _TelCountryPrefix.TelephoneCountryPrefix                             as TelephoneCountryPrefix,
      IsDefaultPhoneNumber,
      CommNumberIsNotUsed,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      MobilePhoneNumber,
      CompleteTelephoneNumber,
      @Semantics.booleanIndicator
      PhoneIsSMSEnabled,
      PhoneNumberType,
      ValidityStartDateTime,
      ValidityEndDateTime,
      @Semantics.businessDate.from: true
      case when ValidityStartDateTime != ''
      then cast ( (substring(ValidityStartDateTime,1,8) ) as abap.dats )
      else cast ( '00010101' as abap.dats )
      end                                                                  as ValidityStartDate,
      @Semantics.businessDate.to: true
      case when ValidityEndDateTime != ''
      then cast ( (substring(ValidityEndDateTime,1,8) ) as abap.dats )
      else cast ( '99991231' as abap.dats )
      end                                                                  as ValidityEndDate,
      /* Record Identification */
      cast( '' as abap.char(209) ) as AddressLine1Text,
      cast( case
              when MDChgProcessSourceModified = '' then 'N'
              when MDChgProcessSourceModified = 'X' then 'M'
              else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,

      /* Associations */
      _BPRelProcess,
      _WorkplaceAddress,
      _TelCountryPrefix,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}

Learn More