I_CycleRunGroup

DDL: I_CYCLERUNGROUP SQL: IALLOCRUNGRP Type: view BASIC

Cycle Run Group

I_CycleRunGroup is a Basic CDS View that provides data about "Cycle Run Group" in SAP S/4HANA. It reads from 2 data sources (I_Ledger, t811p) and exposes 10 fields with key fields AllocationType, AllocationCycleRunGroup, AllocationPostingType, AllocationActualPlanVariant, Ledger. It has 5 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_Ledger I_Ledger inner
t811p t811p from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_AllocationContextType _Context $projection.AllocationType = _Context.AllocationType
[0..1] I_AllocationPostingType _AllocPostingType $projection.AllocationPostingType = _AllocPostingType.AllocationPostingType
[0..1] I_AllocActualPlanVariant _AllocActualPlanVariant $projection.AllocationActualPlanVariant = _AllocActualPlanVariant.AllocationActualPlanVariant
[0..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[0..*] I_CycleRunGroupText _Text $projection.AllocationType = _Text.AllocationType and $projection.Ledger = _Text.Ledger and $projection.AllocationCycleRunGroup = _Text.AllocationCycleRunGroup and $projection.AllocationPostingType = _Text.AllocationPostingType and $projection.AllocationActualPlanVariant = _Text.AllocationActualPlanVariant

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IALLOCRUNGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cycle Run Group view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AllocationType
KEY AllocationCycleRunGroup proc_group
KEY AllocationPostingType
KEY AllocationActualPlanVariant
KEY Ledger
_Context _Context
_AllocPostingType _AllocPostingType
_AllocActualPlanVariant _AllocActualPlanVariant
_Ledger _Ledger
_Text _Text 
@AbapCatalog.sqlViewName: 'IALLOCRUNGRP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cycle Run Group'
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_CycleRunGroup
  as select from t811p
  inner join I_Ledger on t811p.org_unit = I_Ledger.Ledger
  association [0..1] to I_AllocationContextType  as _Context                on  $projection.AllocationType = _Context.AllocationType
  association [0..1] to I_AllocationPostingType  as _AllocPostingType       on  $projection.AllocationPostingType = _AllocPostingType.AllocationPostingType
  association [0..1] to I_AllocActualPlanVariant as _AllocActualPlanVariant on  $projection.AllocationActualPlanVariant = _AllocActualPlanVariant.AllocationActualPlanVariant
  association [0..1] to I_Ledger                 as _Ledger                 on  $projection.Ledger = _Ledger.Ledger  
  association [0..*] to I_CycleRunGroupText      as _Text                   on  $projection.AllocationType              = _Text.AllocationType
                                                                            and $projection.Ledger                      = _Text.Ledger
                                                                            and $projection.AllocationCycleRunGroup     = _Text.AllocationCycleRunGroup
                                                                            and $projection.AllocationPostingType       = _Text.AllocationPostingType
                                                                            and $projection.AllocationActualPlanVariant = _Text.AllocationActualPlanVariant
{
  key cast(tab as fco_allocation_context preserving type )          as AllocationType,
  key proc_group                                   as AllocationCycleRunGroup,
  key cast(alart as fco_alloc_posting_type preserving type )        as AllocationPostingType,
  key cast(ipknz as fco_alloc_ipknz preserving type )              as AllocationActualPlanVariant,
  //key cast(substring(org_unit, 1, 2) as fis_rldnr preserving type ) as Ledger,

  key cast(I_Ledger.Ledger as fis_rldnr preserving type ) as Ledger,
      _Context,
      _AllocPostingType,
      _AllocActualPlanVariant,
      _Ledger,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"T811P"
],
"ASSOCIATED":
[
"I_ALLOCACTUALPLANVARIANT",
"I_ALLOCATIONCONTEXTTYPE",
"I_ALLOCATIONPOSTINGTYPE",
"I_CYCLERUNGROUPTEXT",
"I_LEDGER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More