P_AllocationCycle

@AbapCatalog.sqlViewName: 'PALLOCCYCLE'
@AbapCatalog.compiler.compareFilter: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_AllocationCycle
  //as select from I_AllocationCycle

  as select from P_AllocationCycleCalc

  association [0..*] to C_AllocationCycleKeyFieldTP  as _Field            on  $projection.AllocationType           = _Field.AllocationType
                                                                          and $projection.AllocationCycle          = _Field.AllocationCycle
                                                                          and $projection.AllocationCycleStartDate = _Field.AllocationCycleStartDate

  association [0..1] to I_AllocAssmtDistrLongText    as _Text             on  _Text.AllocationType           = $projection.AllocationType
                                                                          and _Text.AllocationCycle          = $projection.AllocationCycle
                                                                          and _Text.AllocationCycleStartDate = $projection.AllocationCycleStartDate
                                                                          and _Text.LanguageCode             = $session.system_language
                                                                          and _Text.AllocationCycleSegment   = '0000'

  //  association [0..1] to P_AllocationStatus as _Status on  $projection.AllocationType           = _Status.AllocationType

  //                                                      and $projection.AllocationCycle          = _Status.AllocationCycle

  //                                                      and $projection.AllocationCycleStartDate = _Status.AllocationCycleStartDate


  association [1..1] to I_CompanyCode                as _CompanyCode      on  $projection.CompanyCode = _CompanyCode.CompanyCode

  association [1..1] to I_AllocationStatus           as _AllocationStatus on  $projection.AllocationStatus = _AllocationStatus.AllocationStatus

  association [0..*] to P_AllocCycleIsConsistentText as _IsConsistentText on  _IsConsistentText.AllocationCycleIsConsistent = $projection.AllocationCycleIsConsistent   
  
  association [1..1] to I_Ledger                     as _Ledger           on  $projection.Ledger = _Ledger.Ledger
  
  association [0..1] to C_AllocationCycleRunGroupVH as _AllocationCycleRunGroupVH   on  $projection.AllocationType              = _AllocationCycleRunGroupVH.AllocationType
                                                                                    and $projection.Ledger                      = _AllocationCycleRunGroupVH.Ledger
                                                                                    and $projection.AllocationPostingType       = _AllocationCycleRunGroupVH.AllocationPostingType
                                                                                    and $projection.AllocationActualPlanVariant = _AllocationCycleRunGroupVH.AllocationActualPlanVariant
                                                                                    and $projection.AllocationCycleRunGroup     = _AllocationCycleRunGroupVH.AllocationCycleRunGroup
{

      //key DatabaseTable,

  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,

      //cast(substring(AllocationCycle, 3, 8) as fco_alloc_cycle_id) as  AllocationCycleName,

      @ObjectModel.readOnly: true
      AllocationCycleName,
      @ObjectModel.readOnly: true
      _Text.AllocationCycleNameText,


      @ObjectModel.readOnly: true
      _ActualPlanText[1:Language = $session.system_language].AllocActualPlanVariantText,
      @ObjectModel.readOnly: true
      _Context._Text[1:Language = $session.system_language].AllocationContextTypeText,


      CompanyCode,
      _CompanyCode.CompanyCodeName,
      AllocationCostElement,
      AllocationCycleCategory,
      Ledger,
      _Ledger._Text[1:Language = $session.system_language].LedgerName,

      @ObjectModel.readOnly: true
      AllocationStatus,

      @ObjectModel.readOnly: true
      CriticalityCode,

      CreatedByUser,

      @ObjectModel.readOnly: true
      AllocationCycleIsConsistent,
      
      @UI.hidden: true
      _IsConsistentText[1:Language = $session.system_language].AllocCycleIsConsistentText,
      
      AllocationPostingType,
      AllocationActualPlanVariant,     
      //AllocLastExecutionDateTime,          

      
      AllocationCycleRunGroup,
      
      _AllocationCycleRunGroupVH.AllocationCycleRunGroupText,

      _Field,
      //@ObjectModel.association.type: #TO_COMPOSITION_CHILD

      _Text,
      _Context,
      _AllocationStatus
      //      _LastExecUserContactCard,

      //      _LastChangeUserContactCard,

      //      _CreatedByUserContactCard


}
//where

//  DatabaseTable = 'ACDOC_CC'