I_BPCNTCTPERSNMBLNUMBERPROC

CDS View

Workplace Address Mobile Number

I_BPCNTCTPERSNMBLNUMBERPROC is a CDS View in S/4HANA. Workplace Address Mobile Number. It contains 18 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 18 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPCntctPersnMblNmbrProcChgs view_entity from TRANSACTIONAL BP Contact Person Workplace Addr Mobile Phone Proc Changes
I_BPCntctPersnMblNmbrProcChgs view_entity union_all TRANSACTIONAL BP Contact Person Workplace Addr Mobile Phone Proc Changes
I_BPCntctPersnMblNumberProcTP view_entity from TRANSACTIONAL Workplace Addr Mobile Nmber Proc - TP
I_BPContactPersonMblNumberGov view_entity from TRANSACTIONAL Base Union for Workplace Mbl Number
I_BPContactPersonMblNumberGov view_entity union_all TRANSACTIONAL Base Union for Workplace Mbl Number

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 2
KEY MasterDataChangeProcess MasterDataChangeProcess 2
KEY MDChgProcessSrceObject MDChgProcessSrceObject 2
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 2
KEY MDChgProcessStep MDChgProcessStep 2
KEY OrdinalNumber OrdinalNumber 2
_BPRelProcess _BPRelProcess 1
_WorkplaceAddress _WorkplaceAddress 1
CommNumberIsNotUsed CommNumberIsNotUsed 1
CompleteTelephoneNumber InternationalPhoneNumber 1
IsDefaultPhoneNumber IsDefaultPhoneNumber 1
MDChgProcessSourceModified MDChgProcessSourceModified 1
MobilePhoneCountry DestinationLocationCountry 1
MobilePhoneNumber PhoneNumber 1
PhoneIsSMSEnabled PhoneIsSMSEnabled 1
PhoneNumberType PhoneNumberType 1
ValidityEndDateTime ValidityEndDateTime 1
ValidityStartDateTime ValidityStartDateTime 1 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workplace Address Mobile Number'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCntctPersnMblNumberProc
  as select from bur_adr2_prc
  association [1..1] to I_BPContactPersonAddressProc as _WorkplaceAddress on  bur_adr2_prc.process_id        = _WorkplaceAddress.MasterDataChangeProcess
                                                                          and bur_adr2_prc.process_step_no   = _WorkplaceAddress.MDChgProcessStep
                                                                          and bur_adr2_prc.source_system     = _WorkplaceAddress.MDChgProcessSrceSystem
                                                                          and bur_adr2_prc.source_id         = _WorkplaceAddress.MDChgProcessSrceObject
                                                                          and bur_adr2_prc.source_addrnumber = _WorkplaceAddress.AddressNumber
  association [1..1] to I_BusPartRelationshipProcess as _BPRelProcess     on  bur_adr2_prc.process_id      = _BPRelProcess.MasterDataChangeProcess
                                                                          and bur_adr2_prc.process_step_no = _BPRelProcess.MDChgProcessStep
                                                                          and bur_adr2_prc.source_system   = _BPRelProcess.MDChgProcessSrceSystem
                                                                          and bur_adr2_prc.source_id       = _BPRelProcess.MDChgProcessSrceObject
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key source_addrnumber        as AddressNumber,
  key consnumber               as OrdinalNumber,
      date_from                as AddrCommunicationValidFromDate,
      country                  as MobilePhoneCountry,
      case r3_user
        when '3'
          then cast('X' as boole_d)
        else
          cast(' ' as boole_d)
      end                      as IsDefaultPhoneNumber,
      flg_nouse                as CommNumberIsNotUsed,
      tel_number               as MobilePhoneNumber,
      telnr_long               as CompleteTelephoneNumber,
      dft_receiv               as PhoneIsSMSEnabled,
      r3_user                  as PhoneNumberType,
      valid_from               as ValidityStartDateTime,
      valid_to                 as ValidityEndDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,

      //Expose the associations

      _WorkplaceAddress,
      _BPRelProcess
}
where
     r3_user = '2'
  or r3_user = '3'

Learn More