I_ADDRESSHOMEPAGEURL

CDS View

Homepage URL Address

I_ADDRESSHOMEPAGEURL is a CDS View in S/4HANA. Homepage URL Address. It contains 10 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 10 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_AddressHomePageURL view from BASIC Home Page URL
A_BPContactWrkPlaceHomePageURL view inner BASIC BP Contact Work Place URL Address
I_BPContactWbsteURLTP view inner TRANSACTIONAL BO view for BP contact Website URL

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY IsDefaultURLAddress IsDefaultURLAddress 3
KEY OrdinalNumber OrdinalNumber,OrdinalNumberForEdit 3
KEY Person Person 1
KEY ValidityStartDate ValidityStartDate 1
CommNumberIsNotUsed CommNumberIsNotUsed 2
SearchURLAddress SearchURLAddress 2
UniformResourceIdentifierType UniformResourceIdentifierType 2
URLFieldLength URLFieldLength 1
WebsiteURL CorporateWebsiteURL,WebsiteURL 2 
@AbapCatalog.sqlViewName: 'IADDRHOMEPAGEURL'
@EndUserText.label: 'Homepage URL Address'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@AbapCatalog.preserveKey: true
define view I_AddressHomepageURL as select from adr12
  association [0..1] to I_AddressCommunicationRemark as _AddressCommunicationRemark on $projection.AddressID = _AddressCommunicationRemark.AddressID
                                                                                 and $projection.Person = _AddressCommunicationRemark.Person
                                                                                 and $projection.OrdinalNumber = _AddressCommunicationRemark.OrdinalNumber
                                                                                 and _AddressCommunicationRemark.CommunicationMediumType = 'URI'
                                                                                 and _AddressCommunicationRemark.CorrespondenceLanguage = $session.system_language
{
  key addrnumber as AddressID,
  key persnumber as Person,
  key consnumber as OrdinalNumber,
  key date_from as ValidityStartDate,
  key flgdefault as IsDefaultURLAddress,
  uri_srch as SearchURLAddress,
  flg_nouse as CommNumberIsNotUsed,
  uri_type as UniformResourceIdentifierType,
  uri_length as URLFieldLength,  
  adr12.uri_addr as WebsiteURL,

  _AddressCommunicationRemark
} 
where date_from = '00010101'                  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADR12"
],
"ASSOCIATED":
[
"I_ADDRESSCOMMUNICATIONREMARK"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More