R_PurchaseOrderPartnerTP

DDL: R_PURCHASEORDERPARTNERTP Type: view_entity TRANSACTIONAL

Purchase Order Partner TP View

R_PurchaseOrderPartnerTP is a Transactional CDS View that provides data about "Purchase Order Partner TP View" in SAP S/4HANA. It reads from 2 data sources (P_PurchaseOrderItemActive, R_PurchaseOrderPartner) and exposes 24 fields with key fields PurchaseOrder, PartnerFunction.

2 data source(s) 24 fields

Data Sources (2)

SourceAliasJoin Type
P_PurchaseOrderItemActive _PurchaseOrderItemActive inner
R_PurchaseOrderPartner R_PurchaseOrderPartner from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Purchase Order Partner TP View view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrderPartner PurchaseOrder
KEY PartnerFunction R_PurchaseOrderPartner PartnerFunction
SupplierSubrange R_PurchaseOrderPartner SupplierSubrange
Plant R_PurchaseOrderPartner Plant
PurchasingOrganization R_PurchaseOrderPartner PurchasingOrganization
PartnerCounter R_PurchaseOrderPartner PartnerCounter
CreatedByUser R_PurchaseOrderPartner CreatedByUser
CreationDate R_PurchaseOrderPartner CreationDate
PurchasingDocumentPartnerType R_PurchaseOrderPartner PurchasingDocumentPartnerType
Supplier R_PurchaseOrderPartner Supplier
SupplierHierarchyCategory R_PurchaseOrderPartner SupplierHierarchyCategory
SupplierContact R_PurchaseOrderPartner SupplierContact
PersonWorkAgreement R_PurchaseOrderPartner PersonWorkAgreement
EmploymentInternalID R_PurchaseOrderPartner EmploymentInternalID
DefaultPartner R_PurchaseOrderPartner DefaultPartner
_PartnerFunction R_PurchaseOrderPartner _PartnerFunction
_PartnerFunctionText R_PurchaseOrderPartner _PartnerFunctionText
_PersonWorkAgreement R_PurchaseOrderPartner _PersonWorkAgreement
_Plant R_PurchaseOrderPartner _Plant
_PurchaseOrderTP _PurchaseOrderTP
_PurchaseOrder R_PurchaseOrderPartner _PurchaseOrder
_PurchasingOrganization R_PurchaseOrderPartner _PurchasingOrganization
_Supplier R_PurchaseOrderPartner _Supplier
_SupplierContact R_PurchaseOrderPartner _SupplierContact 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: { authorizationCheck: #PRIVILEGED_ONLY, personalData.blocking: #BLOCKED_DATA_EXCLUDED }
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@EndUserText.label: 'Purchase Order Partner TP View'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
define view entity R_PurchaseOrderPartnerTP
  as select from R_PurchaseOrderPartner
    inner join   P_PurchaseOrderItemActive as _PurchaseOrderItemActive on R_PurchaseOrderPartner.PurchaseOrder = _PurchaseOrderItemActive.PurchaseOrder

  association to parent R_PurchaseOrderTP as _PurchaseOrderTP on $projection.PurchaseOrder = _PurchaseOrderTP.PurchaseOrder

{

  key  R_PurchaseOrderPartner.PurchaseOrder,
  key  R_PurchaseOrderPartner.PartnerFunction,
       R_PurchaseOrderPartner.SupplierSubrange,
       R_PurchaseOrderPartner.Plant,
       R_PurchaseOrderPartner.PurchasingOrganization,
       R_PurchaseOrderPartner.PartnerCounter,
       R_PurchaseOrderPartner.CreatedByUser,
       R_PurchaseOrderPartner.CreationDate,
       R_PurchaseOrderPartner.PurchasingDocumentPartnerType,
       R_PurchaseOrderPartner.Supplier,
       R_PurchaseOrderPartner.SupplierHierarchyCategory,
       R_PurchaseOrderPartner.SupplierContact,
       R_PurchaseOrderPartner.PersonWorkAgreement,
       R_PurchaseOrderPartner.EmploymentInternalID,
       R_PurchaseOrderPartner.DefaultPartner,

       /* Associations */
       R_PurchaseOrderPartner._PartnerFunction,
       R_PurchaseOrderPartner._PartnerFunctionText,
       R_PurchaseOrderPartner._PersonWorkAgreement,
       R_PurchaseOrderPartner._Plant,
       _PurchaseOrderTP,
       R_PurchaseOrderPartner._PurchaseOrder,
       R_PurchaseOrderPartner._PurchasingOrganization,
       R_PurchaseOrderPartner._Supplier,
       R_PurchaseOrderPartner._SupplierContact
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PURCHASEORDERITEMACTIVE",
"R_PURCHASEORDERPARTNER"
],
"ASSOCIATED":
[
"I_PARTNERFUNCTION",
"I_PARTNERFUNCTIONTEXT",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER",
"I_SUPPLIERCONTACT",
"R_PURCHASEORDER",
"R_PURCHASEORDERTP"
],
"BASE":
[
"R_PURCHASEORDERPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More