C_PurchaseOrderPartnerTP

DDL: C_PURCHASEORDERPARTNERTP SQL: CPURORDPTNR Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2

Purchase Order Partner

C_PurchaseOrderPartnerTP is a Consumption CDS View that provides data about "Purchase Order Partner" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderPartnerTP) and exposes 29 fields with key fields PurchaseOrder, PartnerFunction, PurchasingOrganization, SupplierSubrange, Plant. It has 3 associations to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderPartnerTP PurchaseOrderPartnerTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_PurchaseOrderTP _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
[0..*] I_PurOrderPartnerFunctionVH _PurOrderPartnerFunctionVH _PurOrderPartnerFunctionVH.PartnerFunction = $projection.PartnerFunction
[0..1] I_PurgDocumentPartnerVH _PurgDocumentPartnerVH _PurgDocumentPartnerVH.PurchasingDocumentPartner = $projection.PurchasingDocumentPartner and _PurgDocumentPartnerVH.PurchasingDocumentPartnerType = $projection.PurchasingDocumentPartnerType

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CPURORDPTNR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Order Partner view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.draftEnabled true view
UI.headerInfo.typeName Partner view
UI.headerInfo.typeNamePlural Partners view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderPartnerTP PurchaseOrder
KEY PartnerFunction I_PurchaseOrderPartnerTP PartnerFunction
KEY PurchasingOrganization I_PurchaseOrderPartnerTP PurchasingOrganization
KEY SupplierSubrange I_PurchaseOrderPartnerTP SupplierSubrange
KEY Plant I_PurchaseOrderPartnerTP Plant
KEY PartnerCounter I_PurchaseOrderPartnerTP PartnerCounter
CreatedByUser I_PurchaseOrderPartnerTP CreatedByUser
CreationDate I_PurchaseOrderPartnerTP CreationDate
PartnerFunctionName I_PurchaseOrderPartnerTP PartnerFunctionName
PurchasingDocumentPartnerType I_PurchaseOrderPartnerTP PurchasingDocumentPartnerType
PartnerFunctionForEdit I_PurchaseOrderPartnerTP PartnerFunctionForEdit
Supplier I_PurchaseOrderPartnerTP Supplier
SupplierHierarchyCategory I_PurchaseOrderPartnerTP SupplierHierarchyCategory
SupplierContact I_PurchaseOrderPartnerTP SupplierContact
PersonWorkAgreement I_PurchaseOrderPartnerTP PersonWorkAgreement
DefaultPartner I_PurchaseOrderPartnerTP DefaultPartner
PurchasingDocumentPartner I_PurchaseOrderPartnerTP PurchasingDocumentPartner
PurchasingDocumentPartnerName I_PurchaseOrderPartnerTP PurchasingDocumentPartnerName
PurchaseOrderType _PurchaseOrder PurchaseOrderType
_PurgDocumentPartnerVH _PurgDocumentPartnerVH
_PartnerFunction I_PurchaseOrderPartnerTP _PartnerFunction
_PartnerFunctionText I_PurchaseOrderPartnerTP _PartnerFunctionText
_PersonWorkAgreement I_PurchaseOrderPartnerTP _PersonWorkAgreement
_Plant I_PurchaseOrderPartnerTP _Plant
_PurchasingOrganization I_PurchaseOrderPartnerTP _PurchasingOrganization
_Supplier I_PurchaseOrderPartnerTP _Supplier
_SupplierContact I_PurchaseOrderPartnerTP _SupplierContact
_PurchaseOrder _PurchaseOrder
_PurOrderPartnerFunctionVH _PurOrderPartnerFunctionVH
@AbapCatalog.sqlViewName: 'CPURORDPTNR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Purchase Order Partner'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    createEnabled : true,
    deleteEnabled : true,
    updateEnabled : true,
    draftEnabled  : true
}
@UI.headerInfo: {
      typeName        : 'Partner',
      typeNamePlural  : 'Partners'
}
@ObjectModel.transactionalProcessingDelegated: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #REQUIRED
@Search.searchable: true

define view C_PurchaseOrderPartnerTP
  as select from I_PurchaseOrderPartnerTP as PurchaseOrderPartnerTP
  association [1..1] to C_PurchaseOrderTP           as _PurchaseOrder             on  _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
  association [0..*] to I_PurOrderPartnerFunctionVH as _PurOrderPartnerFunctionVH on  _PurOrderPartnerFunctionVH.PartnerFunction = $projection.PartnerFunction
  association [0..1] to I_PurgDocumentPartnerVH     as _PurgDocumentPartnerVH     on  _PurgDocumentPartnerVH.PurchasingDocumentPartner     = $projection.PurchasingDocumentPartner
                                                                                  and _PurgDocumentPartnerVH.PurchasingDocumentPartnerType = $projection.PurchasingDocumentPartnerType
{
             @UI.hidden: true
  key        PurchaseOrderPartnerTP.PurchaseOrder,
             @UI.hidden: true
             @ObjectModel.readOnly: true
  key        PurchaseOrderPartnerTP.PartnerFunction,
             @UI.hidden: true
  key        PurchaseOrderPartnerTP.PurchasingOrganization,
             @UI.hidden: true
  key        PurchaseOrderPartnerTP.SupplierSubrange,
             @UI.hidden: true
  key        PurchaseOrderPartnerTP.Plant,
             @UI.hidden: true
  key        PurchaseOrderPartnerTP.PartnerCounter,
             @UI.hidden: true
             PurchaseOrderPartnerTP.CreatedByUser,
             @UI.hidden: true
             PurchaseOrderPartnerTP.CreationDate,
             @ObjectModel: { readOnly: true }
             @UI.hidden: true
             PurchaseOrderPartnerTP.PartnerFunctionName,
             @ObjectModel: { readOnly: true }
             @UI.hidden: true
             PurchaseOrderPartnerTP.PurchasingDocumentPartnerType,
             @Consumption.valueHelpDefinition: [{entity: {name: 'I_PurOrderPartnerFunctionVH', element: 'PartnerFunction'}, additionalBinding: [{ element: 'PurchaseOrderType', localElement: 'PurchaseOrderType' }] } ]
             @UI: {
             identification: [{position: 10, qualifier: 'PartnerItem'}],
             lineItem: [ {position: 10, importance: #HIGH, qualifier: 'PartnerItem'} ]
             }
             @ObjectModel.text.association: '_PartnerFunctionText'
             @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION'}
             @ObjectModel.editableFieldFor: 'PartnerFunction'
             @Search.defaultSearchElement: true
             PurchaseOrderPartnerTP.PartnerFunctionForEdit,
             @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
             @UI.hidden: true
             PurchaseOrderPartnerTP.Supplier,
             @UI.hidden: true
             PurchaseOrderPartnerTP.SupplierHierarchyCategory,
             @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
             @UI.hidden: true
             PurchaseOrderPartnerTP.SupplierContact,
             @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
             @UI.hidden: true
             PurchaseOrderPartnerTP.PersonWorkAgreement,
             @ObjectModel: { readOnly: true }
             PurchaseOrderPartnerTP.DefaultPartner,
             @UI: {
             identification: [{position: 20, qualifier: 'PartnerItem'}],
             lineItem: [ {position: 20, importance: #HIGH, qualifier: 'PartnerItem'} ]
             }
             @ObjectModel.text.element:  [ 'PurchasingDocumentPartnerName' ]
             @Consumption.valueHelpDefinition: [{entity: {name: 'I_PurgDocumentPartnerVH', element: 'PurchasingDocumentPartner'} }]
             @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
             //@Search.fuzzinessThreshold: 0.8    -> removed due to HANA search dump on dyn. generated fields (see DINC0471335)

             //@Search.defaultSearchElement: true -> removed due to HANA search dump on dyn. generated fields (see DINC0471335)

             PurchaseOrderPartnerTP.PurchasingDocumentPartner,
             @ObjectModel: { readOnly: true }
             @UI.hidden: true
             PurchaseOrderPartnerTP.PurchasingDocumentPartnerName,
             @UI.hidden: true
             @ObjectModel: { readOnly: true }
             _PurchaseOrder.PurchaseOrderType,
             /* Associations */
             _PurgDocumentPartnerVH,
             PurchaseOrderPartnerTP._PartnerFunction,
             PurchaseOrderPartnerTP._PartnerFunctionText,
             PurchaseOrderPartnerTP._PersonWorkAgreement,
             PurchaseOrderPartnerTP._Plant,
             PurchaseOrderPartnerTP._PurchasingOrganization,
             PurchaseOrderPartnerTP._Supplier,
             PurchaseOrderPartnerTP._SupplierContact,
             @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
             _PurchaseOrder,
             _PurOrderPartnerFunctionVH
}