C_SupplierAddressIDValueHelp

@AbapCatalog.sqlViewName: 'CSUPLADDRIDVH'
@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: 'Supplier 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_SupplierAddressIDValueHelp as select distinct from I_Supplier as Supplier 
left outer join I_Address as Address on Address.AddressID = Supplier.AddressID{

    @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1 }
    @UI.lineItem: [{position: 30}]
    @UI.selectionField: { position: 30 }
    key cast(Supplier.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(Supplier.Supplier as caaddr_supplierid 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,
        
    Supplier.SupplierName,
    //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
    Supplier.Supplier,
    @UI.hidden: true
    Supplier.AuthorizationGroup,
    @UI.hidden: true
    Supplier.SupplierAccountGroup,
    @UI.hidden: true
    Supplier.IsBusinessPurposeCompleted,
     
    @Consumption.hidden:true
    @UI.hidden:true
    Supplier.DataControllerSet
} 
where Supplier.AddressID is not null and Supplier.AddressID != '' and Supplier.AddressID is null