P_PT_DeliverySeriesCount

DDL: P_PT_DELIVERYSERIESCOUNT Type: view_entity COMPOSITE

Document count of Number Range Series

P_PT_DeliverySeriesCount is a Composite CDS View that provides data about "Document count of Number Range Series" in SAP S/4HANA. It reads from 1 data source (I_PT_DeliveryNumberRange) and exposes 2 fields with key field PortugueseDgtlSignatureSeries. It has 1 association to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_PT_DeliveryNumberRange I_PT_DeliveryNumberRange from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PT_DeliveryDgtlSgntr _DigitalSignature _DigitalSignature.PortugueseDgtlSignatureSeries = $projection.PortugueseDgtlSignatureSeries

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
EndUserText.label Document count of Number Range Series view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PortugueseDgtlSignatureSeries PortugueseDgtlSignatureSeries
DocumentCount 

@VDM.private:true
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Document count of Number Range Series'
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #M,
    dataClass: #CUSTOMIZING
}
define view entity P_PT_DeliverySeriesCount
  as select from I_PT_DeliveryNumberRange
  association [0..*] to I_PT_DeliveryDgtlSgntr as _DigitalSignature on _DigitalSignature.PortugueseDgtlSignatureSeries = $projection.PortugueseDgtlSignatureSeries
{
  key PortugueseDgtlSignatureSeries,
      count( distinct _DigitalSignature.ReferenceDocumentNumber) as DocumentCount
}
group by
  PortugueseDgtlSignatureSeries
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PT_DELIVERYDGTLSGNTR",
"I_PT_DELIVERYNUMBERRANGE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More