C_CustomerAddressIDValueHelp

@AbapCatalog.sqlViewName: 'CCUSTADDRIDVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.semanticKey: 'FullName'
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Customer Address ID Value Help'
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

@UI.presentationVariant.requestAtLeast:  [ 'EmailAddress', 'FullName', 'ReferenceObjectID', 'CareOfName', 'AdditionalStreetSuffixName', 'CorrespondenceLanguage', 'PrfrdCommMediumType', 'POBox', 'POBoxIsWithoutNumber', 'POBoxPostalCode', 'POBoxLobbyName',
'POBoxDeviatingCityName', 'POBoxDeviatingRegion', 'POBoxDeviatingCountry', 'DeliveryServiceTypeCode', 'DeliveryServiceNumber', 'AddressTimeZone', 'CityName', 'District', 'CityCode', 'HomeCityName',
 'PostalCode', 'CompanyPostalCode', 'StreetName', 'StreetPrefixName', 'AdditionalStreetPrefixName', 'StreetSuffixName', 'HouseNumber', 'HouseNumberSupplementText', 'Building', 'Floor', 'RoomNumber',
 'Country', 'Region', 'County', 'FormOfAddress', 'Nation', 'PhoneNumber', 'FaxNumber', 'SearchTerm1', 'StreetSearch', 'CitySearch', 'BusinessPartnerName3', 'BusinessPartnerName4', 'TaxJurisdiction',
 'TransportZone', 'Person']
define view C_CustomerAddressIDValueHelp
  as select distinct from I_Customer as Customer
    left outer join       I_Address  as Address on Address.AddressID = Customer.AddressID
{

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1 }
      @UI.lineItem: [{position: 30}]
      @UI.selectionField: { position: 30 }
  key cast(Customer.AddressID as caaddr_addressid preserving type ) as AddressID,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1 }
      @UI.lineItem: [{position: 10}]
      @UI.selectionField: { position: 10 }
  key cast(Customer.Customer as caaddr_customerid preserving type ) as ReferenceObjectID,

      //    @UI.lineItem: [{position: 20}]

      Address.FullName,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      @UI.lineItem: [{position: 40}]
      @UI.selectionField: { position: 40 }
      Address.BusinessPartnerName1,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      @UI.lineItem: [{position: 50}]
      @UI.selectionField: { position: 50 }
      Address.BusinessPartnerName2,

      @UI.lineItem: [{position: 60}]
      @UI.selectionField: { position: 60 }
      Address.StreetName,

      @UI.lineItem: [{position: 70}]
      //@UI.selectionField: { position: 70 }

      Address.HouseNumber,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1 }
      @UI.lineItem: [{position: 80}]
      @UI.selectionField: { position: 80 }
      Address.PostalCode,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      @UI.lineItem: [{position: 90}]
      @UI.selectionField: { position: 90 }
      Address.CityName,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1 }
      @UI.lineItem: [{position: 100}]
      @UI.selectionField: { position: 100 }
      Address.District,

      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1 }
      @UI.lineItem: [{position: 110}]
      @UI.selectionField: { position: 110 }
      Address.Country,

      @UI.lineItem: [{position: 120}]
      //@UI.selectionField: { position: 120 }

      Address.Region,

      Customer.CustomerName,
      //The rest of the Fields needed to fill all possible addresslayouts


      @Consumption.filter.hidden: true
      Address.CareOfName,
      @Consumption.filter.hidden: true
      Address.AdditionalStreetSuffixName,
      @Consumption.filter.hidden: true
      Address.CorrespondenceLanguage,
      @Consumption.filter.hidden: true
      Address.PrfrdCommMediumType,
      Address.POBox,
      Address.POBoxIsWithoutNumber,
      Address.POBoxPostalCode,
      Address.POBoxLobbyName,
      Address.POBoxDeviatingCityName,
      Address.POBoxDeviatingRegion,
      Address.POBoxDeviatingCountry,
      @Consumption.filter.hidden: true
      Address.DeliveryServiceTypeCode,
      @Consumption.filter.hidden: true
      Address.DeliveryServiceNumber,
      @Consumption.filter.hidden: true
      Address.AddressTimeZone,
      @Consumption.filter.hidden: true
      Address.CityCode,
      @Consumption.filter.hidden: true
      Address.HomeCityName,
      @Consumption.filter.hidden: true
      Address.CompanyPostalCode,
      @Consumption.filter.hidden: true
      Address.StreetPrefixName,
      @Consumption.filter.hidden: true
      Address.AdditionalStreetPrefixName,
      @Consumption.filter.hidden: true
      Address.StreetSuffixName,
      @Consumption.filter.hidden: true
      Address.HouseNumberSupplementText,
      Address.Building,
      Address.Floor,
      Address.RoomNumber,
      Address.County,
      @Consumption.filter.hidden: true
      Address.FormOfAddress,
      @Consumption.filter.hidden: true
      Address.Nation,
      Address.PhoneNumber,
      Address.FaxNumber,
      Address.SearchTerm1,
      @Consumption.filter.hidden: true
      Address.StreetSearch,
      @Consumption.filter.hidden: true
      Address.CitySearch,
      Address.BusinessPartnerName3,
      Address.BusinessPartnerName4,
      Address.TaxJurisdiction,
      Address.TransportZone,
      Address.Person,
      _DefaultEmailAddress.EmailAddress,

      //For Authorization Checks

      @UI.hidden: true
      Customer.Customer,
      @UI.hidden: true
      Customer.CustomerAccountGroup,
      @UI.hidden: true
      Customer.AuthorizationGroup,
      @UI.hidden: true
      Customer.IsBusinessPurposeCompleted,
      @UI.hidden: true
      @Consumption.hidden: true
      Customer.DataControllerSet
}
where
      Customer.AddressID is not null
  and Customer.AddressID != ''
  and Customer.AddressID is null