C_PurOrdSupplierAddressTP

DDL: C_PURORDSUPPLIERADDRESSTP Type: view CONSUMPTION
18 Fields 1 Data Sources 3 Associations

Purchase Order Supplier Address

C_PurOrdSupplierAddressTP is a Consumption CDS View that provides data about "Purchase Order Supplier Address" in SAP S/4HANA. It reads from 1 data source (I_PurOrdSupplierAddressTP) and exposes 18 fields with key field PurchaseOrder. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdSupplierAddressTP PurOrdSupplierAddressTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_PurchaseOrderTP _PurchaseOrderTP _PurchaseOrderTP.PurchaseOrder = $projection.PurchaseOrder
[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 CPOSUPADDTP view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Order Supplier Address view
AccessControl.authorizationCheck #CHECK view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey PurchaseOrder view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
SupplierAddressID SupplierAddressID Address Number
FullName FullName Name
StreetName StreetName Text
HouseNumber HouseNumber House Number
PostalCode PostalCode Postal Code
CityName CityName Name
Country Country Country / Region Key
Region Region Venue Region
PhoneNumber PhoneNumber Telephone no.
FaxNumber FaxNumber Fax Number
EmailAddress EmailAddress E-Mail Address
CorrespondenceLanguage CorrespondenceLanguage Language
CountryName _CountryValueHelp CountryName Country
RegionName _RegionValueHelp RegionName Description
_PurchaseOrderTP _PurchaseOrderTP
_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_PurOrdSupplierAddressTP.
-- 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_PurOrdSupplierAddressTP AS
SELECT
  PurchaseOrder,
  SupplierAddressID,
  FullName,
  StreetName,
  HouseNumber,
  PostalCode,
  CityName,
  Country,
  Region,
  PhoneNumber,
  FaxNumber,
  EmailAddress,
  CorrespondenceLanguage,
  _CountryValueHelp.CountryName AS CountryName,
  _RegionValueHelp.RegionName AS RegionName
FROM I_PurOrdSupplierAddressTP AS PurOrdSupplierAddressTP
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- 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