P_ProjBillgElmntPartnerCount

DDL: P_PROJBILLGELMNTPARTNERCOUNT Type: view_entity TRANSACTIONAL Package: VDM_PROJECTBILLINGELEMENT

partner count for proj billing elelemt

P_ProjBillgElmntPartnerCount is a Transactional CDS View that provides data about "partner count for proj billing elelemt" in SAP S/4HANA. It reads from 1 data source (I_SalesDocItemCompletePartner) and exposes 4 fields with key fields SalesDocument, SalesDocumentItem. Part of development package VDM_PROJECTBILLINGELEMENT.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocItemCompletePartner I_SalesDocItemCompletePartner from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label partner count for proj billing elelemt view
VDM.private true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
KEY SalesDocumentItem SalesDocumentItem
WBSElementInternalID _SalesDocumentItem WBSElementInternalID
NumberOfPartners 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'partner count for proj billing elelemt'
@VDM.private: true
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #TRANSACTIONAL
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view entity P_ProjBillgElmntPartnerCount
  as select from I_SalesDocItemCompletePartner
{
  key SalesDocument,
  key SalesDocumentItem,
      _SalesDocumentItem.WBSElementInternalID,
      count( * ) as NumberOfPartners
}
where
      _PartnerFunction.SDDocumentPartnerType  = 'PE'
  and _SalesDocument.SalesDocumentType        = 'SO01' //Filter PartnerFunctions only of type PE and SalesOrders only of type SO01

  and _SalesDocumentItem.WBSElementInternalID is not initial
group by
  SalesDocument,
  SalesDocumentItem,
  _SalesDocumentItem.WBSElementInternalID

Learn More