C_PurOrdDeliveryAddressTP

DDL: C_PURORDDELIVERYADDRESSTP Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2
20 Fields 1 Data Sources 4 Associations

Purchase Order Delivery Address

C_PurOrdDeliveryAddressTP is a Consumption CDS View that provides data about "Purchase Order Delivery Address" in SAP S/4HANA. It reads from 1 data source (I_PurOrdDeliveryAddressTP) and exposes 20 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 4 associations to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdDeliveryAddressTP PurOrdDeliveryAddressTP from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_PurchaseOrderTP _PurchaseOrderTP _PurchaseOrderTP.PurchaseOrder = $projection.PurchaseOrder
[1..1] C_PurchaseOrderItemTP _PurchaseOrderItemTP _PurchaseOrderItemTP.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderItemTP.PurchaseOrderItem = $projection.PurchaseOrderItem
[0..1] C_MM_CountryValueHelp _CountryValueHelp _CountryValueHelp.Country = $projection.Country
[0..1] C_MM_RegionValueHelp _RegionValueHelp _RegionValueHelp.Country = $projection.Country and _RegionValueHelp.Region = $projection.Region

Annotations (12)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPODELADDTP view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Order Delivery Address view
AccessControl.authorizationCheck #CHECK view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey PurchaseOrderItem view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
ItemDeliveryAddressID ItemDeliveryAddressID Address
FullName FullName Name
StreetName StreetName Text
HouseNumber HouseNumber House Number
PostalCode PostalCode Postal Code
CityName CityName Name
PhoneNumber PhoneNumber Telephone no.
FaxNumber FaxNumber Fax Number
Region Region Venue Region
RegionName _RegionValueHelp RegionName Description
Country Country Venue: Ctry/Reg
CountryName _CountryValueHelp CountryName Country
CorrespondenceLanguage CorrespondenceLanguage Language
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
_PurchaseOrderTP _PurchaseOrderTP
_PurchaseOrderItemTP _PurchaseOrderItemTP
_CountryValueHelp _CountryValueHelp
_RegionValueHelp _RegionValueHelp

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_PurOrdDeliveryAddressTP.
-- 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.

CREATE VIEW C_PurOrdDeliveryAddressTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ItemDeliveryAddressID,
  FullName,
  StreetName,
  HouseNumber,
  PostalCode,
  CityName,
  PhoneNumber,
  FaxNumber,
  Region,
  _RegionValueHelp.RegionName AS RegionName,
  Country,
  _CountryValueHelp.CountryName AS CountryName,
  CorrespondenceLanguage,
  TaxCalculationProcedure
FROM I_PurOrdDeliveryAddressTP AS PurOrdDeliveryAddressTP
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemTP AS _PurchaseOrderItemTP ON _PurchaseOrderItemTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_MM_CountryValueHelp AS _CountryValueHelp ON _CountryValueHelp.Country = Country  -- association [0..1]
LEFT OUTER JOIN C_MM_RegionValueHelp AS _RegionValueHelp ON _RegionValueHelp.Country = Country AND _RegionValueHelp.Region = Region  -- association [0..1]
;

Learn More