C_ProcmtHubRefDeliveryAddrIDVH

DDL: C_PROCMTHUBREFDELIVERYADDRIDVH SQL: CHUBREFDELADDVH Type: view CONSUMPTION
14 Fields 1 Data Sources 1 Associations

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 Connected System ID
KEY AddressID I_Address AddressID Address Reference Number
Country I_Address Country Venue: Ctry/Reg
Region I_Address Region Venue Region
SearchTerm1 I_Address SearchTerm1 Search Term 1
SearchTerm2 I_Address SearchTerm2 Search Term 2
BusinessPartnerName1 I_Address BusinessPartnerName1 Name
StreetName I_Address StreetName Text
CityName I_Address CityName Name
FormOfAddress I_Address FormOfAddress Title Key
BusinessPartnerName2 I_Address BusinessPartnerName2 Name 2
HouseNumber I_Address HouseNumber House Number
PostalCode I_Address PostalCode Postal Code
_BackendSourceSystem _BackendSourceSystem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProcmtHubRefDeliveryAddrIDVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CHUBREFDELADDVH

CREATE VIEW C_ProcmtHubRefDeliveryAddrIDVH AS
SELECT
  _BackendSourceSystem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  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,
  Address.FormOfAddress AS FormOfAddress,
  Address.BusinessPartnerName2 AS BusinessPartnerName2,
  Address.HouseNumber AS HouseNumber,
  Address.PostalCode AS PostalCode
FROM I_Address AS Address
LEFT OUTER JOIN I_BackendSourceSystem AS _BackendSourceSystem ON ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem  -- association [1..1]
;

Learn More