I_BPWEBSITEURL_2

CDS View

BP Website

I_BPWEBSITEURL_2 is a CDS View in S/4HANA. BP Website. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BusPartWebsiteURLTP_2 view_entity from TRANSACTIONAL Transactional View for BP Website with RAP 
@AbapCatalog.sqlViewName: 'IBPWEBSITE_2'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Website'
@AccessControl.personalData.blocking: #REQUIRED
//@AccessControl.privilegedAssociations:  [ '_BPDataControllerUsage' ]

//@Analytics : {dataCategory: #DIMENSION}      // Need to check

@VDM.viewType: #BASIC 
@ObjectModel.representativeKey: 'AddressID' // Need to check

@AbapCatalog.preserveKey:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true

define view I_BPWebsiteURL_2 
    as select from I_AddressURI 
        inner join but020 on I_AddressURI.AddressID = but020.addrnumber

association[1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

association [0..1] to I_BPProtectedAddress as _BPProtectedAddress on $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner
                                                                   and $projection.AddressID = _BPProtectedAddress.AddressID
//association [0..*] to I_BPDataControllerUsage as _BPDataControllerUsage on  $projection.BusinessPartner = _BPDataControllerUsage.BusinessPartner                                                                   

{
    key but020.partner as BusinessPartner,
    key I_AddressURI.AddressID,
    key I_AddressURI.AddressPersonID as Person,
    key I_AddressURI.CommMediumSequenceNumber as OrdinalNumber,
    cast ( '00010101' as abap.dats) as ValidityStartDate,
    I_AddressURI.URLIsCurrentDefault as IsDefaultURLAddress,    
    cast ( '' as ad_flnouse ) as CommNumberIsNotUsed, 
    I_AddressURI.AddressManagementURIType as UniformResourceIdentifierType,  
    cast ( '' as ad_uri2 ) as SearchURLAddress , 
    cast ('00000' as abap.int4 ) as URLFieldLength,
    
    I_AddressURI.UniformResourceIdentifier as WebsiteURL, 
        
    _BusinessPartner,
    _BPProtectedAddress,
    I_AddressURI._AddressCommunicationRemark,
 //   _BPDataControllerUsage,

    I_AddressURI._AddressManagementURIType 
}
where
  ( I_AddressURI.AddressPersonID = ' ' or _BusinessPartner.BusinessPartnerCategory = '1') ////Do not return Person Workplace Addresses

Learn More