C_ProcmtHubRefDeliveryAddrIDVH
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)
| Source | Alias | Join Type |
|---|---|---|
| I_Address | Address | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_BackendSourceSystem | _BackendSourceSystem | $projection.ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA