I_BPINDEPWEBSITEURLPROC

CDS View

Base View for BUT_ADR12_IN_PRC

I_BPINDEPWEBSITEURLPROC is a CDS View in S/4HANA. Base View for BUT_ADR12_IN_PRC. It contains 8 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 8 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPIndepWebsiteURLProcChanges view_entity from BP Independent Website Changes
I_BPIndepWebsiteURLProcChanges view_entity union_all BP Independent Website Changes
I_BPIndepWebsiteURLProcTP view_entity from BP Addr Independent Website

Fields (8)

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
SearchURLAddress MDChgProcessRecordObjectText 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Base View for BUT_ADR12_IN_PRC'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPIndepWebsiteURLProc
  as select from but_adr12_in_prc
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner on  but_adr12_in_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                     and but_adr12_in_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                     and but_adr12_in_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                     and but_adr12_in_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject

{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key consnumber               as OrdinalNumber,
      date_from                as AddrCommunicationValidFromDate,
      //but_adr12_in_prc.source_index             as SourceIndex,

      //but_adr12_in_prc.home_flag                as HomeFlag,

      addrnumber               as AddressNumber,
      flgdefault               as IsDefaultURLAddress,
      flg_nouse                as CommNumberIsNotUsed,
      uri_type                 as UniformResourceIdentifierType,
      uri_srch                 as SearchURLAddress,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      //cast (uri_addr as string) as WebsiteURL,

      uri_length               as URLFieldLength,
      uri_addr                 as WebsiteURL,
      _BusinessPartner

}

Learn More