P_AllocationTagCount

DDL: P_ALLOCATIONTAGCOUNT SQL: ALOTAGCNT Type: view COMPOSITE

P_AllocationTagCount is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocTagObjectAssignment) and exposes 5 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocTagObjectAssignment I_AllocTagObjectAssignment from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ALOTAGCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
NumberOfAllocationTags 
@AbapCatalog.sqlViewName: 'ALOTAGCNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_AllocationTagCount as 
select from I_AllocTagObjectAssignment    
{
   //I_AllocTagObjectAssignment

   //key AllocationTagID,

   key AllocationType,
   key AllocationCycle,
   key AllocationCycleStartDate,
   key AllocationCycleSegment,  
  count(distinct AllocationTagID) as NumberOfAllocationTags     
}
group by AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment

Learn More