C_PurchasingDeliveryAddressVH

DDL: C_PURCHASINGDELIVERYADDRESSVH SQL: CPURDELADDRVH Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

Master Delivery Addresses

C_PurchasingDeliveryAddressVH is a Consumption CDS View that provides data about "Master Delivery Addresses" in SAP S/4HANA. It reads from 1 data source (I_OrganizationAddress) and exposes 16 fields with key field AddressID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_OrganizationAddress I_OrganizationAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AddressGroupText _AddressGroupText $projection.AddressGroup = _AddressGroupText.AddressGroup

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CPURDELADDRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey AddressID view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
EndUserText.label Master Delivery Addresses view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_OrganizationAddress AddressID Ship-to address
AddressGroup I_OrganizationAddress AddressGroup
AddressGroupName
AddresseeFullName I_OrganizationAddress AddresseeFullName Full Name
AddresseeName1 I_OrganizationAddress AddresseeName1
AddresseeName2 I_OrganizationAddress AddresseeName2
CityName I_OrganizationAddress CityName Name
StreetName I_OrganizationAddress StreetName Text
Region I_OrganizationAddress Region Venue Region
Country I_OrganizationAddress Country Venue: Ctry/Reg
PostalCode I_OrganizationAddress PostalCode Postal Code
HouseNumber I_OrganizationAddress HouseNumber House Number
AddressSearchTerm1 I_OrganizationAddress AddressSearchTerm1 Search Term 1
AddressSearchTerm2 I_OrganizationAddress AddressSearchTerm2 Search Term 2
_AddressGroup _AddressGroup
_AddressGroupText _AddressGroupText

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_PurchasingDeliveryAddressVH.
-- 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: CPURDELADDRVH

CREATE VIEW C_PurchasingDeliveryAddressVH AS
SELECT
  I_OrganizationAddress.AddressID AS AddressID,
  I_OrganizationAddress.AddressGroup AS AddressGroup,
  _AddressGroupText[1:Language=$session.system_language].AddressGroupName AS AddressGroupName,
  I_OrganizationAddress.AddresseeFullName AS AddresseeFullName,
  I_OrganizationAddress.AddresseeName1 AS AddresseeName1,
  I_OrganizationAddress.AddresseeName2 AS AddresseeName2,
  I_OrganizationAddress.CityName AS CityName,
  I_OrganizationAddress.StreetName AS StreetName,
  I_OrganizationAddress.Region AS Region,
  I_OrganizationAddress.Country AS Country,
  I_OrganizationAddress.PostalCode AS PostalCode,
  I_OrganizationAddress.HouseNumber AS HouseNumber,
  I_OrganizationAddress.AddressSearchTerm1 AS AddressSearchTerm1,
  I_OrganizationAddress.AddressSearchTerm2 AS AddressSearchTerm2
FROM I_OrganizationAddress
LEFT OUTER JOIN I_AddressGroupText AS _AddressGroupText ON AddressGroup = _AddressGroupText.AddressGroup  -- association [0..*]
;

Learn More