I_BPADDRESSTEXTPROCESS

CDS View

Base View for BUT_ADRCT_PRC

I_BPADDRESSTEXTPROCESS is a CDS View in S/4HANA. Base View for BUT_ADRCT_PRC. It contains 9 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 9 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPAddressTextProcessChanges view_entity from Address Text Changes
I_BPAddressTextProcessChanges view_entity union_all Address Text Changes
I_BPAddressTextProcessTP view_entity from TRANSACTIONAL BP Address Text (Process Data)

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 1
KEY AddressRepresentationCode AddressRepresentationCode 1
KEY Language Language 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
AddressRemarkNote MDChgProcessRecordObjectText 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Base View for BUT_ADRCT_PRC'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPAddressTextProcess
  as select from but_adrct_prc

  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner    on  but_adrct_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                        and but_adrct_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                        and but_adrct_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                        and but_adrct_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BPProtectedAddress     as _BPProtectedAddress on  but_adrct_prc.source_id         = _BPProtectedAddress.BusinessPartner
                                                                        and but_adrct_prc.source_addrnumber = _BPProtectedAddress.AddressID

{
  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 nation                   as AddressRepresentationCode,
  key langu                    as Language,
      date_from                as AddressValidFromDate,

      remark                   as AddressRemarkNote,
      _dataaging               as DataAgingObject,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,

      _BusinessPartner,
      _BPProtectedAddress
      
}

Learn More