I_PurchaseOrderPartnerTP

DDL: I_PURCHASEORDERPARTNERTP SQL: IPURORDPTNR Type: view TRANSACTIONAL
25 Fields 1 Data Sources 1 Associations

Purchase Order Partner - TP

I_PurchaseOrderPartnerTP is a Transactional CDS View that provides data about "Purchase Order Partner - TP" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderPartner) and exposes 25 fields with key fields PurchaseOrder, PartnerFunction, PurchasingOrganization, SupplierSubrange, Plant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderPartner PurchaseOrderPartner from

Associations (1)

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

Annotations (16)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IPURORDPTNR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Order Partner - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.writeDraftPersistence PURORDPTNR_D view
AbapCatalog.preserveKey true view

Fields (25)

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

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_PurchaseOrderPartnerTP.
-- 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: IPURORDPTNR

CREATE VIEW I_PurchaseOrderPartnerTP AS
SELECT
  PurchaseOrderPartner.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderPartner.PartnerFunction AS PartnerFunction,
  PurchaseOrderPartner.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderPartner.SupplierSubrange AS SupplierSubrange,
  PurchaseOrderPartner.Plant AS Plant,
  PurchaseOrderPartner.PartnerCounter AS PartnerCounter,
  PurchaseOrderPartner.CreatedByUser AS CreatedByUser,
  PurchaseOrderPartner.CreationDate AS CreationDate,
  PurchaseOrderPartner.PurchasingDocumentPartnerType AS PurchasingDocumentPartnerType,
  PurchaseOrderPartner.Supplier AS Supplier,
  PurchaseOrderPartner.SupplierHierarchyCategory AS SupplierHierarchyCategory,
  PurchaseOrderPartner.SupplierContact AS SupplierContact,
  PurchaseOrderPartner.PersonWorkAgreement AS PersonWorkAgreement,
  PurchaseOrderPartner.EmploymentInternalID AS EmploymentInternalID,
  PurchaseOrderPartner.DefaultPartner AS DefaultPartner,
  PurchaseOrderPartner.PartnerFunction AS PartnerFunctionForEdit,
  PurchaseOrderPartner._PartnerFunctionText[Language = $session.system_language].PartnerFunctionName AS PartnerFunctionName,
  PurchaseOrderPartner._PartnerFunction AS _PartnerFunction,
  PurchaseOrderPartner._PersonWorkAgreement AS _PersonWorkAgreement,
  PurchaseOrderPartner._Plant AS _Plant,
  PurchaseOrderPartner._PurchasingOrganization AS _PurchasingOrganization,
  PurchaseOrderPartner._Supplier AS _Supplier,
  PurchaseOrderPartner._SupplierContact AS _SupplierContact,
  PurchaseOrderPartner._PartnerFunctionText AS _PartnerFunctionText
FROM R_PurchaseOrderPartner AS PurchaseOrderPartner
LEFT OUTER JOIN I_PurchaseOrderTP AS _PurchaseOrder ON _PurchaseOrder.PurchaseOrder = PurchaseOrder  -- association [1..1]
;

Learn More