I_BPINDEPPHONENUMBERTEXTPROC

CDS View

Core View: Addr-Indep Telephone Text

I_BPINDEPPHONENUMBERTEXTPROC is a CDS View in S/4HANA. Core View: Addr-Indep Telephone Text. It contains 8 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 8 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPIndepEmailTextProcChanges view_entity union_all Indep Email Number Text Changes
I_BPIndepPhoneNumberTextProcTP view_entity from TRANSACTIONAL BP Address-Indep Phone Text (Process)
I_BPIndepPhoneTextProcChanges view_entity from BP Address-Indep Phone Number Text Chngs
I_BPIndepPhoneTextProcChanges view_entity union_all BP Address-Indep Phone Number Text Chngs
I_BPIndepWbsteTextProcChanges view_entity union_all Indep Website Text Changes

Fields (8)

KeyField CDS FieldsUsed in Views
KEY Language Language 3
KEY MasterDataChangeProcess MasterDataChangeProcess 3
KEY MDChgProcessSrceObject MDChgProcessSrceObject 3
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 3
KEY MDChgProcessStep MDChgProcessStep 3
KEY OrdinalNumber OrdinalNumber 3
CommunicationRemarkText MDChgProcessRecordObjectText 3
MDChgProcessSourceModified MDChgProcessSourceModified 3 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Core View: Addr-Indep Telephone Text'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPIndepPhoneNumberTextProc
  as select from but_adr2t_in_prc as _text inner join but_adr2_in_prc as _phone 
  on _text.process_id = _phone.process_id and _text.process_step_no = _phone.process_step_no and _text.source_system = _phone.source_system and
     _text.source_id = _phone.source_id and _text.consnumber = _phone.consnumber
     
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner    on  _text.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                        and _text.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                        and _text.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                        and _text.source_id       = _BusinessPartner.MDChgProcessSrceObject
{
  key _text.process_id               as MasterDataChangeProcess,
  key _text.process_step_no          as MDChgProcessStep,
  key _text.source_system            as MDChgProcessSrceSystem,
  key _text.source_id                as MDChgProcessSrceObject,
  key _text.consnumber               as OrdinalNumber,
  key _text.langu                    as Language,
      _text.date_from                as AddrCommunicationValidFromDate,
      _text.addrnumber               as AddressNumber,
      _text.remark                   as CommunicationRemarkText,
      _text.source_recency           as MDChgProcSrceLastChgdDateTime,
      _text.source_modified          as MDChgProcessSourceModified,
      _text.source_modification_blip as MDChgProcessSourceModifBinary,

      _BusinessPartner
} where
       _phone.r3_user = '' 
    or _phone.r3_user = '1'

Learn More