P_UnivAllocCycleLockCounter

DDL: P_UNIVALLOCCYCLELOCKCOUNTER Type: view_entity COMPOSITE Package: ODATA_MANAGE_ALLOCATION_V2

Cycle Lock Counter

P_UnivAllocCycleLockCounter is a Composite CDS View that provides data about "Cycle Lock Counter" in SAP S/4HANA. It reads from 2 data sources (I_UniversalAllocationCycle, I_UniversalAllocationSegment) and exposes 5 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationSegmentIsLocked. Part of development package ODATA_MANAGE_ALLOCATION_V2.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_UniversalAllocationCycle _Cycle from
I_UniversalAllocationSegment _Segment inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cycle Lock Counter view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY AllocationType I_UniversalAllocationCycle AllocationType
KEY AllocationCycle I_UniversalAllocationCycle AllocationCycle
KEY AllocationCycleStartDate I_UniversalAllocationCycle AllocationCycleStartDate
KEY AllocationSegmentIsLocked I_UniversalAllocationSegment AllocationSegmentIsLocked
StatusCount 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Cycle Lock Counter'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    serviceQuality: #B ,
    sizeCategory: #M  }
define view entity P_UnivAllocCycleLockCounter 
  as select from I_UniversalAllocationCycle   as _Cycle
    inner join   I_UniversalAllocationSegment as _Segment on  _Segment.AllocationCycle          = _Cycle.AllocationCycle
                                                          and _Segment.AllocationType           = _Cycle.AllocationType
                                                          and _Segment.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate
{
      //key Cycle.DatabaseTable,

  key _Cycle.AllocationType,
  key _Cycle.AllocationCycle,
  key _Cycle.AllocationCycleStartDate,
  key _Segment.AllocationSegmentIsLocked,
      count( * ) as StatusCount
}
group by
  _Cycle.AllocationType,
  _Cycle.AllocationCycle,
  _Cycle.AllocationCycleStartDate,
  _Segment.AllocationSegmentIsLocked

Learn More