I_BUSPARTWEBSITEURLPROC

CDS View

shows Business Partner Website (Process)

I_BUSPARTWEBSITEURLPROC is a CDS View in S/4HANA. shows Business Partner Website (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_BPWebsiteURLProcessChanges view from TRANSACTIONAL BP Website Process Changes
I_BPWebsiteURLProcessChanges view union_all TRANSACTIONAL BP Website Process Changes
I_BusPartWebsiteURLGov view from BASIC BP Website URL Governance
I_BusPartWebsiteURLProcTP view_entity from TRANSACTIONAL BP Website URL (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 
@AbapCatalog.sqlViewName: 'IPUBURLPROC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@EndUserText.label: 'shows Business Partner Website (Process)'
define view I_BusPartWebsiteURLProc
  as select from but_adr12_prc
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner    on  but_adr12_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                        and but_adr12_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                        and but_adr12_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                        and but_adr12_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BPProtectedAddress     as _BPProtectedAddress on  but_adr12_prc.source_id         = _BPProtectedAddress.BusinessPartner
                                                                        and but_adr12_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 consnumber               as OrdinalNumber,
      //  key date_from         as ValidityStartDateTime,

      //      addrnumber        as AddressID,

      flgdefault               as IsDefaultURLAddress,
      flg_nouse                as CommNumberIsNotUsed,
      //      home_flag         as

      uri_type                 as UniformResourceIdentifierType,
      uri_srch                 as SearchURLAddress,
      //      dft_receiv        as ,

      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,
      uri_length               as URLFieldLength,
      uri_addr                 as WebsiteURL,

      _BusinessPartner,
      _BPProtectedAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BUT_ADR12_PRC"
],
"ASSOCIATED":
[
"I_BPPROTECTEDADDRESS",
"I_BUSINESSPARTNERPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More