C_PlantAddressIDValueHelp

@AbapCatalog.sqlViewName: 'CPLNTADDRIDVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations: ['_Address']
@ObjectModel.semanticKey: 'FullName'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Plant Address ID Value Help'
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true

@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_PlantAddressIDValueHelp as select distinct from I_Plant as Plant
{
    @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1 }
    @UI.lineItem: [{position: 30}]
    @UI.selectionField: { position: 30 }
    key cast(Plant.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(Plant.Plant as caaddr_plantid 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,
    
    Plant.PlantName,  
    //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,
    _Address._DefaultEmailAddress.EmailAddress,
    _Address
}
where Plant.AddressID is not null and Plant.AddressID != ''