C_AllocationCycleVH

DDL: C_ALLOCATIONCYCLEVH SQL: CALOCYCLEVH Type: view CONSUMPTION

Allocation Cycle Value Help

C_AllocationCycleVH is a Consumption CDS View that provides data about "Allocation Cycle Value Help" in SAP S/4HANA. It reads from 2 data sources (C_AllocationContextVH, P_AllocationCycle) and exposes 12 fields with key fields AllocationCycle, AllocationType, AllocationCycleStartDate. It has 2 associations to related views. It is exposed through 2 OData services (FCO_ALLOCATION_RUN_GROUP, FCO_ALLOCATION_TAG_V3). It is used in 2 Fiori applications: Manage Allocation Tags, Manage Cycle Run Groups.

2 data source(s) Exposed by 2 service(s) Used in 2 Fiori app(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
C_AllocationContextVH _context inner
P_AllocationCycle P_AllocationCycle from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_AllocationCycle _AllocationCycleCalc $projection.AllocationType = _AllocationCycleCalc.AllocationType and $projection.AllocationCycle = _AllocationCycleCalc.AllocationCycle and $projection.AllocationCycleStartDate = _AllocationCycleCalc.AllocationCycleStartDate
[1..1] I_UserContactCard _CreatedByUserContactCard $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CALOCYCLEVH view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Allocation Cycle Value Help view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey AllocationCycle view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
FCO_ALLOCATION_RUN_GROUP FCO_ALLOCATION_RUN_GROUP V2 C1 NOT_RELEASED
FCO_ALLOCATION_TAG_V3 FCO_ALLOCATION_TAG_V3 V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F4523 Manage Allocation Tags Transactional This app provides tagging functionality for Universal Allocation data
F4935 Manage Cycle Run Groups Transactional You use this app to manage your allocation cycle run groups. With this Fiori application, user can maintain cycle run groups and assign allocation cycles into the run groups. With grouping provided, parallel processing of allocation cycles is possible.

Manage Allocation Tags

Business Role: Cost Accountant - Overhead

With this app, you can create and assign allocation tags. Allocation tags are semantic tags you can assign to allocation cycles and segments that allow you to group and identify those cycles and segments. The tags can be used across allocation contexts and types, allowing you to track and label all elements of an allocation process.

Manage Cycle Run Groups

Business Role: Cost Accountant - Overhead

With this app, you can organize allocation cycles into groups to enable parallel processing. If you don't organize your allocation cycles into groups, the cycles are always processed sequentially. This can be time consuming. A cycle run group is always processed in parallel with other cycle run groups, so you can significantly reduce the processing time if you organize your allocation cycles into groups. The allocation cycles within a single group are processed sequentially, but in parallel with other groups.

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AllocationCycle AllocationCycle
KEY AllocationType P_AllocationCycle AllocationType
KEY AllocationCycleStartDate AllocationCycleStartDate
AllocationContextTypeText C_AllocationContextVH AllocationContextTypeText
AllocationCycleName _AllocationCycleCalc AllocationCycleName
AllocationCycleNameText _AllocationCycleCalc AllocationCycleNameText
FullName _CreatedByUserContactCard FullName
CreatedByUser CreatedByUser
Ledger Ledger
AllocationPostingType AllocationPostingType
AllocationActualPlanVariant AllocationActualPlanVariant
_CreatedByUserContactCard _CreatedByUserContactCard 
@AbapCatalog.sqlViewName: 'CALOCYCLEVH'
//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Allocation Cycle Value Help'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'AllocationCycle'
@AccessControl.privilegedAssociations:  ['_CreatedByUserContactCard']

@Search.searchable: true
define view C_AllocationCycleVH
  as
  //with parameters P_AllocationType: FCO_ALLOCATION_CONTEXT

  //as

  select from  P_AllocationCycle
    inner join C_AllocationContextVH as _context on P_AllocationCycle.AllocationType = _context.AllocationType

  association [1..1] to P_AllocationCycle as _AllocationCycleCalc      on  $projection.AllocationType           = _AllocationCycleCalc.AllocationType
                                                                       and $projection.AllocationCycle          = _AllocationCycleCalc.AllocationCycle
                                                                       and $projection.AllocationCycleStartDate = _AllocationCycleCalc.AllocationCycleStartDate

  association [1..1] to I_UserContactCard as _CreatedByUserContactCard on  $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID

  //association [1..1] to I_AllocationContextType as _AllocationType      on $projection.AllocationType = _AllocationType.AllocationType

{
      @UI.hidden: true
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.5 }
  key AllocationCycle,
      @UI.hidden: true
      @ObjectModel.text.element: ['AllocationContextTypeText']
      @Consumption.labelElement: 'AllocationContextTypeText'
  key P_AllocationCycle.AllocationType,
  
      @Semantics.businessDate.from: true
      @Consumption.filter.multipleSelections: false
      @Consumption.filter.selectionType: #SINGLE  
  key AllocationCycleStartDate,

      _context.AllocationContextTypeText,

      @ObjectModel.text.element: ['AllocationCycleNameText']
      @Consumption.labelElement: 'AllocationCycleNameText'
      _AllocationCycleCalc.AllocationCycleName,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.5 }
      _AllocationCycleCalc.AllocationCycleNameText,
      _CreatedByUserContactCard.FullName,
      @UI.hidden: true
      CreatedByUser,
      @UI.hidden: true
      Ledger,
      AllocationPostingType,
      AllocationActualPlanVariant,

      _CreatedByUserContactCard
}
//where AllocationType = P_AllocationType

//where

//  AllocationType = 'ACDOC_CC'

Learn More