C_CntrlPurOrderDelivAddr

DDL: C_CNTRLPURORDERDELIVADDR SQL: CPUDELADDR Type: view CONSUMPTION
15 Fields 1 Data Sources 1 Associations

Central Purchase Order Delivery Address

C_CntrlPurOrderDelivAddr is a Consumption CDS View that provides data about "Central Purchase Order Delivery Address" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurOrderDelivAddr) and exposes 15 fields with key fields PurchaseOrder, PurchaseOrderItem, ExtSourceSystem, ItemDeliveryAddressID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurOrderDelivAddr _CPOAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_CentralPurchaseOrderTP _CentralPurchaseOrder $projection.PurchaseOrder = _CentralPurchaseOrder.ProcurementHubPO and $projection.ExtSourceSystem = _CentralPurchaseOrder.ExtSourceSystem

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName CPUDELADDR view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Purchase Order Delivery Address view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY ExtSourceSystem ExtSourceSystem Connected System ID
KEY ItemDeliveryAddressID ItemDeliveryAddressID Address
Plant Plant Valuation Area
BusinessPartnerName1 I_CntrlPurOrderDelivAddr BusinessPartnerName1 Name
BusinessPartnerName2 I_CntrlPurOrderDelivAddr BusinessPartnerName2 Name 2
FullName I_CntrlPurOrderDelivAddr FullName Name
StreetName I_CntrlPurOrderDelivAddr StreetName Text
HouseNumber I_CntrlPurOrderDelivAddr HouseNumber House Number
PostalCode I_CntrlPurOrderDelivAddr PostalCode Postal Code
CityName I_CntrlPurOrderDelivAddr CityName Name
Region I_CntrlPurOrderDelivAddr Region Venue Region
Country I_CntrlPurOrderDelivAddr Country Venue: Ctry/Reg
_CentralPurchaseOrder _CentralPurchaseOrder

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_CntrlPurOrderDelivAddr.
-- 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: CPUDELADDR

CREATE VIEW C_CntrlPurOrderDelivAddr AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ExtSourceSystem,
  ItemDeliveryAddressID,
  Plant,
  _CPOAddress.BusinessPartnerName1 AS BusinessPartnerName1,
  _CPOAddress.BusinessPartnerName2 AS BusinessPartnerName2,
  _CPOAddress.FullName AS FullName,
  _CPOAddress.StreetName AS StreetName,
  _CPOAddress.HouseNumber AS HouseNumber,
  _CPOAddress.PostalCode AS PostalCode,
  _CPOAddress.CityName AS CityName,
  _CPOAddress.Region AS Region,
  _CPOAddress.Country AS Country
FROM I_CntrlPurOrderDelivAddr AS _CPOAddress
LEFT OUTER JOIN C_CentralPurchaseOrderTP AS _CentralPurchaseOrder ON PurchaseOrder = _CentralPurchaseOrder.ProcurementHubPO AND ExtSourceSystem = _CentralPurchaseOrder.ExtSourceSystem  -- association [1..1]
;

Learn More