R_PURCHASEORDERPARTNER

CDS View

Purchase Order Partner

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

Used by 4 CDS view(s) 23 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_PurOrderPartnerFactSheet view from CONSUMPTION Purchase Order Partner Fact Sheet
I_PurchaseOrderPartnerTP view from TRANSACTIONAL Purchase Order Partner - TP
R_PPS_PurchaseOrderPartnerTP view_entity 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 4
KEY PartnerFunction PartnerFunction,PartnerFunctionForEdit 4
KEY Plant Plant 4
KEY PurchaseOrder PurchaseOrder 4
KEY PurchasingOrganization PurchasingOrganization 4
KEY SupplierSubrange SupplierSubrange 4
_PartnerFunction _PartnerFunction 4
_PartnerFunctionText _PartnerFunctionText 4
_PersonWorkAgreement _PersonWorkAgreement 4
_Plant _Plant 4
_PurchaseOrder _PurchaseOrder 1
_PurchasingOrganization _PurchasingOrganization 4
_Supplier _Supplier 4
_SupplierContact _SupplierContact 4
CreatedByUser CreatedByUser 4
CreationDate CreationDate 4
DefaultPartner DefaultPartner 4
EmploymentInternalID EmploymentInternalID 3
PersonWorkAgreement PersonWorkAgreement 4
PurchasingDocumentPartnerType PurchasingDocumentPartnerType 4
Supplier Supplier 4
SupplierContact SupplierContact 4
SupplierHierarchyCategory SupplierHierarchyCategory 4 
@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