I_PurchaseOrderSupplierAddress

DDL: I_PURCHASEORDERSUPPLIERADDRESS SQL: IPUORDSUPADD Type: view COMPOSITE
6 Fields 1 Data Sources 2 Associations

Supplier Address in Purchase Order

I_PurchaseOrderSupplierAddress is a Composite CDS View that provides data about "Supplier Address in Purchase Order" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrder) and exposes 6 fields with key field PurchaseOrder. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrder I_PurchaseOrder from

Associations (2)

CardinalityTargetAliasCondition
[1] I_Address _Address $projection.SupplierAddressID = _Address.AddressID
[0..1] I_Address_2 _Address_2 $projection.SupplierAddressID = _Address_2.AddressID and _Address_2.AddressPersonID = '' and _Address_2.AddressRepresentationCode = ''

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IPUORDSUPADD view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Supplier Address in Purchase Order view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
_Address _Address
_Address_2 _Address_2
PurchaseOrderType PurchaseOrderType PO Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group

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 I_PurchaseOrderSupplierAddress.
-- 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: IPUORDSUPADD

CREATE VIEW I_PurchaseOrderSupplierAddress AS
SELECT
  PurchaseOrder,
  PurchaseOrderType,
  PurchasingOrganization,
  PurchasingGroup
FROM I_PurchaseOrder
LEFT OUTER JOIN I_Address AS _Address ON SupplierAddressID = _Address.AddressID  -- association [1]
LEFT OUTER JOIN I_Address_2 AS _Address_2 ON SupplierAddressID = _Address_2.AddressID AND _Address_2.AddressPersonID = '' AND _Address_2.AddressRepresentationCode = ''  -- association [0..1]
;

Learn More