I_BPWebsiteURLTP

@AbapCatalog.sqlViewName: 'IBPWEBSITEURLTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Website'
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true
@ObjectModel.writeDraftPersistence: 'BUPA_WEBURL_D'
@ObjectModel.draftEnabled:true

@ObjectModel.semanticKey: ['BusinessPartner','AddressID','Person', 'OrdinalNumber', 'ValidityStartDate', 'IsDefaultURLAddress' ] // Need to check

@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BPWebsiteURLTP as select from I_BPWebsiteURL as BPWebsiteURL

association [1..1] to I_BusinessPartnerTP as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to I_BusinessPartnerAddressTP as _BusinessPartnerAddress on  $projection.AddressID = _BusinessPartnerAddress.AddressNumber
                                                                             and $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner


{
      
  key BPWebsiteURL.BusinessPartner,
  key BPWebsiteURL.AddressID,
  key BPWebsiteURL.Person,
  key BPWebsiteURL.OrdinalNumber,
  key BPWebsiteURL.ValidityStartDate,
  key BPWebsiteURL.IsDefaultURLAddress,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #HIGH
  BPWebsiteURL.SearchURLAddress ,
  _AddressCommunicationRemark.AddressCommunicationRemarkText,  
  BPWebsiteURL.URLFieldLength ,
  //@Search.defaultSearchElement: true

  //@Search.fuzzinessThreshold: 0.8

  //@Search.ranking: #HIGH

  @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
  BPWebsiteURL.WebsiteURL,
  @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
  _BusinessPartner,
  @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
  _BusinessPartnerAddress
}