R_PURCHASEORDERPARTNER

CDS View

Purchase Order Partner

R_PURCHASEORDERPARTNER is a CDS View in S/4HANA. Purchase Order Partner. It contains 23 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 23 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PurOrderPartnerFactSheet view from CONSUMPTION Purchase Order Partner Fact Sheet
I_PurchaseOrderPartnerTP view from TRANSACTIONAL Purchase Order Partner - TP
R_PurchaseOrderPartnerTP view_entity from TRANSACTIONAL Purchase Order Partner TP View

Fields (23)

KeyField CDS FieldsUsed in Views
KEY PartnerCounter PartnerCounter 3
KEY PartnerFunction PartnerFunction,PartnerFunctionForEdit 3
KEY Plant Plant 3
KEY PurchaseOrder PurchaseOrder 3
KEY PurchasingOrganization PurchasingOrganization 3
KEY SupplierSubrange SupplierSubrange 3
_PartnerFunction _PartnerFunction 3
_PartnerFunctionText _PartnerFunctionText 3
_PersonWorkAgreement _PersonWorkAgreement 3
_Plant _Plant 3
_PurchaseOrder _PurchaseOrder 1
_PurchasingOrganization _PurchasingOrganization 3
_Supplier _Supplier 3
_SupplierContact _SupplierContact 3
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
DefaultPartner DefaultPartner 3
EmploymentInternalID EmploymentInternalID 2
PersonWorkAgreement PersonWorkAgreement 3
PurchasingDocumentPartnerType PurchasingDocumentPartnerType 3
Supplier Supplier 3
SupplierContact SupplierContact 3
SupplierHierarchyCategory SupplierHierarchyCategory 3 
@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