R_PurchaseOrderPartner

DDL: R_PURCHASEORDERPARTNER SQL: RPURORDPARTNER Type: view BASIC Package: VDM_MM_PUR_PO

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.

2 data source(s) 23 fields

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
KEY PartnerFunction
SupplierSubrange I_PurchasingDocumentPartner SupplierSubrange
Plant I_PurchasingDocumentPartner Plant
PurchasingOrganization I_PurchasingDocumentPartner PurchasingOrganization
PartnerCounter I_PurchasingDocumentPartner PartnerCounter
CreatedByUser I_PurchasingDocumentPartner CreatedByUser
CreationDate I_PurchasingDocumentPartner CreationDate
PurchasingDocumentPartnerType I_PurchasingDocumentPartner PurchasingDocumentPartnerType
Supplier I_PurchasingDocumentPartner Supplier
SupplierHierarchyCategory I_PurchasingDocumentPartner SupplierHierarchyCategory
SupplierContact I_PurchasingDocumentPartner SupplierContact
PersonWorkAgreement I_PurchasingDocumentPartner PersonWorkAgreement
EmploymentInternalID I_PurchasingDocumentPartner EmploymentInternalID
DefaultPartner I_PurchasingDocumentPartner DefaultPartner
_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 
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'RPURORDPARTNER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: { authorizationCheck: #PRIVILEGED_ONLY, personalData.blocking: #BLOCKED_DATA_EXCLUDED }
@VDM.viewType : #BASIC
@EndUserText.label: 'Purchase Order Partner'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view R_PurchaseOrderPartner
  as select from I_PurchasingDocumentPartner as partner

    inner join   R_PurchaseOrder          as PurchaseOrder on partner.PurchasingDocument = PurchaseOrder.PurchaseOrder
    association [0..1] to R_PurchaseOrder as _PurchaseOrder on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder 
{
       //Key

       @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key  partner.PurchasingDocument                                 as PurchaseOrder,

  key  cast(partner.PartnerFunction as parvw_unv preserving type) as PartnerFunction,

       partner.SupplierSubrange,

       partner.Plant,

       partner.PurchasingOrganization,

       partner.PartnerCounter,

       partner.CreatedByUser,

       partner.CreationDate,

       partner.PurchasingDocumentPartnerType, // transient


       partner.Supplier,

       partner.SupplierHierarchyCategory,

       partner.SupplierContact,

       partner.PersonWorkAgreement,
       //deprecated, replaced by PersonWorkAgreement

       partner.EmploymentInternalID,

       partner.DefaultPartner, // default for a particular partner function, checkbox on partner tab in ME21N



       // Associations

       _PurchaseOrder,
       partner._PurchasingOrganization,
       partner._Plant,
       partner._PartnerFunction, //_PartnerFunctionsValueHelp, _PartnerFunctionsValueHelp2,

       partner._PartnerFunctionText,
       partner._Supplier,
       partner._SupplierContact,
       partner._PersonWorkAgreement 
}
where
      partner.PurchasingDocumentItem              = '00000'
  and PurchaseOrder.IsEndOfPurposeBlocked = ''

Learn More