I_BUSPARTTELEPHONENUMBERPROC

CDS View

Core View: Bus Part Telephone (Process)

I_BUSPARTTELEPHONENUMBERPROC is a CDS View in S/4HANA. Core View: Bus Part Telephone (Process). It contains 7 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 7 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPTelNumberProcessChanges view from TRANSACTIONAL Business Partner Process Changes
I_BPTelNumberProcessChanges view union_all TRANSACTIONAL Business Partner Process Changes
I_BusPartTelephoneNumberGov view from BASIC BP Governance Telephone Number
I_BusPartTelephoneNumberProcTP view_entity from TRANSACTIONAL BP Telephone Number (Process Data)

Fields (7)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY OrdinalNumber OrdinalNumber 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Core View: Bus Part Telephone (Process)'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusPartTelephoneNumberProc
  as select from I_BusPartPhoneNumbersProc as _PhoneNumber

{
  key _PhoneNumber.MasterDataChangeProcess        as MasterDataChangeProcess,
  key _PhoneNumber.MDChgProcessStep               as MDChgProcessStep,
  key _PhoneNumber.MDChgProcessSrceSystem         as MDChgProcessSrceSystem,
  key _PhoneNumber.MDChgProcessSrceObject         as MDChgProcessSrceObject,
  key _PhoneNumber.AddressNumber                  as AddressNumber,
  key _PhoneNumber.OrdinalNumber                  as OrdinalNumber,
      _PhoneNumber.AddrCommunicationValidFromDate as AddrCommunicationValidFromDate,
      _PhoneNumber.DestinationLocationCountry     as DestinationLocationCountry,
      case _PhoneNumber.PhoneNumberType
        when '1'
          then cast('X' as boole_d)
        else
          cast(' ' as boole_d)
      end                                         as IsDefaultPhoneNumber,
      _PhoneNumber.CommNumberIsNotUsed            as CommNumberIsNotUsed,
      _PhoneNumber.PhoneNumber                    as PhoneNumber,
      _PhoneNumber.PhoneNumberExtension           as PhoneNumberExtension,
      _PhoneNumber.InternationalPhoneNumber       as InternationalPhoneNumber,
      _PhoneNumber.PhoneIsSMSEnabled              as PhoneIsSMSEnabled,
      _PhoneNumber.PhoneNumberType                as PhoneNumberType,
      _PhoneNumber.ValidityStartDateTime          as ValidityStartDateTime,
      _PhoneNumber.ValidityEndDateTime            as ValidityEndDateTime,
      _PhoneNumber.MDChgProcessSourceModified     as MDChgProcessSourceModified,
      _PhoneNumber.MDChgProcessSourceModifBinary  as MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,

      _BPProtectedAddress,
      _BusinessPartner

}
where
     PhoneNumberType = ''
  or PhoneNumberType = '1'

Learn More