R_PurchaseOrderPartner

DDL: R_PURCHASEORDERPARTNER SQL: RPURORDPARTNER Type: view BASIC Package: VDM_MM_PUR_PO
23 Fields 2 Data Sources 1 Associations

Purchase Order Partner

R_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, R_PurchaseOrder) and exposes 23 fields with key fields PurchaseOrder, PartnerFunction. It has 1 association to related views. Part of development package VDM_MM_PUR_PO.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentPartner partner from
R_PurchaseOrder PurchaseOrder inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (12)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchasingDocumentPartner PurchasingDocument Purchasing Document
KEY PartnerFunction
SupplierSubrange I_PurchasingDocumentPartner SupplierSubrange Suppl. Subrange
Plant I_PurchasingDocumentPartner Plant Valuation Area
PurchasingOrganization I_PurchasingDocumentPartner PurchasingOrganization Purchasing Organization
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 I_PurchasingDocumentPartner _SupplierContact
_PersonWorkAgreement I_PurchasingDocumentPartner _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 R_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: RPURORDPARTNER

CREATE VIEW R_PurchaseOrderPartner AS
SELECT
  partner.PurchasingDocument AS PurchaseOrder,
  cast(partner.PartnerFunction as parvw_unv preserving type) AS PartnerFunction,
  partner.SupplierSubrange AS SupplierSubrange,
  partner.Plant AS Plant,
  partner.PurchasingOrganization AS PurchasingOrganization,
  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,
  partner._SupplierContact AS _SupplierContact,
  partner._PersonWorkAgreement AS _PersonWorkAgreement
FROM I_PurchasingDocumentPartner AS partner
INNER JOIN R_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
;

Learn More