I_PurchaseOrderPartner

DDL: I_PURCHASEORDERPARTNER SQL: IPURORDPARTNER Type: view BASIC
23 Fields 2 Data Sources 1 Associations

Purchase Order Partner

I_PurchaseOrderPartner is a Basic CDS View that provides data about "Purchase Order Partner" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentPartner, I_PurchaseOrder) and exposes 23 fields with key fields PurchaseOrder, PurchasingOrganization, SupplierSubrange, Plant, PartnerFunction. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentPartner partner from
I_PurchaseOrder PurchaseOrder inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IPURORDPARTNER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Purchase Order Partner view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchasingDocumentPartner PurchasingDocument Purchasing Document
KEY PurchasingOrganization I_PurchasingDocumentPartner PurchasingOrganization Purchasing Organization
KEY SupplierSubrange I_PurchasingDocumentPartner SupplierSubrange Suppl. Subrange
KEY Plant I_PurchasingDocumentPartner Plant Valuation Area
KEY PartnerFunction I_PurchasingDocumentPartner PartnerFunction Partner Functn
KEY PartnerCounter I_PurchasingDocumentPartner PartnerCounter Partner counter
CreatedByUser I_PurchasingDocumentPartner CreatedByUser User Name
CreationDate I_PurchasingDocumentPartner CreationDate Time Stamp
PurchasingDocumentPartnerType I_PurchasingDocumentPartner PurchasingDocumentPartnerType Partner Type
Supplier I_PurchasingDocumentPartner Supplier Supplier
SupplierHierarchyCategory I_PurchasingDocumentPartner SupplierHierarchyCategory Hierarchy Cat.
SupplierContact I_PurchasingDocumentPartner SupplierContact Contact Person
PersonWorkAgreement I_PurchasingDocumentPartner PersonWorkAgreement Personnel No.
EmploymentInternalID I_PurchasingDocumentPartner EmploymentInternalID WorkForce Assgmt ID
DefaultPartner I_PurchasingDocumentPartner DefaultPartner Default Partner
_PurchaseOrder _PurchaseOrder
_PurchasingOrganization I_PurchasingDocumentPartner _PurchasingOrganization
_Plant I_PurchasingDocumentPartner _Plant
_PartnerFunction I_PurchasingDocumentPartner _PartnerFunction
_PartnerFunctionText I_PurchasingDocumentPartner _PartnerFunctionText
_Supplier I_PurchasingDocumentPartner _Supplier
_SupplierContact _SupplierContact
_PersonWorkAgreement _PersonWorkAgreement

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_PurchaseOrderPartner.
-- 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: IPURORDPARTNER

CREATE VIEW I_PurchaseOrderPartner AS
SELECT
  partner.PurchasingDocument AS PurchaseOrder,
  partner.PurchasingOrganization AS PurchasingOrganization,
  partner.SupplierSubrange AS SupplierSubrange,
  partner.Plant AS Plant,
  partner.PartnerFunction AS PartnerFunction,
  partner.PartnerCounter AS PartnerCounter,
  partner.CreatedByUser AS CreatedByUser,
  partner.CreationDate AS CreationDate,
  partner.PurchasingDocumentPartnerType AS PurchasingDocumentPartnerType,
  partner.Supplier AS Supplier,
  partner.SupplierHierarchyCategory AS SupplierHierarchyCategory,
  partner.SupplierContact AS SupplierContact,
  partner.PersonWorkAgreement AS PersonWorkAgreement,
  partner.EmploymentInternalID AS EmploymentInternalID,
  partner.DefaultPartner AS DefaultPartner,
  partner._PurchasingOrganization AS _PurchasingOrganization,
  partner._Plant AS _Plant,
  partner._PartnerFunction AS _PartnerFunction,
  partner._PartnerFunctionText AS _PartnerFunctionText,
  partner._Supplier AS _Supplier
FROM I_PurchasingDocumentPartner AS partner
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON _PurchaseOrder.PurchaseOrder = PurchaseOrder  -- association [1..1]
;

Learn More