C_ProcmtHubRefDeliveryAddrIDVH

DDL: C_PROCMTHUBREFDELIVERYADDRIDVH SQL: CHUBREFDELADDVH Type: view CONSUMPTION

Reference Delivery Addr ID Value Help from Connected System

C_ProcmtHubRefDeliveryAddrIDVH is a Consumption CDS View that provides data about "Reference Delivery Addr ID Value Help from Connected System" in SAP S/4HANA. It reads from 1 data source (I_Address) and exposes 14 fields with key fields ProcurementHubSourceSystem, AddressID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_Address Address from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BackendSourceSystem _BackendSourceSystem $projection.ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CHUBREFDELADDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Reference Delivery Addr ID Value Help from Connected System view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProcurementHubSourceSystem _BackendSourceSystem ProcurementHubSourceSystem
KEY AddressID I_Address AddressID Address Reference Number
Country I_Address Country
Region I_Address Region
SearchTerm1 I_Address SearchTerm1
SearchTerm2 I_Address SearchTerm2
BusinessPartnerName1 I_Address BusinessPartnerName1
StreetName I_Address StreetName
CityName I_Address CityName
FormOfAddress I_Address FormOfAddress
BusinessPartnerName2 I_Address BusinessPartnerName2
HouseNumber I_Address HouseNumber
PostalCode I_Address PostalCode
_BackendSourceSystem _BackendSourceSystem
@AbapCatalog.sqlViewName: 'CHUBREFDELADDVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Reference Delivery Addr ID Value Help from Connected System'
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.semanticKey:  [  'AddressID' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_ProcmtHubRefDeliveryAddrIDVH as select from I_Address as Address
  association [1..1] to I_BackendSourceSystem as _BackendSourceSystem on $projection.ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem
  
  
{
      @Consumption.filter.hidden: true
 key _BackendSourceSystem.ProcurementHubSourceSystem as ProcurementHubSourceSystem,
      @Search: { defaultSearchElement: true, ranking: #HIGH,  fuzzinessThreshold: 0.9 }
      @EndUserText.label: 'Address Reference Number'
  key Address.AddressID                 as AddressID, 
   
      Address.Country                   as Country,   
      Address.Region                    as Region,
      Address.SearchTerm1               as SearchTerm1,
      Address.SearchTerm2               as SearchTerm2, 
      Address.BusinessPartnerName1      as BusinessPartnerName1, 
      Address.StreetName                as StreetName,
      Address.CityName                  as CityName,   
      
      @UI.hidden: true
      Address.FormOfAddress             as FormOfAddress, 
      @UI.hidden: true
      Address.BusinessPartnerName2      as BusinessPartnerName2,
      @UI.hidden: true
      Address.HouseNumber               as HouseNumber,
      @UI.hidden: true
      Address.PostalCode                as PostalCode,  
       
      
        
  
   _BackendSourceSystem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_BACKENDSOURCESYSTEM"
],
"ASSOCIATED":
[
"I_BACKENDSOURCESYSTEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/