C_PurchasingDeliveryAddressVH

@AbapCatalog.sqlViewName: 'CPURDELADDRVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@VDM.viewType: #CONSUMPTION

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'AddressID'

@ObjectModel.modelingPattern:#NONE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true
@Consumption.ranked: true

@ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
@EndUserText.label: 'Master Delivery Addresses'

define view C_PurchasingDeliveryAddressVH
  as select from I_OrganizationAddress
    
association [0..*] to I_AddressGroupText                 as _AddressGroupText                  on  $projection.AddressGroup = _AddressGroupText.AddressGroup
     
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key I_OrganizationAddress.AddressID,
  
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.text.element: ['AddressGroupName']
//      @ObjectModel.text.association: '_AddressGroupText'

      I_OrganizationAddress.AddressGroup,
        
      @Semantics.text:true
      @UI.hidden: true    
      _AddressGroupText[1:Language=$session.system_language].AddressGroupName,
      
      I_OrganizationAddress.AddresseeFullName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.AddresseeName1,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.AddresseeName2,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.CityName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.StreetName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.Region,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.Country,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.PostalCode,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.HouseNumber,
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #MEDIUM
      I_OrganizationAddress.AddressSearchTerm1,
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #MEDIUM
      I_OrganizationAddress.AddressSearchTerm2,
      
      _AddressGroup,
      _AddressGroupText
      
   
      
      
      
} where ( AddressGroup = 'ME01' 
     or AddressGroup = 'BP' 
     or AddressGroup = 'CA01'
     or AddressGroup = 'ME02'
     or AddressGroup = 'ME03'
     or AddressGroup = 'PM01'
     or AddressGroup = 'PS02'
     or AddressGroup = 'PSL2'
     or AddressGroup = 'SCTM' )
and AddressRepresentationCode = ' '
and AddressPersonID = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSGROUPTEXT",
"I_ORGANIZATIONADDRESS"
],
"ASSOCIATED":
[
"I_ADDRESSGROUP",
"I_ADDRESSGROUPTEXT"
],
"BASE":
[
"I_ORGANIZATIONADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/