I_GHOAllocationRunCount

DDL: I_GHOALLOCATIONRUNCOUNT Type: view_entity COMPOSITE

Allocation run Count

I_GHOAllocationRunCount is a Composite CDS View that provides data about "Allocation run Count" in SAP S/4HANA. It reads from 2 data sources (gho_allocres_h, upot_udm_allocv) and exposes 16 fields with key field NumberOfAllocationResults.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
gho_allocres_h gho_allocres_h union
upot_udm_allocv upot_udm_allocv from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Allocation run Count view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY NumberOfAllocationResults
GHONetworkID
NetworkMedium medium
ProductionAllocationType alloc_type
AllocationFrequencyCode frequency
ProductionAllocationDate prod_date
ProductionAllocationTime prod_time
NetworkAllocationPurpose alloc_purpose
GHONetworkID
NetworkMedium medium
ProductionAllocationType alloc_type
AllocationFrequencyCode frequency
ProductionAllocationDate prod_date
ProductionAllocationTime prod_time
NetworkAllocationPurpose alloc_purpose
NetworkAllocationStatus alloc_status 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Allocation run Count'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_GHOAllocationRunCount
  as select from upot_udm_allocv
{
  key    count(distinct alloc_run_id)                   as NumberOfAllocationResults,
         cast (netid as gho_network_id preserving type) as GHONetworkID,
         medium                                         as NetworkMedium,
         alloc_type                                     as ProductionAllocationType,
         frequency                                      as AllocationFrequencyCode,
         prod_date                                      as ProductionAllocationDate,
         prod_time                                      as ProductionAllocationTime,
         alloc_purpose                                  as NetworkAllocationPurpose,
         alloc_status                                   as NetworkAllocationStatus
}
group by
  netid,
  prod_date,
  prod_time,
  frequency,
  medium,
  alloc_type,
  alloc_purpose,
  alloc_status
union select from gho_allocres_h
{
  key    count(distinct alloc_run_id)                   as NumberOfAllocationResults,
         cast (netid as gho_network_id preserving type) as GHONetworkID,
         medium                                         as NetworkMedium,
         alloc_type                                     as ProductionAllocationType,
         frequency                                      as AllocationFrequencyCode,
         prod_date                                      as ProductionAllocationDate,
         prod_time                                      as ProductionAllocationTime,
         alloc_purpose                                  as NetworkAllocationPurpose,
         alloc_status                                   as NetworkAllocationStatus
}
group by
  netid,
  prod_date,
  prod_time,
  frequency,
  medium,
  alloc_type,
  alloc_purpose,
  alloc_status

Learn More