@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
@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,
@Consumption.hidden: true
@UI.hidden: true
Customer.DataController1,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController2,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController3,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController4,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController5,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController6,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController7,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController8,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController9,
@UI.hidden: true
@Consumption.hidden: true
Customer.DataController10
}
where
Customer.AddressID is not null
and Customer.AddressID != ''
and Customer.AddressID is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_ADDRESSEMAILADDRESS",
"I_CUSTOMER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/